# Eventsforce schema ERD

Table and field reference for the Fivetran Eventsforce connector.

## Table & Field Reference

### payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_number | Unknown | PK, FK |
| amount | Unknown |  |
| comment | Unknown |  |
| creation_timestamp | Unknown |  |
| currency_code | Unknown |  |
| payment_method | Unknown |  |
| transaction_reference | Unknown |  |

### event_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| custom_event_field_id | Unknown | PK |
| event_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amendment_end_date_time | Unknown |  |
| amendment_start_date_time | Unknown |  |
| attendee_id_mode | Unknown |  |
| attendee_list_paged_url | Unknown |  |
| cancellation_end_date_time | Unknown |  |
| cancellation_start_date_time | Unknown |  |
| event_end_date_time | Unknown |  |
| event_name | Unknown |  |
| event_start_date_time | Unknown |  |
| event_status | Unknown |  |
| event_website_url | Unknown |  |
| registration_end_date_time | Unknown |  |
| registration_start_date_time | Unknown |  |
| session_list_url | Unknown |  |
| time_zone | Unknown |  |
| venue_address | Unknown |  |
| venue_description | Unknown |  |
| venue_image_url | Unknown |  |
| venue_location_url | Unknown |  |
| venue_name | Unknown |  |

### orders_attendee

| Column | Type | Keys |
| --- | --- | --- |
| person_id | Unknown | PK |
| order_id | Unknown | PK, FK |
| id | Unknown | FK |
| attendee_registration_status | Unknown |  |
| category | Unknown |  |
| check_in_code | Unknown |  |
| payment_status | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| all_attendees_completed_status | Unknown |  |
| amount_paid | Unknown |  |
| company | Unknown |  |
| country | Unknown |  |
| created | Unknown |  |
| currency_code | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_modified | Unknown |  |
| last_name | Unknown |  |
| order_reference | Unknown |  |
| order_status | Unknown |  |
| payment_status | Unknown |  |
| phone_number | Unknown |  |
| post_code | Unknown |  |
| total_amount | Unknown |  |
| total_tax_amount | Unknown |  |
| town | Unknown |  |
| us_state | Unknown |  |

### unsubscribes

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| email | Unknown | FK |
| unsubscribed_at | Unknown |  |

### session_abstract_co_author

| Column | Type | Keys |
| --- | --- | --- |
| abstract_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |

### session_abstract_uploaded_file

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| abstract_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |
| file_url | Unknown |  |

### session_abstract_uploaded_paper

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| abstract_id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |
| paper_url | Unknown |  |

### session_abstract

| Column | Type | Keys |
| --- | --- | --- |
| abstract_id | Unknown | PK |
| session_id | Unknown | PK, FK |
| main_author_id | Unknown | FK |
| presenting_author_id | Unknown | FK |
| abstract_content_url | Unknown |  |
| presentation_end_date_time | Unknown |  |
| presentation_method | Unknown |  |
| presentation_start_date_time | Unknown |  |
| reference_number | Unknown |  |
| summary | Unknown |  |
| title | Unknown |  |
| topic | Unknown |  |

### session_label

| Column | Type | Keys |
| --- | --- | --- |
| label_id | Unknown | PK |
| session_id | Unknown | PK, FK |
| hex_color | Unknown |  |
| name | Unknown |  |

### session_restricted_category

| Column | Type | Keys |
| --- | --- | --- |
| attendee_category_id | Unknown | PK |
| session_id | Unknown | PK, FK |
| attendee_category_name | Unknown |  |

### session_presenter

| Column | Type | Keys |
| --- | --- | --- |
| person_id | Unknown | PK |
| session_id | Unknown | PK, FK |
| id | Unknown | FK |

### session

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| attended_count | Unknown |  |
| booked_count | Unknown |  |
| capacity | Unknown |  |
| last_modified | Unknown |  |
| live_video_url | Unknown |  |
| location_name | Unknown |  |
| recorded_video_url | Unknown |  |
| session_code | Unknown |  |
| session_end_date_time | Unknown |  |
| session_name | Unknown |  |
| session_start_date_time | Unknown |  |
| session_status | Unknown |  |
| session_summary | Unknown |  |
| session_type | Unknown |  |
| walk_in_count | Unknown |  |

### invoice_line_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_number | Unknown | PK, FK |
| amount | Unknown |  |
| description | Unknown |  |
| quantity | Unknown |  |
| type | Unknown |  |
| unit_price | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| invoice_number | Unknown | PK |
| event_id | Unknown | FK |
| business_unit | Unknown |  |
| creation_timestamp | Unknown |  |
| credit_controller | Unknown |  |
| currency_code | Unknown |  |
| customer_po_number | Unknown |  |
| due_days | Unknown |  |
| external_invoice_reference | Unknown |  |
| grand_total | Unknown |  |
| invoice_address_address_line_1 | Unknown |  |
| invoice_address_address_line_2 | Unknown |  |
| invoice_address_address_line_3 | Unknown |  |
| invoice_address_company | Unknown |  |
| invoice_address_country | Unknown |  |
| invoice_address_email | Unknown |  |
| invoice_address_first_name | Unknown |  |
| invoice_address_last_name | Unknown |  |
| invoice_address_post_code | Unknown |  |
| invoice_address_town | Unknown |  |
| invoice_address_us_state | Unknown |  |
| invoice_address_work_phone_number | Unknown |  |
| invoice_document_url | Unknown |  |
| invoice_recipient_details_url | Unknown |  |
| is_deleted | Unknown |  |
| marked_as_printed | Unknown |  |
| next_related_invoice_number | Unknown |  |
| number_of_attendees | Unknown |  |
| payment_status | Unknown |  |
| previous_related_invoice_number | Unknown |  |
| registration_reference | Unknown |  |
| selected_payment_method | Unknown |  |
| total_before_vat | Unknown |  |
| type | Unknown |  |
| vat_applied | Unknown |  |
| vat_registration_number | Unknown |  |

### custom_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| person_id | Unknown | PK, FK |
| code | Unknown |  |
| key | Unknown |  |
| value | Unknown |  |

### booked_session

| Column | Type | Keys |
| --- | --- | --- |
| session_id | Unknown | PK |
| person_id | Unknown | PK, FK |
| detail_url | Unknown |  |
| session_name | Unknown |  |

### booked_day

| Column | Type | Keys |
| --- | --- | --- |
| day_id | Unknown | PK |
| person_id | Unknown | PK, FK |
| day_name | Unknown |  |
| detail_url | Unknown |  |

### attended_session

| Column | Type | Keys |
| --- | --- | --- |
| session_id | Unknown | PK |
| person_id | Unknown | PK, FK |
| detail_url | Unknown |  |
| last_update | Unknown |  |
| session_name | Unknown |  |

### attended_day

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| person_id | Unknown | PK, FK |
| date | Unknown |  |
| last_update | Unknown |  |

### custom_registration_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| person_id | Unknown | PK, FK |
| code | Unknown |  |
| key | Unknown |  |
| value | Unknown |  |

### attendee_person

| Column | Type | Keys |
| --- | --- | --- |
| person_id | Unknown | PK |
| event_id | Unknown | PK, FK |
| id | Unknown | FK |
| category | Unknown |  |
| check_in_code | Unknown |  |
| marketing_code | Unknown |  |
| payment_status | Unknown |  |
| person_booked_ticket | Unknown |  |
| registration_reference | Unknown |  |
| registration_status | Unknown |  |
| registration_timestamp | Unknown |  |

### people_custom_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| person_id | Unknown | PK, FK |
| code | Unknown |  |
| key | Unknown |  |
| value | Unknown |  |

### people

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_line_3 | Unknown |  |
| company | Unknown |  |
| country | Unknown |  |
| county | Unknown |  |
| email | Unknown |  |
| external_customer_account | Unknown |  |
| first_name | Unknown |  |
| gender | Unknown |  |
| is_anonymized | Unknown |  |
| job_title | Unknown |  |
| last_modified | Unknown |  |
| last_name | Unknown |  |
| phone_number | Unknown |  |
| picture_thumbnail_url | Unknown |  |
| picture_url | Unknown |  |
| post_code | Unknown |  |
| superseded_by_person_id | Unknown |  |
| superseded_by_person_url | Unknown |  |
| title | Unknown |  |
| town | Unknown |  |
| us_state | Unknown |  |
| username | Unknown |  |
| work_phone_number | Unknown |  |

### event_day

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| attended_attendees_url | Unknown |  |
| attended_count | Unknown |  |
| booked_attendees_url | Unknown |  |
| booked_count | Unknown |  |
| capacity | Unknown |  |
| date | Unknown |  |
| name | Unknown |  |
| walk_in_count | Unknown |  |

## Relationships

- payment(invoice_number) → invoice(invoice_number)
- event_custom_field(event_id) → event(id)
- orders_attendee(order_id) → orders(id)
- orders_attendee(id) → people(id)
- unsubscribes(email) → people(email)
- session_abstract_co_author(id) → people(id)
- session_abstract_co_author(abstract_id) → session_abstract(abstract_id)
- session_abstract_co_author(session_id) → session(id)
- session_abstract_uploaded_file(abstract_id) → session_abstract(abstract_id)
- session_abstract_uploaded_file(session_id) → session(id)
- session_abstract_uploaded_paper(abstract_id) → session_abstract(abstract_id)
- session_abstract_uploaded_paper(session_id) → session(id)
- session_abstract(main_author_id) → people(id)
- session_abstract(presenting_author_id) → people(id)
- session_abstract(session_id) → session(id)
- session_label(session_id) → session(id)
- session_restricted_category(session_id) → session(id)
- session_presenter(id) → people(id)
- session_presenter(session_id) → session(id)
- session(event_id) → event(id)
- invoice_line_item(invoice_number) → invoice(invoice_number)
- invoice(event_id) → event(id)
- custom_data(person_id) → attendee_person(person_id)
- booked_session(person_id) → attendee_person(person_id)
- booked_day(person_id) → attendee_person(person_id)
- attended_session(person_id) → attendee_person(person_id)
- attended_day(person_id) → attendee_person(person_id)
- custom_registration_data(person_id) → attendee_person(person_id)
- attendee_person(event_id) → event(id)
- attendee_person(id) → people(id)
- people_custom_data(person_id) → people(id)
- event_day(event_id) → event(id)