cal_course_label_history


Columns

Column Type Size Nulls Auto Default Children Parents Comments
course_id "_quest"."quest_course_id" 2147483647 null
cal_course_history.course_id cal_course_label_history_course_id_fkey1R
cal_course.course_id cal_course_label_history_course_id_fkeyR
course_as_of date 13 null
cal_course_history.course_as_of cal_course_label_history_course_id_fkey1R
label_seq int4 10 null
subject_code text 2147483647 null
cal_subject.subject_code cal_course_label_history_subject_code_fkeyR
catalog text 2147483647 null
campus_code text 2147483647 √ null
uw_campus.campus_code cal_course_label_history_campus_code_fkeyR
group_code text 2147483647 null
uw_group.group_code cal_course_label_history_group_code_fkeyR
unit_code text 2147483647 null
uw_unit.unit_code cal_course_label_history_unit_code_fkeyR
career_code "_quest"."quest_career" 2147483647 null
requisite_id "_quest"."quest_requisite_id" 2147483647 √ null
cal_requisite.requisite_id cal_course_label_history_requisite_id_fkeyR
label_schedule_print bool 1 null

Table contained 67175 rows

Indexes

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

Relationships

Close relationships within degrees of separation