Saltar al contenido

app.support_ticket_messages

TablaSeguridad a nivel de fila activa

The conversation on a support ticket, oldest first. Append-only; written through app.post_support_message or by the platform team.

Clave primaria: id

Columnas de app.support_ticket_messages
ColumnaTipoAdmite nulosDescripción
iduuidNoPrimary key, UUID v7.
org_iduuidNoOwning org, derived from app.support_tickets on insert; never accepted from the caller and never changed.Hace referencia a app.organizations.id
support_ticket_iduuidNoTicket the message belongs to.Hace referencia a app.support_tickets.id
author_membership_iduuidSíMember who wrote it; NULL for the platform support team.Hace referencia a app.memberships.id
bodytextNoMessage text.
created_attimestamp with time zoneNoWhen the row was inserted. Set by the database.
created_byuuidSíPerson who inserted the row, or null for a platform process. Set by the database.Hace referencia a app.people.id
updated_attimestamp with time zoneNoWhen the row last changed. Set by the database.
updated_byuuidSíPerson who last changed the row, or null for a platform process. Set by the database.Hace referencia a app.people.id
deleted_attimestamp with time zoneSíSoft delete time. A row with deleted_at set is ignored by every access helper.