uw_campus_history


Description

A campus on which classes may be held, as of a particular date

Columns

Column Type Size Nulls Auto Default Children Parents Comments
campus_code text 2147483647 null
uw_campus.campus_code uw_campus_campus_code_fkeyR
campus_as_of date 13 null
uw_campus.campus_as_of uw_campus_campus_code_fkeyR
campus_active bool 1 null
campus_description text 2147483647 null
campus_short_description text 2147483647 null
location_code text 2147483647 null
uw_location.location_code uw_campus_history_location_code_fkeyR

Table contained 47 rows

Indexes

Constraint Name Type Sort Column(s)
uw_campus_history_pkey Primary key Asc/Asc campus_code + campus_as_of

Relationships

Close relationships within degrees of separation