Visit by GES

Explore the interactive ERD

Table & Field Reference

partner_contact_address

Column	Type	Keys
`index`	Unknown	PK
`partner_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`visitor_id`	Unknown	PKFK
`reference`	Unknown
`type`	Unknown
`value`	Unknown

visitor_question

Column	Type	Keys
`id`	Unknown	PK
`visitor_id`	Unknown	PKFK
`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