app.feedback_submissions
TablaSeguridad a nivel de fila activa
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.
Clave primaria: id
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| 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.Hace referencia a app.people.id |
| context_org_id | uuid | Sí | Org the person was working in when they sent it, if any; cleared when that org is purged.Hace referencia a app.organizations.id |
| app_code | text | No | App the feedback came from: Atlas or Gateway. |
| message | text | No | What the person wrote. |
| route | text | Sí | Path of the page it was sent from, without the query string. |
| app_version | text | Sí | App version the person was running. |
| locale | text | Sí | Language the person was using. |
| viewport | text | Sí | Window size in CSS pixels, width x height. |
| screenshot_path | text | Sí | 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 | Sí | Platform staff note on what was decided. |
| triaged_at | timestamp with time zone | Sí | When platform staff last triaged it; null while New. |
| triaged_by | uuid | Sí | Platform staff member who last triaged it.Hace referencia a app.people.id |
| created_at | timestamp with time zone | No | When the row was inserted. Set by the database. |
| created_by | uuid | Sí | Person who inserted the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Sí | Person who last changed the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |
| deleted_at | timestamp with time zone | Sí | Soft delete time. A row with deleted_at set is ignored by every access helper. |