Cvent
Explore the interactive ERD
Table & Field Reference
event_question
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | FK |
created | Unknown | |
created_by | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
text | Unknown |
attendee_insight_score
| Column | Type | Keys |
|---|---|---|
attendee_id | Unknown | PKFK |
attendee_insight_id | Unknown | PKFK |
event_id | Unknown | PKFK |
created | Unknown | |
created_by | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
points | Unknown | |
rank | Unknown |
appointment_participant
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
appointment_id | Unknown | PKFK |
attendee_id | Unknown | FK |
contact_id | Unknown | |
created | Unknown | |
created_by | Unknown | |
deleted | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
participated | Unknown | |
private_note_viewer | Unknown | |
question_viewer | Unknown | |
response | Unknown | |
type | Unknown |
appointment_question
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
appointment_id | Unknown | PKFK |
name | Unknown | |
order_number | Unknown | |
type | Unknown | |
value | Json |
appointment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
appointment_event_id | Unknown | FK |
auto_accept_attendee | Unknown | |
code | Unknown | |
created | Unknown | |
created_by | Unknown | |
deleted | Unknown | |
end_date | Unknown | |
enforce_schedule_rule | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
location_name | Unknown | |
modified | Unknown | |
name | Unknown | |
start_date | Unknown | |
status | Unknown | |
type_name | Unknown |
attendance_duration
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
attendee_id | Unknown | FK |
event_id | Unknown | FK |
session_id | Unknown | FK |
created | Unknown | |
created_by | Unknown | |
deleted | Unknown | |
duration | Unknown | |
duration_type | Unknown | |
first_seen | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
last_seen | Unknown | |
type | Unknown |
attendee_activity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
attendee_id | Unknown | FK |
event_id | Unknown | FK |
created | Unknown | |
data_type | Unknown | |
name | Unknown | |
opened | Unknown | |
type | Unknown |
contact_custom_field
| Column | Type | Keys |
|---|---|---|
contact_id | Unknown | PKFK |
id | Unknown | PKFK |
value | Json |
contact
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company | Unknown | |
created | Unknown | |
created_by | Unknown | |
deleted | Unknown | |
email | Unknown | |
first_name | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
last_name | Unknown | |
opt_outby | Unknown | |
opt_outdate | Unknown | |
opt_outopted_out | Unknown | |
primary_address_type | Unknown | |
source_id | Unknown |
attendee_insight_stats
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
attendee_insight_id | Unknown | FK |
activity_count | Unknown | |
attendee_count | Unknown | |
average_attendee_score | Unknown |
card_transaction_reconciliation
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
card_transaction_id | Unknown | PKFK |
amount | Unknown | |
budget_item_id | Unknown | |
reconciled_by | Unknown | |
reconciled_date | Unknown | |
status | Unknown |
card_transaction_description
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
card_transaction_id | Unknown | PKFK |
description | Unknown |
card_transaction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
card_id | Unknown | FK |
event_id | Unknown | FK |
amount | Unknown | |
currency | Unknown | |
merchant | Unknown | |
transaction_date | Unknown | |
type | Unknown |
event_role_assignment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | FK |
user_id | Unknown | FK |
assigned | Unknown | |
assigned_by | Unknown | |
role_id | Unknown |
attendee_insight
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | FK |
created | Unknown | |
created_by | Unknown | |
defaultly | Unknown | |
description | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
name | Unknown |
users_email
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
users_id | Unknown | PKFK |
is_primary | Unknown | |
type | Unknown | |
value | Unknown |
users_phone_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
users_id | Unknown | PKFK |
type | Unknown | |
value | Unknown |
users_address
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
users_id | Unknown | PKFK |
country | Unknown | |
is_primary | Unknown | |
locality | Unknown | |
postal_code | Unknown | |
region | Unknown | |
street_address | Unknown | |
type | Unknown |
users_group
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
users_id | Unknown | PKFK |
display | Unknown | |
value | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
company | Unknown | |
created | Unknown | |
family_name | Unknown | |
federated_id | Unknown | |
given_name | Unknown | |
home_fax | Unknown | |
honorific_prefix | Unknown | |
last_modified | Unknown | |
locale | Unknown | |
location | Unknown | |
middle_name | Unknown | |
name | Unknown | |
pager | Unknown | |
resource_type | Unknown | |
send_login_detail | Unknown | |
timezone | Unknown | |
title | Unknown | |
user_type | Unknown | |
work_fax | Unknown |
event_transaction_order
| Column | Type | Keys |
|---|---|---|
event_id | Unknown | PKFK |
event_transaction_id | Unknown | PKFK |
order_id | Unknown | PKFK |
event_transaction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | PKFK |
attendee_id | Unknown | FK |
amount | Unknown | |
batch_number | Unknown | |
billing_address_1 | Unknown | |
billing_address_2 | Unknown | |
billing_address_3 | Unknown | |
billing_city | Unknown | |
billing_country_code | Unknown | |
billing_postal_code | Unknown | |
billing_region | Unknown | |
billing_region_code | Unknown | |
cc_expiration_date | Unknown | |
created | Unknown | |
created_by | Unknown | |
currency | Unknown | |
date | Unknown | |
journal_number | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
name_on_credit_card | Unknown | |
payment_method | Unknown | |
payment_note | Unknown | |
payment_type | Unknown | |
processor_transaction_id | Unknown | |
reference_number | Unknown | |
success | Unknown |
speaker
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
event_id | Unknown | FK |
biography | Unknown | |
category_id | Unknown | |
category_name | Unknown | |
code | Unknown | |
company | Unknown | |
created | Unknown | |
created_by | Unknown | |
designation | Unknown | |
email | Unknown | |
featured | Unknown | |
first_name | Unknown | |
internal_note | Unknown | |
last_modified | Instant | |
last_modified_by | Unknown | |
last_name | Unknown | |
order_number | Unknown | |
prefix | Unknown | |
tittle | Unknown | |
visibility | Unknown |
campaign
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
click_tracking_enabled | Unknown | |
company_name | Unknown | |
created | Unknown | |
created_by | Unknown | |
from_name | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
name | Unknown |
survey_event
| Column | Type | Keys |
|---|---|---|
event_id | Unknown | PK |
survey_id | Unknown | PKFK |
survey
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
activate_date | Unknown | |
author_company | Unknown | |
author_email | Unknown | |
author_first_name | Unknown | |
author_last_name | Unknown | |
author_title | Unknown | |
code | Unknown | |
created | Unknown | |
created_by | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
response_count | Unknown | |
status | Unknown | |
timezone | Unknown | |
title | Unknown | |
type | Unknown |
appointment_event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | FK |
deleted | Unknown |
meeting_request_form_status
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
meeting_request_form_id | Unknown | PKFK |
status | Unknown |
meeting_request_form_question
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
meeting_request_form_id | Unknown | PKFK |
field | Unknown | |
hidden | Unknown | |
max_date | Unknown | |
max_length | Unknown | |
min_date | Unknown | |
name | Unknown | |
order_number | Unknown | |
required | Unknown | |
type | Unknown |
meeting_request_form
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
consent_question | Json | |
name | Unknown |
card_reporting_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
card_id | Unknown | PKFK |
name | Unknown | |
value | Unknown |
card
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | FK |
available_balance | Unknown | |
billing_account_id | Unknown | |
card_holder_name | Unknown | |
company | Unknown | |
description | Unknown | |
end_date | Unknown | |
first_6 | Unknown | |
full_name | Unknown | |
issuer | Unknown | |
last_4 | Unknown | |
last_7 | Unknown | |
purchase_template | Unknown | |
spend_limit | Unknown | |
start_date | Unknown | |
status | Unknown | |
total_transaction_amount | Unknown | |
type | Unknown |
session
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | FK |
capacity_unlimited | Unknown | |
code | Unknown | |
created | Unknown | |
custom_fields | Json | |
data_tag_code | Unknown | |
description | Unknown | |
display_on_agenda | Unknown | |
enable_waitlist | Unknown | |
end_date | Unknown | |
featured | Unknown | |
group_id | Unknown | |
included_session | Unknown | |
last_modified | Unknown | |
open_for_attendee_hub | Unknown | |
open_for_registration | Unknown | |
presentation_type | Unknown | |
registration_types | Json | |
start | Unknown | |
status | Unknown | |
timezone | Unknown | |
title | Unknown | |
type_id | Unknown | |
type_name | Unknown | |
virtual | Unknown | |
virtual_capacity_unlimited | Unknown | |
waitlist_capacity | Unknown |
session_speaker
| Column | Type | Keys |
|---|---|---|
session_id | Unknown | PKFK |
speaker_id | Unknown | PKFK |
video_session
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
video_id | Unknown | PKFK |
session_id | Unknown |
video_speaker
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
video_id | Unknown | PKFK |
speaker_id | Unknown |
video_exhibitor
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
video_id | Unknown | PKFK |
exhibitor_id | Unknown |
video
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | FK |
created | Unknown | |
duration | Unknown | |
encoding_profile | Unknown | |
generated_thumbnail_url | Unknown | |
hls_input | Unknown | |
last_modified | Unknown | |
size | Unknown | |
source_id | Unknown | |
source_status | Unknown | |
status | Unknown | |
tags | Json | |
title | Unknown | |
type | Unknown | |
upload_completed | Unknown | |
upload_started | Unknown | |
url | Unknown |
event_venue
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
address_1 | Unknown | |
address_2 | Unknown | |
address_3 | Unknown | |
city | Unknown | |
country | Unknown | |
country_code | Unknown | |
latitude | Unknown | |
longitude | Unknown | |
name | Unknown | |
postal_code | Unknown | |
region | Unknown | |
region_code | Unknown |
event_language
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
languages | Unknown |
event_planner
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
deleted | Unknown | |
email | Unknown | |
first_name | Unknown | |
last_name | Unknown |
event_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | PKFK |
name | Unknown | |
order_number | Unknown | |
type | Unknown | |
value | Json |
event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agenda_link | Unknown | |
archive_after | Unknown | |
capacity | Unknown | |
category_name | Unknown | |
close_after | Unknown | |
code | Unknown | |
created | Unknown | |
created_by | Unknown | |
currency | Unknown | |
default_locale | Unknown | |
description | Unknown | |
end_date | Unknown | |
event_status | Unknown | |
format | Unknown | |
invitation_link | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
launch_after | Unknown | |
note | Unknown | |
registration_link | Unknown | |
registration_security_level | Unknown | |
start_date | Unknown | |
status | Unknown | |
summary_link | Unknown | |
test_mode | Unknown | |
timezone | Unknown | |
title | Unknown | |
type | Unknown | |
virtual | Unknown |
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
attendee_id | Unknown | FK |
contact_id | Unknown | FK |
event_id | Unknown | FK |
bounced | Unknown | |
clicked | Unknown | |
created | Unknown | |
created_by | Unknown | |
first_clicked | Unknown | |
first_opened | Unknown | |
from_date | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
opened | Unknown | |
sent | Unknown | |
status | Unknown | |
subject | Unknown | |
to_date | Unknown | |
type | Unknown | |
undeliverable | Unknown |
custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
last_modified_by | Unknown | FK |
active | Unknown | |
category | Unknown | |
code | Unknown | |
consent_field | Unknown | |
created | Unknown | |
default_tag_text | Unknown | |
details | Json | |
display_in_data_tag | Unknown | |
display_in_event_creation_wizard | Unknown | |
help_text | Unknown | |
last_modified | Unknown | |
name | Unknown | |
orders | Unknown | |
page_visibility_essential_event_creation_form | Unknown | |
page_visibility_essential_event_details_form | Unknown | |
page_visibility_webinar_creation_form | Unknown | |
page_visibility_webinar_details_form | Unknown | |
required | Unknown | |
type | Unknown |
text_track
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
video_id | Unknown | PKFK |
auto_generated | Unknown | |
created | Unknown | |
created_by | Unknown | |
defaultly | Unknown | |
error_message | Unknown | |
kind | Unknown | |
label | Unknown | |
languages | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
published | Unknown | |
status | Unknown | |
url | Unknown |
question_value
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
attendee_id | Unknown | PKFK |
attendee_question_id | Unknown | PKFK |
value | String |
attendee_question
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
attendee_id | Unknown | PKFK |
name | Unknown | |
order_number | Unknown | |
type | Unknown |
attendee_answer_value
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
question_id | Unknown | PK |
attendee_id | Unknown | PKFK |
value | Unknown |
attendee
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
event_id | Unknown | FK |
admission_item_code | Unknown | |
admission_item_id | Unknown | |
admission_item_name | Unknown | |
allow_appointment_push_notification | Unknown | |
attendee_last_modified | Unknown | |
checked_in | Unknown | |
confirmation_number | Unknown | |
contact_attendee_segment_id | Json | |
contact_opt_out_attendee_segment_id | Json | |
contact_type_attendee_segment_id | Json | |
created | Unknown | |
created_by | Unknown | |
group_leader | Unknown | |
group_member | Unknown | |
guest | Unknown | |
home_address_address_1 | Unknown | |
home_address_address_2 | Unknown | |
home_address_city | Unknown | |
home_address_country | Unknown | |
home_address_country_code | Unknown | |
home_address_postal_code | Unknown | |
home_address_region | Unknown | |
home_address_region_code | Unknown | |
invitation_list_id | Unknown | |
invitation_list_name | Unknown | |
invited_by | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
opted_out | Unknown | |
registered_at | Unknown | |
registration_last_modified | Unknown | |
registration_path_code | Unknown | |
registration_path_id | Unknown | |
registration_path_name | Unknown | |
registration_type_attendee_segment_id | Unknown | |
registration_type_code | Unknown | |
registration_type_id | Unknown | |
registration_type_name | Unknown | |
response_method | Unknown | |
status | Unknown | |
test_record | Unknown | |
type_id | Unknown | |
type_name | Unknown | |
unsubscribed | Unknown |
question_choice
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
question_id | Unknown | PKFK |
label | Unknown | |
short_text | Unknown | |
text | Unknown |
question_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
question_id | Unknown | PKFK |
required | Unknown | |
short_text | Unknown | |
text | Unknown |
question_sub_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
question_id | Unknown | PKFK |
short_text | Unknown | |
text | Unknown |
question_fields_choice
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
question_field_id | Unknown | FK |
question_id | Unknown | FK |
label | Unknown | |
short_text | Unknown | |
text | Unknown |
question_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
question_id | Unknown | PKFK |
notapplicableanswer_shorttext | Unknown | |
notapplicableanswer_text | Unknown | |
otheranswer_shorttext | Unknown | |
otheranswer_text | Unknown | |
required | Unknown | |
short_text | Unknown | |
text | Unknown | |
type | Unknown |
question
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | FK |
survey_id | Unknown | FK |
code | Unknown | |
comments | Unknown | |
created | Unknown | |
created_by | Unknown | |
html_text | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
max_score | Unknown | |
not_applicable_answershort_text | Unknown | |
not_applicable_answertext | Unknown | |
other_answershort_text | Unknown | |
other_answertext | Unknown | |
required | Unknown | |
short_text | Unknown | |
text | Unknown | |
total_sum | Unknown | |
type | Unknown |
exhibitor
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | PKFK |
address_1 | Unknown | |
address_2 | Unknown | |
banner_id | Unknown | |
banner_url | Unknown | |
city | Unknown | |
code | Unknown | |
country | Unknown | |
created | Unknown | |
created_by | Unknown | |
deleted | Unknown | |
description | Unknown | |
email | Unknown | |
event_sponsor | Unknown | |
facebook_url | Unknown | |
featured | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
linked_in_url | Unknown | |
location | Unknown | |
mobile_phone | Unknown | |
name | Unknown | |
other_phone | Unknown | |
postal_code | Unknown | |
profile_logo_id | Unknown | |
profile_logo_url | Unknown | |
region | Unknown | |
source_id | Unknown | |
sponsorship_level_id | Unknown | |
twitter_url | Unknown | |
website | Unknown | |
work_phone | Unknown |
budget_item_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
budget_item_id | Unknown | PKFK |
name | Unknown | |
order_number | Unknown | |
type | Unknown | |
value | Json |
budget_item_cost_tax_detail
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
budget_item_cost_detail_id | Unknown | PKFK |
budget_item_id | Unknown | PKFK |
applied_tax_value | Unknown | |
name | Unknown | |
tax | Unknown | |
tax_type | Unknown |
budget_item_cost_detail
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
budget_item_id | Unknown | PKFK |
applied_gratuity_value | Unknown | |
cost | Unknown | |
gratuity | Unknown | |
name | Unknown | |
total_cost | Unknown | |
unit | Unknown |
budget_item_saving
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
budget_item_id | Unknown | PKFK |
name | Unknown | |
value | Unknown |
budget_item_associated_registrant
| Column | Type | Keys |
|---|---|---|
invitee_id | Unknown | PK |
budget_item_id | Unknown | PKFK |
contact_id | Unknown | PKFK |
first_name | Unknown | |
hcp_status | Unknown | |
last_name | Unknown |
budget_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | PKFK |
associated_session | Unknown | |
calculate_tax_on_gratuity | Unknown | |
category_id | Unknown | |
category_name | Unknown | |
code | Unknown | |
conversion_rate | Unknown | |
conversion_rate_locked | Unknown | |
cost_avoidance_amount | Unknown | |
cost_avoidance_description | Unknown | |
cost_includes_tax_gratuity | Unknown | |
cost_type | Unknown | |
currency | Unknown | |
date | Unknown | |
deleted | Unknown | |
general_ledger_code | Unknown | |
general_ledger_id | Unknown | |
general_ledger_name | Unknown | |
gratuity_type | Unknown | |
internal_note | Unknown | |
last_modified_date | Unknown | |
name | Unknown | |
status | Unknown | |
sub_category_id | Unknown | |
sub_category_name | Unknown | |
vendor_id | Unknown | |
vendor_name | Unknown | |
vendor_type | Unknown |
meeting_request_question
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
meeting_request_id | Unknown | PKFK |
name | Unknown | |
type | Unknown | |
value | Json |
meeting_request
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | FK |
meeting_request_form_id | Unknown | FK |
name | Unknown | |
source_id | Unknown | |
status | Unknown |
lead
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
attendee_id | Unknown | FK |
event_id | Unknown | FK |
application | Unknown | |
appointment_id | Unknown | |
booth_staff_id | Unknown | |
company | Unknown | |
created | Unknown | |
deleted | Unknown | |
device_id | Unknown | |
email | Unknown | |
exhibitor_id | Unknown | |
first_name | Unknown | |
home_address_address_1 | Unknown | |
home_address_address_2 | Unknown | |
home_address_city | Unknown | |
home_address_country | Unknown | |
home_address_postal_code | Unknown | |
home_address_region | Unknown | |
last_modified | Unknown | |
last_name | Unknown | |
license_code | Unknown | |
matched | Unknown | |
mobile_phone | Unknown | |
qualified | Unknown | |
source | Unknown | |
title | Unknown | |
type | Unknown |
campaign_email_template
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | FK |
active | Unknown | |
click_tracking_enabled | Unknown | |
created | Unknown | |
created_by | Unknown | |
from_email | Unknown | |
from_name | Unknown | |
html_body | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
locale | Unknown | |
name | Unknown | |
plaintext_body | Unknown | |
reply_to_email | Unknown | |
reply_to_name | Unknown | |
subject | Unknown |
enrollment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
attendee_id | Unknown | FK |
event_id | Unknown | FK |
session_id | Unknown | FK |
created | Unknown | |
deleted | Unknown | |
last_modified | Unknown | |
status | Unknown |
audio_track
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
video_id | Unknown | PKFK |
created | Unknown | |
created_by | Unknown | |
defaultly | Unknown | |
duration | Unknown | |
languages | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
status | Unknown | |
type | Unknown | |
url | Unknown | |
variant | Unknown |
response_answer
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
response_id | Unknown | PKFK |
category_id | Unknown | |
choice_id | Unknown | |
field_id | Unknown | |
sub_category_id | Unknown | |
type | Unknown | |
value | Unknown |
response
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | FK |
question_id | Unknown | FK |
session_id | Unknown | FK |
speaker_id | Unknown | FK |
survey_id | Unknown | FK |
attempt | Unknown | |
chapter_id | Unknown | |
created | Unknown | |
created_by | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
looping_choice_id | Unknown | |
respondent_id | Unknown | |
score | Unknown |
video_view
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
contact_id | Unknown | FK |
video_id | Unknown | FK |
solution | Unknown | |
total_duration | Unknown | |
type | Unknown | |
watch_duration | Unknown | |
watch_percentage | Unknown |
event_order_discount
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
event_id | Unknown | PKFK |
event_order_id | Unknown | PKFK |
code | Unknown | |
name | Unknown | |
type | Unknown | |
value | Unknown |
event_order
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | PKFK |
attendee_id | Unknown | FK |
cancelled | Unknown | |
created | Unknown | |
created_by | Unknown | |
last_modified | Unknown | |
last_modified_by | Unknown | |
payment_method | Unknown | |
type | Unknown |