app.feedback_submissions
TableRow level security on
Feedback a person sent the platform team from the widget in Atlas or Gateway (Section 11.7, A65-022): their message, the page context the widget showed them before sending and an optional screenshot they chose. Never anything they did not see. Read by the sender and platform staff; written only through app.send_feedback and app.triage_feedback.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| submission_number | text | No | Reference the platform team quotes, FB-000001 and up. Set by the database. |
| person_id | uuid | No | Person who sent the feedback.References app.people.id |
| context_org_id | uuid | Yes | Org the person was working in when they sent it, if any; cleared when that org is purged.References app.organizations.id |
| app_code | text | No | App the feedback came from: Atlas or Gateway. |
| message | text | No | What the person wrote. |
| route | text | Yes | Path of the page it was sent from, without the query string. |
| app_version | text | Yes | App version the person was running. |
| locale | text | Yes | Language the person was using. |
| viewport | text | Yes | Window size in CSS pixels, width x height. |
| screenshot_path | text | Yes | Screenshot the person chose to attach: <person_id>/<file> in the support-screenshots bucket (1034). |
| triage_state | text | No | New until platform staff read it, then Read, Planned or Closed. |
| triage_note | text | Yes | Platform staff note on what was decided. |
| triaged_at | timestamp with time zone | Yes | When platform staff last triaged it; null while New. |
| triaged_by | uuid | Yes | Platform staff member who last triaged it.References app.people.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. |