app.supplier_diversity_events
TableRow level security on
The owner's access log for their supplier diversity certifications (Section 8.4 access transparency): every change they make, every share and revocation, and every read by an org, never a value. Written only by the database; the owner reads all of theirs and an org's audit readers read the rows naming their org.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| supplier_diversity_certification_id | uuid | No | Certification touched.References app.supplier_diversity_certifications.id |
| person_id | uuid | Yes | Owner, when a person owns it.References app.people.id |
| account_id | uuid | Yes | Owner, when an external account owns it.References app.organizations.id |
| actor_person_id | uuid | Yes | Person who acted; NULL for the database.References app.people.id |
| org_id | uuid | Yes | Org the certification was shared with or read by; NULL for the owner's own changes.References app.organizations.id |
| action | text | No | What happened: created, updated, removed, shared, share_revoked or viewed. |
| request_id | text | Yes | API request id, for correlating with logs. |
| created_at | timestamp with time zone | No | When it happened. Set by the database. |