cal_course_history


Columns

Column Type Size Nulls Auto Default Children Parents Comments
course_id "_quest"."quest_course_id" 2147483647 null
cal_course.course_id cal_course_course_id_fkeyR
cal_course_component.course_id cal_course_component_course_id_fkeyR
cal_course_label_history.course_id cal_course_label_history_course_id_fkey1R
cal_course_topic_history.course_id cal_course_topic_history_course_id_fkeyR
off_course_as_of.course_id off_course_as_of_course_id_fkeyR
course_as_of date 13 null
cal_course.course_as_of cal_course_course_id_fkeyR
cal_course_component.course_as_of cal_course_component_course_id_fkeyR
cal_course_label_history.course_as_of cal_course_label_history_course_id_fkey1R
cal_course_topic_history.course_as_of cal_course_topic_history_course_id_fkeyR
off_course_as_of.course_as_of off_course_as_of_course_id_fkeyR
course_active bool 1 null
course_short_title text 2147483647 null
course_title text 2147483647 null
course_description text 2147483647 √ null
course_take_units numeric 5,2 null
course_ap_units numeric 5,2 null
course_add_consent "_quest"."quest_consent" 2147483647 null
course_drop_consent "_quest"."quest_consent" 2147483647 null

Table contained 65090 rows

Indexes

Constraint Name Type Sort Column(s)
cal_course_history_pkey Primary key Asc/Asc course_id + course_as_of

Relationships

Close relationships within degrees of separation