Fivetran documentation

Search the docs

/

Hopin

Explore the interactive ERD

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	PKFK
`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	PKFK
`status`	Unknown
`title`	Unknown
`type`	String

event

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

custom_registration_child_question

Column	Type	Keys
`id`	Unknown	PK
`custom_registration_id`	Unknown	PKFK
`event_id`	Unknown	PKFK
`registration_id`	Unknown	PKFK
`external_id`	Unknown
`name`	Unknown
`type`	Unknown
`value`	Unknown

custom_registration

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`registration_id`	Unknown	PKFK
`external_id`	Unknown
`name`	Unknown
`type`	Unknown
`value`	Unknown

registration

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`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	PKFK
`created_at`	Unknown
`name`	Unknown
`updated_at`	Unknown

magic_link

Column	Type	Keys
`id`	Unknown	PK
`ticket_id`	Unknown	PKFK
`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	PKFK
`status`	Unknown
`title`	Unknown
`url`	Unknown

session

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`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	PKFK
`claimed`	Unknown
`count`	Unknown
`created_at`	Unknown
`description`	Unknown
`discount`	Unknown
`name`	Unknown
`price`	Unknown
`private`	Unknown
`remaining`	Unknown
`slug`	Unknown