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.
- Aerospace and Defense QMS
- Data model
The tables behind Aerospace and Defense QMS
Aerospace and Defense 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 connect to inspection checks, first article checks and Nonconformances.
Corrective work
Nonconformances connect to corrective actions, which name an Owner in People.
Audit work
Audits connect to audit findings and their owners.
Document work
Controlled documents connect to training acknowledgments and the acknowledging Person.
Trace work
Material trace links retain certificate attachments and a verifying person.
Every table, by feature
- Inspection execution3
- Inspection disposition4
- Corrective actions4
- Audit management3
- Controlled documents3
- Trace evidence5
- Shared and settings1
- Inspections
Quality inspections for aerospace and defense programs: incoming, in-process, final and service verification of parts and assemblies.
Linked to People - Inspection checks
Characteristic-level inspection checks recorded against an inspection, with requirement, observation, result and evidence.
Linked to Inspections - People
QMS people directory: quality managers, inspectors, auditors and approvers, each linked to their platform user.
Linked to Users
- Inspections
Quality inspections for aerospace and defense programs: incoming, in-process, final and service verification of parts and assemblies.
Linked to People - Inspection checks
Characteristic-level inspection checks recorded against an inspection, with requirement, observation, result and evidence.
Linked to Inspections - Nonconformances
Nonconformances raised from inspections, with severity, containment, investigation and disposition state.
Linked to Inspections - People
QMS people directory: quality managers, inspectors, auditors and approvers, each linked to their platform user.
Linked to Users
- Corrective actions
Corrective and preventive actions linked to a nonconformance, with root cause, action plan and effectiveness review.
Linked to Nonconformances, People - Nonconformances
Nonconformances raised from inspections, with severity, containment, investigation and disposition state.
Linked to Inspections - Inspections
Quality inspections for aerospace and defense programs: incoming, in-process, final and service verification of parts and assemblies.
Linked to People - People
QMS people directory: quality managers, inspectors, auditors and approvers, each linked to their platform user.
Linked to Users
- Audits
AS9100 internal and supplier quality audits with scope, auditor, planned date and lifecycle status.
Linked to People - Audit findings
Audit findings linked to their source audit requirement, with severity, owner and due date.
Linked to Audits, People - People
QMS people directory: quality managers, inspectors, auditors and approvers, each linked to their platform user.
Linked to Users
- Controlled documents
Controlled quality documents with version, effective date and lifecycle status.
- Training acknowledgments
Recorded acknowledgment of a controlled document by a person, with the acknowledgment timestamp.
Linked to Controlled documents, People - People
QMS people directory: quality managers, inspectors, auditors and approvers, each linked to their platform user.
Linked to Users
- First article checks
First article characteristic verification against an operational inspection record, with requirement, actual result and disposition.
Linked to Inspections - Material trace links
Material traceability links: part serial, heat number and supplier/process certificates with the verifying person.
Linked to People - Inspections
Quality inspections for aerospace and defense programs: incoming, in-process, final and service verification of parts and assemblies.
Linked to People - Inspection checks
Characteristic-level inspection checks recorded against an inspection, with requirement, observation, result and evidence.
Linked to Inspections - People
QMS people directory: quality managers, inspectors, auditors and approvers, each linked to their platform user.
Linked to Users
Keys and references
Each record has its own Id or identifying field. Inspection checks.Inspection, first article checks.operational record and Nonconformances.Inspection point to Inspections. Corrective actions.Nonconformance points to Nonconformances. Audit findings.Audit points to Audits. Training acknowledgments.Document points to controlled documents. People.User points to Users. Preserve these references during import so a result still leads to its source case.
Migration order
- People and users. Establish the people who own, inspect and approve work.
- Core cases. Load controlled documents, Audits and Inspections with their identities and dates.
- Linked evidence. Load inspection checks, first article checks, audit findings, material trace links and training acknowledgments against the correct parents.
- Quality follow-up. Load Nonconformances and then corrective actions, retaining their inspection and parent links.
- Reconcile. Open representative cases and compare their linked evidence with the original record set.
Set up Aerospace and Defense QMS your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.