Equipment 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. This focused diagram leaves shared-domain target tables, such as users, rooms, and projects, out of view while retaining their foreign-key columns.

Main relationships

• equipment_equipment is the central record. Its foreign keys establish the equipment's placement, ownership, classification, and primary equipment module.

• Equipment categories and category types provide classification. Equipment modules extend an equipment record with module types, parameters, assets, functions, status rules, ECNs, issues, and change history.

• Access and scheduling are modelled through equipment users, roles, requests and approval flows, reservations, and reservation blocks.

• Operational history is split into logging data and service-processing configuration, preventive-maintenance schedules and executions, documents, links, properties, pictures, and status-mail records.

Use this view to follow persistence around an equipment record. Follow an FK into the full ERD when the relationship continues into Room, Organisation, Process, or another shared domain.