Bizzabo

Explore the interactive ERD

Table & Field Reference

contact_role

Column	Type	Keys
`index`	Unknown	PK
`contact_id`	Unknown	PKFK
`event_id`	Unknown	PKFK
`role`	Unknown

contact_ticket_type

Column	Type	Keys
`index`	Unknown	PK
`contact_id`	Unknown	PKFK
`event_id`	Unknown	PKFK
`ticket_type`	Unknown

contact_area_interested

Column	Type	Keys
`index`	Unknown	PK
`contact_id`	Unknown	PKFK
`event_id`	Unknown	PKFK
`areas_interested`	Unknown

contact_current

Column	Type	Keys
`index`	Unknown	PK
`contact_id`	Unknown	PKFK
`event_id`	Unknown	PKFK
`current`	Unknown

contact_country

Column	Type	Keys
`index`	Unknown	PK
`contact_id`	Unknown	PKFK
`event_id`	Unknown	PKFK
`country`	Unknown

contact_attending

Column	Type	Keys
`index`	Unknown	PK
`contact_id`	Unknown	PKFK
`event_id`	Unknown	PKFK
`attending`	Unknown

contact

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`created`	Unknown
`modified`	Unknown
`contact_properties_`

registration_interested_area

Column	Type	Keys
`index`	Unknown	PK
`registration_id`	Unknown	PKFK
`area`	Unknown

session_registration

Column	Type	Keys
`index`	Unknown	PK
`registration_id`	Unknown	PKFK
`session_id`	Unknown	FK

registration_opportunity

Column	Type	Keys
`index`	Unknown	PK
`registration_id`	Unknown	PKFK
`opportunity`	Unknown

registration_wanted_subject

Column	Type	Keys
`index`	Unknown	PK
`registration_id`	Unknown	PKFK
`wanted_subject`	Unknown

registration_considered_property

Column	Type	Keys
`index`	Unknown	PK
`registration_id`	Unknown	PKFK
`considered`	Unknown

registration_destination

Column	Type	Keys
`index`	Unknown	PK
`registration_id`	Unknown	PKFK
`destination`	Unknown

registration_ticket_type

Column	Type	Keys
`index`	Unknown	PK
`registration_id`	Unknown	PKFK
`ticket_type`	Unknown

registration_country

Column	Type	Keys
`index`	Unknown	PK
`registration_id`	Unknown	PKFK
`which_country`	Unknown

please_tick_this_box

Column	Type	Keys
`index`	Unknown	PK
`registration_id`	Unknown	PKFK
`please_tick_this_box`	Unknown

registration_curriculum_offered

Column	Type	Keys
`index`	Unknown	PK
`registration_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`filter_id`	Unknown	PKFK
`name`	Unknown

agenda_setting_filter

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`name`	Unknown
`type`	Unknown
`visible`	Unknown

agenda_setting_sublocation

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`location_id`	Unknown	PKFK
`name`	Unknown

agenda_setting_location

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`name`	Unknown

agenda_setting

Column	Type	Keys
`event_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`event_id`	Unknown	PKFK
`session_id`	Unknown	PKFK
`feedback`	Unknown
`rated`	Unknown
`score`	Unknown

session_registration_setting

Column	Type	Keys
`event_id`	Unknown	PKFK
`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	PKFK
`session_id`	Unknown	PKFK
`ticket_id`	Unknown	PKFK
`done_by_organizer`	Unknown
`overrule`	Unknown
`status`	Unknown

session_speaker

Column	Type	Keys
`event_id`	Unknown	PKFK
`session_id`	Unknown	PKFK
`speaker_id`	Unknown	PKFK
`role`	Unknown

session_filter_tag

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`session_filter_id`	Unknown	PKFK
`session_id`	Unknown	PKFK
`tag_id`	Unknown

session_filter

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`session_id`	Unknown	PKFK

session_attachment

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`session_id`	Unknown	PKFK
`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	PKFK
`session_id`	Unknown	PKFK
`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	PKFK
`session_id`	Unknown	PKFK
`moderator_id`	Unknown

session

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`registration_type_property_index`	Unknown	PKFK
`ticket_id`	Unknown	PKFK
`value`	Unknown

registration_type_property

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`ticket_id`	Unknown	PKFK
`label`	Unknown
`mandatory`	Unknown
`name`	Unknown
`type`	Unknown

registration_type

Column	Type	Keys
`ticket_id`	Unknown	PK
`event_id`	Unknown	PKFK
`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	PKFK
`partner_id`	Unknown	PKFK
`name`	Unknown
`url`	Unknown

partner_mobile_custom_button

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`partner_id`	Unknown	PKFK
`name`	Unknown
`url`	Unknown

partner

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`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	PKFK
`created`	Unknown
`name`	Unknown
`size`	Unknown
`type`	Unknown