Swoogo

Explore the interactive ERD

Table & Field Reference

data_list

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`name`	Unknown
`note`	Unknown

sponsor

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	FK
`created_at`	Unknown
`description`	Unknown
`level_id`	Unknown
`level_value`	Unknown
`logo_id`	Unknown
`name`	Unknown
`notes`	Unknown
`updated_at`	LocalDateTime
`website`	Unknown

registrant_line_item

Column	Type	Keys
`_fivetran_id`	String	PK
`event_id`	Unknown	FK
`group_id`	Unknown	FK
`question_id`	Unknown	FK
`registrant_id`	Unknown	FK
`datetime`	LocalDateTime
`full_price_gross`	Unknown
`full_price_net`	Unknown
`gross`	Unknown
`net`	Unknown
`object`	Unknown
`object_id`	Unknown
`quantity`	Unknown
`status`	Unknown
`tax`	Unknown
`tax_rate`	Unknown

event_folder

Column	Type	Keys
`id`	Unknown	PK
`parent_id`	Unknown	FK
`name`	Unknown

event_question_choice

Column	Type	Keys
`id`	Unknown	PK
`event_question_id`	Unknown	PKFK
`event_id`	Unknown	FK
`admin_short_name`	Unknown
`badge_name`	Unknown
`capacity`	Unknown
`name`	Unknown
`public_short_name`	Unknown
`question_id`	Unknown
`sold_out_message`	Unknown
`sort`	Unknown
`visible`	Unknown

event_question

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`page_id`	Unknown	FK
`admin_short_name`	Unknown
`attribute`	Unknown
`created_at`	Unknown
`hint`	Unknown
`name`	Unknown
`public_short_name`	Unknown
`sort`	Unknown
`type`	Unknown
`updated_at`	LocalDateTime

event_field_choice

Column	Type	Keys
`id`	Unknown	PK
`event_field_id`	Unknown	PKFK
`name`	Unknown
`sort`	Unknown

event_field

Column	Type	Keys
`id`	Unknown	PK
`allow_html`	Unknown
`attribute`	Unknown
`name`	Unknown
`required`	Unknown
`s_button_text`	Unknown
`s_hint`	Unknown
`s_link_collection_field`	Unknown
`s_max_link`	Unknown
`s_url_display_format`	Unknown
`s_url_image_id`	Unknown
`sort`	Unknown
`type`	Unknown
`visible`	Unknown

session

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`capacity`	Unknown
`created_at`	Unknown
`date`	Unknown
`description`	Unknown
`end_time`	Unknown
`location`	Unknown
`location_id`	Unknown
`name`	Unknown
`notes`	Unknown
`start_time`	Unknown
`track`	Unknown
`track_id`	Unknown
`type_id`	Unknown
`updated_at`	LocalDateTime
`custom_`

scan

Column	Type	Keys
`_fivetran_id`	String	PK
`event_id`	Unknown	FK
`registrant_id`	Unknown	FK
`created_by`	Unknown
`scan_id`	Unknown
`type`	Unknown

sponsor_field_choice

Column	Type	Keys
`id`	Unknown	PK
`sponsor_field_id`	Unknown	PKFK
`name`	Unknown
`sort`	Unknown

sponsor_field

Column	Type	Keys
`id`	Unknown	PK
`allow_html`	Unknown
`attribute`	Unknown
`name`	Unknown
`required`	Unknown
`s_button_text`	Unknown
`s_hint`	Unknown
`s_link_collection_field`	Unknown
`s_max_link`	Unknown
`s_url_display_format`	Unknown
`s_url_image_id`	Unknown
`settings`	Unknown
`sort`	Unknown
`type`	Unknown
`visible`	Unknown

contact_registrant

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	PKFK
`event_id`	Unknown	FK

contact

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown
`billing_address`	Json
`bio`	Unknown
`birth_date`	Unknown
`cc_email`	Unknown
`company`	Unknown
`created_at`	Unknown
`email`	Unknown
`first_name`	Unknown
`gender_id`	Unknown
`gender_value`	Unknown
`home_address`	Json
`job_title`	Unknown
`last_name`	Unknown
`middle_name`	Unknown
`mobile_phone`	Unknown
`note`	Unknown
`prefix`	Unknown
`profile_picture`	Unknown
`subscribe_status`	Unknown
`suffix`	Unknown
`twitter_handle`	Unknown
`unsubscribed_events`	Json
`updated_at`	LocalDateTime
`vat_number`	Unknown
`work_address`	Json
`work_phone`	Unknown
`custom_`

event_language

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`languages`	Unknown

event

Column	Type	Keys
`id`	Unknown	PK
`folder_id`	Unknown	FK
`capacity`	Unknown
`close_date`	Unknown
`close_time`	Unknown
`created_at`	Unknown
`created_by`	Unknown
`currency`	Unknown
`description`	Unknown
`domain`	Unknown
`end_date`	Unknown
`end_time`	Unknown
`event_venue_type`	Unknown
`free_event`	Unknown
`hashtag`	Unknown
`location_city`	Unknown
`location_company`	Unknown
`location_country_code`	Unknown
`location_country_continent`	Unknown
`location_country_currency_code`	Unknown
`location_country_name`	Unknown
`location_country_tax_name`	Unknown
`location_country_zipcode_required`	Unknown
`location_latitude`	Unknown
`location_line_1`	Unknown
`location_line_2`	Unknown
`location_line_3`	Unknown
`location_longitude`	Unknown
`location_name`	Unknown
`location_phone`	Unknown
`location_state`	Unknown
`location_website`	Unknown
`location_zip`	Unknown
`name`	Unknown
`organizer_id`	Unknown
`reg_count`	Unknown
`start_date`	Unknown
`start_time`	Unknown
`status`	Unknown
`swoogo_virtual_location`	Unknown
`target_attendance`	Unknown
`timezone`	Unknown
`translation`	Json
`type_id`	Unknown
`type_value`	Unknown
`updated_at`	LocalDateTime
`updated_by`	Unknown
`url`	Unknown
`virtual_host`	Unknown
`webinar_url`	Unknown
`custom_`

event_website

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`event_id`	Unknown	FK
`module`	Unknown
`theme_id`	Unknown
`url`	Unknown

package

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`admin_short_name`	Unknown
`capacity`	Unknown
`created_at`	Unknown
`description`	Unknown
`max_group_size`	Unknown
`min_group_size`	Unknown
`name`	Unknown
`public_short_name`	Unknown
`sold_out_message`	Unknown
`updated_at`	LocalDateTime

call_for_speaker_submission

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	FK
`created_at`	Unknown
`date`	Unknown
`description`	Unknown
`direct_link`	Unknown
`end_time`	Unknown
`location`	Unknown
`name`	Unknown
`note`	Unknown
`reviews`	Unknown
`session_included`	Unknown
`session_status`	Unknown
`start_time`	Unknown
`timezone`	Unknown
`track`	Unknown
`updated_at`	LocalDateTime
`virtual_link`	Unknown

registrant_type

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`admin_short_name`	Unknown
`capacity`	Unknown
`created_at`	Unknown
`description`	Unknown
`max_group_size`	Unknown
`min_group_size`	Unknown
`name`	Unknown
`public_short_name`	Unknown
`sold_out_message`	Unknown
`updated_at`	LocalDateTime

contact_field

Column	Type	Keys
`id`	Unknown	PK
`admin_short_name`	Unknown
`attribute`	Unknown
`default_response`	Unknown
`hint`	Unknown
`icon`	Unknown
`icon_alignment`	Unknown
`max_length`	Unknown
`min_length`	Unknown
`name`	Unknown
`note`	Unknown
`public_short_name`	Unknown
`type`	Unknown

event_badge

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`active`	Unknown
`created_at`	Unknown
`created_by`	Unknown
`name`	Unknown
`note`	Unknown
`updated_at`	LocalDateTime
`updated_by`	Unknown

session_field_choice

Column	Type	Keys
`id`	Unknown	PK
`session_field_id`	Unknown	PKFK
`name`	Unknown
`sort`	Unknown

session_field

Column	Type	Keys
`id`	Unknown	PK
`allow_html`	Unknown
`attribute`	Unknown
`name`	Unknown
`required`	Unknown
`setting`	Unknown
`sort`	Unknown
`type`	Unknown
`visible`	Unknown

call_for_speaker_contact

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	FK
`event_id`	Unknown	FK
`created_at`	Unknown
`reviewer`	Unknown
`reviewer_role`	Unknown
`submitter`	Unknown
`updated_at`	LocalDateTime

speaker

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	FK
`bio`	Unknown
`company`	Unknown
`created_at`	Unknown
`email`	Unknown
`first_name`	Unknown
`job_title`	Unknown
`last_name`	Unknown
`profile_picture`	Unknown
`updated_at`	LocalDateTime

registrant

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	FK
`event_id`	Unknown	FK
`group_id`	Unknown	FK
`package_id`	Unknown	FK
`reg_type_id`	Unknown	FK
`cancelled_at`	Unknown
`checked_in_at`	Unknown
`created_at`	Unknown
`group_balance_due`	Unknown
`group_gross`	Unknown
`group_net`	Unknown
`group_paid`	Unknown
`group_tax`	Unknown
`group_tax_2`	Unknown
`individual_gross`	Unknown
`individual_net`	Unknown
`individual_tax`	Unknown
`individual_tax_2`	Unknown
`ip_address`	Unknown
`languages`	Unknown
`payment_method`	Unknown
`payment_plan`	Json
`po_number`	Unknown
`reference`	Unknown
`reg_type_value`	Unknown
`registered_at`	Unknown
`registration_status`	Unknown
`session`	Json
`session_attendance`	Json
`sponsor_attendance`	Json
`timezone`	Unknown
`updated_at`	LocalDateTime
`custom_`

call_for_speaker_review

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	FK
`created_at`	Unknown
`notes`	Unknown
`rating`	Unknown
`reviewer_id`	Unknown
`submission_date`	Unknown
`submission_description`	Unknown
`submission_end_time`	Unknown
`submission_id`	Unknown
`submission_name`	Unknown
`submission_reviews`	Unknown
`submission_session_status`	Unknown
`submission_start_time`	Unknown
`updated_at`	LocalDateTime

page

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	FK
`event_website_id`	Unknown	FK
`parent_id`	Unknown	FK
`created_at`	Unknown
`event_question`	Unknown
`full_url`	Unknown
`icon`	Unknown
`name`	Unknown
`slug`	Unknown
`sort`	Unknown
`type`	Unknown
`updated_at`	LocalDateTime

transaction

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`registrant_id`	Unknown	FK
`amount`	Unknown
`card_number_last_4`	Unknown
`card_type`	Unknown
`created_at`	Unknown
`created_by`	Unknown
`datetime`	Unknown
`gateway_id`	Unknown
`name_on_card`	Unknown
`note`	Unknown
`payment_gateway_name`	Unknown
`status`	Unknown
`type`	Unknown
`updated_at`	LocalDateTime
`updated_by`	Unknown