app.guest_list_entries
TableRow level security on
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.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| 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.References app.organizations.id |
| project_id | uuid | No | Project.References app.projects.id |
| scope_node_id | uuid | Yes | Show or other scope node of the same project the guest attends; NULL for the whole project.References app.scope_nodes.id |
| person_id | uuid | Yes | Person whose list the guest is on, such as the artist.References app.people.id |
| counterparty_id | uuid | Yes | Organization whose list the guest is on.References 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 | Yes | 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 | Yes | When the request was approved or declined. Set by the database. |
| decided_by | uuid | Yes | Who decided. Set by the database.References app.people.id |
| checked_in_at | timestamp with time zone | Yes | When the guest was checked in. Set by the database. |
| checked_in_by | uuid | Yes | Who checked the guest in. Set by the database.References app.people.id |
| deleted_at | timestamp with time zone | Yes | 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 | Yes | Person who inserted the row, or null for a platform process. Set by the database.References app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Yes | Person who last changed the row, or null for a platform process. Set by the database.References app.people.id |
| engagement_id | uuid | Yes | Engagement the guest was requested under, on the same project and party; NULL for guests the production adds itself.References app.engagements.id |