Ticket Tailor

Explore the interactive ERD

Table & Field Reference

waitlist

Column	Type	Keys
`id`	Unknown	PK
`event_occurence_id`	Unknown	FK
`event_series_id`	Unknown	FK
`created_at_date`	Instant
`created_at_formatted`	Unknown
`created_at_iso`	Unknown
`created_at_time`	Unknown
`created_at_timezone`	Unknown
`created_at_unix`	Unknown
`email`	Unknown
`notified_date_date`	Unknown
`notified_date_formatted`	Unknown
`notified_date_iso`	Unknown
`notified_date_time`	Unknown
`notified_date_timezone`	Unknown
`notified_date_unix`	Unknown

checkin

Column	Type	Keys
`id`	Unknown	PK
`event_occurence_id`	Unknown	FK
`event_series_id`	Unknown	FK
`issued_ticket_id`	Unknown	FK
`check_in_at`	Unknown
`created_at`	Instant
`quantity`	Unknown

voucher_code

Column	Type	Keys
`id`	Unknown	PK
`voucher_id`	Unknown	FK
`code`	Unknown
`expiry_date`	Unknown
`expiry_formatted`	Unknown
`expiry_iso`	Unknown
`expiry_time`	Unknown
`expiry_timezone`	Unknown
`expiry_unix`	Unknown
`used_date`	Unknown
`used_formatted`	Unknown
`used_iso`	Unknown
`used_time`	Unknown
`used_timezone`	Unknown
`used_unix`	Unknown
`value`	Unknown

issued_ticket

Column	Type	Keys
`id`	Unknown	PK
`event_occurence_id`	Unknown	FK
`event_series_id`	Unknown	FK
`order_id`	Unknown	FK
`ticket_type_id`	Unknown	FK
`add_on_id`	Unknown
`barcode`	Unknown
`barcode_url`	Unknown
`checked_in`	Unknown
`created_at`	Instant
`custom_question`	Json
`description`	Unknown
`email`	Unknown
`first_name`	Unknown
`full_name`	Unknown
`group_ticket_barcode`	Unknown
`last_name`	Unknown
`qr_code_url`	Unknown
`reference`	Unknown
`reservation`	Unknown
`source`	Unknown
`status`	Unknown
`updated_at`	Unknown
`voided_at`	Unknown

product_event_series_id

Column	Type	Keys
`event_series_id`	Unknown	PKFK
`product_id`	Unknown	PKFK

product

Column	Type	Keys
`id`	Unknown	PK
`created_at_formatted`	Unknown
`created_at_iso`	Unknown
`created_at_time`	Unknown
`created_at_timezone`	Unknown
`created_at_unix`	Unknown
`currency`	Unknown
`description`	Unknown
`instruction`	Unknown
`issue_ticket_voucher`	Unknown
`linked_to_all_event_series`	Unknown
`name`	Unknown
`price`	Unknown
`quantity`	Unknown
`status`	Unknown
`updated_at_date`	LocalDate
`updated_at_formatted`	Unknown
`updated_at_iso`	Unknown
`updated_at_time`	Unknown
`updated_at_timezone`	Unknown
`updated_at_unix`	Unknown

order_issued_ticket

Column	Type	Keys
`issued_ticket_id`	Unknown	PKFK
`order_id`	Unknown	PKFK

order_line_item

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	PKFK
`booking_fee`	Unknown
`description`	Unknown
`quantity`	Unknown
`total`	Unknown
`type`	Unknown
`value`	Unknown

orders

Column	Type	Keys
`id`	Unknown	PK
`event_occurence_id`	Unknown	FK
`event_series_id`	Unknown	FK
`payment_method_id`	Unknown	FK
`buyer_detail_custom_questions`	Json
`buyer_detail_email`	Unknown
`buyer_detail_first_name`	Unknown
`buyer_detail_last_name`	Unknown
`buyer_detail_name`	Unknown
`buyer_detail_phone`	Unknown
`buyer_details_address_1`	Unknown
`buyer_details_address_2`	Unknown
`buyer_details_address_3`	Unknown
`buyer_details_postal_code`	Unknown
`created_at`	Instant
`currency_base_multiplier`	Unknown
`currency_code`	Unknown
`event_occurence_name`	Unknown
`event_summary_venue_name`	Unknown
`event_summary_venue_postal_code`	Unknown
`marketing_opt_in`	Unknown
`meta_data`	Json
`referral_tag`	Unknown
`refund_amount`	Unknown
`refunded_voucher_id`	Unknown
`status`	Unknown
`status_message`	Unknown
`subtotal`	Unknown
`tax`	Unknown
`tax_treatment`	Unknown
`total`	Unknown
`total_paid`	Unknown
`txn_id`	Unknown

event_series_voucher_id

Column	Type	Keys
`event_series_id`	Unknown	PKFK
`voucher_id`	Unknown	PKFK

event_series_payment_method

Column	Type	Keys
`id`	Unknown	PK
`event_series_id`	Unknown	PKFK
`external_id`	Unknown
`instructions`	Unknown
`name`	Unknown
`type`	Unknown

event_series_bundle_ticket_type

Column	Type	Keys
`id`	Unknown	PK
`event_series_bundle_id`	Unknown	PKFK
`event_series_id`	Unknown	PKFK
`quantity`	Unknown

event_series_bundle

Column	Type	Keys
`id`	Unknown	PK
`event_series_id`	Unknown	PKFK
`booking_fee`	Unknown
`description`	Unknown
`name`	Unknown
`price`	Unknown
`product`	Json
`status`	Unknown

event_series_default_ticket_type

Column	Type	Keys
`id`	Unknown	PK
`event_series_id`	Unknown	PKFK
`access_code`	Unknown
`booking_fee`	Unknown
`description`	Unknown
`group_id`	Unknown
`has_overrides`	Unknown
`max_per_order`	Unknown
`min_per_order`	Unknown
`name`	Unknown
`override_id`	Unknown
`price`	Unknown
`quantity`	Unknown
`quantity_held`	Unknown
`quantity_issued`	Unknown
`quantity_total`	Unknown
`sort_order`	Unknown
`status`	Unknown
`type`	Unknown

event_series_default_group_ticket

Column	Type	Keys
`event_series_default_ticket_group_event_series_id`	Unknown	PKFK
`event_series_default_ticket_group_id`	Unknown	PKFK
`ticket_id`	Unknown	PKFK

event_series_default_ticket_group

Column	Type	Keys
`id`	Unknown	PK
`event_series_id`	Unknown	PKFK
`max_per_order`	Unknown
`name`	Unknown
`sort_order`	Unknown

event_series

Column	Type	Keys
`id`	Unknown	PK
`access_code`	Unknown
`add_ons`	Json
`call_to_action`	Unknown
`created_at`	Instant
`currency`	Unknown
`default_max_tickets_sold_per_occurrence`	Unknown
`description`	Unknown
`image_header`	Unknown
`image_thumbnail`	Unknown
`name`	Unknown
`next_occurrence_date_date`	Unknown
`next_occurrence_date_formatted`	Unknown
`next_occurrence_date_iso`	Unknown
`next_occurrence_date_time`	Unknown
`next_occurrence_date_timezone`	Unknown
`next_occurrence_date_unix`	Unknown
`online_event`	Unknown
`private`	Unknown
`revenue`	Unknown
`status`	Unknown
`timezone`	Unknown
`total_issued_ticket`	Unknown
`total_occurrence`	Unknown
`upcoming_occurrence`	Unknown
`url`	Unknown
`venue_name`	Unknown
`venue_postal_code`	Unknown

hold_quantity

Column	Type	Keys
`index`	Unknown	PK
`hold_id`	Unknown	PKFK
`quantity`	Unknown
`ticket_type_id`	Unknown

hold

Column	Type	Keys
`id`	Unknown	PK
`event_occurence_id`	Unknown	FK
`created_at_date`	Unknown
`created_at_formatted`	Unknown
`created_at_iso`	Unknown
`created_at_time`	Unknown
`created_at_timezone`	Unknown
`created_at_unix`	Unknown
`note`	Unknown
`total_on_hold`	Unknown
`update_at_date`	LocalDate
`update_at_formatted`	Unknown
`update_at_iso`	Unknown
`update_at_time`	Unknown
`update_at_timezone`	Unknown
`update_at_unix`	Unknown

event_override_line

Column	Type	Keys
`index`	Unknown	PK
`event_override_id`	Unknown	PKFK
`price`	Unknown
`quantity`	Unknown
`reference_id`	Unknown
`reference_type`	Unknown
`status`	Unknown

event_override

Column	Type	Keys
`id`	Unknown	PK
`event_series_id`	Unknown	FK
`created_at_date`	LocalDate
`created_at_formatted`	Unknown
`created_at_iso`	Unknown
`created_at_time`	Unknown
`created_at_timezone`	Unknown
`created_at_unix`	Unknown
`max_sellable_ticket`	Unknown
`name`	Unknown

discount_product

Column	Type	Keys
`discount_id`	Unknown	PKFK
`product_id`	Unknown	PKFK

discount_ticket_type

Column	Type	Keys
`index`	Unknown	PK
`discount_id`	Unknown	PKFK
`ticket_type`	Unknown	FK

discount

Column	Type	Keys
`id`	Unknown	PK
`booking_fee_amount`	Unknown
`booking_fee_percentage`	Unknown
`code`	Unknown
`expires`	Unknown
`face_value_amount`	Unknown
`face_value_percentage`	Unknown
`max_redemption`	Unknown
`name`	Unknown
`times_redeemed`	Unknown
`type`	Unknown

event_occurence

Column	Type	Keys
`id`	Unknown	PK
`event_series_id`	Unknown	PKFK
`chk`	Unknown
`end_date`	Unknown
`end_formatted`	Unknown
`end_iso`	Unknown
`end_time`	Unknown
`end_timezone`	Unknown
`end_unix`	Unknown
`hidden`	Unknown
`override_id`	Unknown
`start_date`	LocalDate
`start_formatted`	Unknown
`start_iso`	Unknown
`start_time`	Unknown
`start_timezone`	Unknown
`start_unix`	Unknown
`tickets_available`	Unknown
`unavailable`	Unknown
`unavailable_status`	Unknown

voucher

Column	Type	Keys
`id`	Unknown	PK
`available_codes`	Unknown
`expiry_date`	Unknown
`expiry_formatted`	Unknown
`expiry_iso`	Unknown
`expiry_time`	Unknown
`expiry_timezone`	Unknown
`expiry_unix`	Unknown
`name`	Unknown
`partial_redemption`	Unknown
`total_codes`	Unknown
`type`	Unknown
`value`	Unknown