uw_unit


Description

An academic unit (department, school, or other unit) as of the most recent update to that unit in uw_unit_history

Columns

Column Type Size Nulls Auto Default Children Parents Comments
unit_code text 2147483647 null
work_application_instance.unit_code work_application_instance_unit_code_fkeyR
exam_unit.unit_code exam_unit_unit_code_fkeyR
ta_plan_entitlement.unit_code ta_plan_entitlement_unit_code_fkeyR
ta_unit.unit_code ta_unit_unit_code_fkeyR
teaching_admin_unit.unit_code teaching_admin_unit_unit_code_fkeyR
cal_course_label_history.unit_code cal_course_label_history_unit_code_fkeyR
cal_subject.unit_code cal_subject_unit_code_fkeyR
cal_subject_history.unit_code cal_subject_history_unit_code_fkeyR
off_course_section_complete.unit_code Implied ConstraintR
off_course_section_plus.unit_code Implied ConstraintR
off_instruct_section_meet_plus.unit_code Implied ConstraintR
pps_plan.unit_code pps_plan_unit_code_fkeyR
pps_plan_history.unit_code pps_plan_history_unit_code_fkeyR
pps_program.unit_code pps_program_unit_code_fkeyR
pps_program_history.unit_code pps_program_history_unit_code_fkeyR
std_term_course_plus.unit_code Implied ConstraintR
std_term_plan_plus.unit_code Implied ConstraintR
uw_room.unit_code uw_room_unit_code_fkeyR
uw_unit_history.unit_code uw_unit_unit_code_fkeyR
unit_as_of date 13 null
uw_unit_history.unit_as_of uw_unit_unit_code_fkeyR
unit_active bool 1 null
unit_short_description text 2147483647 null
unit_description text 2147483647 null
unit_full_description text 2147483647 null
campus_code text 2147483647 null
uw_campus.campus_code uw_unit_campus_code_fkeyR
group_code text 2147483647 null
uw_group.group_code uw_unit_group_code_fkeyR

Table contained 71 rows

Indexes

Constraint Name Type Sort Column(s)
uw_unit_pkey Primary key Asc unit_code

Relationships

Close relationships within degrees of separation