app.legal_acceptances
TableRow level security on
Append-only log of legal document acceptances (Section 14.4): who accepted which version of which document, when and from which IP, and for which org when accepted on its behalf. Written only by app.record_legal_acceptances; never updated or deleted.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | Yes | Org the acceptance binds, when accepted on its behalf (for example the Terms of Service and DPA at signup); NULL for a personal acceptance such as the Worker Terms.References app.organizations.id |
| person_id | uuid | No | Person who accepted.References app.people.id |
| user_id | uuid | No | Sign-in the person used, kept as evidence even after the sign-in is deleted. |
| document_slug | text | No | Legal document slug from legal/index.yaml, as published at /legal/{slug}. |
| document_version | text | No | Semantic version of the document text accepted. |
| accepted_at | timestamp with time zone | No | When the acceptance was recorded. Set by the database. |
| ip | inet | Yes | Client IP address the acceptance came from, as reported by the platform server or seen by the database. |
| 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. |