# Cvent schema ERD

Table and field reference for the Fivetran Cvent connector.

## 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 | PK, FK |
| attendee_insight_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

### event_fee_item_pricing

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_fee_item_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| amount | Unknown |  |
| max_refund | Unknown |  |
| register_by_date | Unknown |  |

### event_fee_item_refund_policy

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

### event_fee_item_registration_type

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

### event_fee_item_general_ledger_code

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

### event_fee_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| active | Unknown |  |
| amount | Unknown |  |
| created | Unknown |  |
| created_by | Unknown |  |
| currency | Unknown |  |
| display | Unknown |  |
| is_default | Unknown |  |
| last_modified | Unknown |  |
| last_modified_by | Unknown |  |
| name | Unknown |  |
| product_id | Unknown |  |
| product_name | Unknown |  |
| product_type | Unknown |  |

### contact_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| is_primary | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### users_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | Unknown | PK, FK |
| type | Unknown |  |
| value | Unknown |  |

### users_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| event_transaction_id | Unknown | PK, FK |
| order_id | Unknown | PK, FK |

### event_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| 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 | PK, FK |

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

### admission_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| allow_optional_sessions | Unknown |  |
| code | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |

### meeting_request_form_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| meeting_request_form_id | Unknown | PK, FK |
| status | Unknown |  |

### meeting_request_form_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| meeting_request_form_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 |  |

### event_order_item_discount

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK |
| id | Unknown | PK |
| event_order_item_id | Unknown | PK, FK |
| amount | Unknown |  |
| code | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### event_order_item_general_ledger_item

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK |
| id | Unknown | PK |
| event_order_item_id | Unknown | PK, FK |
| allocation_percentage | Unknown |  |
| code | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |

### event_order_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attendee_id | Unknown | FK |
| event_id | Unknown | FK |
| order_id | Unknown | FK |
| active | Unknown |  |
| amount_due | Unknown |  |
| amount_ordered | Unknown |  |
| amount_paid | Unknown |  |
| created | Unknown |  |
| created_by | Unknown |  |
| deleted | Unknown |  |
| fee_id | Unknown |  |
| fee_name | Unknown |  |
| guest | Unknown |  |
| guest_detail_id | Unknown |  |
| last_modified | Unknown |  |
| last_modified_by | Unknown |  |
| name | Unknown |  |
| order_type | Unknown |  |
| price | Unknown |  |
| product_id | Unknown |  |
| product_price_tier_amount | Unknown |  |
| product_type | Unknown |  |
| quantity | Unknown |  |
| tiered | Unknown |  |

### session

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| admission_items | Json |  |
| automatically_closes_on | Unknown |  |
| automatically_opens_on | Unknown |  |
| capacity | Unknown |  |
| capacity_unlimited | Unknown |  |
| capacity_virtual | Unknown |  |
| category_id | Unknown |  |
| category_name | Unknown |  |
| code | Unknown |  |
| created | Unknown |  |
| created_by | Unknown |  |
| custom_fields | Json |  |
| data_tag_code | Unknown |  |
| description | Unknown |  |
| display_on_agenda | Unknown |  |
| enable_waitlist | Unknown |  |
| enable_waitlist_virtual | Unknown |  |
| end_date | Unknown |  |
| featured | Unknown |  |
| group_id | Unknown |  |
| included_session | Unknown |  |
| last_modified | Unknown |  |
| last_modified_by | Unknown |  |
| location_code | Unknown |  |
| location_id | Unknown |  |
| location_name | Unknown |  |
| open_for_attendee_hub | Unknown |  |
| open_for_registration | Unknown |  |
| presentation_type | Unknown |  |
| registration_types | Json |  |
| relevance | Unknown |  |
| segments | Json |  |
| session_order | Unknown |  |
| start | Unknown |  |
| status | Unknown |  |
| timezone | Unknown |  |
| title | Unknown |  |
| type_code | Unknown |  |
| type_id | Unknown |  |
| type_name | Unknown |  |
| virtual | Unknown |  |
| virtual_capacity_unlimited | Unknown |  |
| waitlist_capacity | Unknown |  |
| waitlist_capacity_virtual | Unknown |  |

### session_speaker

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

### video_session

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

### video_speaker

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| video_id | Unknown | PK, FK |
| speaker_id | Unknown |  |

### video_exhibitor

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| video_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| languages | Unknown |  |

### event_planner

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| deleted | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |

### event_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| 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 |  |

### email

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

### player

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| video_id | Unknown | FK |
| webcast_id | Unknown | FK |
| created | Instant |  |
| created_by | Unknown |  |
| duration | Unknown |  |
| last_modified | Instant |  |
| last_modified_by | Unknown |  |
| page | Unknown |  |
| player_type_provider | Unknown |  |
| region | Unknown |  |
| schedule_id | Unknown |  |
| schedule_scheduled_execution | Unknown |  |
| scheduled_action | Unknown |  |
| simulive_offset | Unknown |  |
| stram_recording_id | Unknown |  |
| stram_recording_status | Unknown |  |
| stream_id | Unknown |  |
| stream_key | Unknown |  |
| stream_session_id | Unknown |  |
| stream_status | Unknown |  |
| stream_url | Unknown |  |

### webcast

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| appointment_id | Unknown | FK |
| event_id | Unknown | FK |
| session_id | Unknown | FK |
| video_id | Unknown | FK |
| auto_add_to_library | Unknown |  |
| created | Instant |  |
| created_by | Unknown |  |
| details | Unknown |  |
| exhibitor_id | Unknown |  |
| format | Unknown |  |
| host_code | Unknown |  |
| host_href | Unknown |  |
| host_key | Unknown |  |
| join_code | Unknown |  |
| join_href | Unknown |  |
| last_modified | Instant |  |
| last_modified_by | Unknown |  |
| meeting_id | Unknown |  |
| on_demand_video | Unknown |  |
| player_type | Unknown |  |
| provider | Unknown |  |
| record_live_stream | Unknown |  |
| recording_code | Unknown |  |
| recording_href | Unknown |  |
| simulated_live | Unknown |  |
| solution_type | Unknown |  |
| source_id | Unknown |  |
| speaker_code | Unknown |  |
| speaker_href | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| type | 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 |  |

### event_tax

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| active | Unknown |  |
| amount | Unknown |  |
| calculate_by | Unknown |  |
| code | Unknown |  |
| created | Unknown |  |
| created_by | Unknown |  |
| general_ledger_code_allocation | Unknown |  |
| general_ledger_code_code | Unknown |  |
| general_ledger_code_id | Unknown |  |
| general_ledger_code_name | Unknown |  |
| last_modified | Unknown |  |
| last_modified_by | Unknown |  |
| name | Unknown |  |
| percentage | Unknown |  |
| tax_schedule_default_rate | Unknown |  |
| tax_schedule_id | Unknown |  |
| tax_schedule_name | Unknown |  |

### text_track

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| video_id | Unknown | PK, FK |
| 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 | PK, FK |
| attendee_question_id | Unknown | PK, FK |
| value | String |  |

### attendee_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attendee_id | Unknown | PK, FK |
| name | Unknown |  |
| order_number | Unknown |  |
| type | Unknown |  |

### attendee_answer_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| question_id | Unknown | PK |
| attendee_id | Unknown | PK, FK |
| value | Unknown |  |

### attendee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| event_id | Unknown | FK |
| administrator_id | Unknown |  |
| admission_item_code | Unknown |  |
| admission_item_id | Unknown |  |
| admission_item_name | Unknown |  |
| allow_appointment_push_notification | Unknown |  |
| allow_push_notifications | Unknown |  |
| appointment_groups | Json |  |
| attendee_last_modified | Unknown |  |
| bio | Unknown |  |
| check_out | Unknown |  |
| checked_in | Unknown |  |
| checkin | 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 |  |
| credit | Unknown |  |
| custom_fields | Json |  |
| deleted_guest | Unknown |  |
| duration | Unknown |  |
| external_references | Json |  |
| group_id | 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 |  |
| note | Unknown |  |
| opted_out | Unknown |  |
| primary_id | Unknown |  |
| reference_id | Unknown |  |
| registered_at | Unknown |  |
| registration_cancelled_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 |  |
| show_popup_notification | Unknown |  |
| status | Unknown |  |
| test_record | Unknown |  |
| type_id | Unknown |  |
| type_name | Unknown |  |
| unsubscribed | Unknown |  |
| visibility | Unknown |  |
| web_links | Json |  |
| website_url | Unknown |  |

### question_choice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| question_id | Unknown | PK, FK |
| label | Unknown |  |
| short_text | Unknown |  |
| text | Unknown |  |

### question_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| question_id | Unknown | PK, FK |
| required | Unknown |  |
| short_text | Unknown |  |
| text | Unknown |  |

### question_sub_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| question_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

### attendee_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attendee_id | Unknown | FK |
| event_id | Unknown | FK |
| session_id | Unknown | FK |
| webcast_id | Unknown | FK |
| created | Instant |  |
| created_by | Unknown |  |
| join_code | Unknown |  |
| join_href | Unknown |  |
| last_modified | Instant |  |
| last_modified_by | Unknown |  |
| source_id | Unknown |  |

### budget_item_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| budget_item_id | Unknown | PK, FK |
| 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 | PK, FK |
| budget_item_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### budget_item_associated_registrant

| Column | Type | Keys |
| --- | --- | --- |
| invitee_id | Unknown | PK |
| budget_item_id | Unknown | PK, FK |
| contact_id | Unknown | PK, FK |
| first_name | Unknown |  |
| hcp_status | Unknown |  |
| last_name | Unknown |  |

### budget_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| event_order_id | Unknown | PK, FK |
| code | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### event_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| attendee_id | Unknown | FK |
| amount_due | Unknown |  |
| amount_paid | Unknown |  |
| cancelled | Unknown |  |
| created | Unknown |  |
| created_by | Unknown |  |
| deleted | Unknown |  |
| invoice_number | Unknown |  |
| last_modified | Unknown |  |
| last_modified_by | Unknown |  |
| order_code | Unknown |  |
| payment_method | Unknown |  |
| reference_number | Unknown |  |
| total_ordered_amount | Unknown |  |
| type | Unknown |  |

## Relationships

- event_question(event_id) → event(id)
- attendee_insight_score(attendee_id) → attendee(id)
- attendee_insight_score(event_id) → event(id)
- attendee_insight_score(attendee_insight_id) → attendee_insight(id)
- appointment_participant(attendee_id) → attendee(id)
- appointment_participant(appointment_id) → appointment(id)
- appointment_question(appointment_id) → appointment(id)
- appointment(appointment_event_id) → appointment_event(id)
- attendance_duration(event_id) → event(id)
- attendance_duration(attendee_id) → attendee(id)
- attendance_duration(session_id) → session(id)
- attendee_activity(attendee_id) → attendee(id)
- attendee_activity(event_id) → event(id)
- event_fee_item_pricing(event_fee_item_id) → event_fee_item(id)
- event_fee_item_pricing(event_id) → event_fee_item(event_id)
- event_fee_item_refund_policy(event_fee_item_id) → event_fee_item(id)
- event_fee_item_refund_policy(event_id) → event_fee_item(event_id)
- event_fee_item_registration_type(event_fee_item_id) → event_fee_item(id)
- event_fee_item_registration_type(event_id) → event_fee_item(event_id)
- event_fee_item_general_ledger_code(event_fee_item_id) → event_fee_item(id)
- event_fee_item_general_ledger_code(event_id) → event_fee_item(event_id)
- event_fee_item(event_id) → event(id)
- contact_custom_field(id) → custom_field(id)
- contact_custom_field(contact_id) → contact(id)
- attendee_insight_stats(attendee_insight_id) → attendee_insight(id)
- card_transaction_reconciliation(card_transaction_id) → card_transaction(id)
- card_transaction_description(card_transaction_id) → card_transaction(id)
- card_transaction(card_id) → card(id)
- card_transaction(event_id) → event(id)
- event_role_assignment(event_id) → event(id)
- event_role_assignment(user_id) → users(id)
- attendee_insight(event_id) → event(id)
- users_email(users_id) → users(id)
- users_phone_number(users_id) → users(id)
- users_address(users_id) → users(id)
- users_group(users_id) → users(id)
- event_transaction_order(order_id) → event_order(id)
- event_transaction_order(event_transaction_id) → event_transaction(id)
- event_transaction_order(event_id) → event_transaction(event_id)
- event_transaction(event_id) → event(id)
- event_transaction(attendee_id) → attendee(id)
- speaker(event_id) → event(id)
- speaker(contact_id) → contact(id)
- survey_event(survey_id) → survey(id)
- appointment_event(event_id) → event(id)
- admission_item(event_id) → event(id)
- meeting_request_form_status(meeting_request_form_id) → meeting_request_form(id)
- meeting_request_form_question(meeting_request_form_id) → meeting_request_form(id)
- card_reporting_field(card_id) → card(id)
- card(event_id) → event(id)
- event_order_item_discount(event_order_item_id) → event_order_item(id)
- event_order_item_general_ledger_item(event_order_item_id) → event_order_item(id)
- event_order_item(event_id) → event(id)
- event_order_item(attendee_id) → attendee(id)
- event_order_item(order_id) → event_order(id)
- session(event_id) → event(id)
- session_speaker(speaker_id) → speaker(id)
- session_speaker(session_id) → session(id)
- video_session(video_id) → video(id)
- video_speaker(video_id) → video(id)
- video_exhibitor(video_id) → video(id)
- video(event_id) → event(id)
- event_venue(event_id) → event(id)
- event_language(event_id) → event(id)
- event_planner(event_id) → event(id)
- event_custom_field(event_id) → event(id)
- email(event_id) → event(id)
- email(attendee_id) → attendee(id)
- email(contact_id) → contact(id)
- player(video_id) → video(id)
- player(webcast_id) → webcast(id)
- webcast(event_id) → event(id)
- webcast(appointment_id) → appointment(id)
- webcast(video_id) → video(id)
- webcast(session_id) → session(id)
- custom_field(last_modified_by) → users(id)
- custom_field(created_by) → users(id)
- event_tax(event_id) → event(id)
- text_track(video_id) → video(id)
- question_value(attendee_id) → attendee_question(attendee_id)
- question_value(attendee_question_id) → attendee_question(id)
- attendee_question(attendee_id) → attendee(id)
- attendee_answer_value(attendee_id) → attendee(id)
- attendee(event_id) → event(id)
- attendee(contact_id) → contact(id)
- question_choice(question_id) → question(id)
- question_category(question_id) → question(id)
- question_sub_category(question_id) → question(id)
- question_fields_choice(question_id) → question_field(question_id)
- question_fields_choice(question_field_id) → question_field(id)
- question_field(question_id) → question(id)
- question(event_id) → event(id)
- question(survey_id) → survey(id)
- exhibitor(event_id) → event(id)
- attendee_link(event_id) → event(id)
- attendee_link(attendee_id) → attendee(id)
- attendee_link(webcast_id) → webcast(id)
- attendee_link(session_id) → session(id)
- budget_item_custom_field(budget_item_id) → budget_item(id)
- budget_item_cost_tax_detail(budget_item_id) → budget_item_cost_detail(budget_item_id)
- budget_item_cost_tax_detail(budget_item_cost_detail_id) → budget_item_cost_detail(id)
- budget_item_cost_detail(budget_item_id) → budget_item(id)
- budget_item_saving(budget_item_id) → budget_item(id)
- budget_item_associated_registrant(contact_id) → contact(id)
- budget_item_associated_registrant(budget_item_id) → budget_item(id)
- budget_item(event_id) → event(id)
- meeting_request_question(meeting_request_id) → meeting_request(id)
- meeting_request(meeting_request_form_id) → meeting_request_form(id)
- meeting_request(event_id) → event(id)
- lead(event_id) → event(id)
- lead(attendee_id) → attendee(id)
- campaign_email_template(campaign_id) → campaign(id)
- enrollment(event_id) → event(id)
- enrollment(attendee_id) → attendee(id)
- enrollment(session_id) → session(id)
- audio_track(video_id) → video(id)
- response_answer(response_id) → response(id)
- response(event_id) → event(id)
- response(question_id) → question(id)
- response(speaker_id) → speaker(id)
- response(session_id) → session(id)
- response(survey_id) → survey(id)
- video_view(video_id) → video(id)
- video_view(contact_id) → contact(id)
- event_order_discount(event_order_id) → event_order(id)
- event_order_discount(event_id) → event_order(event_id)
- event_order(event_id) → event(id)
- event_order(attendee_id) → attendee(id)