room_location

14 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
room.location_id fk_room_location_id N
room_summary.location_id fk_room_summary_location_id N
name text 2147483647 √ null
ref_code varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_room_location Primary key Asc id
unq_room_location_name Must be unique Asc name

Relationships

Close relationships within degrees of separation