Competency Coursecompsetting Table Schema (competency_coursecompsetting)


Description

This table contains the course specific settings for competencies.

competency_coursecompsetting table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
courseid bigint 10 null
course.id Implied Constraint R

The course this setting is linked to.

pushratingstouserplans tinyint 2 null

Does this course push ratings to user plans?

timecreated bigint 10 null

The time this setting was created.

timemodified bigint 10 null

The time this setting was last modified.

usermodified bigint 10 null

The user who last modified this setting

Table contained -1 rows

competency_coursecompsetting table indexes

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

competency_coursecompsetting table relationships