Bizzabo
Explore the interactive ERD
Table & Field Reference
attendee_analytics
| Column | Type | Keys |
|---|---|---|
account_id | Unknown | PK |
event_id | Unknown | PKFK |
session_id | Unknown | PKFK |
ticket_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
type | Unknown |
event_category
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
session_id | Unknown | PKFK |
ticket_id | Unknown | FK |
email | Unknown | |
viewed_at | Unknown |
session_rate
| Column | Type | Keys |
|---|---|---|
contact_id | Unknown | PKFK |
event_id | Unknown | PKFK |
session_id | Unknown | PKFK |
feedback | Unknown | |
rated | Unknown | |
score | Unknown |
session_speaker
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | PKFK |
session_id | Unknown | PKFK |
speaker_id | Unknown | FK |
role | Unknown |
session_filter
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | PKFK |
session_id | Unknown | PKFK |
tags | Json |
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 |
session_sponsor
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
session_id | Unknown | PKFK |
sponsor_id | Unknown |
recording_authorization
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
recording_session_id | Unknown | PKFK |
session_id | Unknown | PKFK |
recording_authorization | Unknown |
recording_session
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | PKFK |
session_id | Unknown | PKFK |
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 | PKFK |
session_id | Unknown | PKFK |
account_id | Unknown | |
asset_id | Unknown | |
future_asset_id | Unknown |
video_producer_session
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
session_id | Unknown | PKFK |
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 | PKFK |
session_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
session_id | Unknown | PKFK |
ticket_id | Unknown | PKFK |
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 | PKFK |
filter_id | Unknown | PKFK |
name | Unknown |
agenda_setting_filter_url_filter
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | PKFK |
filter_url_id | Unknown | PKFK |
name | Unknown | |
type | Unknown | |
visible | Unknown |
agenda_setting_filter_url_location_sublocation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | PKFK |
filter_url_id | Unknown | PKFK |
filter_url_location_id | Unknown | PKFK |
name | Unknown |
agenda_setting_filter_url_location
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | PKFK |
filter_url_id | Unknown | PKFK |
name | Unknown |
agenda_setting_filter_url
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | PKFK |
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 | 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 |
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 | 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 | PKFK |
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 | PKFK |
created | Instant | |
name | Unknown | |
size | Unknown | |
type | Unknown |
session_starring
| Column | Type | Keys |
|---|---|---|
event_id | Unknown | PKFK |
session_id | Unknown | PKFK |
contact_id | Unknown | FK |
starred | Unknown |
registration_property_value
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
flow_id | Unknown | PKFK |
value | Unknown |
registration_type_property
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
flow_id | Unknown | PKFK |
label | Unknown | |
name | Unknown | |
type | Unknown |
registration_form
| Column | Type | Keys |
|---|---|---|
flow_id | Unknown | PKFK |
event_id | Unknown | FK |
registration_flow
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | PKFK |
active | Unknown | |
flow_name | Unknown |