# Ticket Tailor schema ERD

Table and field reference for the Fivetran Ticket Tailor connector.

## 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 | PK, FK |
| product_id | Unknown | PK, FK |

### 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 | PK, FK |
| order_id | Unknown | PK, FK |

### order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | PK, FK |
| 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 | PK, FK |
| voucher_id | Unknown | PK, FK |

### event_series_payment_method

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_series_id | Unknown | PK, FK |
| 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 | PK, FK |
| event_series_id | Unknown | PK, FK |
| quantity | Unknown |  |

### event_series_bundle

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_series_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| event_series_default_ticket_group_id | Unknown | PK, FK |
| ticket_id | Unknown | PK, FK |

### event_series_default_ticket_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_series_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| product_id | Unknown | PK, FK |

### discount_ticket_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| discount_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- waitlist(event_occurence_id) → event_occurence(id)
- waitlist(event_series_id) → event_series(id)
- checkin(event_occurence_id) → event_occurence(id)
- checkin(event_series_id) → event_series(id)
- checkin(issued_ticket_id) → issued_ticket(id)
- voucher_code(voucher_id) → voucher(id)
- issued_ticket(event_occurence_id) → event_occurence(id)
- issued_ticket(ticket_type_id) → event_series_default_ticket_type(id)
- issued_ticket(event_series_id) → event_series(id)
- issued_ticket(order_id) → orders(id)
- product_event_series_id(event_series_id) → event_series(id)
- product_event_series_id(product_id) → product(id)
- order_issued_ticket(issued_ticket_id) → issued_ticket(id)
- order_issued_ticket(order_id) → orders(id)
- order_line_item(order_id) → orders(id)
- orders(payment_method_id) → event_series_payment_method(id)
- orders(event_occurence_id) → event_occurence(id)
- orders(event_series_id) → event_series(id)
- event_series_voucher_id(voucher_id) → voucher(id)
- event_series_voucher_id(event_series_id) → event_series(id)
- event_series_payment_method(event_series_id) → event_series(id)
- event_series_bundle_ticket_type(event_series_id) → event_series_bundle(event_series_id)
- event_series_bundle_ticket_type(event_series_bundle_id) → event_series_bundle(id)
- event_series_bundle(event_series_id) → event_series(id)
- event_series_default_ticket_type(event_series_id) → event_series(id)
- event_series_default_group_ticket(ticket_id) → event_series_default_ticket_type(id)
- event_series_default_group_ticket(event_series_default_ticket_group_id) → event_series_default_ticket_group(id)
- event_series_default_group_ticket(event_series_default_ticket_group_event_series_id) → event_series_default_ticket_group(event_series_id)
- event_series_default_ticket_group(event_series_id) → event_series(id)
- hold_quantity(hold_id) → hold(id)
- hold(event_occurence_id) → event_occurence(id)
- event_override_line(event_override_id) → event_override(id)
- event_override(event_series_id) → event_series(id)
- discount_product(product_id) → product(id)
- discount_product(discount_id) → discount(id)
- discount_ticket_type(ticket_type) → event_series_default_ticket_type(id)
- discount_ticket_type(discount_id) → discount(id)
- event_occurence(event_series_id) → event_series(id)