app.supplier_diversity_certifications
TableRow level security on
Self-declared supplier diversity certifications (Section 4.4.1) of a person or an external account, used only where an org runs a supplier diversity program and shared one org at a time under separate consent (app.supplier_diversity_shares). Only the owner reads and writes them: the person, or the account's Owner and Admin members.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| person_id | uuid | Yes | Person who declared it for themselves; NULL when an account owns it.References app.people.id |
| account_id | uuid | Yes | External account (company) that declared it; NULL when a person owns it.References app.organizations.id |
| diversity_kind | app.supplier_diversity_kind | No | Kind of certification. Confidential: special category data, never read by AI. |
| certifying_body | text | No | Body that certified it, for example a state DBE program, or Self-Declared. |
| certificate_number | text | Yes | Certificate number. Restricted (data.restricted.read.government_id): write-only to the owner, who sees its last four characters. |
| issued_on | date | Yes | Day issued. |
| expires_on | date | Yes | Day it expires. |
| evidence_path | text | Yes | Certificate scan: object path in the profile-media bucket, starting with the owner id. |
| created_at | timestamp with time zone | No | When the row was inserted. Set by the database. |
| created_by | uuid | Yes | Person who inserted the row, or null for a platform process. Set by the database.References app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Yes | Person who last changed the row, or null for a platform process. Set by the database.References app.people.id |
| deleted_at | timestamp with time zone | Yes | Soft delete time. A row with deleted_at set is ignored by every access helper. |