app.work_detail_events
TablaSeguridad a nivel de fila activa
The person's own access log for their work details (Section 8.4 access transparency): every change they make, every share and revocation, and every read or reveal by an engaging org, with the categories and changed column names but never a value. Written only by the database; the person reads all of theirs and an org's audit readers read the rows naming their org.
Clave primaria: id
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| person_id | uuid | No | Person whose work details were touched.Hace referencia a app.people.id |
| actor_person_id | uuid | Sí | Person who acted; NULL for the database or a service.Hace referencia a app.people.id |
| org_id | uuid | Sí | Org whose member acted or whose share changed; NULL for the owner's own changes.Hace referencia a app.organizations.id |
| engagement_id | uuid | Sí | Engagement the share serves, for share, read and reveal events.Hace referencia a app.engagements.id |
| action | text | No | What happened, as subject.verb: for example person_work_details.update, work_details.shared, work_details.viewed or passport.revealed. |
| categories | app.work_detail_category[] | No | Categories the act covered. |
| changed_columns | text[] | No | Columns an owner change touched, never their values. |
| reason | text | Sí | Reason an org member gave for revealing the passport number. |
| request_id | text | Sí | API request id, for correlating with logs. |
| created_at | timestamp with time zone | No | When it happened. Set by the database. |