cal_subject


Description

A subject code under which a course may be offered

Columns

Column Type Size Nulls Auto Default Children Parents Comments
subject_code text 2147483647 null
teaching_admin_subject.subject_code teaching_admin_subject_subject_code_fkeyR
offer_course_term.subject_code offer_course_term_subject_code_fkeyR
cal_course_label_history.subject_code cal_course_label_history_subject_code_fkeyR
off_course_section_complete.subject_code Implied ConstraintR
off_course_section_plus.subject_code Implied ConstraintR
std_term_course_plus.subject_code Implied ConstraintR
std_transfer_credit_detail_plus.subject_code Implied ConstraintR
cal_subject_history.subject_code cal_subject_subject_code_fkeyR
subject_as_of date 13 null
cal_subject_history.subject_as_of cal_subject_subject_code_fkeyR
subject_active bool 1 null
subject_description text 2147483647 null
subject_short_description text 2147483647 null
unit_code text 2147483647 null
uw_unit.unit_code cal_subject_unit_code_fkeyR

Table contained 236 rows

Indexes

Constraint Name Type Sort Column(s)
cal_subject_pkey Primary key Asc subject_code

Relationships

Close relationships within degrees of separation