Eloqua

Explore the interactive ERD

Table & Field Reference

contact_list_contact

Column	Type	Keys
`contact_id`	Long	PKFK
`contact_list_id`	Long	PKFK

campaign

Column	Type	Keys
`id`	Long	PK
`created_by`	Long	FK
`updated_by`	String	FK
`accessed_at`	Instant
`actual_cost`	BigDecimal
`badge_id`	String
`budgeted_cost`	BigDecimal
`campaign_category`	String
`campaign_type`	String
`clr_end_date`	String
`created_at`	Instant
`crm_id`	String
`current_status`	String
`description`	String
`end_at`	Instant
`first_activation`	Instant
`folder_id`	Long
`is_email_marketing_campaign`	Boolean
`is_included_in_roi`	Boolean
`is_member_allowed_re_entry`	Boolean
`is_read_only`	Boolean
`is_synced_with_crm`	Boolean
`member_count`	Long
`name`	String
`product`	String
`region`	String
`run_as_user_id`	Long
`scheduled_for`	String
`source_template_id`	String
`start_at`	Instant
`updated_at`	Instant

event_registration_session_field

Column	Type	Keys
`id`	Long	PK
`event_registration_id`	Long	PKFK
`data_type`	String
`name`	String
`type`	String
`output_format_`

contact_list_segment_element

Column	Type	Keys
`id`	Long	PK
`segment_id`	Long	PKFK
`contact_list_id`	Long	FK
`count`	Long
`is_included`	Boolean
`last_calculated_at`	Instant
`type`	String

contact_list

Column	Type	Keys
`id`	Long	PK
`created_by`	String	FK
`updated_by`	String	FK
`created_at`	Instant
`current_status`	String
`data_lookup_id`	String
`folder_id`	Long
`name`	String
`scope`	String
`type`	String
`updated_at`	Instant

event_registration_session_field_value

Column	Type	Keys
`id`	Long	PK
`event_registration_id`	Long	PKFK
`session_id`	Long	PKFK
`session_field_id`	Long	FK
`type`	String
`value`	String

event_registration_session

Column	Type	Keys
`id`	Long	PK
`event_registration_id`	Long	PKFK
`name`	String
`participants_limit`	Int
`type`	String

email_form

Column	Type	Keys
`email_id`	Long	PKFK
`form_id`	Long	PKFK

form

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`current_status`	String
`name`	String
`processing_type`	String
`updated_at`	Instant

form_submission

Column	Type	Keys
`id`	Long	PK
`form_id`	Long	FK
`submitted_by_contact_id`	Long	FK
`submitted_at`	Instant

option

Column	Type	Keys
`index`	Long	PK
`option_list_id`	Long	PKFK
`display_name`	String
`type`	String
`value`	String

event_registration_registrant

Column	Type	Keys
`id`	Long	PK
`account_id`	Long	FK
`contact_id`	Long	FK
`event_registration_id`	Long	FK
`created_at`	Instant
`custom_object_record_status`	String
`is_mapped`	String
`name`	String
`type`	String
`unique_code`	String
`updated_at`	Instant

event_registration

Column	Type	Keys
`id`	Long	PK
`created_by`	Long	FK
`updated_by`	Long	FK
`created_at`	Instant
`description`	String
`email_address_field_id`	Long
`event_group_by_field_id`	Long
`folder_id`	Long
`name`	String
`type`	String
`unique_code_field_id`	Long
`updated_at`	Instant

contact_activity

Column	Type	Keys
`activity_type`	String	PK
`id`	Long	PK
`campaign_id`	Long	FK
`contact_id`	Long	FK
`form_id`	Long	FK
`visitor_id`	Long	FK
`activity_date`	Instant
`asset_id`	Long
`asset_name`	String
`asset_type`	String
`contact_id_ext`	String
`deployment_id`	Long
`duration`	String
`email_address`	String
`email_clicked_thru_link`	String
`email_clickthrough_saved_id`	String
`email_recipient_id`	String
`email_send_type`	String
`email_web_link`	String
`external_asset_name`	String
`external_asset_type`	String
`external_id`	String
`external_type`	String
`first_page_view_url`	String
`ip_address`	String
`is_web_tracking_opted_in`	String
`number_of_pages`	Long
`raw_data`	String
`referrer_url`	String
`smtp_error_code`	String
`smtp_message`	String
`smtp_status_code`	Long
`subject_line`	String
`url`	String
`visitor_external_id`	String
`web_visit_id`	String

account

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`description`	String
`name`	String
`updated_at`	Instant

contact_segment

Column	Type	Keys
`contact_id`	Long	PKFK
`segment_id`	Long	PKFK

visitor

Column	Type	Keys
`id`	Long	PK
`last_visit_date_and_time`	Instant	PK
`contact_id`	Long	FK
`browser_type`	String
`city_from_ip`	String
`company_dns_name`	String
`company_name_from_ip_1`	String
`country_from_ip`	String
`country_name`	String
`created_at`	Instant
`current_status`	String
`current_total_pages`	Long
`current_visit_length`	Long
`external_id`	String
`first_page_in_visit`	String
`first_visit_date_and_time`	Instant
`host_name`	String
`ip_address`	String
`isp_from_ip`	String
`last_page_in_visit`	String
`latitude_from_ip`	String
`longitude_from_ip`	String
`name`	String
`province_from_ip`	String
`time_zone`	String
`time_zone_offset_min`	String
`total_pages`	Long
`total_time`	Long
`total_visits`	Long
`type`	String
`zip_code_from_ip`	String

email

Column	Type	Keys
`id`	Long	PK
`created_by`	String	FK
`updated_by`	String	FK
`archived`	String
`bounce_back_email`	String
`created_at`	Instant
`current_status`	String
`html_content_content_source`	String
`html_content_html`	String
`html_content_type`	String
`is_content_protected`	Boolean
`is_plain_text_editable`	Boolean
`is_private`	Boolean
`is_tracked`	Boolean
`name`	String
`plain_text`	String
`render_mode`	String
`reply_to_email`	String
`reply_to_name`	String
`send_plain_text_only`	Boolean
`sender_email`	String
`sender_name`	String
`subject`	String
`updated_at`	Instant

event_registration_field

Column	Type	Keys
`id`	Long	PK
`event_registration_id`	Long	PKFK
`checked_value`	String
`data_type`	String
`default_value`	String
`display_type`	String
`internal_name`	String
`name`	String
`option_list_id`	String
`type`	String
`unchecked_value`	String

contact

Column	Type	Keys
`id`	Long	PK
`created_by`	Long	FK
`updated_by`	Long	FK
`account_name`	String
`address_1`	String
`address_2`	String
`address_3`	String
`bounceback_date`	Instant
`business_phone`	String
`city`	String
`country`	String
`created_at`	Instant
`current_status`	String
`email_address`	String
`fax`	String
`first_name`	String
`is_bounceback`	Boolean
`is_subscribed`	Boolean
`last_name`	String
`mobile_phone`	String
`name`	String
`postal_code`	String
`province`	String
`sales_person`	String
`subscription_date`	Instant
`title`	String
`unsubscription_date`	Instant
`updated_at`	Instant

contact_filter

Column	Type	Keys
`id`	Long	PK
`created_by`	String	FK
`updated_by`	String	FK
`created_at`	Instant
`current_status`	String
`folder_id`	Long
`name`	String
`scope`	String
`statement`	String
`type`	String
`updated_at`	Instant

segment

Column	Type	Keys
`id`	Long	PK
`created_by`	String	FK
`updated_by`	String	FK
`count`	Long
`created_at`	Instant
`current_status`	String
`folder_id`	Long
`is_stale`	Boolean
`name`	String
`type`	String
`updated_at`	Instant

event_registration_registrant_field_value

Column	Type	Keys
`id`	Long	PK
`event_registration_id`	Long	PKFK
`registrant_id`	Long	PKFK
`name`	String
`type`	String
`value`	String

contact_filter_segment_element

Column	Type	Keys
`id`	Long	PK
`segment_id`	Long	PKFK
`contact_filter_id`	Long	FK
`count`	Long
`is_included`	Boolean
`last_calculated_at`	Instant
`type`	String

option_list

Column	Type	Keys
`id`	Long	PK
`created_by`	String	FK
`updated_by`	String	FK
`created_at`	Instant
`current_status`	String
`description`	String
`name`	String
`permissions`	Json
`type`	String
`updated_at`	Instant

email_hyperlink

Column	Type	Keys
`id`	String	PK
`email_id`	Long	PKFK
`href`	String
`name`	String
`type`	String

user_info

Column	Type	Keys
`id`	Long	PK
`city`	String
`company_display_name`	String
`company_url`	String
`country`	String
`created_at`	Instant
`created_by`	Long
`department`	String
`description`	String
`digital_signature_id`	String
`email_address`	String
`first_name`	String
`folder_id`	Long
`is_disabled`	Boolean
`job_title`	String
`last_name`	String
`login_name`	String
`name`	String
`reply_to_address`	String
`sender_display_name`	String
`sender_email_address`	String
`state`	String
`type`	String
`updated_at`	Instant
`updated_by`	Long
`zip_code`	String