Eventsforce

Explore the interactive ERD

Table & Field Reference

payment

Column	Type	Keys
`id`	Unknown	PK
`invoice_number`	Unknown	PKFK
`amount`	Unknown
`comment`	Unknown
`creation_timestamp`	Unknown
`currency_code`	Unknown
`payment_method`	Unknown
`transaction_reference`	Unknown

event_custom_field

Column	Type	Keys
`custom_event_field_id`	Unknown	PK
`event_id`	Unknown	PKFK
`name`	Unknown
`value`	Unknown

event

Column	Type	Keys
`id`	Unknown	PK
`amendment_end_date_time`	Unknown
`amendment_start_date_time`	Unknown
`attendee_id_mode`	Unknown
`attendee_list_paged_url`	Unknown
`cancellation_end_date_time`	Unknown
`cancellation_start_date_time`	Unknown
`event_end_date_time`	Unknown
`event_name`	Unknown
`event_start_date_time`	Unknown
`event_status`	Unknown
`event_website_url`	Unknown
`registration_end_date_time`	Unknown
`registration_start_date_time`	Unknown
`session_list_url`	Unknown
`time_zone`	Unknown
`venue_address`	Unknown
`venue_description`	Unknown
`venue_image_url`	Unknown
`venue_location_url`	Unknown
`venue_name`	Unknown

orders_attendee

Column	Type	Keys
`person_id`	Unknown	PK
`order_id`	Unknown	PKFK
`id`	Unknown	FK
`attendee_registration_status`	Unknown
`category`	Unknown
`check_in_code`	Unknown
`payment_status`	Unknown

orders

Column	Type	Keys
`id`	Unknown	PK
`address_line_1`	Unknown
`address_line_2`	Unknown
`all_attendees_completed_status`	Unknown
`amount_paid`	Unknown
`company`	Unknown
`country`	Unknown
`created`	Unknown
`currency_code`	Unknown
`email`	Unknown
`first_name`	Unknown
`last_modified`	Unknown
`last_name`	Unknown
`order_reference`	Unknown
`order_status`	Unknown
`payment_status`	Unknown
`phone_number`	Unknown
`post_code`	Unknown
`total_amount`	Unknown
`total_tax_amount`	Unknown
`town`	Unknown
`us_state`	Unknown

unsubscribes

Column	Type	Keys
`id`	Unknown	PK
`email`	Unknown	FK
`unsubscribed_at`	Unknown

session_abstract_co_author

Column	Type	Keys
`abstract_id`	Unknown	PKFK
`id`	Unknown	PKFK
`session_id`	Unknown	PKFK

session_abstract_uploaded_file

Column	Type	Keys
`index`	Unknown	PK
`abstract_id`	Unknown	PKFK
`session_id`	Unknown	PKFK
`file_url`	Unknown

session_abstract_uploaded_paper

Column	Type	Keys
`index`	Unknown	PK
`abstract_id`	Unknown	PKFK
`session_id`	Unknown	PKFK
`paper_url`	Unknown

session_abstract

Column	Type	Keys
`abstract_id`	Unknown	PK
`session_id`	Unknown	PKFK
`main_author_id`	Unknown	FK
`presenting_author_id`	Unknown	FK
`abstract_content_url`	Unknown
`presentation_end_date_time`	Unknown
`presentation_method`	Unknown
`presentation_start_date_time`	Unknown
`reference_number`	Unknown
`summary`	Unknown
`title`	Unknown
`topic`	Unknown

session_label

Column	Type	Keys
`label_id`	Unknown	PK
`session_id`	Unknown	PKFK
`hex_color`	Unknown
`name`	Unknown

session_restricted_category

Column	Type	Keys
`attendee_category_id`	Unknown	PK
`session_id`	Unknown	PKFK
`attendee_category_name`	Unknown

session_presenter

Column	Type	Keys
`person_id`	Unknown	PK
`session_id`	Unknown	PKFK
`id`	Unknown	FK

session

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`attended_count`	Unknown
`booked_count`	Unknown
`capacity`	Unknown
`last_modified`	Unknown
`live_video_url`	Unknown
`location_name`	Unknown
`recorded_video_url`	Unknown
`session_code`	Unknown
`session_end_date_time`	Unknown
`session_name`	Unknown
`session_start_date_time`	Unknown
`session_status`	Unknown
`session_summary`	Unknown
`session_type`	Unknown
`walk_in_count`	Unknown

invoice_line_item

Column	Type	Keys
`index`	Unknown	PK
`invoice_number`	Unknown	PKFK
`amount`	Unknown
`description`	Unknown
`quantity`	Unknown
`type`	Unknown
`unit_price`	Unknown

invoice

Column	Type	Keys
`invoice_number`	Unknown	PK
`event_id`	Unknown	FK
`business_unit`	Unknown
`creation_timestamp`	Unknown
`credit_controller`	Unknown
`currency_code`	Unknown
`customer_po_number`	Unknown
`due_days`	Unknown
`external_invoice_reference`	Unknown
`grand_total`	Unknown
`invoice_address_address_line_1`	Unknown
`invoice_address_address_line_2`	Unknown
`invoice_address_address_line_3`	Unknown
`invoice_address_company`	Unknown
`invoice_address_country`	Unknown
`invoice_address_email`	Unknown
`invoice_address_first_name`	Unknown
`invoice_address_last_name`	Unknown
`invoice_address_post_code`	Unknown
`invoice_address_town`	Unknown
`invoice_address_us_state`	Unknown
`invoice_address_work_phone_number`	Unknown
`invoice_document_url`	Unknown
`invoice_recipient_details_url`	Unknown
`is_deleted`	Unknown
`marked_as_printed`	Unknown
`next_related_invoice_number`	Unknown
`number_of_attendees`	Unknown
`payment_status`	Unknown
`previous_related_invoice_number`	Unknown
`registration_reference`	Unknown
`selected_payment_method`	Unknown
`total_before_vat`	Unknown
`type`	Unknown
`vat_applied`	Unknown
`vat_registration_number`	Unknown

custom_data

Column	Type	Keys
`index`	Unknown	PK
`person_id`	Unknown	PKFK
`code`	Unknown
`key`	Unknown
`value`	Unknown

booked_session

Column	Type	Keys
`session_id`	Unknown	PK
`person_id`	Unknown	PKFK
`detail_url`	Unknown
`session_name`	Unknown

booked_day

Column	Type	Keys
`day_id`	Unknown	PK
`person_id`	Unknown	PKFK
`day_name`	Unknown
`detail_url`	Unknown

attended_session

Column	Type	Keys
`session_id`	Unknown	PK
`person_id`	Unknown	PKFK
`detail_url`	Unknown
`last_update`	Unknown
`session_name`	Unknown

attended_day

Column	Type	Keys
`index`	Unknown	PK
`person_id`	Unknown	PKFK
`date`	Unknown
`last_update`	Unknown

custom_registration_data

Column	Type	Keys
`index`	Unknown	PK
`person_id`	Unknown	PKFK
`code`	Unknown
`key`	Unknown
`value`	Unknown

attendee_person

Column	Type	Keys
`person_id`	Unknown	PK
`event_id`	Unknown	PKFK
`id`	Unknown	FK
`category`	Unknown
`check_in_code`	Unknown
`marketing_code`	Unknown
`payment_status`	Unknown
`person_booked_ticket`	Unknown
`registration_reference`	Unknown
`registration_status`	Unknown
`registration_timestamp`	Unknown

people_custom_data

Column	Type	Keys
`index`	Unknown	PK
`person_id`	Unknown	PKFK
`code`	Unknown
`key`	Unknown
`value`	Unknown

people

Column	Type	Keys
`id`	Unknown	PK
`address_line_1`	Unknown
`address_line_2`	Unknown
`address_line_3`	Unknown
`company`	Unknown
`country`	Unknown
`county`	Unknown
`email`	Unknown
`external_customer_account`	Unknown
`first_name`	Unknown
`gender`	Unknown
`is_anonymized`	Unknown
`job_title`	Unknown
`last_modified`	Unknown
`last_name`	Unknown
`phone_number`	Unknown
`picture_thumbnail_url`	Unknown
`picture_url`	Unknown
`post_code`	Unknown
`superseded_by_person_id`	Unknown
`superseded_by_person_url`	Unknown
`title`	Unknown
`town`	Unknown
`us_state`	Unknown
`username`	Unknown
`work_phone_number`	Unknown

event_day

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`attended_attendees_url`	Unknown
`attended_count`	Unknown
`booked_attendees_url`	Unknown
`booked_count`	Unknown
`capacity`	Unknown
`date`	Unknown
`name`	Unknown
`walk_in_count`	Unknown