Table odyssey_test._quest.uw_room
A room in which events may be held

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
building_id int4 10
room_code text 2147483647
facility_as_of date 13
room_description text 2147483647
facility_active bool 1
facility_id text 2147483647
facility_type_code text 2147483647
location_code text 2147483647
uw_location.location_code Implied Constraint R
room_capacity int4 10
unit_code text 2147483647  √  null
uw_unit.unit_code uw_room_unit_code_fkey R
facility_partition int4 10  √  null

Table contained 810 rows at Wed Feb 19 10:30 EST 2014

Indexes:
Column(s) Type Sort Constraint Name
building_id + room_code Primary key Asc/Asc uw_room_pkey

Close relationships  within of separation: