# Bizzabo schema ERD

Table and field reference for the Fivetran Bizzabo connector.

## Table & Field Reference

### contact_role

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| role | Unknown |  |

### contact_ticket_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| ticket_type | Unknown |  |

### contact_area_interested

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| areas_interested | Unknown |  |

### contact_current

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| current | Unknown |  |

### contact_country

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| country | Unknown |  |

### contact_attending

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| attending | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| created | Unknown |  |
| modified | Unknown |  |
| contact_properties_** |  |  |

### registration_interested_area

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| registration_id | Unknown | PK, FK |
| area | Unknown |  |

### session_registration

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| registration_id | Unknown | PK, FK |
| session_id | Unknown | FK |

### registration_opportunity

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| registration_id | Unknown | PK, FK |
| opportunity | Unknown |  |

### registration_wanted_subject

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| registration_id | Unknown | PK, FK |
| wanted_subject | Unknown |  |

### registration_considered_property

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| registration_id | Unknown | PK, FK |
| considered | Unknown |  |

### registration_destination

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| registration_id | Unknown | PK, FK |
| destination | Unknown |  |

### registration_ticket_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| registration_id | Unknown | PK, FK |
| ticket_type | Unknown |  |

### registration_country

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| registration_id | Unknown | PK, FK |
| which_country | Unknown |  |

### please_tick_this_box

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| registration_id | Unknown | PK, FK |
| please_tick_this_box | Unknown |  |

### registration_curriculum_offered

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| registration_id | Unknown | PK, FK |
| curriculum_offered | Unknown |  |

### registration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| event_id | Unknown | FK |
| ticket_id | Unknown | FK |
| charge | Unknown |  |
| checked_in | Unknown |  |
| checked_in_date | Unknown |  |
| created | Unknown |  |
| currency | Unknown |  |
| fees | Unknown |  |
| invoice | Unknown |  |
| magic_link | Unknown |  |
| manage_registration_link | Unknown |  |
| modified | Unknown |  |
| order_id | Unknown |  |
| order_type | Unknown |  |
| payment_date | Unknown |  |
| payment_method | Unknown |  |
| payment_status | Unknown |  |
| price | Unknown |  |
| promo_code | Unknown |  |
| promo_name | Unknown |  |
| registration_date | Unknown |  |
| social_promo | Unknown |  |
| status | Unknown |  |
| swapped | Unknown |  |
| ticket_name | Unknown |  |
| utm_campaign | Unknown |  |
| utm_medium | Unknown |  |
| utm_source | Unknown |  |
| utm_term | Unknown |  |
| validity | Unknown |  |
| virtual_checkin | Unknown |  |
| custom_billing_address_** |  |  |
| custom_properties_** |  |  |

### event_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| type | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attendance_type | Unknown |  |
| cover_photo_url | Unknown |  |
| created | Unknown |  |
| description | Unknown |  |
| end_date | Unknown |  |
| header_logo_url | Unknown |  |
| languages | Unknown |  |
| modified | Unknown |  |
| name | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| support_email | Unknown |  |
| timezone | Unknown |  |
| venue_address_1 | Unknown |  |
| venue_city | Unknown |  |
| venue_country | Unknown |  |
| venue_display_address | Unknown |  |
| venue_id | Unknown |  |
| venue_name | Unknown |  |
| venue_state | Unknown |  |
| website_url | Unknown |  |

### agenda_setting_filter_tag

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

### agenda_setting_filter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |
| visible | Unknown |  |

### agenda_setting_sublocation

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

### agenda_setting_location

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

### agenda_setting

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK, FK |
| date_format | Unknown |  |
| defaulte_date | Unknown |  |
| end_date | Unknown |  |
| month_display | Unknown |  |
| start_date | Unknown |  |
| time_format | Unknown |  |

### speaker

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| bio | Unknown |  |
| blog | Unknown |  |
| company | Unknown |  |
| country | Unknown |  |
| county | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| hidden | Unknown |  |
| last_name | Unknown |  |
| linked_in | Unknown |  |
| photoset_blur | Unknown |  |
| photoset_large | Unknown |  |
| photoset_medium | Unknown |  |
| photoset_small | Unknown |  |
| title | Unknown |  |
| twitter_handle | Unknown |  |
| web | Unknown |  |

### sessions_rate

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |
| feedback | Unknown |  |
| rated | Unknown |  |
| score | Unknown |  |

### session_registration_setting

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK, FK |
| allow_overlapping_registration | Unknown |  |
| capacity_limit_enabled | Unknown |  |
| capacity_limit_reached_enabled | Unknown |  |
| capacity_unlimit_enabled | Unknown |  |
| custom_** |  |  |

### sessions_checkin

| Column | Type | Keys |
| --- | --- | --- |
| created | Unknown | PK |
| event_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |
| ticket_id | Unknown | PK, FK |
| done_by_organizer | Unknown |  |
| overrule | Unknown |  |
| status | Unknown |  |

### session_speaker

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |
| speaker_id | Unknown | PK, FK |
| role | Unknown |  |

### session_filter_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| session_filter_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |
| tag_id | Unknown |  |

### session_filter

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

### session_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |
| display_name | Unknown |  |
| file_name | Unknown |  |
| icon | Unknown |  |
| position | Unknown |  |
| type | Unknown |  |
| url | Unknown |  |

### session_sponsor

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |
| sponsor_id | Unknown |  |

### virtual_session_authorization_value

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| session_id | Unknown | FK |
| authorization_type | Unknown |  |
| authorization_value | Unknown |  |
| event_id | Unknown |  |

### virtual_session_recording_authorization_value

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| session_id | Unknown | FK |
| authorization_type | Unknown |  |
| authorization_value | Unknown |  |
| event_id | Unknown |  |

### session_moderator

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |
| moderator_id | Unknown |  |

### session

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| location_id | Unknown | FK |
| sublocation_id | Unknown | FK |
| allow_rating | Unknown |  |
| associated_contact | Json |  |
| description | Unknown |  |
| description_html | Unknown |  |
| enable_virtual_session | Unknown |  |
| end_date | Unknown |  |
| end_minute | Unknown |  |
| external_id | Unknown |  |
| hidden | Unknown |  |
| image_type | Unknown |  |
| image_url | Unknown |  |
| private | Unknown |  |
| recording_session_account_id | Unknown |  |
| recording_session_broadcast_recording | Unknown |  |
| recording_session_custom_asset_id | Unknown |  |
| recording_session_event_id | Unknown |  |
| recording_session_id | Unknown |  |
| recording_session_recording_is_ready | Unknown |  |
| recording_session_recording_primary_asset_type | Unknown |  |
| recording_session_session_id | Unknown |  |
| registration | Unknown |  |
| registration_capacity | Unknown |  |
| registration_capacity_enable | Unknown |  |
| registration_count | Unknown |  |
| registration_full | Unknown |  |
| registration_visibility | Unknown |  |
| session_card_size | Unknown |  |
| start_date | Unknown |  |
| start_minute | Unknown |  |
| title | Unknown |  |
| virtual_session_detail_account_id | Unknown |  |
| virtual_session_detail_asset_association_id | Unknown |  |
| virtual_session_detail_asset_id | Unknown |  |
| virtual_session_detail_asset_is_primary | Unknown |  |
| virtual_session_detail_asset_media | Unknown |  |
| virtual_session_detail_asset_type | Unknown |  |
| virtual_session_detail_asset_url | Unknown |  |
| virtual_session_detail_attendee_url | Unknown |  |
| virtual_session_detail_available_hls | Unknown |  |
| virtual_session_detail_description | Unknown |  |
| virtual_session_detail_duration | Unknown |  |
| virtual_session_detail_event_id | Unknown |  |
| virtual_session_detail_join_action | Unknown |  |
| virtual_session_detail_session_id | Unknown |  |
| virtual_session_detail_title | Unknown |  |
| virtual_session_detail_type | Unknown |  |
| virtual_session_detail_video_provider_type | Unknown |  |
| recording_session_authorization_** |  |  |

### sessions_recording_view

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| session_id | Unknown | PK, FK |
| event_id | Unknown | FK |
| ticket_id | Unknown | FK |
| email | Unknown |  |
| viewed_at | Unknown |  |

### registration_property_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| registration_type_property_index | Unknown | PK, FK |
| ticket_id | Unknown | PK, FK |
| value | Unknown |  |

### registration_type_property

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| ticket_id | Unknown | PK, FK |
| label | Unknown |  |
| mandatory | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### registration_type

| Column | Type | Keys |
| --- | --- | --- |
| ticket_id | Unknown | PK |
| event_id | Unknown | PK, FK |
| availability | Unknown |  |
| availability_end | Unknown |  |
| availability_end_timestamp | Unknown |  |
| availability_start_timestamp | Unknown |  |
| currency_code | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| per_order_max | Unknown |  |
| per_order_min | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| sale_method | Unknown |  |
| tax_name | Unknown |  |
| tax_rate | Unknown |  |

### partner_custom_button

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| partner_id | Unknown | PK, FK |
| name | Unknown |  |
| url | Unknown |  |

### partner_mobile_custom_button

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| partner_id | Unknown | PK, FK |
| name | Unknown |  |
| url | Unknown |  |

### partner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| booth | Unknown |  |
| contact_email | Unknown |  |
| contact_phone | Unknown |  |
| created | Unknown |  |
| description | Unknown |  |
| external_id | Unknown |  |
| facebook | Unknown |  |
| level | Unknown |  |
| linkedin | Unknown |  |
| logo | Unknown |  |
| name | Unknown |  |
| promoted_offer | Unknown |  |
| twitter | Unknown |  |
| type | Unknown |  |
| visible | Unknown |  |
| website | Unknown |  |

### contact_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| created | Unknown |  |
| name | Unknown |  |
| size | Unknown |  |
| type | Unknown |  |

## Relationships

- contact_role(event_id) → contact(event_id)
- contact_role(contact_id) → contact(id)
- contact_ticket_type(event_id) → contact(event_id)
- contact_ticket_type(contact_id) → contact(id)
- contact_area_interested(event_id) → contact(event_id)
- contact_area_interested(contact_id) → contact(id)
- contact_current(event_id) → contact(event_id)
- contact_current(contact_id) → contact(id)
- contact_country(event_id) → contact(event_id)
- contact_country(contact_id) → contact(id)
- contact_attending(event_id) → contact(event_id)
- contact_attending(contact_id) → contact(id)
- contact(event_id) → event(id)
- registration_interested_area(registration_id) → registration(id)
- session_registration(session_id) → session(id)
- session_registration(registration_id) → registration(id)
- registration_opportunity(registration_id) → registration(id)
- registration_wanted_subject(registration_id) → registration(id)
- registration_considered_property(registration_id) → registration(id)
- registration_destination(registration_id) → registration(id)
- registration_ticket_type(registration_id) → registration(id)
- registration_country(registration_id) → registration(id)
- please_tick_this_box(registration_id) → registration(id)
- registration_curriculum_offered(registration_id) → registration(id)
- registration(event_id) → event(id)
- registration(ticket_id) → registration_type(ticket_id)
- registration(contact_id) → contact(id)
- event_type(event_id) → event(id)
- agenda_setting_filter_tag(filter_id) → agenda_setting_filter(id)
- agenda_setting_filter_tag(event_id) → agenda_setting_filter(event_id)
- agenda_setting_filter(event_id) → agenda_setting(event_id)
- agenda_setting_sublocation(location_id) → agenda_setting_location(id)
- agenda_setting_sublocation(event_id) → agenda_setting_location(event_id)
- agenda_setting_location(event_id) → agenda_setting(event_id)
- agenda_setting(event_id) → event(id)
- speaker(event_id) → event(id)
- sessions_rate(contact_id) → contact(id)
- sessions_rate(session_id) → session(id)
- sessions_rate(event_id) → event(id)
- session_registration_setting(event_id) → event(id)
- sessions_checkin(session_id) → session(id)
- sessions_checkin(ticket_id) → registration_type(ticket_id)
- sessions_checkin(event_id) → event(id)
- session_speaker(speaker_id) → speaker(id)
- session_speaker(event_id) → session(event_id)
- session_speaker(session_id) → session(id)
- session_filter_tag(event_id) → session_filter(event_id)
- session_filter_tag(session_filter_id) → session_filter(id)
- session_filter_tag(session_id) → session_filter(session_id)
- session_filter(event_id) → session(event_id)
- session_filter(session_id) → session(id)
- session_attachment(event_id) → session(event_id)
- session_attachment(session_id) → session(id)
- session_sponsor(event_id) → session(event_id)
- session_sponsor(session_id) → session(id)
- virtual_session_authorization_value(session_id) → session(id)
- virtual_session_recording_authorization_value(session_id) → session(id)
- session_moderator(event_id) → session(event_id)
- session_moderator(session_id) → session(id)
- session(sublocation_id) → agenda_setting_sublocation(id)
- session(location_id) → agenda_setting_location(id)
- session(event_id) → event(id)
- sessions_recording_view(session_id) → session(id)
- sessions_recording_view(event_id) → event(id)
- sessions_recording_view(ticket_id) → registration_type(ticket_id)
- registration_property_value(event_id) → registration_type_property(event_id)
- registration_property_value(ticket_id) → registration_type_property(ticket_id)
- registration_property_value(registration_type_property_index) → registration_type_property(index)
- registration_type_property(event_id) → registration_type(event_id)
- registration_type_property(ticket_id) → registration_type(ticket_id)
- registration_type(event_id) → event(id)
- partner_custom_button(partner_id) → partner(id)
- partner_custom_button(event_id) → partner(event_id)
- partner_mobile_custom_button(partner_id) → partner(id)
- partner_mobile_custom_button(event_id) → partner(event_id)
- partner(event_id) → event(id)
- contact_list(event_id) → event(id)