cal_course


Description

A course as defined in the Calendar

Columns

Column Type Size Nulls Auto Default Children Parents Comments
course_id "_quest"."quest_course_id" 2147483647 null
teaching_admin_course.course_id teaching_admin_course_course_id_fkeyR
cal_course_label_history.course_id cal_course_label_history_course_id_fkeyR
off_course.course_id Implied ConstraintR
off_course_section_complete.course_id Implied ConstraintR
off_course_section_plus.course_id Implied ConstraintR
std_term_course_plus.course_id Implied ConstraintR
std_term_course_section.course_id Implied ConstraintR
std_transfer_credit_detail.course_id std_transfer_credit_detail_course_id_fkeyR
std_transfer_credit_detail_plus.course_id Implied ConstraintR
cal_course_history.course_id cal_course_course_id_fkeyR
course_as_of date 13 null
cal_course_history.course_as_of cal_course_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 15437 rows

Indexes

Constraint Name Type Sort Column(s)
cal_course_pkey Primary key Asc course_id

Relationships

Close relationships within degrees of separation