uw_room


Description

A room in which events may be held

Columns

Column Type Size Nulls Auto Default Children Parents Comments
building_id int4 10 null
uw_building.building_id uw_room_building_id_fkeyR
room_code text 2147483647 null
facility_as_of date 13 null
room_description text 2147483647 null
facility_active bool 1 null
facility_id text 2147483647 null
off_instruct_section_meet.facility_id off_instruct_section_meet_facility_id_fkeyR
off_instruct_section_meet_plus.facility_id Implied ConstraintR
facility_type_code text 2147483647 null
location_code text 2147483647 null
uw_location.location_code Implied ConstraintR
room_capacity int4 10 null
unit_code text 2147483647 √ null
uw_unit.unit_code uw_room_unit_code_fkeyR
facility_partition int4 10 √ null

Table contained 1006 rows

Indexes

Constraint Name Type Sort Column(s)
uw_room_pkey Primary key Asc facility_id
uw_room_building_id_room_code_facility_id_key Must be unique Asc/Asc/Asc building_id + room_code + facility_id

Relationships

Close relationships within degrees of separation