# Hopin schema ERD

Table and field reference for the Fivetran Hopin connector.

## Table & Field Reference

### schedule_item_speaker

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| schedule_item_id | Unknown | FK |
| name | Unknown |  |

### schedule_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| area | Unknown |  |
| area_id | Unknown |  |
| area_name | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| time_end | Unknown |  |
| time_start | Unknown |  |
| updated_at | Unknown |  |

### report_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| status | Unknown |  |
| title | Unknown |  |
| type | String |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| created_at | Unknown |  |
| description | Unknown |  |
| metadata | Json |  |
| name | Unknown |  |
| published | Unknown |  |
| slug | Unknown |  |
| status | Unknown |  |
| time_end | Unknown |  |
| time_start | Unknown |  |
| timezone | Unknown |  |
| type | Unknown |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| email | Unknown |  |
| facebook | Unknown |  |
| name | Unknown |  |
| twitter | Unknown |  |
| website | Unknown |  |

### booth

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| about | Unknown |  |
| booth_size | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| facebook | Unknown |  |
| headline | Unknown |  |
| instagram | Unknown |  |
| linkedin | Unknown |  |
| name | Unknown |  |
| priority | Unknown |  |
| twitter | Unknown |  |
| updated_at | Unknown |  |
| website | Unknown |  |

### template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| name | Unknown |  |

### custom_registration_child_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| custom_registration_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| registration_id | Unknown | PK, FK |
| external_id | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### custom_registration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| registration_id | Unknown | PK, FK |
| external_id | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### registration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| magic_link_id | Unknown | FK |
| ticket_id | Unknown | FK |
| attended | Unknown |  |
| bio | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| first_check_in | Unknown |  |
| first_name | Unknown |  |
| headline | Unknown |  |
| last_name | Unknown |  |
| linkedin | Unknown |  |
| metadata | Json |  |
| phone_number | Unknown |  |
| qr_code_data | Unknown |  |
| qr_code_image_url | Unknown |  |
| question_bank_enabled | Unknown |  |
| refunded | Unknown |  |
| registered_through | Unknown |  |
| timezone | Unknown |  |
| twitter | Unknown |  |
| updated_at | Unknown |  |
| user_id | Unknown |  |
| utm_campaign | Unknown |  |
| utm_content | Unknown |  |
| utm_medium | Unknown |  |
| utm_source | Unknown |  |
| utm_term | Unknown |  |
| website | Unknown |  |

### download_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| report_type_id | Unknown | FK |
| country | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| headline | Unknown |  |
| last_name | Unknown |  |
| report_type_title | Unknown |  |
| ticket_type | Unknown |  |
| custom_** |  |  |

### stage

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### magic_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ticket_id | Unknown | PK, FK |
| registration_id | Unknown | FK |
| created_at | Unknown |  |
| email | Unknown |  |
| extra_fields | Json |  |
| first_name | Unknown |  |
| headline | Unknown |  |
| last_name | Unknown |  |
| magic_link | Unknown |  |
| metadata | Json |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### report_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| status | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |

### session

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### schedule_item_tag

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| schedule_item_id | Unknown | FK |
| id | Unknown |  |
| name | Unknown |  |

### booth_tag

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| booth_id | Unknown | FK |
| id | Unknown |  |
| name | Unknown |  |

### ticket

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| claimed | Unknown |  |
| count | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| discount | Unknown |  |
| name | Unknown |  |
| price | Unknown |  |
| private | Unknown |  |
| remaining | Unknown |  |
| slug | Unknown |  |

## Relationships

- schedule_item_speaker(schedule_item_id) → schedule_item(id)
- schedule_item(event_id) → event(id)
- report_type(event_id) → event(id)
- event(organization_id) → organization(id)
- booth(event_id) → event(id)
- template(organization_id) → organization(id)
- custom_registration_child_question(event_id) → event(id)
- custom_registration_child_question(registration_id) → registration(id)
- custom_registration_child_question(custom_registration_id) → custom_registration(id)
- custom_registration(event_id) → event(id)
- custom_registration(registration_id) → registration(id)
- registration(magic_link_id) → magic_link(id)
- registration(ticket_id) → ticket(id)
- registration(event_id) → event(id)
- download_report(report_type_id) → report_type(id)
- stage(event_id) → event(id)
- magic_link(registration_id) → registration(id)
- magic_link(ticket_id) → ticket(id)
- report_list(event_id) → event(id)
- session(event_id) → event(id)
- schedule_item_tag(schedule_item_id) → schedule_item(id)
- booth_tag(booth_id) → booth(id)
- ticket(event_id) → event(id)