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

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
unit_code text 2147483647
cal_course_label.unit_code cal_course_label_unit_code_fkey R
cal_course_label_history.unit_code cal_course_label_history_unit_code_fkey R
cal_subject.unit_code cal_subject_unit_code_fkey R
cal_subject_history.unit_code cal_subject_history_unit_code_fkey R
off_course_section_complete.unit_code Implied Constraint R
off_course_section_plus.unit_code Implied Constraint R
off_instruct_section_meet_plus.unit_code Implied Constraint R
pps_plan.unit_code pps_plan_unit_code_fkey R
pps_plan_history.unit_code pps_plan_history_unit_code_fkey R
pps_program.unit_code pps_program_unit_code_fkey R
pps_program_history.unit_code pps_program_history_unit_code_fkey R
std_term_plan_plus.unit_code Implied Constraint R
uw_room.unit_code uw_room_unit_code_fkey R
uw_unit_history.unit_code uw_unit_unit_code_fkey R
unit_as_of date 13
uw_unit_history.unit_as_of uw_unit_unit_code_fkey R
unit_active bool 1
unit_short_description text 2147483647
unit_description text 2147483647
unit_full_description text 2147483647
campus_code text 2147483647
uw_campus.campus_code uw_unit_campus_code_fkey R
group_code text 2147483647  √  null
uw_group.group_code uw_unit_group_code_fkey R

Table contained 70 rows at Wed Feb 19 10:30 EST 2014

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

Close relationships  within of separation: