# OnceHub schema ERD

Table and field reference for the Fivetran OnceHub connector.

## Table & Field Reference

### master_page

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| label | Unknown |  |
| name | Unknown |  |
| url | Unknown |  |

### event_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| label | Unknown |  |
| name | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| role_name | Unknown |  |
| status | Unknown |  |

### booking_page

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| label | Unknown |  |
| name | Unknown |  |
| timezone | Unknown |  |
| url | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner | Unknown | FK |
| bot | Unknown |  |
| city | Unknown |  |
| company | Unknown |  |
| company_size | Unknown |  |
| country | Unknown |  |
| creation_time | Unknown |  |
| email | Unknown |  |
| employees | Unknown |  |
| first_name | Unknown |  |
| form | Unknown |  |
| has_consent | Unknown |  |
| job_title | Unknown |  |
| last_interacted_time | Unknown |  |
| last_name | Unknown |  |
| last_updated_time | Unknown |  |
| mobile_phone | Unknown |  |
| phone | Unknown |  |
| post_code | Unknown |  |
| salutation | Unknown |  |
| state | Unknown |  |
| street_address | Unknown |  |
| terms_of_service | Unknown |  |
| timezone | Unknown |  |
| custom_** |  |  |

### booking

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| booking_page_id | Unknown | FK |
| cancel_reschedule_user_id | Unknown | FK |
| contact_id | Unknown | FK |
| event_type_id | Unknown | FK |
| master_page_id | Unknown | FK |
| owner | Unknown | FK |
| rescheduled_booking_id | Unknown | FK |
| booking_calendar | Unknown |  |
| cancel_reschedule_actioned_by | Unknown |  |
| cancel_reschedule_reason | Unknown |  |
| cancel_url | Unknown |  |
| conversation | Unknown |  |
| creation_time | Unknown |  |
| customer_timezone | Unknown |  |
| duration_minutes | Unknown |  |
| external_calendar_event_id | Unknown |  |
| external_calendar_id | Unknown |  |
| external_calendar_name | Unknown |  |
| external_calendar_type | Unknown |  |
| form_submission_company | Unknown |  |
| form_submission_email | Unknown |  |
| form_submission_guests | Json |  |
| form_submission_mobile_phone | Unknown |  |
| form_submission_name | Unknown |  |
| form_submission_note | Unknown |  |
| form_submission_phone | Unknown |  |
| in_trash | Unknown |  |
| last_updated_time | Unknown |  |
| location_description | Unknown |  |
| reschedule_url | Unknown |  |
| starting_time | Unknown |  |
| status | Unknown |  |
| subject | Unknown |  |
| tracking_id | Unknown |  |
| utm_params_campaign | Unknown |  |
| utm_params_content | Unknown |  |
| utm_params_medium | Unknown |  |
| utm_params_source | Unknown |  |
| utm_params_term | Unknown |  |
| virtual_conferencing_join_url | Unknown |  |
| form_submission_custom_** |  |  |

## Relationships

- contact(owner) → users(id)
- booking(owner) → users(id)
- booking(booking_page_id) → booking_page(id)
- booking(master_page_id) → master_page(id)
- booking(rescheduled_booking_id) → booking(id)
- booking(event_type_id) → event_type(id)
- booking(contact_id) → contact(id)
- booking(cancel_reschedule_user_id) → users(id)