Saltar al contenido

app.help_desk_team_members

TablaSeguridad a nivel de fila activa

Members who answer a help desk team's requests. Removing a member soft deletes the row.

Clave primaria: id

Columnas de app.help_desk_team_members
ColumnaTipoAdmite nulosDescripción
iduuidNoPrimary key, UUID v7.
org_iduuidNoOwning org, derived from app.help_desk_teams on insert; never accepted from the caller and never changed.Hace referencia a app.organizations.id
help_desk_team_iduuidNoTeam.Hace referencia a app.help_desk_teams.id
membership_iduuidNoMember who answers for it.Hace referencia a app.memberships.id
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.