room

283 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
intf_keycard_logs.room_id intf_room_room_id_fk C
intf_room.room_id intf_room_room_id_fk C
out_of_order.room_id fk_out_of_order_room_id C
registration.room_id fk_registration_room_id R
room.connecting_room fk_room_connecting_room N
room_block.room_id fk_room_block_room_id C
room_status.room_id fk_room_status_room_id C
room_summary.room_id fk_room_summary_room_id N
room_number t_room_number 2147483647 null
roomtype_id int4 10 null
room_type.id fk_room_roomtype_id R
bedtype_id int4 10 √ null
bed_type.id fk_room_bedtype_id N
location_id int4 10 √ null
room_location.id fk_room_location_id N
building_id int4 10 √ null
building.id fk_room_building_id N
exposure_id int4 10 √ null
room_exposure.id fk_room_exposure_id N
connecting bool 1 √ false
connecting_room int4 10 √ null
room.id fk_room_connecting_room N
facilities _int4 10 √ null
connect_rooms _int4 10 √ null
remark text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_rooom Primary key Asc id
idx_room_bedtype_id Performance Asc bedtype_id
idx_room_building_id Performance Asc building_id
idx_room_connecting_room Performance Asc connecting_room
idx_room_exposure_id Performance Asc exposure_id
idx_room_location_id Performance Asc location_id
idx_room_roomtype_id Performance Asc roomtype_id
unq_room_room_number Must be unique Asc room_number

Relationships

Close relationships within degrees of separation