uw_building_history


Description

A building on campus as of a specific date

Columns

Column Type Size Nulls Auto Default Children Parents Comments
building_id int4 10 null
uw_building.building_id uw_building_building_id_fkeyR
building_as_of date 13 null
uw_building.building_as_of uw_building_building_id_fkeyR
building_active bool 1 null

Whether the building is active
building_code text 2147483647 null

The short code for this building
building_description text 2147483647 null

The name of this building

Table contained 64 rows

Indexes

Constraint Name Type Sort Column(s)
uw_building_history_pkey Primary key Asc/Asc building_id + building_as_of

Relationships

Close relationships within degrees of separation