0..*
site 1
0..*
room 1
0..1
document 1
0..*
room 1
0..*
label 0..1
0..*
zoneGroup 1
0..*
building 1
0..*
label 0..1
0..*
room 1
0..*
type 1
0..*
room 1
0..*
room 0..1
0..*
room 1
0..*
request 1
0..*
role 1
0..*
room 1
0..*
room 1
0..*
site 1
0..*
group 1
0..*
label 0..1
0..*
room 1
0..*
group 1
0..*
recurringLink 0..1
0..*
zone 1
0..*
zone 1
room_building
id: integer
code: string
name: string
status: smallint
dateCreated: datetime
lastUpdate: datetime
site_id: FK
room_document
id: integer
description: text
date_added: datetime
lastUpdate: datetime
filename: text
user_id: FK
room_id: FK
room_document_file
id: integer
file: blob
document_id: FK
room_floorplan
id: integer
mimeType: string
extension: string
fileSize: integer
width: integer
height: integer
type: integer
dateCreated: datetime
lastUpdate: datetime
image: blob
room_id: FK
room_location
id: integer
name: string
code: string
status: boolean
dateCreated: datetime
lastUpdate: datetime
zone_group_id: FK
label_id: FK
room_location_subdivision_template
id: integer
name: string
rows: smallint
columns: smallint
orientation: smallint
rowLabelType: string
columnLabelType: string
labelFormat: string
custom_labels: json
dateCreated: datetime
lastUpdate: datetime
room_role
id: integer
title: string
description: text
sequence: integer
room_room
id: integer
name: text
code: string
department: string
purpose: string
tags: string
opening_time: time
closing_time: time
openingHoursOnReservationsEnforcement: integer
lastUpdate: datetime
description: text
phone: text
location_details: text
status: smallint
training_description: text
building_id: FK
label_id: FK
room_room_link
id: integer
dateCreated: datetime
lastUpdate: datetime
name: string
url: string
room_id: FK
type_id: FK
room_room_link_type
id: integer
dateCreated: datetime
lastUpdate: datetime
name: string
room_room_mailing_recipient
id: integer
type: string
title: string
description: string
room_room_program
id: integer
dateCreated: datetime
isActive: boolean
program_id: FK
room_id: FK
room_room_project
id: integer
dateCreated: datetime
isActive: boolean
project_id: FK
wbs_id: FK
room_id: FK
room_room_request
id: integer
dateCreated: datetime
lastUpdate: datetime
hasMentorApproval: boolean
reason: text
equipment: text
materials: text
frequency: text
status: smallint
room_id: FK
user_id: FK
user_mentor_id: FK
room_room_request_flow
id: integer
order: integer
dateCreated: datetime
lastUpdate: datetime
comment: text
status: smallint
request_id: FK
user_id: FK
room_room_role
id: integer
dateCreated: datetime
lastUpdate: datetime
comment: text
status: smallint
inApprovalFlow: smallint
room_id: FK
user_id: FK
role_id: FK
room_room_user
id: integer
dateCreated: datetime
lastUpdate: datetime
comment: text
status: smallint
room_id: FK
user_id: FK
user_mentor_id: FK
room_site
id: integer
code: string
name: string
dateCreated: datetime
lastUpdate: datetime
hasExternalChemicalLabelling: boolean
room_site_floor_plan
id: integer
mimeType: string
extension: string
fileSize: integer
width: integer
height: integer
type: integer
dateCreated: datetime
lastUpdate: datetime
image: blob
site_id: FK
room_zone
id: integer
name: string
dateCreated: datetime
lastUpdate: datetime
description: text
status: smallint
group_id: FK
label_id: FK
room_zone_group
id: integer
dateCreated: datetime
lastUpdate: datetime
name: string
description: text
capacity: smallint
room_id: FK
room_zone_group_user
id: integer
dateCreated: datetime
lastUpdate: datetime
isActive: boolean
group_id: FK
user_id: FK
room_zone_reservation
id: integer
time_start: datetime
time_end: datetime
recurring: integer
recurringEndDate: datetime
type: integer
title: string
recurring_link_id: FK
user_id: FK
zone_id: FK
room_zone_user
id: integer
dateCreated: datetime
lastUpdate: datetime
isActive: boolean
zone_id: FK
user_id: FK
chemical_label