1. Quality Management
  2. Data model
Reference

The tables behind Quality Management

Quality Management 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
Change it
Add fields and tables in Proto

How the model is organised

Inspection work

Inspections own inspection checks; failed scope can lead to a linked Nonconformance.

Correction

Nonconformances own corrective actions, which point to an Owner in People.

Audits

Audits own audit findings; each finding has an Owner in People.

Documents

Controlled documents connect to training acknowledgments, and each acknowledgment points to a Person.

Measures

Quality objectives connect to quality reviews and have an Owner in People.

Identity

People link to Users so assignments can be tied to signed-in staff.

Every table, by feature

Inspections

5 tablesAbout this feature
  • Inspections

    Inspections records for Quality Management.

    Linked to People
  • Inspection checks

    Inspection Checks records for Quality Management.

    Linked to Inspections
  • Nonconformances

    Nonconformances records for Quality Management.

    Linked to Inspections
  • People

    People records for Quality Management.

    Linked to Users
  • Users

    Users

    Linked to Users

Nonconformances

4 tablesAbout this feature
  • Nonconformances

    Nonconformances records for Quality Management.

    Linked to Inspections
  • Inspections

    Inspections records for Quality Management.

    Linked to People
  • Inspection checks

    Inspection Checks records for Quality Management.

    Linked to Inspections
  • Corrective actions

    Corrective Actions records for Quality Management.

    Linked to Nonconformances, People

Corrective Actions

5 tablesAbout this feature
  • Corrective actions

    Corrective Actions records for Quality Management.

    Linked to Nonconformances, People
  • Nonconformances

    Nonconformances records for Quality Management.

    Linked to Inspections
  • Inspections

    Inspections records for Quality Management.

    Linked to People
  • People

    People records for Quality Management.

    Linked to Users
  • Users

    Users

    Linked to Users

Audits

4 tablesAbout this feature
  • Audits

    Audits records for Quality Management.

    Linked to People
  • Audit findings

    Audit Findings records for Quality Management.

    Linked to Audits, People
  • People

    People records for Quality Management.

    Linked to Users
  • Users

    Users

    Linked to Users

Controlled Documents

4 tablesAbout this feature
  • Controlled documents

    Controlled Documents records for Quality Management.

  • Training acknowledgments

    Training Acknowledgments records for Quality Management.

    Linked to Controlled documents, People
  • People

    People records for Quality Management.

    Linked to Users
  • Users

    Users

    Linked to Users

Quality Objectives

4 tablesAbout this feature
  • Quality objectives

    Quality Objectives records for Quality Management.

    Linked to People
  • Quality reviews

    Quality Reviews records for Quality Management.

    Linked to Quality objectives
  • People

    People records for Quality Management.

    Linked to Users
  • Users

    Users

    Linked to Users

Keys and references

Inspection checks.Inspection points to Inspections. Nonconformances.Inspection points to Inspections, and corrective actions.Nonconformance points to Nonconformances. Audit findings.Audit points to Audits. Training acknowledgments.Document points to controlled documents, while training acknowledgments.Person points to People. Quality reviews.Objective points to quality objectives. Check these links during migration before importing dependent records.

Migration order

  1. Load Users and People, then confirm the user-to-person links.
  2. Load controlled documents and quality objectives with their owners.
  3. Load Inspections and Audits with assigned people.
  4. Load inspection checks, audit findings, quality reviews and training acknowledgments under their parents.
  5. Load Nonconformances under inspections and corrective actions under issues.

Set up Quality Management your way.

Start free, then use Proto to change fields, steps and approvals before your team goes live.

How to get started