# Eventbrite schema ERD

Table and field reference for the Fivetran Eventbrite connector.

## Table & Field Reference

### display_setting

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| event_id | Unknown | FK |
| show_end_date | Unknown |  |
| show_facebook_friends_going | Unknown |  |
| show_map | Unknown |  |
| show_organizer_facebook | Unknown |  |
| show_organizer_twitter | Unknown |  |
| show_remaining | Unknown |  |
| show_start_date | Unknown |  |
| show_start_end_time | Unknown |  |
| show_timezone | Unknown |  |
| terminology | Unknown |  |

### discount_hold

| Column | Type | Keys |
| --- | --- | --- |
| discount_id | Unknown | PK, FK |
| hold_id | Unknown | PK, FK |

### discount_ticket_class

| Column | Type | Keys |
| --- | --- | --- |
| discount_id | Unknown | PK, FK |
| ticket_class_id | Unknown | PK, FK |

### discount

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| organization_id | Unknown | FK |
| amount_off | Unknown |  |
| code | Unknown |  |
| discount_type | Unknown |  |
| end_date | Unknown |  |
| end_date_relative | Unknown |  |
| event | Unknown |  |
| percent_off | Unknown |  |
| quantity_available | Unknown |  |
| quantity_sold | Unknown |  |
| start_date | Unknown |  |
| start_date_relative | Unknown |  |
| ticket_group_id | Unknown |  |
| ticket_ids | Unknown |  |
| type | Unknown |  |

### custom_question_ticket_class

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| custom_question_id | Unknown | PK, FK |
| name | Unknown |  |

### custom_question_choice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| custom_question_id | Unknown | PK, FK |
| answer_text | Unknown |  |
| low_stock | Unknown |  |
| quantity_available | Unknown |  |
| quantity_sold | Unknown |  |
| subquestion_ids | Json |  |

### custom_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| display_answer_on_order | Unknown |  |
| parent_choice_id | Unknown |  |
| parent_id | Unknown |  |
| question_text | Unknown |  |
| required | Unknown |  |
| respondent | Unknown |  |
| sorting | Unknown |  |
| type | Unknown |  |

### format

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| name_localized | Unknown |  |
| short_name | Unknown |  |
| short_name_localized | Unknown |  |

### user_request

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| user_id | Unknown | PK, FK |
| is_primary | Unknown |  |
| verified | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| first_name | Unknown |  |
| is_public | Unknown |  |
| last_name | Unknown |  |
| name | Unknown |  |

### seat_map

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| organization_id | Unknown | FK |
| venue_id | Unknown | FK |
| capacity | Unknown |  |
| name | Unknown |  |
| thumbnail_url | Unknown |  |

### structure_content_working_module

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| data_body_alignment | Unknown |  |
| data_body_text | Unknown |  |
| layout | Unknown |  |
| semantic_purpose | Unknown |  |
| type | Unknown |  |
| custom_** |  |  |

### structure_content_working_widget_tab_slot_host

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| event_id | Unknown | PK, FK |
| widget_tab_name | Unknown | PK, FK |
| widget_type | Unknown | PK, FK |

### structure_content_working_widget_tab_slot

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| event_id | Unknown | FK |
| widget_tab_name | Unknown | FK |
| widget_type | Unknown | FK |
| description | Unknown |  |
| end_time | Unknown |  |
| start_time | Unknown |  |
| title | Unknown |  |

### structure_content_working_widget_tab

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| widget_type | Unknown | PK |
| event_id | Unknown | PK, FK |

### structure_content_working

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| event_id | Unknown | FK |
| access_type | Unknown |  |
| has_autogenerated_content | Unknown |  |
| hide_virtual_venue_content | Unknown |  |
| page_version_number | Unknown |  |
| purpose | Unknown |  |

### ticket_class_confirmation_setting

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| event_id | Unknown | FK |
| order_id | Unknown | FK |
| ticket_class_id | Unknown | FK |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| organization_id | Unknown | FK |
| base_price_currency | Unknown |  |
| base_price_display | Unknown |  |
| base_price_major_value | Unknown |  |
| base_price_value | Unknown |  |
| changed | Unknown |  |
| cost_discount_type | Unknown |  |
| cost_has_gts_tax | Unknown |  |
| cost_tax_name | Unknown |  |
| created | Unknown |  |
| discount_amount_currency | Unknown |  |
| discount_amount_display | Unknown |  |
| discount_amount_major_value | Unknown |  |
| discount_amount_value | Unknown |  |
| display_fee_currency | Unknown |  |
| display_fee_display | Unknown |  |
| display_fee_major_value | Unknown |  |
| display_fee_value | Unknown |  |
| display_price_currency | Unknown |  |
| display_price_display | Unknown |  |
| display_price_major_value | Unknown |  |
| display_price_value | Unknown |  |
| display_tax_currency | Unknown |  |
| display_tax_display | Unknown |  |
| display_tax_major_value | Unknown |  |
| display_tax_value | Unknown |  |
| event_id | Unknown |  |
| eventbrite_fee_currency | Unknown |  |
| eventbrite_fee_display | Unknown |  |
| eventbrite_fee_major_value | Unknown |  |
| eventbrite_fee_value | Unknown |  |
| gross_currency | Unknown |  |
| gross_display | Unknown |  |
| gross_major_value | Unknown |  |
| gross_value | Unknown |  |
| owner_email | Unknown |  |
| owner_first_name | Unknown |  |
| owner_last_name | Unknown |  |
| owner_name | Unknown |  |
| payment_fee_currency | Unknown |  |
| payment_fee_display | Unknown |  |
| payment_fee_major_value | Unknown |  |
| payment_fee_value | Unknown |  |
| price_before_discount_currency | Unknown |  |
| price_before_discount_display | Unknown |  |
| price_before_discount_major_value | Unknown |  |
| price_before_discount_value | Unknown |  |
| status | Unknown |  |
| tax_currency | Unknown |  |
| tax_display | Unknown |  |
| tax_major_value | Unknown |  |
| tax_value | Unknown |  |
| ticket_buyer_confirmation_message_text | Unknown |  |
| ticket_buyer_instructions_text | Unknown |  |
| ticket_buyer_settings_event_id | Unknown |  |
| ticket_buyer_settings_refund_request_enabled | Unknown |  |
| time_remaining | Unknown |  |

### code_component

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | Unknown | PK |
| base | Unknown |  |
| bucket | Unknown |  |
| discount_currency | Unknown |  |
| discount_display | Unknown |  |
| discount_major_value | Unknown |  |
| discount_reason | Unknown |  |
| discount_value | Unknown |  |
| group_name | Unknown |  |
| intermediate | Unknown |  |
| internal_name | Unknown |  |
| name | Unknown |  |
| payer | Unknown |  |
| recipient | Unknown |  |
| rule_id | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### organization_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| deletable | Unknown |  |
| description | Unknown |  |
| grantable | Unknown |  |
| immutable | Unknown |  |
| name | Unknown |  |
| permission | Json |  |
| permission_type | Unknown |  |

### ticket_delivery_method

| Column | Type | Keys |
| --- | --- | --- |
| delivery_method | Unknown | PK |
| event_id | Unknown | PK, FK |
| ticket_class_id | Unknown | PK, FK |

### ticket_delivery_sales_channel

| Column | Type | Keys |
| --- | --- | --- |
| sales_channel | Unknown | PK |
| event_id | Unknown | PK, FK |
| ticket_class_id | Unknown | PK, FK |

### ticket_class

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| inventory_tier_id | Unknown | FK |
| actual_cost_currency | Unknown |  |
| actual_cost_display | Unknown |  |
| actual_cost_major_value | Unknown |  |
| actual_cost_value | Unknown |  |
| actual_fee_currency | Unknown |  |
| actual_fee_display | Unknown |  |
| actual_fee_major_value | Unknown |  |
| actual_fee_value | Unknown |  |
| auto_hide | Unknown |  |
| auto_hide_after | Unknown |  |
| auto_hide_before | Unknown |  |
| capacity | Unknown |  |
| cost_currency | Unknown |  |
| cost_display | Unknown |  |
| cost_major_value | Unknown |  |
| cost_value | Unknown |  |
| description | Unknown |  |
| display_name | Unknown |  |
| donation | Unknown |  |
| fee_currency | Unknown |  |
| fee_display | Unknown |  |
| fee_major_value | Unknown |  |
| fee_value | Unknown |  |
| free | Unknown |  |
| has_pdf_ticket | Unknown |  |
| hidden | Unknown |  |
| hidden_currently | Unknown |  |
| hide_description | Unknown |  |
| hide_sale_dates | Unknown |  |
| include_fee | Unknown |  |
| maximum_quantity | Unknown |  |
| maximum_quantity_per_order | Unknown |  |
| minimum_quantity | Unknown |  |
| name | Unknown |  |
| on_sale_status | Unknown |  |
| order_confirmation_message | Unknown |  |
| payment_constraints | Json |  |
| quantity_sold | Unknown |  |
| quantity_total | Unknown |  |
| sales_channels | Unknown |  |
| sales_end | Unknown |  |
| sales_end_relative | Unknown |  |
| sales_start | Unknown |  |
| sales_start_after | Unknown |  |
| secondary_assignment_enabled | Unknown |  |
| sorting | Unknown |  |
| split_fee | Unknown |  |
| tax_currency | Unknown |  |
| tax_display | Unknown |  |
| tax_major_value | Unknown |  |
| tax_value | Unknown |  |

### venue

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| address_address_1 | Unknown |  |
| address_address_2 | Unknown |  |
| address_city | Unknown |  |
| address_country | Unknown |  |
| address_latitude | Unknown |  |
| address_localized_address_display | Unknown |  |
| address_localized_area_display | Unknown |  |
| address_localized_multi_line_address_display | Json |  |
| address_longitude | Unknown |  |
| address_postal_code | Unknown |  |
| address_region | Unknown |  |
| age_restriction | Unknown |  |
| capacity | Unknown |  |
| latitude | Unknown |  |
| longitude | Unknown |  |
| name | Unknown |  |

### default_question_ticket_class

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| default_question_id | Unknown | PK, FK |
| name | Unknown |  |

### default_question_choice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| default_question_id | Unknown | PK, FK |
| answer_text | Unknown |  |
| low_stock | Unknown |  |
| quantity_available | Unknown |  |
| quantity_sold | Unknown |  |
| subquestion_ids | Json |  |

### default_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| default_value | Unknown |  |
| editable | Unknown |  |
| group_display_header | Unknown |  |
| group_id | Unknown |  |
| include | Unknown |  |
| question_text | Unknown |  |
| required | Unknown |  |
| respondent | Unknown |  |
| type | Unknown |  |

### event_checkout_offline_setting

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| event_id | Unknown | FK |
| instructions | Unknown |  |
| payment_method | Unknown |  |

### event_subcategory

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| name | Unknown |  |
| parent_category | Json |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown | FK |
| format_id | Unknown | FK |
| organization_id | Unknown | FK |
| organizer_id | Unknown | FK |
| subcategory_id | Unknown | FK |
| venue_id | Unknown | FK |
| capacity | Unknown |  |
| capacity_is_custom | Unknown |  |
| category_name | Unknown |  |
| category_name_localized | Unknown |  |
| category_short_name | Unknown |  |
| category_short_name_localized | Unknown |  |
| changed | Unknown |  |
| checkout_settings_changed | Unknown |  |
| checkout_settings_checkout_method | Unknown |  |
| checkout_settings_country_code | Unknown |  |
| checkout_settings_created | Unknown |  |
| checkout_settings_currency_code | Unknown |  |
| checkout_settings_user_instrument_vault_id | Unknown |  |
| created | Instant |  |
| currency | Unknown |  |
| description_text | Unknown |  |
| end_local | Unknown |  |
| end_timezone | Unknown |  |
| end_utc | Unknown |  |
| event_sales_start_date_local | Unknown |  |
| event_sales_start_date_timezone | Unknown |  |
| event_sales_start_date_utc | Unknown |  |
| event_sales_status | Unknown |  |
| external_ticketing_external_url | Unknown |  |
| external_ticketing_is_free | Unknown |  |
| external_ticketing_sales_end | Unknown |  |
| external_ticketing_sales_start | Unknown |  |
| external_ticketing_ticketing_provider_name | Unknown |  |
| facebook_event_id | Unknown |  |
| format_name | Unknown |  |
| format_name_localized | Unknown |  |
| format_short_name | Unknown |  |
| format_short_name_localized | Unknown |  |
| hide_end_date | Unknown |  |
| hide_start_date | Unknown |  |
| inventory_type | Unknown |  |
| invite_only | Unknown |  |
| is_externally_ticketed | Unknown |  |
| is_free | Unknown |  |
| is_locked | Unknown |  |
| is_reserved_seating | Unknown |  |
| is_series | Unknown |  |
| is_series_parent | Unknown |  |
| listed | Unknown |  |
| locale | Unknown |  |
| logo_aspect_ratio | Unknown |  |
| logo_crop_mask_height | Unknown |  |
| logo_crop_mask_top_left_x | Unknown |  |
| logo_crop_mask_top_left_y | Unknown |  |
| logo_crop_mask_width | Unknown |  |
| logo_edge_color | Unknown |  |
| logo_edge_color_set | Unknown |  |
| logo_id | Unknown |  |
| logo_original_height | Unknown |  |
| logo_original_url | Unknown |  |
| logo_original_width | Unknown |  |
| logo_url | Unknown |  |
| max_ticket_price_currency | Unknown |  |
| max_ticket_price_display | Unknown |  |
| max_ticket_price_major_value | Unknown |  |
| max_ticket_price_value | Unknown |  |
| min_ticket_price_currency | Unknown |  |
| min_ticket_price_display | Unknown |  |
| min_ticket_price_major_value | Unknown |  |
| min_ticket_price_value | Unknown |  |
| music_properties_age_restriction | Unknown |  |
| music_properties_door_time | Unknown |  |
| music_properties_presented_by | Unknown |  |
| name_text | Unknown |  |
| online_event | Unknown |  |
| organizer_description | Unknown |  |
| organizer_facebook | Unknown |  |
| organizer_logo_aspect_ratio | Unknown |  |
| organizer_logo_crop_mask_height | Unknown |  |
| organizer_logo_crop_mask_top_left_x | Unknown |  |
| organizer_logo_crop_mask_top_left_y | Unknown |  |
| organizer_logo_crop_mask_width | Unknown |  |
| organizer_logo_edge_color | Unknown |  |
| organizer_logo_edge_color_set | Unknown |  |
| organizer_logo_id | Unknown |  |
| organizer_logo_original_height | Unknown |  |
| organizer_logo_original_url | Unknown |  |
| organizer_logo_original_width | Unknown |  |
| organizer_logo_url | Unknown |  |
| organizer_long_description | Unknown |  |
| organizer_name | Unknown |  |
| organizer_num_future_events | Unknown |  |
| organizer_num_past_events | Unknown |  |
| organizer_twitter | Unknown |  |
| organizer_url | Unknown |  |
| privacy_setting | Unknown |  |
| published | Unknown |  |
| series_id | Unknown |  |
| shareable | Unknown |  |
| show_colors_in_seatmap_thumbnail | Unknown |  |
| show_pick_a_seat | Unknown |  |
| show_remaining | Unknown |  |
| show_seatmap_thumbnail | Unknown |  |
| source | Unknown |  |
| start_local | Unknown |  |
| start_timezone | Unknown |  |
| start_utc | Unknown |  |
| status | Unknown |  |
| subcategory_name | Unknown |  |
| subcategory_parent_category_id | Unknown |  |
| subcategory_parent_category_name | Unknown |  |
| subcategory_parent_category_name_localized | Unknown |  |
| subcategory_parent_category_short_name | Unknown |  |
| subcategory_parent_category_short_name_localized | Unknown |  |
| subcategory_parent_category_subcategories | Unknown |  |
| ticket_availability_has_available_tickets | Unknown |  |
| ticket_availability_is_sold_out | Unknown |  |
| ticket_availability_max_ticket_price_currency | Unknown |  |
| ticket_availability_max_ticket_price_display | Unknown |  |
| ticket_availability_max_ticket_price_major_value | Unknown |  |
| ticket_availability_max_ticket_price_value | Unknown |  |
| ticket_availability_min_ticket_price_currency | Unknown |  |
| ticket_availability_min_ticket_price_display | Unknown |  |
| ticket_availability_min_ticket_price_major_value | Unknown |  |
| ticket_availability_min_ticket_price_value | Unknown |  |
| ticket_availability_start_sales_date_local | Unknown |  |
| ticket_availability_start_sales_date_timezone | Unknown |  |
| ticket_availability_start_sales_date_utc | Unknown |  |
| ticket_availability_waitlist_available | Unknown |  |
| tx_time_limit | Unknown |  |
| url | Unknown |  |
| vanity_url | Unknown |  |
| venue_address_1 | Unknown |  |
| venue_address_2 | Unknown |  |
| venue_age_restriction | Unknown |  |
| venue_capacity | Unknown |  |
| venue_city | Unknown |  |
| venue_country | Unknown |  |
| venue_latitude | Unknown |  |
| venue_longitude | Unknown |  |
| venue_name | Unknown |  |
| venue_postal_code | Unknown |  |
| venue_region | Unknown |  |
| version | Unknown |  |

### event_hold

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| abbreviation | Unknown |  |
| color | Unknown |  |
| name | Unknown |  |
| quantity_pending | Unknown |  |
| quantity_sold | Unknown |  |
| quantity_total | Unknown |  |
| sort_order | Unknown |  |

### event_capacity

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK, FK |
| capacity_is_custom | Unknown |  |
| capacity_pending | Unknown |  |
| capacity_sold | Unknown |  |
| capacity_total | Unknown |  |
| quantity_pending | Unknown |  |
| quantity_sold | Unknown |  |
| quantity_total | Unknown |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created | Unknown |  |
| locale | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| type | Unknown |  |
| vertical | Unknown |  |

### attendee_barcode

| Column | Type | Keys |
| --- | --- | --- |
| barcode | Unknown | PK |
| attendee_id | Unknown | FK |
| changed | Unknown |  |
| checkin_type | Unknown |  |
| created | Unknown |  |
| is_printed | Unknown |  |
| status | Unknown |  |

### attendee_answer

| Column | Type | Keys |
| --- | --- | --- |
| attendee_id | Unknown | PK, FK |
| question_id | Unknown | PK, FK |
| answer | Unknown |  |
| question | Unknown |  |
| type | Unknown |  |

### attendee_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attendee_id | Unknown | PK, FK |
| label | Unknown |  |
| required | Unknown |  |
| type | Unknown |  |

### attendee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| invited_by | Unknown | FK |
| order_id | Unknown | FK |
| organization_id | Unknown | FK |
| ticket_class_id | Unknown | FK |
| affiliate | Unknown |  |
| assigned_unit_description | Unknown |  |
| assigned_unit_id | Unknown |  |
| assigned_unit_labels | Json |  |
| assigned_unit_titles | Json |  |
| base_price_currency | Unknown |  |
| base_price_display | Unknown |  |
| base_price_major_value | Unknown |  |
| base_price_value | Unknown |  |
| cancelled | Unknown |  |
| changed | Unknown |  |
| checked_in | Unknown |  |
| contact_list_preferences_has_contact_list | Unknown |  |
| contact_list_preferences_has_opted_in | Unknown |  |
| contact_list_preferences_type | Unknown |  |
| created | Unknown |  |
| delivery_method | Unknown |  |
| eventbrite_fee_currency | Unknown |  |
| eventbrite_fee_display | Unknown |  |
| eventbrite_fee_major_value | Unknown |  |
| eventbrite_fee_value | Unknown |  |
| gross_currency | Unknown |  |
| gross_display | Unknown |  |
| gross_major_value | Unknown |  |
| gross_value | Unknown |  |
| guestlist_id | Unknown |  |
| payment_fee_currency | Unknown |  |
| payment_fee_display | Unknown |  |
| payment_fee_major_value | Unknown |  |
| payment_fee_value | Unknown |  |
| profile_addresses_bill_address_1 | Unknown |  |
| profile_addresses_bill_address_2 | Unknown |  |
| profile_addresses_bill_city | Unknown |  |
| profile_addresses_bill_country | Unknown |  |
| profile_addresses_bill_latitude | Unknown |  |
| profile_addresses_bill_localized_address_display | Unknown |  |
| profile_addresses_bill_localized_area_display | Unknown |  |
| profile_addresses_bill_localized_multi_line_address_display | Json |  |
| profile_addresses_bill_longitude | Unknown |  |
| profile_addresses_bill_postal_code | Unknown |  |
| profile_addresses_bill_region | Unknown |  |
| profile_addresses_home_address_1 | Unknown |  |
| profile_addresses_home_address_2 | Unknown |  |
| profile_addresses_home_city | Unknown |  |
| profile_addresses_home_country | Unknown |  |
| profile_addresses_home_latitude | Unknown |  |
| profile_addresses_home_localized_address_display | Unknown |  |
| profile_addresses_home_localized_area_display | Unknown |  |
| profile_addresses_home_localized_multi_line_address_display | Json |  |
| profile_addresses_home_longitude | Unknown |  |
| profile_addresses_home_postal_code | Unknown |  |
| profile_addresses_home_region | Unknown |  |
| profile_addresses_ship_address_1 | Unknown |  |
| profile_addresses_ship_address_2 | Unknown |  |
| profile_addresses_ship_city | Unknown |  |
| profile_addresses_ship_country | Unknown |  |
| profile_addresses_ship_latitude | Unknown |  |
| profile_addresses_ship_localized_address_display | Unknown |  |
| profile_addresses_ship_localized_area_display | Unknown |  |
| profile_addresses_ship_localized_multi_line_address_display | Json |  |
| profile_addresses_ship_longitude | Unknown |  |
| profile_addresses_ship_postal_code | Unknown |  |
| profile_addresses_ship_region | Unknown |  |
| profile_addresses_work_address_1 | Unknown |  |
| profile_addresses_work_address_2 | Unknown |  |
| profile_addresses_work_city | Unknown |  |
| profile_addresses_work_country | Unknown |  |
| profile_addresses_work_latitude | Unknown |  |
| profile_addresses_work_localized_address_display | Unknown |  |
| profile_addresses_work_localized_area_display | Unknown |  |
| profile_addresses_work_localized_multi_line_address_display | Json |  |
| profile_addresses_work_longitude | Unknown |  |
| profile_addresses_work_postal_code | Unknown |  |
| profile_addresses_work_region | Unknown |  |
| profile_age | Unknown |  |
| profile_birth_date | Unknown |  |
| profile_blog | Unknown |  |
| profile_cell_phone | Unknown |  |
| profile_company | Unknown |  |
| profile_email | Unknown |  |
| profile_first_name | Unknown |  |
| profile_gender | Unknown |  |
| profile_job_title | Unknown |  |
| profile_last_name | Unknown |  |
| profile_name | Unknown |  |
| profile_prefix | Unknown |  |
| profile_suffix | Unknown |  |
| profile_website | Unknown |  |
| profile_work_phone | Unknown |  |
| refunded | Unknown |  |
| status | Unknown |  |
| tax_currency | Unknown |  |
| tax_display | Unknown |  |
| tax_major_value | Unknown |  |
| tax_value | Unknown |  |
| team_date_joined | Unknown |  |
| team_event_id | Unknown |  |
| team_id | Unknown |  |
| team_name | Unknown |  |
| variant_id | Unknown |  |

### inventory_tier_ticket_class

| Column | Type | Keys |
| --- | --- | --- |
| ticket_class_id | Unknown | PK |
| inventory_tier_id | Unknown | PK, FK |

### inventory_tier_hold

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| inventory_tier_id | Unknown | PK, FK |
| event_id | Unknown | FK |

### inventory_tier

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| capacity_total | Unknown |  |
| color | Unknown |  |
| count_against_event_capacity | Unknown |  |
| name | Unknown |  |
| quantity_held | Unknown |  |
| quantity_pending | Unknown |  |
| quantity_sold | Unknown |  |
| quantity_total | Unknown |  |
| seatmap_number | Unknown |  |
| sort_order | Unknown |  |
| tier | Unknown |  |

### buyer_ticket_class

| Column | Type | Keys |
| --- | --- | --- |
| survey_ticket_class_id | Unknown | PK |
| ticket_buyer_event_id | Unknown | PK, FK |

### ticket_buyer

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK, FK |
| allow_attendee_update | Unknown |  |
| confirmation_message_text | Unknown |  |
| instructions_text | Unknown |  |
| redirect_url | Unknown |  |
| refund_request_enabled | Unknown |  |
| sales_ended_message_text | Unknown |  |
| survey_info_text | Unknown |  |
| survey_name | Unknown |  |
| survey_respondent | Unknown |  |
| survey_time_limit | Unknown |  |

### organization_member

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Unknown | PK |
| organization_id | Unknown | FK |
| immutable | Unknown |  |
| role_summary | Unknown |  |
| type | String |  |

### ticket_group

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| organization_id | Unknown | FK |
| event_ticket_ids | Json |  |
| name | Unknown |  |
| status | Unknown |  |
| tickets | Json |  |

### sub_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown | PK, FK |
| name | Unknown |  |
| parent_category | Json |  |

### category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| name_localized | Unknown |  |
| short_name | Unknown |  |
| short_name_localized | Unknown |  |

### pricing

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| channel | Unknown | FK |
| payment_type | Unknown | FK |
| country | Unknown |  |
| currency | Unknown |  |
| fee_name | Unknown |  |
| fixed_currency | Unknown |  |
| fixed_display | Unknown |  |
| fixed_major_value | Unknown |  |
| fixed_value | Unknown |  |
| item_type | Unknown |  |
| maximum_currency | Unknown |  |
| maximum_display | Unknown |  |
| maximum_major_value | Unknown |  |
| maximum_value | Unknown |  |
| minimum_currency | Unknown |  |
| minimum_display | Unknown |  |
| minimum_major_value | Unknown |  |
| minimum_value | Unknown |  |
| payment_fee | Unknown |  |
| percentage | Unknown |  |
| plan | Unknown |  |

## Relationships

- display_setting(event_id) → event(id)
- discount_hold(hold_id) → event_hold(id)
- discount_hold(discount_id) → discount(id)
- discount_ticket_class(ticket_class_id) → ticket_class(id)
- discount_ticket_class(discount_id) → discount(id)
- discount(event_id) → event(id)
- discount(organization_id) → organization(id)
- custom_question_ticket_class(custom_question_id) → custom_question(id)
- custom_question_choice(custom_question_id) → custom_question(id)
- custom_question(event_id) → event(id)
- user_request(user_id) → users(id)
- users(id) → organization_member(user_id)
- seat_map(event_id) → event(id)
- seat_map(venue_id) → venue(id)
- seat_map(organization_id) → organization(id)
- structure_content_working_module(event_id) → structure_content_working(event_id)
- structure_content_working_widget_tab_slot_host(widget_type) → structure_content_working_widget_tab_slot(widget_type)
- structure_content_working_widget_tab_slot_host(event_id) → structure_content_working_widget_tab(event_id)
- structure_content_working_widget_tab_slot_host(widget_tab_name) → structure_content_working_widget_tab(name)
- structure_content_working_widget_tab_slot(widget_type) → structure_content_working_widget_tab(widget_type)
- structure_content_working_widget_tab_slot(event_id) → structure_content_working_widget_tab(event_id)
- structure_content_working_widget_tab_slot(widget_tab_name) → structure_content_working_widget_tab(name)
- structure_content_working_widget_tab(event_id) → structure_content_working(event_id)
- structure_content_working(event_id) → event(id)
- ticket_class_confirmation_setting(ticket_class_id) → ticket_class(id)
- ticket_class_confirmation_setting(event_id) → event(id)
- ticket_class_confirmation_setting(order_id) → orders(id)
- orders(id) → event(id)
- orders(organization_id) → organization(id)
- organization_role(organization_id) → organization(id)
- ticket_delivery_method(ticket_class_id) → ticket_class(id)
- ticket_delivery_method(event_id) → event(id)
- ticket_delivery_sales_channel(ticket_class_id) → ticket_class(id)
- ticket_delivery_sales_channel(event_id) → event(id)
- ticket_class(inventory_tier_id) → inventory_tier(id)
- ticket_class(event_id) → event(id)
- venue(organization_id) → organization(id)
- default_question_ticket_class(default_question_id) → default_question(id)
- default_question_choice(default_question_id) → default_question(id)
- default_question(event_id) → event(id)
- event_checkout_offline_setting(event_id) → event(id)
- event_subcategory(event_id) → event(id)
- event(category_id) → category(id)
- event(subcategory_id) → sub_category(id)
- event(venue_id) → venue(id)
- event(organization_id) → organization(id)
- event(organizer_id) → organization_member(user_id)
- event(format_id) → format(id)
- event_hold(event_id) → event(id)
- event_capacity(event_id) → event(id)
- attendee_barcode(attendee_id) → attendee(id)
- attendee_answer(question_id) → attendee_question(id)
- attendee_answer(attendee_id) → attendee(id)
- attendee_question(attendee_id) → attendee(id)
- attendee(event_id) → event(id)
- attendee(ticket_class_id) → ticket_class(id)
- attendee(invited_by) → organization_member(user_id)
- attendee(order_id) → orders(id)
- attendee(organization_id) → organization(id)
- inventory_tier_ticket_class(inventory_tier_id) → inventory_tier(id)
- inventory_tier_hold(id) → event_hold(id)
- inventory_tier_hold(event_id) → event(id)
- inventory_tier_hold(inventory_tier_id) → inventory_tier(id)
- inventory_tier(event_id) → event(id)
- buyer_ticket_class(ticket_buyer_event_id) → ticket_buyer(event_id)
- ticket_buyer(event_id) → event(id)
- organization_member(organization_id) → organization(id)
- ticket_group(organization_id) → organization(id)
- sub_category(category_id) → category(id)
- pricing(payment_type) → event_checkout_offline_setting(payment_method)
- pricing(channel) → ticket_delivery_sales_channel(sales_channel)