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.
- Lean Manufacturing Tools
- Data model
The tables behind Lean Manufacturing Tools
Lean Manufacturing Tools ships with 13 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
- 13
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
5S Audits
Audits defines scope, dates and auditor. Five S audit checks links category scoring to an audit. Audit findings links the requirement, severity and response owner to that same audit.
Kaizen Improvement
Kaizen proposals retains Area, Problem, proposed change, Status and Owner. The owner points to People.
Inspections
Inspections defines the subject and assigned person; inspection checks carries the linked requirements, observations and results.
Nonconformance Control
Nonconformances points to the originating Inspection and records the failure's detection date, severity and state.
Corrective Action Review
Corrective actions connects each response and owner to a Nonconformance. Corrective action reviews preserves the decision, evidence and reviewer with operation key and input hash for repeat-operation handling.
Document Control
Controlled documents retains the document version, attachment and status. Training acknowledgments joins Document and Person with acknowledged at.
Identity
People links a named person to Users through User. The published model includes the Users.User self-reference; preserve it when mapping existing identities.
Every table, by feature
- 5S Audits4
- Kaizen Improvement2
- Inspections3
- Nonconformance Control3
- Corrective Action Review4
- Document Control3
- Shared and settings1
- Audits
Lean Manufacturing Tools Audits records
Linked to People - Five s audit checks
Lean Manufacturing Tools Five S Audit Checks records
Linked to Audits - Audit findings
Lean Manufacturing Tools Audit Findings records
Linked to Audits, People - People
Lean Manufacturing Tools People records
Linked to Users
- Kaizen proposals
Lean Manufacturing Tools Kaizen Proposals records
Linked to People - People
Lean Manufacturing Tools People records
Linked to Users
- Inspections
Lean Manufacturing Tools Inspections records
Linked to People - Inspection checks
Lean Manufacturing Tools Inspection Checks records
Linked to Inspections - People
Lean Manufacturing Tools People records
Linked to Users
- Nonconformances
Lean Manufacturing Tools Nonconformances records
Linked to Inspections - Inspections
Lean Manufacturing Tools Inspections records
Linked to People - Corrective actions
Lean Manufacturing Tools Corrective Actions records
Linked to Nonconformances, People
- Corrective actions
Lean Manufacturing Tools Corrective Actions records
Linked to Nonconformances, People - Corrective action reviews
Immutable review/effectiveness log for WF-03. Doubles as the idempotency ledger: one row per accepted or rejected operation key.
Linked to Corrective actions, People - Nonconformances
Lean Manufacturing Tools Nonconformances records
Linked to Inspections - People
Lean Manufacturing Tools People records
Linked to Users
- Controlled documents
Lean Manufacturing Tools Controlled Documents records
- Training acknowledgments
Lean Manufacturing Tools Training Acknowledgments records
Linked to Controlled documents, People - People
Lean Manufacturing Tools People records
Linked to Users
Keys and references
Use the actual record identity for every reference. Audit number and inspection number help people identify work, while their links must resolve to the intended records. Confirm People.User before enabling personal views or authenticated commands. A display name alone does not establish which person is signed in.
Keep corrective review operations distinguishable by operation key and input hash. Preserve the original accepted or rejected decision when handling retries. Retain document identities that historical acknowledgments reference, and agree how a replacement version is introduced before importing document history.
Migration order
- Resolve Users and People identities, including active people and account mappings.
- Load Audits, Inspections and controlled documents with the intended source identities.
- Load five S audit checks, audit findings and inspection checks against their correct parent records.
- Load kaizen proposals and Nonconformances with their owner or inspection references.
- Load corrective actions, then preserve authorized corrective action reviews history without replaying decisions as new work.
- Load training acknowledgments against the exact document and person, then rehearse personal access and linked closure behavior.
Set up Lean Manufacturing Tools your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.