1. QMS for Electronics Manufacturing
  2. Data model
Reference

The tables behind QMS for Electronics Manufacturing

QMS for Electronics Manufacturing 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 is the parent record for inspection checks and Nonconformances.

Electronics evidence

Board defects and ESD checks each use operational record to point to Inspections.

Correction

Corrective actions points to Nonconformances and to its Owner in People.

Audit

Audit findings points to Audits and to its Owner in People; Audits has an Auditor in People.

Documents

Training acknowledgments connects controlled documents with the Person in People.

Access

People connects to Users and supplies the named assignee and action owner.

Every table, by feature

Inspections

4 tablesAbout this feature
  • 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

Board defects

4 tablesAbout this feature
  • Board defects

    Board Defects 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

ESD checks

4 tablesAbout this feature
  • ESD checks

    ESD 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

Nonconformances

6 tablesAbout this feature
  • 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
  • Board defects

    Board Defects records for Quality & Compliance (Source).

    Linked to Inspections
  • ESD checks

    ESD Checks records for Quality & Compliance (Source).

    Linked to Inspections

Corrective actions

5 tablesAbout this feature
  • 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
  • Inspection checks

    Inspection Checks records for Quality & Compliance (Source).

    Linked to Inspections
  • People

    People records for Quality & Compliance (Source).

    Linked to Users

Audits and documents

6 tablesAbout this feature
  • 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
  • Users

    Users

    Linked to Users

Keys and references

An inspection number identifies the human case while the record reference binds its checks, board defects, ESD checks and nonconformances. Corrective actions reference a nonconformance; that chain leads back to the inspection and check evidence. A document acknowledgment references a particular controlled document record and a person. Preserve those references during import so a status can be explained from its source evidence.

Migration order

  1. Load Users and People, then confirm the People-to-Users reference.
  2. Load controlled documents and Audits with their version and audit numbers.
  3. Load Inspections with subject references, types, assignees and current states.
  4. Load inspection checks, board defects, ESD checks and Nonconformances against their inspection references.
  5. Load corrective actions, audit findings and training acknowledgments after their parent records exist.
  6. Compare imported cases with their original evidence and review the active queues before daily use.

Set up QMS for Electronics Manufacturing your way.

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

How to get started