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.
- Food and Beverage QMS
- Data model
The tables behind Food and Beverage QMS
Food and Beverage 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
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Inspection work
Inspections connects assigned work to inspection checks and the final review outcome.
Food and beverage checks
HACCP checks and allergen verifications each reference the operational Inspections record.
Issue follow-up
Nonconformances references Inspections; corrective actions references Nonconformances.
Audit evidence
Audit findings references Audits and an owner in People.
Document evidence
Training acknowledgments references controlled documents and People.
Access
People references Users; assignments point to People.
Every table, by feature
- Inspections4
- HACCP checks4
- Allergen verification4
- Nonconformances4
- Corrective actions4
- Audits and documents5
- Shared and settings1
- 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 - Nonconformances
Nonconformances records for Quality & Compliance (Source).
Linked to Inspections
- HACCP checks
HACCP Checks records for Quality & Compliance (Source).
Linked to Inspections - Inspections
Inspections records for Quality & Compliance (Source).
Linked to People - People
People records for Quality & Compliance (Source).
Linked to Users - Nonconformances
Nonconformances records for Quality & Compliance (Source).
Linked to Inspections
- Allergen verifications
Allergen Verifications records for Quality & Compliance (Source).
Linked to Inspections - Inspections
Inspections records for Quality & Compliance (Source).
Linked to People - Nonconformances
Nonconformances records for Quality & Compliance (Source).
Linked to Inspections - People
People records for Quality & Compliance (Source).
Linked to Users
- 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
- Corrective actions
Corrective Actions records for Quality & Compliance (Source).
Linked to Nonconformances, People - Nonconformances
Nonconformances records for Quality & Compliance (Source).
Linked to Inspections - Inspections
Inspections records for Quality & Compliance (Source).
Linked to People - People
People records for Quality & Compliance (Source).
Linked to Users
- Audits
Audits records for Quality & Compliance (Source).
Linked to People - Audit findings
Audit Findings records for Quality & Compliance (Source).
Linked to Audits, People - 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
Keys and references
The source inspection is the central reference for check evidence and rejected-case follow-up. Use inspection number and subject reference to identify the work in daily use. Product lot is entered on a HACCP check, while Line, previous allergen and next product identify the changeover. Corrective action and finding owners point to People. Acknowledgments attach a person to a controlled document record.
Migration order
- People and access. Establish Users and People before assigning work.
- Quality references. Load controlled documents and the operating inspection subjects.
- Inspection history. Load Inspections before inspection checks, HACCP checks, allergen verifications and Nonconformances.
- Follow-up. Load corrective actions after their parent nonconformances.
- Audits and acknowledgments. Load Audits before audit findings and controlled documents before training acknowledgments.
Set up Food and Beverage QMS your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.