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.
- Manufacturing QMS
- Data Model
The tables behind Manufacturing QMS
Manufacturing 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 own inspection checks and reference the assigned person.
Production context
Production inspection lots point to Inspections; defect observations point to their production inspection lots.
Issue work
Nonconformances point to Inspections; corrective actions point to their Nonconformances and owners.
Audit work
Audits own audit findings, with People referenced for auditor and finding owner.
Document work
Controlled documents own training acknowledgments; each acknowledgment references a person.
Access identity
People link to Users for person attribution.
Every table, by feature
- Inspections4
- Production Lots3
- Defect Observations4
- Nonconformances5
- Corrective Actions4
- Audits and Documents5
- Shared and settings1
- Inspections
Inspections records for QMS for Manufacturing.
Linked to People - Inspection checks
Inspection Checks records for QMS for Manufacturing.
Linked to Inspections - People
People records for QMS for Manufacturing.
Linked to Users - Nonconformances
Nonconformances records for QMS for Manufacturing.
Linked to Inspections
- Production inspection lots
Production Inspection Lots records for QMS for Manufacturing.
Linked to Inspections - Inspections
Inspections records for QMS for Manufacturing.
Linked to People - Defect observations
Defect Observations records for QMS for Manufacturing.
Linked to Production inspection lots
- Defect observations
Defect Observations records for QMS for Manufacturing.
Linked to Production inspection lots - Production inspection lots
Production Inspection Lots records for QMS for Manufacturing.
Linked to Inspections - Inspections
Inspections records for QMS for Manufacturing.
Linked to People - Inspection checks
Inspection Checks records for QMS for Manufacturing.
Linked to Inspections
- Nonconformances
Nonconformances records for QMS for Manufacturing.
Linked to Inspections - Inspections
Inspections records for QMS for Manufacturing.
Linked to People - Inspection checks
Inspection Checks records for QMS for Manufacturing.
Linked to Inspections - Corrective actions
Corrective Actions records for QMS for Manufacturing.
Linked to Nonconformances, People - Production inspection lots
Production Inspection Lots records for QMS for Manufacturing.
Linked to Inspections
- Corrective actions
Corrective Actions records for QMS for Manufacturing.
Linked to Nonconformances, People - Nonconformances
Nonconformances records for QMS for Manufacturing.
Linked to Inspections - People
People records for QMS for Manufacturing.
Linked to Users - Inspections
Inspections records for QMS for Manufacturing.
Linked to People
- Audits
Audits records for QMS for Manufacturing.
Linked to People - Audit findings
Audit Findings records for QMS for Manufacturing.
Linked to Audits, People - Controlled documents
Controlled Documents records for QMS for Manufacturing.
- Training acknowledgments
Training Acknowledgments records for QMS for Manufacturing.
Linked to Controlled documents, People - People
People records for QMS for Manufacturing.
Linked to Users
Keys and references
Use the inspection number and subject reference to distinguish reviewed scopes. A production inspection lots record stores the work order reference, product code and lot number as text, with its operational record pointing to Inspections. Defect observations.Lot points to that saved lot. Inspection checks.Inspection and Nonconformances.Inspection lead to the same quality decision. Corrective actions.Nonconformance keeps later work tied to the issue. Audit findings.Audit and training acknowledgments.Document preserve their parent histories.
Migration order
- Import Users and People so assignments resolve.
- Import controlled documents and Audits, then their training acknowledgments and audit findings.
- Import Inspections, then inspection checks and production inspection lots.
- Import defect observations and Nonconformances once their parent references exist.
- Import corrective actions against the correct Nonconformances and owners.
Set up Manufacturing QMS your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.