# GlobalMeet schema ERD

Table and field reference for the Fivetran GlobalMeet connector.

## Table & Field Reference

### event_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| event_id | Unknown | FK |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| answer_1 | Unknown |  |
| answer_2 | Unknown |  |
| answer_3 | Unknown |  |
| business_email | Unknown |  |
| business_phone | Unknown |  |
| campaign_id | Unknown |  |
| certificate_link | Unknown |  |
| city | Unknown |  |
| company | Unknown |  |
| cost_center | Unknown |  |
| country | Unknown |  |
| duration | Unknown |  |
| event_title | Unknown |  |
| fax_number | Unknown |  |
| first_name | Unknown |  |
| hidden_field | Unknown |  |
| ip_address | Unknown |  |
| iqvia_expert_contact | Unknown |  |
| iqvia_opt_in | Unknown |  |
| last_name | Unknown |  |
| live_duration | Unknown |  |
| live_session | Unknown |  |
| media | Unknown |  |
| mobile_number | Unknown |  |
| on_demand_duration | Unknown |  |
| on_demand_session | Unknown |  |
| pass_fail | Unknown |  |
| postal_code | Unknown |  |
| question_1 | Unknown |  |
| question_2 | Unknown |  |
| question_3 | Unknown |  |
| referrer | Unknown |  |
| registered_on | Unknown |  |
| simlive_duration | Unknown |  |
| simlive_session | Unknown |  |
| state_or_province_region | Unknown |  |
| time_in | Unknown |  |
| time_out | Unknown |  |
| title | Unknown |  |
| total_duration | Unknown |  |
| total_session | Unknown |  |
| type | Unknown |  |
| unsubscribed | Unknown |  |
| user_agent | Unknown |  |
| survey_** |  |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| content | Unknown |  |
| cost_center | Unknown |  |
| event_expiry | Unknown |  |
| folder_id | Unknown |  |
| is_expired | Unknown |  |
| latest_registration | Unknown |  |
| latest_session | Unknown |  |
| sched_end | Unknown |  |
| sched_start | Unknown |  |
| tp_key | Unknown |  |

## Relationships

- event_report(event_id) → event(id)