app.project_attendance_totals

Vista

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.

Columnas de app.project_attendance_totals
Columna	Tipo	Admite nulos	Descripción
project_id	uuid	Sí	Project.
scope_node_id	uuid	Sí	Show or scope node, or NULL for figures without one.
org_id	uuid	Sí	Org.
tickets_sold	bigint	Sí	Tickets sold.
tickets_scanned	bigint	Sí	Tickets scanned, over the rows that report scans.
scans_unreported_count	bigint	Sí	Rows whose source reported no scans.
comps	bigint	Sí	Complimentary tickets, over the rows that report them.
gross_minor	bigint	Sí	Gross revenue in minor units, or NULL when any row is unpriced or currencies differ.
currency_code	bpchar	Sí	Currency of gross_minor, when there is one.
unpriced_count	bigint	Sí	Rows without a gross.
first_day	date	Sí	First day counted.
last_day	date	Sí	Last day counted.