The digital version of our on-site inspection certificate — capture registration details, organization information, category scores and inspector sign-off. Percentages, the overall compliance score and the safety status compute live as you type.
Everything on this form maps to six related tables. PK marks a primary key, FK a foreign key. One organization can have many inspections; each inspection holds ten assessment scores, is carried out by one inspector, produces one certificate, and each certificate can be verified many times.
| Parent table | Child table | Linking key | Relationship | Meaning |
|---|---|---|---|---|
| ORGANIZATION | INSPECTION | org_id | 1 : N | One organization is inspected many times over the years |
| INSPECTOR | INSPECTION | inspector_id | 1 : N | One inspector conducts many inspections |
| INSPECTION | ASSESSMENT_SCORE | inspection_id | 1 : 10 | Every inspection records exactly ten category scores |
| CATEGORY | ASSESSMENT_SCORE | category_id | 1 : N | Each category is scored across many inspections |
| INSPECTION | CERTIFICATE | inspection_id | 1 : 1 | A passing inspection issues exactly one certificate |
| CERTIFICATE | VERIFICATION_LOG | certificate_no | 1 : N | One certificate is verified many times by employers and the public |
| org_id | Organization | inspection_id | Score | Status | certificate_no | Valid until | Verifications |
|---|---|---|---|---|---|---|---|
| 101 | Alfa Textile Mills | 5001 | 92 / 100 | Excellent | PHSO-HSE-2026-0141 | 12 Dec 2026 | 38 |
| 101 | Alfa Textile Mills | 4620 | 84 / 100 | Good | PHSO-HSE-2025-0902 | Expired · renewed | 21 |
| 102 | City Care Hospital | 5002 | 76 / 100 | Satisfactory | PHSO-HSE-2026-0142 | 03 Jan 2027 | 12 |
| 103 | Metro Builders (Site B) | 5003 | 58 / 100 | Non-compliant | — corrective actions | — | — |
Rows 1–2 show the six-month renewal relationship: the same org_id (101) appears across multiple inspections, each producing its own certificate.