Dataset - Ticketing | Knowledge Center

Table: `channels`

Sales channels through which ticketing orders are placed.

Column	Required	Type	Description
`ordered_at`	YES	TIMESTAMP	When the order was created
`merchant_id`	YES	INT64	Unique identifier of the merchant
`channel_id`	YES	INT64	Unique identifier of the channel
`order_id`	YES	INT64	ID of the associated order
`channel`	YES	STRUCT	Channel details (id, name)

Table: `consumers`

Customer information for ticket purchasers.

Column	Required	Type	Description
`ordered_at`	YES	TIMESTAMP	When the order was created
`merchant_id`	YES	INT64	Unique identifier of the merchant
`order_id`	YES	INT64	ID of the associated order
`language`	YES	STRING	Preferred language of the consumer
`email`	YES	STRING	Consumer email address
`country`	YES	STRING	Consumer country
`consumer`	YES	STRUCT	Full consumer details including contact info, address, and preferences

Table: `discounts`

Discount codes applied to ticketing orders.

Column	Required	Type	Description
`ordered_at`	YES	TIMESTAMP	When the order was created
`merchant_id`	YES	INT64	Unique identifier of the merchant
`order_id`	YES	INT64	ID of the associated order
`event_id`	YES	INT64	ID of the event the discount applies to
`code`	YES	STRING	Discount code used
`discount`	YES	STRUCT	Discount details including value, validity period, and giftcard status

Table: `external_scans`

Ticket scans performed by external scanning systems.

Column	Required	Type	Description
`merchant_id`	YES	INT64	Unique identifier of the merchant
`ticket_id`	YES	STRING	Unique identifier of the scanned ticket
`provider`	YES	STRING	External scanning provider
`scanned_at`	YES	TIMESTAMP	When the ticket was scanned

Table: `group_reservation_tickets`

Tickets associated with group reservations.

Column	Required	Type	Description
`ordered_at`	YES	TIMESTAMP	When the order was created
`merchant_id`	YES	INT64	Unique identifier of the merchant
`reservation_id`	YES	INT64	Unique identifier of the group reservation
`order_id`	YES	INT64	ID of the associated order
`ticket`	YES	STRUCT	Ticket details including quantity, price, and status
`ticket_type`	YES	STRUCT	Ticket type information including event and timeslot details

Table: `group_reservations`

Group bookings for museums, attractions, or events.

Column	Required	Type	Description
`ordered_at`	YES	TIMESTAMP	When the order was created
`merchant_id`	YES	INT64	Unique identifier of the merchant
`reservation_id`	YES	INT64	Unique identifier of the group reservation
`order_id`	YES	INT64	ID of the associated order
`reservation_code`	YES	STRING	Human-readable reservation code
`reservation`	YES	STRUCT	Reservation details including participants, guide info, and status
`activity`	YES	STRUCT	Activity/exposition details including dates, capacity, and pricing
`contact`	YES	STRUCT	Contact person information including address and phone
`payment`	YES	STRUCT	Payment details for the reservation
`updated_at`	YES	TIMESTAMP	When the reservation was last updated

Table: `merchants`

Business entities operating ticketing systems.

Column	Required	Type	Description
`merchant_id`	YES	INT64	Unique identifier of the merchant
`merchant_name`	YES	STRING	Display name of the merchant/venue
`merchant`	YES	STRUCT	Extended merchant information including legacy ID

Table: `orders`

Ticketing order transactions.

Column	Required	Type	Description
`ordered_at`	YES	TIMESTAMP	When the order was created
`merchant_id`	YES	INT64	Unique identifier of the merchant
`order_id`	YES	INT64	Unique identifier of the order
`channel_id`	YES	INT64	ID of the sales channel
`is_live`	YES	BOOL	Whether this is a live/production order
`status`	YES	STRING	Order status (e.g., completed, cancelled, pending)
`type`	YES	STRING	Order type classification
`system_type`	YES	STRING	System that created the order
`source`	YES	STRING	Origin of the order
`service_fee`	YES	STRUCT	Service fee details (price and total)
`language`	YES	STRING	Order language
`currency`	YES	STRING	ISO currency code
`total`	YES	NUMERIC	Total order amount
`discount`	YES	NUMERIC	Total discount applied
`donation`	YES	NUMERIC	Optional donation amount
`updated_at`	YES	TIMESTAMP	When the order was last updated
`discount_codes`	NO	ARRAY	List of discount codes applied
`ticket_type_ids`	NO	ARRAY	List of ticket type IDs in the order
`ticket_event_ids`	NO	ARRAY	List of event IDs for tickets in the order
`event_time_slot_ids`	NO	ARRAY	List of timeslot IDs for the tickets
`ticket_event_categories`	NO	ARRAY	List of event categories

Table: `payments`

Payment transactions for ticketing orders.

Column	Required	Type	Description
`ordered_at`	YES	TIMESTAMP	When the order was created
`merchant_id`	YES	INT64	Unique identifier of the merchant
`order_id`	YES	INT64	ID of the associated order
`payment_id`	YES	INT64	Unique identifier of the payment
`payment_uuid`	YES	STRING	UUID of the payment
`status`	YES	STRING	Payment status
`payment`	YES	STRUCT	Payment details including method, provider, and amount

Table: `reseller_consumers`

Consumer information for tickets sold through resellers.

Column	Required	Type	Description
`ordered_at`	YES	TIMESTAMP	When the order was created
`merchant_id`	YES	INT64	Unique identifier of the merchant
`order_id`	YES	NUMERIC	ID of the associated order
`reseller_merchant_id`	YES	NUMERIC	ID of the reseller merchant
`reseller_id`	YES	INT64	Unique identifier of the reseller
`consumer`	YES	STRUCT	Consumer details (name, email)

Table: `reseller_merchants`

Reseller/partner merchants authorized to sell tickets.

Column	Required	Type	Description
`reseller_merchant_id`	YES	NUMERIC	Unique identifier of the reseller merchant
`merchant_id`	YES	INT64	ID of the merchant whose tickets are being sold
`reseller_merchant`	YES	STRUCT	Reseller details including company info, address, and category

Table: `reseller_orders`

Orders placed through reseller channels.

Column	Required	Type	Description
`ordered_at`	YES	TIMESTAMP	When the order was created
`merchant_id`	YES	INT64	Unique identifier of the merchant
`order_id`	YES	NUMERIC	Unique identifier of the order
`reseller_merchant_id`	YES	NUMERIC	ID of the reseller merchant
`reseller_id`	YES	INT64	Unique identifier of the reseller
`order`	YES	STRUCT	Order details including dates, status, and totals

Table: `reseller_reseller`

Reseller account information.

Column	Required	Type	Description
`reseller_id`	YES	NUMERIC	Unique identifier of the reseller
`reseller`	YES	STRUCT	Reseller details including contact info, address, and status

Table: `reseller_tickets`

Individual tickets sold through reseller channels.

Column	Required	Type	Description
`ordered_at`	YES	TIMESTAMP	When the order was created
`merchant_id`	YES	INT64	Unique identifier of the merchant
`order_id`	YES	NUMERIC	ID of the associated order
`ticket_id`	YES	INT64	Unique identifier of the ticket
`reseller_merchant_id`	YES	NUMERIC	ID of the reseller merchant
`reseller_id`	YES	INT64	Unique identifier of the reseller
`ticket`	YES	STRUCT	Ticket details including barcode, price, and scan status
`ticket_type`	YES	STRUCT	Ticket type information including name and validity

Table: `ticket_scans`

Records of ticket validation scans at entry points.

Column	Required	Type	Description
`ordered_at`	YES	TIMESTAMP	When the order was created
`merchant_id`	YES	INT64	Unique identifier of the merchant
`order_id`	YES	INT64	ID of the associated order
`ticket_id`	YES	INT64	Unique identifier of the scanned ticket
`scanned_at`	YES	TIMESTAMP	When the ticket was scanned
`ip_address`	YES	STRING	IP address of the scanning device

Table: `tickets`

Individual tickets issued for events and attractions.

Column	Required	Type	Description
`ordered_at`	YES	TIMESTAMP	When the order was created
`merchant_id`	YES	INT64	Unique identifier of the merchant
`order_id`	YES	INT64	ID of the associated order
`ticket_id`	YES	INT64	Unique identifier of the ticket
`is_active`	YES	BOOL	Whether the ticket is currently valid
`ticket`	YES	STRUCT	Ticket details including barcode, price, schedule, and cancellation status
`ticket_type`	YES	STRUCT	Ticket type information including event, translations, and restrictions
`updated_at`	YES	TIMESTAMP	When the ticket was last updated

Notes

All ticketing data is partitioned by merchant_id for data isolation
ordered_at represents when the business transaction occurred
STRUCT fields contain nested JSON-like data structures with multiple attributes
Tickets can be sold directly or through reseller channels
Scan data is captured both internally and from external systems
Group reservations support educational visits and guided tours
Multi-language support is available through translation structs

Public ERD

jLVVJzim47xFN-69Xr5fY8TDUq1THSjQX0OTAqNJdYAJ7Ar5OaUEqr71_lVPpY-xTjgEGHuG-UxY-tpttTazpGNceaWJD2VH0mX25sX45ZyAu6iqddqDWdSnt1CAQ3uSNOuFAKwXXu0A8jP8lQ1-7ntEFnnC9aFvzD1Wq7nn_UtmiOVwTuD-CNZi7nU3_l5TQvsKLg9CP104-GEX6UOuHOaqYtK6Y76nP8QX2liK83J2qSE2iuB6PonX7FrS4W4

Table: channels

Table: consumers

Table: discounts

Table: external_scans

Table: group_reservation_tickets

Table: group_reservations

Table: merchants

Table: orders

Table: payments

Table: reseller_consumers

Table: reseller_merchants

Table: reseller_orders

Table: reseller_reseller

Table: reseller_tickets

Table: ticket_scans

Table: tickets