uw_building


Description

A building on campus as of the most recent update to that building

Columns

Column Type Size Nulls Auto Default Children Parents Comments
building_id int4 10 null
off_instruct_section_meet_plus.building_id Implied ConstraintR
uw_room.building_id uw_room_building_id_fkeyR
uw_building_history.building_id uw_building_building_id_fkeyR
building_as_of date 13 null
uw_building_history.building_as_of uw_building_building_id_fkeyR

When this version of the building is effective
building_active bool 1 null

Whether the building is currently active
building_code text 2147483647 null

The short code for this building
building_description text 2147483647 null

The name of this building

Table contained 54 rows

Indexes

Constraint Name Type Sort Column(s)
uw_building_pkey Primary key Asc building_id

Relationships

Close relationships within degrees of separation