# Swoogo schema ERD

Table and field reference for the Fivetran Swoogo connector.

## Table & Field Reference

### data_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| name | Unknown |  |
| note | Unknown |  |

### sponsor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| level_id | Unknown |  |
| level_value | Unknown |  |
| logo_id | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| updated_at | LocalDateTime |  |
| website | Unknown |  |

### registrant_line_item

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| event_id | Unknown | FK |
| group_id | Unknown | FK |
| question_id | Unknown | FK |
| registrant_id | Unknown | FK |
| datetime | LocalDateTime |  |
| full_price_gross | Unknown |  |
| full_price_net | Unknown |  |
| gross | Unknown |  |
| net | Unknown |  |
| object | Unknown |  |
| object_id | Unknown |  |
| quantity | Unknown |  |
| status | Unknown |  |
| tax | Unknown |  |
| tax_rate | Unknown |  |

### event_folder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| name | Unknown |  |

### event_question_choice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_question_id | Unknown | PK, FK |
| event_id | Unknown | FK |
| admin_short_name | Unknown |  |
| badge_name | Unknown |  |
| capacity | Unknown |  |
| name | Unknown |  |
| public_short_name | Unknown |  |
| question_id | Unknown |  |
| sold_out_message | Unknown |  |
| sort | Unknown |  |
| visible | Unknown |  |

### event_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| page_id | Unknown | FK |
| admin_short_name | Unknown |  |
| attribute | Unknown |  |
| created_at | Unknown |  |
| hint | Unknown |  |
| name | Unknown |  |
| public_short_name | Unknown |  |
| sort | Unknown |  |
| type | Unknown |  |
| updated_at | LocalDateTime |  |

### event_field_choice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_field_id | Unknown | PK, FK |
| name | Unknown |  |
| sort | Unknown |  |

### event_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| allow_html | Unknown |  |
| attribute | Unknown |  |
| name | Unknown |  |
| required | Unknown |  |
| s_button_text | Unknown |  |
| s_hint | Unknown |  |
| s_link_collection_field | Unknown |  |
| s_max_link | Unknown |  |
| s_url_display_format | Unknown |  |
| s_url_image_id | Unknown |  |
| sort | Unknown |  |
| type | Unknown |  |
| visible | Unknown |  |

### session

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| capacity | Unknown |  |
| created_at | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| end_time | Unknown |  |
| location | Unknown |  |
| location_id | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| start_time | Unknown |  |
| track | Unknown |  |
| track_id | Unknown |  |
| type_id | Unknown |  |
| updated_at | LocalDateTime |  |
| custom_** |  |  |

### scan

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| event_id | Unknown | FK |
| registrant_id | Unknown | FK |
| created_by | Unknown |  |
| scan_id | Unknown |  |
| type | Unknown |  |

### sponsor_field_choice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sponsor_field_id | Unknown | PK, FK |
| name | Unknown |  |
| sort | Unknown |  |

### sponsor_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| allow_html | Unknown |  |
| attribute | Unknown |  |
| name | Unknown |  |
| required | Unknown |  |
| s_button_text | Unknown |  |
| s_hint | Unknown |  |
| s_link_collection_field | Unknown |  |
| s_max_link | Unknown |  |
| s_url_display_format | Unknown |  |
| s_url_image_id | Unknown |  |
| settings | Unknown |  |
| sort | Unknown |  |
| type | Unknown |  |
| visible | Unknown |  |

### contact_registrant

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

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| billing_address | Json |  |
| bio | Unknown |  |
| birth_date | Unknown |  |
| cc_email | Unknown |  |
| company | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| gender_id | Unknown |  |
| gender_value | Unknown |  |
| home_address | Json |  |
| job_title | Unknown |  |
| last_name | Unknown |  |
| middle_name | Unknown |  |
| mobile_phone | Unknown |  |
| note | Unknown |  |
| prefix | Unknown |  |
| profile_picture | Unknown |  |
| subscribe_status | Unknown |  |
| suffix | Unknown |  |
| twitter_handle | Unknown |  |
| unsubscribed_events | Json |  |
| updated_at | LocalDateTime |  |
| vat_number | Unknown |  |
| work_address | Json |  |
| work_phone | Unknown |  |
| custom_** |  |  |

### event_language

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| languages | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| folder_id | Unknown | FK |
| capacity | Unknown |  |
| close_date | Unknown |  |
| close_time | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| currency | Unknown |  |
| description | Unknown |  |
| domain | Unknown |  |
| end_date | Unknown |  |
| end_time | Unknown |  |
| event_venue_type | Unknown |  |
| free_event | Unknown |  |
| hashtag | Unknown |  |
| location_city | Unknown |  |
| location_company | Unknown |  |
| location_country_code | Unknown |  |
| location_country_continent | Unknown |  |
| location_country_currency_code | Unknown |  |
| location_country_name | Unknown |  |
| location_country_tax_name | Unknown |  |
| location_country_zipcode_required | Unknown |  |
| location_latitude | Unknown |  |
| location_line_1 | Unknown |  |
| location_line_2 | Unknown |  |
| location_line_3 | Unknown |  |
| location_longitude | Unknown |  |
| location_name | Unknown |  |
| location_phone | Unknown |  |
| location_state | Unknown |  |
| location_website | Unknown |  |
| location_zip | Unknown |  |
| name | Unknown |  |
| organizer_id | Unknown |  |
| reg_count | Unknown |  |
| start_date | Unknown |  |
| start_time | Unknown |  |
| status | Unknown |  |
| swoogo_virtual_location | Unknown |  |
| target_attendance | Unknown |  |
| timezone | Unknown |  |
| translation | Json |  |
| type_id | Unknown |  |
| type_value | Unknown |  |
| updated_at | LocalDateTime |  |
| updated_by | Unknown |  |
| url | Unknown |  |
| virtual_host | Unknown |  |
| webinar_url | Unknown |  |
| custom_** |  |  |

### event_website

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| event_id | Unknown | FK |
| module | Unknown |  |
| theme_id | Unknown |  |
| url | Unknown |  |

### package

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| admin_short_name | Unknown |  |
| capacity | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| max_group_size | Unknown |  |
| min_group_size | Unknown |  |
| name | Unknown |  |
| public_short_name | Unknown |  |
| sold_out_message | Unknown |  |
| updated_at | LocalDateTime |  |

### call_for_speaker_submission

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| created_at | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| direct_link | Unknown |  |
| end_time | Unknown |  |
| location | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| reviews | Unknown |  |
| session_included | Unknown |  |
| session_status | Unknown |  |
| start_time | Unknown |  |
| timezone | Unknown |  |
| track | Unknown |  |
| updated_at | LocalDateTime |  |
| virtual_link | Unknown |  |

### registrant_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| admin_short_name | Unknown |  |
| capacity | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| max_group_size | Unknown |  |
| min_group_size | Unknown |  |
| name | Unknown |  |
| public_short_name | Unknown |  |
| sold_out_message | Unknown |  |
| updated_at | LocalDateTime |  |

### contact_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| admin_short_name | Unknown |  |
| attribute | Unknown |  |
| default_response | Unknown |  |
| hint | Unknown |  |
| icon | Unknown |  |
| icon_alignment | Unknown |  |
| max_length | Unknown |  |
| min_length | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| public_short_name | Unknown |  |
| type | Unknown |  |

### event_badge

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| active | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| updated_at | LocalDateTime |  |
| updated_by | Unknown |  |

### session_field_choice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| session_field_id | Unknown | PK, FK |
| name | Unknown |  |
| sort | Unknown |  |

### session_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| allow_html | Unknown |  |
| attribute | Unknown |  |
| name | Unknown |  |
| required | Unknown |  |
| setting | Unknown |  |
| sort | Unknown |  |
| type | Unknown |  |
| visible | Unknown |  |

### call_for_speaker_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| event_id | Unknown | FK |
| created_at | Unknown |  |
| reviewer | Unknown |  |
| reviewer_role | Unknown |  |
| submitter | Unknown |  |
| updated_at | LocalDateTime |  |

### speaker

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| bio | Unknown |  |
| company | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| job_title | Unknown |  |
| last_name | Unknown |  |
| profile_picture | Unknown |  |
| updated_at | LocalDateTime |  |

### registrant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| event_id | Unknown | FK |
| group_id | Unknown | FK |
| package_id | Unknown | FK |
| reg_type_id | Unknown | FK |
| cancelled_at | Unknown |  |
| checked_in_at | Unknown |  |
| created_at | Unknown |  |
| group_balance_due | Unknown |  |
| group_gross | Unknown |  |
| group_net | Unknown |  |
| group_paid | Unknown |  |
| group_tax | Unknown |  |
| group_tax_2 | Unknown |  |
| individual_gross | Unknown |  |
| individual_net | Unknown |  |
| individual_tax | Unknown |  |
| individual_tax_2 | Unknown |  |
| ip_address | Unknown |  |
| languages | Unknown |  |
| payment_method | Unknown |  |
| payment_plan | Json |  |
| po_number | Unknown |  |
| reference | Unknown |  |
| reg_type_value | Unknown |  |
| registered_at | Unknown |  |
| registration_status | Unknown |  |
| session | Json |  |
| session_attendance | Json |  |
| sponsor_attendance | Json |  |
| timezone | Unknown |  |
| updated_at | LocalDateTime |  |
| custom_** |  |  |

### call_for_speaker_review

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| created_at | Unknown |  |
| notes | Unknown |  |
| rating | Unknown |  |
| reviewer_id | Unknown |  |
| submission_date | Unknown |  |
| submission_description | Unknown |  |
| submission_end_time | Unknown |  |
| submission_id | Unknown |  |
| submission_name | Unknown |  |
| submission_reviews | Unknown |  |
| submission_session_status | Unknown |  |
| submission_start_time | Unknown |  |
| updated_at | LocalDateTime |  |

### page

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| event_website_id | Unknown | FK |
| parent_id | Unknown | FK |
| created_at | Unknown |  |
| event_question | Unknown |  |
| full_url | Unknown |  |
| icon | Unknown |  |
| name | Unknown |  |
| slug | Unknown |  |
| sort | Unknown |  |
| type | Unknown |  |
| updated_at | LocalDateTime |  |

### transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| registrant_id | Unknown | FK |
| amount | Unknown |  |
| card_number_last_4 | Unknown |  |
| card_type | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| datetime | Unknown |  |
| gateway_id | Unknown |  |
| name_on_card | Unknown |  |
| note | Unknown |  |
| payment_gateway_name | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| updated_at | LocalDateTime |  |
| updated_by | Unknown |  |

## Relationships

- data_list(account_id) → contact(account_id)
- sponsor(event_id) → event(id)
- registrant_line_item(question_id) → event_question_choice(question_id)
- registrant_line_item(group_id) → registrant(id)
- registrant_line_item(registrant_id) → registrant(id)
- registrant_line_item(event_id) → event(id)
- event_folder(parent_id) → event_folder(id)
- event_question_choice(event_id) → event(id)
- event_question_choice(event_question_id) → event_question(id)
- event_question(event_id) → event(id)
- event_question(page_id) → page(id)
- event_field_choice(event_field_id) → event_field(id)
- session(event_id) → event(id)
- scan(event_id) → event(id)
- scan(registrant_id) → registrant(id)
- sponsor_field_choice(sponsor_field_id) → sponsor_field(id)
- contact_registrant(event_id) → event(id)
- contact_registrant(contact_id) → contact(id)
- event_language(event_id) → event(id)
- event(folder_id) → event_folder(id)
- event_website(account_id) → contact(account_id)
- event_website(event_id) → event(id)
- package(event_id) → event(id)
- call_for_speaker_submission(event_id) → event(id)
- registrant_type(event_id) → event(id)
- event_badge(event_id) → event(id)
- session_field_choice(session_field_id) → session_field(id)
- call_for_speaker_contact(event_id) → event(id)
- call_for_speaker_contact(contact_id) → contact(id)
- speaker(event_id) → event(id)
- registrant(event_id) → event(id)
- registrant(group_id) → event(id)
- registrant(package_id) → package(id)
- registrant(contact_id) → contact(id)
- registrant(reg_type_id) → registrant_type(id)
- call_for_speaker_review(event_id) → event(id)
- page(event_id) → event(id)
- page(event_website_id) → event_website(id)
- page(parent_id) → page(id)
- transaction(registrant_id) → registrant(id)
- transaction(event_id) → event(id)