uw_unit_history


Description

An academic unit (department, school, or other unit) as of a particular date

Columns

Column Type Size Nulls Auto Default Children Parents Comments
unit_code text 2147483647 null
uw_unit.unit_code uw_unit_unit_code_fkeyR
unit_as_of date 13 null
uw_unit.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_history_campus_code_fkeyR
group_code text 2147483647 null
uw_group.group_code uw_unit_history_group_code_fkeyR

Table contained 95 rows

Indexes

Constraint Name Type Sort Column(s)
uw_unit_history_pkey Primary key Asc/Asc unit_code + unit_as_of

Relationships

Close relationships within degrees of separation