app.product_events
TableRow level security on
Consent-gated, first-party product analytics events (Section 11.14, A65-022): what happened in which app, on which route template or workflow step, keyed to a random browser session. No person, org, path or free text, so no event identifies anyone. Recorded only through app.record_product_events after the person consented; read by platform staff.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| occurred_at | timestamp with time zone | No | When it happened, by the browser's clock, held to the day before it was received. |
| received_at | timestamp with time zone | No | When the platform received it. Set by the database. |
| app_code | text | No | App it happened in: Atlas, Gateway or Compass. |
| event_name | text | No | Page Viewed, Workflow Started, Workflow Step or Workflow Completed. |
| route_template | text | Yes | Route template of the page, with every org slug, key, id and token replaced by its parameter name; never the path itself. |
| workflow_code | text | Yes | Workflow of Sections 11.11 to 11.13 (private.product_workflows) a funnel event belongs to. |
| step | smallint | Yes | Step of the workflow a Workflow Step event reached, from 0. |
| session_key | uuid | No | Random key the browser makes for its session and forgets when the session ends, so a funnel follows one visit without knowing whose it is. |