Saltar al contenido

app.sandbox_orgs

TablaSeguridad a nivel de fila activa

A private sandbox org (Section 11.7, A65-022): one per person, filled from the sandbox template, never billed, sending no email or SMS and open to nobody else. It is purged with all its rows once expires_at passes. Written only by app.open_my_sandbox and the purge.

Clave primaria: id

Columnas de app.sandbox_orgs
ColumnaTipoAdmite nulosDescripción
iduuidNoPrimary key, UUID v7.
org_iduuidNoThe sandbox org.Hace referencia a app.organizations.id
person_iduuidNoPerson the sandbox belongs to, its only member.Hace referencia a app.people.id
expires_attimestamp with time zoneNoInstant the sandbox ends; the hourly purge removes it after this.
purge_errortextSíWhy the last purge attempt failed, for the platform team; null while none has.
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.