Room entity relationship diagram

Reading the diagram

Each box is a database table and lists its mapped columns. Columns marked FK hold a relationship to another entity. The text beside a connecting line is the Doctrine association name; 1, 0..1, and 0..* indicate required single, optional single, and zero-or-more relationships respectively. Shared references, including users, equipment, projects, and labels, may be represented only by the foreign-key column in this domain-focused view.

Main relationships

• Physical structure starts with room_site, which has buildings; each room_room belongs to a building. Sites and rooms can each have floor-plan records.

• A room has zone groups, and each zone group has zones. Locations belong to a zone group and can use an optional subdivision template; zone reservations and zone-user records capture local allocation and access.

• Room access is modelled by room roles and room users, plus room requests and their approval-flow records. Requests can retain a mentor reference.

• Documents, links, programme assignments, project assignments, mailing recipients, and room properties extend the core room record without changing the physical hierarchy.

Use this view to trace facilities, zones, and room access data. Follow an FK into the full ERD when a relationship crosses into Equipment, Chemical, Organisation, or another domain.