# Visit by GES schema ERD

Table and field reference for the Fivetran Visit by GES connector.

## Table & Field Reference

### partner_contact_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| partner_id | Unknown | PK, FK |
| address | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| house_number | Unknown |  |
| house_number_suffix | Unknown |  |
| name | Unknown |  |
| postal_code | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |

### partner_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| partner_id | Unknown | PK, FK |
| tag_name | Unknown |  |

### partner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| expo_id | Unknown | FK |
| booth_number | Unknown |  |
| booth_size | Unknown |  |
| contact_coc_number | Unknown |  |
| contact_comments | Unknown |  |
| contact_company | Unknown |  |
| contact_company_fax | Unknown |  |
| contact_company_name | Unknown |  |
| contact_company_phone | Unknown |  |
| contact_company_website | Unknown |  |
| contact_department | Unknown |  |
| contact_dob | Unknown |  |
| contact_email | Unknown |  |
| contact_fax | Unknown |  |
| contact_first_initials | Unknown |  |
| contact_first_name | Unknown |  |
| contact_gender | Unknown |  |
| contact_id | Unknown |  |
| contact_job_function | Unknown |  |
| contact_last_name | Unknown |  |
| contact_last_name_prefix | Unknown |  |
| contact_nationality | Unknown |  |
| contact_phone_1 | Unknown |  |
| contact_phone_2 | Unknown |  |
| contact_reference | Unknown |  |
| contact_social_security_number | Unknown |  |
| contact_suffix | Unknown |  |
| contact_title | Unknown |  |
| contact_vat_number | Unknown |  |
| contact_website | Unknown |  |
| deleted | Unknown |  |
| license_download_url | Unknown |  |
| licenses | Json |  |
| name | Unknown |  |
| registration_type_id | Unknown |  |
| registration_type_level | Unknown |  |
| registration_type_name | Unknown |  |
| registration_type_reference | Unknown |  |
| registration_url | Unknown |  |
| revision | Unknown |  |
| translation_id | Unknown |  |
| translation_iso | Unknown |  |
| translation_language | Unknown |  |
| translation_name | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_email | Unknown |  |
| description | Unknown |  |
| ends | Unknown |  |
| name | Unknown |  |
| reference | Unknown |  |
| revision | Unknown |  |
| start | Unknown |  |
| timezone | Unknown |  |

### visitor_contact_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| visitor_id | Unknown | PK, FK |
| address | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| house_number | Unknown |  |
| house_number_suffix | Unknown |  |
| name | Unknown |  |
| postal_code | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |

### visitor_ordered_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| visitor_id | Unknown | PK, FK |
| amount_name | Unknown |  |
| count | Unknown |  |
| name | Unknown |  |
| reference | Unknown |  |
| shop_item_id | Unknown |  |
| text | Unknown |  |
| total_amount | Unknown |  |
| total_amount_vat | Unknown |  |

### visitor_ordered_payment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| visitor_id | Unknown | PK, FK |
| amount | Unknown |  |
| code | Unknown |  |
| payment_method | Unknown |  |
| payment_method_info | Unknown |  |
| payment_state | Unknown |  |
| reference | Unknown |  |
| time | Unknown |  |

### visitor_policy

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| visitor_id | Unknown | PK, FK |
| checked | Unknown |  |
| type | Unknown |  |

### visitor_activity

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| content_id | Unknown | FK |
| partner_id | Unknown | FK |
| visitor_id | Unknown | FK |
| action | Unknown |  |
| location_direction | Unknown |  |
| location_id | Unknown |  |
| location_name | Unknown |  |
| time | Unknown |  |
| type | Unknown |  |

### visitor_question_answer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| question_id | Unknown | PK, FK |
| visitor_id | Unknown | PK, FK |
| reference | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### visitor_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| visitor_id | Unknown | PK, FK |
| level | Unknown |  |
| name | Unknown |  |
| reference | Unknown |  |
| type | Unknown |  |

### visitor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| expo_id | Unknown | FK |
| action_code_name | Unknown |  |
| action_code_type | Unknown |  |
| action_code_value | Unknown |  |
| comments | Unknown |  |
| confirmation_document_url | Unknown |  |
| contact_coc_number | Unknown |  |
| contact_comments | Unknown |  |
| contact_company | Unknown |  |
| contact_company_fax | Unknown |  |
| contact_company_name | Unknown |  |
| contact_company_phone | Unknown |  |
| contact_company_website | Unknown |  |
| contact_department | Unknown |  |
| contact_dob | Unknown |  |
| contact_email | Unknown |  |
| contact_fax | Unknown |  |
| contact_first_initials | Unknown |  |
| contact_first_name | Unknown |  |
| contact_gender | Unknown |  |
| contact_id | Unknown |  |
| contact_job_function | Unknown |  |
| contact_last_name | Unknown |  |
| contact_last_name_prefix | Unknown |  |
| contact_nationality | Unknown |  |
| contact_phone_1 | Unknown |  |
| contact_phone_2 | Unknown |  |
| contact_reference | Unknown |  |
| contact_social_security_number | Unknown |  |
| contact_suffix | Unknown |  |
| contact_title | Unknown |  |
| contact_vat_number | Unknown |  |
| contact_website | Unknown |  |
| data_use_1 | Unknown |  |
| data_use_2 | Unknown |  |
| data_use_3 | Unknown |  |
| deleted | Unknown |  |
| dwelling_dwelling_time | Unknown |  |
| dwelling_first_entry_time | Unknown |  |
| dwelling_last_exit_time | Unknown |  |
| embedded_digital_badge_url | Unknown |  |
| form_id | Unknown |  |
| form_name | Unknown |  |
| form_url | Unknown |  |
| mailing | Unknown |  |
| master_visitor_id | Unknown |  |
| method | Unknown |  |
| ordered_code | Unknown |  |
| ordered_currency | Unknown |  |
| ordered_total | Unknown |  |
| ordered_total_due | Unknown |  |
| ordered_total_paid | Unknown |  |
| ordered_total_sub | Unknown |  |
| ordered_total_vat | Unknown |  |
| partner | Unknown |  |
| partner_association | Unknown |  |
| picture_url | Unknown |  |
| reference | Unknown |  |
| register_time | Unknown |  |
| registration_state | Unknown |  |
| registration_type_id | Unknown |  |
| registration_type_level | Unknown |  |
| registration_type_name | Unknown |  |
| registration_type_reference | Unknown |  |
| registration_url | Unknown |  |
| revision | Unknown |  |
| timeslots | Json |  |
| tracking_utm_campaign | Unknown |  |
| tracking_utm_content | Unknown |  |
| tracking_utm_medium | Unknown |  |
| tracking_utm_source | Unknown |  |
| tracking_utm_term | Unknown |  |
| translation_id | Unknown |  |
| translation_iso | Unknown |  |
| translation_language | Unknown |  |
| translation_name | Unknown |  |
| visit_discover_url | Unknown |  |
| visit_time | Unknown |  |

### content

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| expo_id | Unknown | FK |
| partner_id | Unknown | FK |
| name | Unknown |  |
| revision | Unknown |  |
| source | Unknown |  |
| summary | Unknown |  |
| type | Unknown |  |

## Relationships

- partner_contact_address(partner_id) → partner(id)
- partner_tag(partner_id) → partner(id)
- partner(expo_id) → event(id)
- visitor_contact_address(visitor_id) → visitor(id)
- visitor_ordered_item(visitor_id) → visitor(id)
- visitor_ordered_payment(visitor_id) → visitor(id)
- visitor_policy(visitor_id) → visitor(id)
- visitor_activity(partner_id) → partner(id)
- visitor_activity(content_id) → content(id)
- visitor_activity(visitor_id) → visitor(id)
- visitor_question_answer(visitor_id) → visitor_question(visitor_id)
- visitor_question_answer(question_id) → visitor_question(id)
- visitor_question(visitor_id) → visitor(id)
- visitor(expo_id) → event(id)
- content(expo_id) → event(id)
- content(partner_id) → partner(id)