app.guest_list_entries
TablaSeguridad a nivel de fila activa
Guest list of a project: each guest with plus-ones and the party whose list it is. Requested guests are approved or declined by someone with advancing.submission.review who did not request them, then checked in at the door.
Clave primaria: id
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Owning org, derived from app.projects on insert; never accepted from the caller and never changed.Hace referencia a app.organizations.id |
| project_id | uuid | No | Project.Hace referencia a app.projects.id |
| scope_node_id | uuid | Sí | Show or other scope node of the same project the guest attends; NULL for the whole project.Hace referencia a app.scope_nodes.id |
| person_id | uuid | Sí | Person whose list the guest is on, such as the artist.Hace referencia a app.people.id |
| counterparty_id | uuid | Sí | Organization whose list the guest is on.Hace referencia a app.counterparties.id |
| guest_name | text | No | Name the guest gives at the door. |
| plus_ones | smallint | No | Additional guests admitted with this guest, 0 to 20. |
| note | text | Sí | Notes for the door, such as access level asked. |
| entry_state | app.guest_entry_state | No | Requested, Approved, Declined or Checked In. |
| decided_at | timestamp with time zone | Sí | When the request was approved or declined. Set by the database. |
| decided_by | uuid | Sí | Who decided. Set by the database.Hace referencia a app.people.id |
| checked_in_at | timestamp with time zone | Sí | When the guest was checked in. Set by the database. |
| checked_in_by | uuid | Sí | Who checked the guest in. 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. |
| 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 |
| engagement_id | uuid | Sí | Engagement the guest was requested under, on the same project and party; NULL for guests the production adds itself.Hace referencia a app.engagements.id |