These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Hotels and Hospitality QMS
- Data model
The tables behind Hotels and Hospitality QMS
Hotels and Hospitality QMS ships with 12 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 12
- Features
- 7
- Change it
- Add fields and tables in Proto
How the model is organised
Inspection work
Inspections own inspection checks and may be referenced by property checks, guest service issues and Nonconformances.
Issue follow-up
Nonconformances own linked corrective actions; People identify assigned inspectors and action owners.
Assurance
Audits own audit findings, while controlled documents own training acknowledgments.
Access
People point to Users for the person associated with a record.
Every table, by feature
- Inspections6
- Nonconformances6
- Corrective Actions5
- Audits5
- Controlled Documents5
- Property Checks5
- Guest Service Issues5
- Inspections
Inspections records for Quality & Compliance (Source).
Linked to People - Inspection checks
Inspection Checks records for Quality & Compliance (Source).
Linked to Inspections - People
People records for Quality & Compliance (Source).
Linked to Users - Property checks
Property Checks records for Quality & Compliance (Source).
Linked to Inspections - Guest service issues
Guest Service Issues records for Quality & Compliance (Source).
Linked to Inspections - Nonconformances
Nonconformances records for Quality & Compliance (Source).
Linked to Inspections
- Nonconformances
Nonconformances records for Quality & Compliance (Source).
Linked to Inspections - Inspections
Inspections records for Quality & Compliance (Source).
Linked to People - Inspection checks
Inspection Checks records for Quality & Compliance (Source).
Linked to Inspections - Corrective actions
Corrective Actions records for Quality & Compliance (Source).
Linked to Nonconformances, People - Property checks
Property Checks records for Quality & Compliance (Source).
Linked to Inspections - Guest service issues
Guest Service Issues records for Quality & Compliance (Source).
Linked to Inspections
- Corrective actions
Corrective Actions records for Quality & Compliance (Source).
Linked to Nonconformances, People - Nonconformances
Nonconformances records for Quality & Compliance (Source).
Linked to Inspections - People
People records for Quality & Compliance (Source).
Linked to Users - Inspections
Inspections records for Quality & Compliance (Source).
Linked to People - Inspection checks
Inspection Checks records for Quality & Compliance (Source).
Linked to Inspections
- Audits
Audits records for Quality & Compliance (Source).
Linked to People - Audit findings
Audit Findings records for Quality & Compliance (Source).
Linked to Audits, People - People
People records for Quality & Compliance (Source).
Linked to Users - Inspections
Inspections records for Quality & Compliance (Source).
Linked to People - Nonconformances
Nonconformances records for Quality & Compliance (Source).
Linked to Inspections
- Controlled documents
Controlled Documents records for Quality & Compliance (Source).
- Training acknowledgments
Training Acknowledgments records for Quality & Compliance (Source).
Linked to Controlled documents, People - People
People records for Quality & Compliance (Source).
Linked to Users - Users
Users
Linked to Users - Audits
Audits records for Quality & Compliance (Source).
Linked to People
- Property checks
Property Checks records for Quality & Compliance (Source).
Linked to Inspections - Inspections
Inspections records for Quality & Compliance (Source).
Linked to People - Inspection checks
Inspection Checks records for Quality & Compliance (Source).
Linked to Inspections - Nonconformances
Nonconformances records for Quality & Compliance (Source).
Linked to Inspections - People
People records for Quality & Compliance (Source).
Linked to Users
- Guest service issues
Guest Service Issues records for Quality & Compliance (Source).
Linked to Inspections - Inspections
Inspections records for Quality & Compliance (Source).
Linked to People - Inspection checks
Inspection Checks records for Quality & Compliance (Source).
Linked to Inspections - Nonconformances
Nonconformances records for Quality & Compliance (Source).
Linked to Inspections - Corrective actions
Corrective Actions records for Quality & Compliance (Source).
Linked to Nonconformances, People
Keys and references
Each record has its own identifier or business reference. Required references tie checks to an inspection, actions to a nonconformance, findings to an audit and acknowledgments to a document and person. Preserve those links during migration. A saved list such as Open inspections is a filtered view of Inspections, not another table.
Migration order
- Prepare Users and People so assignments and ownership references resolve.
- Bring in controlled documents, then training acknowledgments linked to their documents and people.
- Bring in Inspections, then inspection checks, property checks and guest service issues linked to inspections.
- Bring in Nonconformances against inspections, then corrective actions against nonconformances and People.
- Bring in Audits, then audit findings linked to audits and People.
Set up Hotels and Hospitality QMS your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.