building

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
room.building_id fk_room_building_id N
room_summary.building_id fk_room_summary_building_id N
name text 2147483647 √ null
ref_code varchar 2147483647 √ null

Indexes

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

Relationships

Close relationships within degrees of separation