competency_coursecompsetting

0 rows


Description

This table contains the course specific settings for competencies.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
courseid BIGINT 19 null
course.id compcour_cou2_fkR

The course this setting is linked to.

pushratingstouserplans TINYINT 3 null

Does this course push ratings to user plans?

timecreated BIGINT 19 null

The time this setting was created.

timemodified BIGINT 19 null

The time this setting was last modified.

usermodified BIGINT 19 null
user.id compcour_use3_fkR

The user who last modified this setting

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
compcour_cou_uix Must be unique Asc courseid
compcour_use_ix Performance Asc usermodified

Relationships