# Bizzabo schema ERD

Table and field reference for the Fivetran Bizzabo connector.

## Table & Field Reference

### attendee_analytics

| Column | Type | Keys |
| --- | --- | --- |
| account_id | Unknown | PK |
| event_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |
| ticket_id | Unknown | PK, FK |
| attended_type | Unknown |  |
| attendee_email | Unknown |  |
| attendee_first_name | Unknown |  |
| attendee_last_name | Unknown |  |
| checkin_time | Instant |  |
| checkout_time | Instant |  |
| created | Instant |  |
| modified | Instant |  |
| session_name | Unknown |  |

### contact

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

### event_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created | Instant |  |
| description | Unknown |  |
| event_type | Unknown |  |
| icon | Unknown |  |
| modified | Instant |  |
| name | Unknown |  |
| status | Unknown |  |

### event_type

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

### event_category

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

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| archived | Unknown |  |
| attendance_type | Unknown |  |
| cover_photo_url | Unknown |  |
| created | Instant |  |
| description | Unknown |  |
| end_date | Instant |  |
| header_logo_url | Unknown |  |
| languages | Unknown |  |
| modified | Instant |  |
| name | Unknown |  |
| short_code | Unknown |  |
| start_date | Instant |  |
| status | Unknown |  |
| support_email | Unknown |  |
| timezone | Unknown |  |
| twitter_hashtag | 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 |  |

### registration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| event_id | Unknown | FK |
| flow_id | Unknown | FK |
| ticket_id | Unknown | FK |
| charge | Unknown |  |
| checked_in | Unknown |  |
| checked_in_date | Instant |  |
| checkedout_date | Instant |  |
| created | Instant |  |
| currency | Unknown |  |
| fees | Unknown |  |
| form_submission_status | Unknown |  |
| invoice | Unknown |  |
| magic_link | Unknown |  |
| manage_registration_link | Unknown |  |
| modified | Instant |  |
| order_id | Unknown |  |
| order_type | Unknown |  |
| payment_date | Instant |  |
| payment_method | Unknown |  |
| payment_status | Unknown |  |
| price | Unknown |  |
| promo_code | Unknown |  |
| registration_date | Instant |  |
| social_promo | Unknown |  |
| swapped | Unknown |  |
| tax | Unknown |  |
| ticket_name | Unknown |  |
| validity | Unknown |  |
| virtual_checkin | Unknown |  |
| custom_billing_address_** |  |  |
| custom_properties_** |  |  |
| custom_utm_params_** |  |  |

### event_goal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| created | Instant |  |
| date_period | Unknown |  |
| end_timestamp | Instant |  |
| goal_value | Unknown |  |
| interval | Unknown |  |
| modified | Instant |  |
| start_timestamp | Instant |  |

### session_registration_setting

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

### session_recording_view

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

### session_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_speaker

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

### session_filter

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

### 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 |  |

### session_sponsor

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

### recording_authorization

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

### recording_session

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |
| broadcast_recording | Unknown |  |
| custom_asset_id | Unknown |  |
| external_asset_id | Unknown |  |
| original_asset_id | Unknown |  |
| recording_is_ready | Unknown |  |
| recording_primary_asset_type | Unknown |  |

### preroll_session

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

### video_producer_session

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |
| associated_provider_livestream_id | Unknown |  |
| guest_url | Unknown |  |
| host_url | Unknown |  |
| restream_video_producer_id | Unknown |  |
| video_producer_id | Unknown |  |
| video_producer_title | Unknown |  |

### session_asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |
| account_id | Unknown |  |
| asset_association_id | Unknown |  |
| asset_id | Unknown |  |
| asset_is_primary | Unknown |  |
| asset_is_ready | Unknown |  |
| asset_media | Unknown |  |
| asset_metadata | Json |  |
| asset_type | Unknown |  |
| creation_date_time | Instant |  |

### 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 |  |
| background_color | Unknown |  |
| description | Unknown |  |
| description_html | Unknown |  |
| enable_recording_session | Unknown |  |
| enable_virtual_session | Unknown |  |
| end_date | Instant |  |
| end_minute | Unknown |  |
| external_id | Unknown |  |
| hidden | Unknown |  |
| image_type | Unknown |  |
| image_url | Unknown |  |
| moderator | Json |  |
| private | Unknown |  |
| registration | Unknown |  |
| registration_capacity | Unknown |  |
| registration_capacity_enable | Unknown |  |
| registration_count | Unknown |  |
| registration_full | Unknown |  |
| registration_visibility | Unknown |  |
| session_card_size | Unknown |  |
| session_type | Unknown |  |
| start_date | Instant |  |
| start_minute | Unknown |  |
| text_color | Unknown |  |
| title | Unknown |  |
| virtual_session_details | Json |  |
| onsite_visibility_** |  |  |

### registration_type

| Column | Type | Keys |
| --- | --- | --- |
| ticket_id | Unknown | PK |
| event_id | Unknown | PK, FK |
| currency_code | Unknown |  |
| name | Unknown |  |
| per_order_max | Unknown |  |
| per_order_min | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| sale_method | Unknown |  |
| tax_rate | Unknown |  |

### session_checkin

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

### agenda_setting_filter_url_filter_tag

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

### agenda_setting_filter_url_filter

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

### agenda_setting_filter_url_location_sublocation

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

### agenda_setting_filter_url_location

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

### agenda_setting_filter_url

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| end_date | Unknown |  |
| end_time | Unknown |  |
| name | Unknown |  |
| start_date | Unknown |  |
| start_time | 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 |  |

### 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 | Instant |  |
| description | Unknown |  |
| email | Unknown |  |
| external_id | Unknown |  |
| facebook | Unknown |  |
| level | Unknown |  |
| linkedin | Unknown |  |
| logo | Unknown |  |
| modified | Instant |  |
| name | Unknown |  |
| position_in_list | Unknown |  |
| promoted_offer | Unknown |  |
| twitter | Unknown |  |
| type | Unknown |  |
| visible | Unknown |  |
| website | Unknown |  |

### speaker

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| bio | Unknown |  |
| blog | Unknown |  |
| company | Unknown |  |
| country | Unknown |  |
| created | Instant |  |
| email | Unknown |  |
| first_name | Unknown |  |
| hidden | Unknown |  |
| last_name | Unknown |  |
| linked_in | Unknown |  |
| modified | Instant |  |
| photo_set_blur | Unknown |  |
| photo_set_large | Unknown |  |
| photo_set_medium | Unknown |  |
| photo_set_small | Unknown |  |
| prefix | Unknown |  |
| title | Unknown |  |
| twitter_handle | Unknown |  |
| web | Unknown |  |

### contact_list

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

### session_starring

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |
| contact_id | Unknown | FK |
| starred | Unknown |  |

### registration_property_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| flow_id | Unknown | PK, FK |
| value | Unknown |  |

### registration_type_property

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| flow_id | Unknown | PK, FK |
| label | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### registration_form

| Column | Type | Keys |
| --- | --- | --- |
| flow_id | Unknown | PK, FK |
| event_id | Unknown | FK |

### registration_flow

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| active | Unknown |  |
| flow_name | Unknown |  |

## Relationships

- attendee_analytics(event_id) → event(id)
- attendee_analytics(ticket_id) → registration_type(ticket_id)
- attendee_analytics(session_id) → session(id)
- contact(event_id) → event(id)
- event_type(event_id) → event(id)
- event_category(event_id) → event(id)
- registration(event_id) → event(id)
- registration(ticket_id) → registration_type(ticket_id)
- registration(flow_id) → registration_flow(id)
- registration(contact_id) → contact(id)
- event_goal(event_id) → event(id)
- session_registration_setting(event_id) → event(id)
- session_recording_view(session_id) → session(id)
- session_recording_view(ticket_id) → registration_type(ticket_id)
- session_recording_view(event_id) → event(id)
- session_rate(contact_id) → contact(id)
- session_rate(session_id) → session(id)
- session_rate(event_id) → event(id)
- session_speaker(event_id) → session(event_id)
- session_speaker(session_id) → session(id)
- session_speaker(speaker_id) → speaker(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)
- recording_authorization(recording_session_id) → recording_session(id)
- recording_authorization(event_id) → recording_session(event_id)
- recording_authorization(session_id) → recording_session(session_id)
- recording_session(event_id) → session(event_id)
- recording_session(session_id) → session(id)
- preroll_session(event_id) → session(event_id)
- preroll_session(session_id) → session(id)
- video_producer_session(event_id) → session(event_id)
- video_producer_session(session_id) → session(id)
- session_asset(event_id) → session(event_id)
- session_asset(session_id) → session(id)
- session(sublocation_id) → agenda_setting_sublocation(id)
- session(location_id) → agenda_setting_location(id)
- session(event_id) → event(id)
- registration_type(event_id) → event(id)
- session_checkin(session_id) → session(id)
- session_checkin(ticket_id) → registration_type(ticket_id)
- session_checkin(event_id) → event(id)
- agenda_setting_filter_url_filter_tag(filter_id) → agenda_setting_filter_url_filter(id)
- agenda_setting_filter_url_filter_tag(event_id) → agenda_setting_filter_url_filter(event_id)
- agenda_setting_filter_url_filter(filter_url_id) → agenda_setting_filter_url(id)
- agenda_setting_filter_url_filter(event_id) → agenda_setting_filter_url(event_id)
- agenda_setting_filter_url_location_sublocation(filter_url_location_id) → agenda_setting_filter_url_location(id)
- agenda_setting_filter_url_location_sublocation(filter_url_id) → agenda_setting_filter_url_location(filter_url_id)
- agenda_setting_filter_url_location_sublocation(event_id) → agenda_setting_filter_url_location(event_id)
- agenda_setting_filter_url_location(filter_url_id) → agenda_setting_filter_url(id)
- agenda_setting_filter_url_location(event_id) → agenda_setting_filter_url(id)
- agenda_setting_filter_url(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) → 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) → 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)
- speaker(event_id) → event(id)
- contact_list(event_id) → event(id)
- session_starring(session_id) → session(id)
- session_starring(contact_id) → contact(id)
- session_starring(event_id) → event(id)
- registration_property_value(flow_id) → registration_type_property(flow_id)
- registration_type_property(flow_id) → registration_form(flow_id)
- registration_form(flow_id) → registration_flow(id)
- registration_form(event_id) → event(id)
- registration_flow(event_id) → event(id)