app.project_attendance_totals
View
Attendance totals per project and show for the gate 8 measurement. Gross is NULL when any row is unpriced or currencies differ, with the unpriced count beside it; scans not reported are counted, never treated as zero.
| Column | Type | Nullable | Description |
|---|---|---|---|
| project_id | uuid | Yes | Project. |
| scope_node_id | uuid | Yes | Show or scope node, or NULL for figures without one. |
| org_id | uuid | Yes | Org. |
| tickets_sold | bigint | Yes | Tickets sold. |
| tickets_scanned | bigint | Yes | Tickets scanned, over the rows that report scans. |
| scans_unreported_count | bigint | Yes | Rows whose source reported no scans. |
| comps | bigint | Yes | Complimentary tickets, over the rows that report them. |
| gross_minor | bigint | Yes | Gross revenue in minor units, or NULL when any row is unpriced or currencies differ. |
| currency_code | bpchar | Yes | Currency of gross_minor, when there is one. |
| unpriced_count | bigint | Yes | Rows without a gross. |
| first_day | date | Yes | First day counted. |
| last_day | date | Yes | Last day counted. |