Fivetran documentation

Search the docs

/

Ometria

Explore the interactive ERD

Table & Field Reference

collection

Column	Type	Keys
`id`	Unknown	PK
`count`	Unknown

contact_store_id

Column	Type	Keys
`store_id`	Unknown	PK
`contact_id`	Unknown	PKFK

contact

Column	Type	Keys
`id`	Unknown	PK
`collection_id`	Unknown	PKFK
`customer_id`	Unknown	FK
`profile_id`	Unknown	FK
`collection`	Unknown
`dt_object_created`	Unknown
`dt_object_observed`	Unknown
`dt_object_updated`	Unknown
`dt_observed`	Unknown
`email`	Unknown
`marketing_optin`	Unknown
`object_version`	Unknown
`phone_number`	Unknown
`source`	Unknown

unsubscribed_contact

Column	Type	Keys
`_fivetran_id`	String	PK
`profile_id`	Unknown	FK
`email_address`	Unknown
`mass_campaign_id`	Unknown
`reason`	Unknown
`reason_text`	Unknown
`send_id`	Unknown
`time_stamp`	Unknown
`trigger_campaign_id`	Unknown
`type`	Unknown

list_change

Column	Type	Keys
`list_id`	Unknown	PKFK
`profile_id`	Unknown	PKFK
`email`	Unknown
`event`	Unknown
`time_stamp`	Unknown

custom_event

Column	Type	Keys
`id`	Unknown	PK
`profile_id`	Unknown	FK
`dt_observed`	Unknown
`event_type`	Unknown
`identity_account_id`	Unknown
`identity_email`	Unknown
`time_stamp`	Unknown
`custom_`

profile_list

Column	Type	Keys
`id`	Unknown	PK
`profile_id`	Unknown	PKFK
`profile_customer_id`	Unknown
`title`	Unknown
`type`	Unknown

profile

Column	Type	Keys
`id`	Unknown	PK
`country`	Unknown
`customer_id`	Unknown
`date_of_birth`	Unknown
`default_store`	Unknown
`dt_predicted_next_order`	Unknown
`email`	Unknown
`first_name`	Unknown
`first_visit`	Unknown
`gender`	Unknown
`is_email_valid`	Unknown
`last_name`	Unknown
`lifecycle_status`	Unknown
`marketing_optin`	Unknown
`middle_name`	Unknown
`name`	Unknown
`phone_number`	Unknown
`phone_number_country`	Unknown
`preferred_lang`	Unknown
`prefix`	Unknown
`seen`	Unknown
`suffix`	Unknown
`tags`	Json
`time_zone`	Unknown
`custom_`

list_member_store_id

Column	Type	Keys
`_fivetran_id`	String	PK
`list_member_id`	Unknown	FK
`store_id`	Unknown

list_member

Column	Type	Keys
`id`	Unknown	PKFK
`customer_id`	Unknown	FK
`list_id`	Unknown	FK
`add_to_list`	Json
`collection`	Unknown
`country_id`	Unknown
`force_optin`	Unknown
`merge`	Unknown
`remove_from_list`	Json
`timestamp_subscribed`	Unknown
`timestamp_unsubscribed`	Unknown
`type`	Unknown

product_store

Column	Type	Keys
`store_id`	Unknown	PK
`product_id`	Unknown	PKFK

product_attribute

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	PKFK
`label`	Unknown
`type`	Unknown

product_listing

Column	Type	Keys
`product_id`	Unknown	PKFK
`store_id`	Unknown	PKFK
`currency`	Unknown
`image_url`	Unknown
`is_active`	Unknown
`price`	Unknown
`store`	Unknown
`title`	Unknown
`url`	Unknown

product

Column	Type	Keys
`id`	Unknown	PK
`currency`	Unknown
`image_url`	Unknown
`is_active`	Unknown
`is_in_stock`	Unknown
`is_variant`	Unknown
`price`	Unknown
`properties`	Json
`sku`	Unknown
`special_price`	Unknown
`special_price_dt_from`	Unknown
`special_price_dt_to`	Unknown
`title`	Unknown
`url`	Unknown
`custom_`

orders_line_item_variant_option

Column	Type	Keys
`id`	Unknown	PK
`type`	Unknown	PK
`index`	Unknown	PKFK
`order_id`	Unknown	PKFK
`label`	Unknown

orders_line_item

Column	Type	Keys
`index`	Unknown	PK
`order_id`	Unknown	PKFK
`product_id`	Unknown	FK
`base_currency`	Unknown
`base_discount`	Unknown
`base_refunded`	Unknown
`base_subtotal`	Unknown
`base_tax`	Unknown
`base_total`	Unknown
`base_unit_price`	Unknown
`currency`	Unknown
`discount`	Unknown
`local_currency`	Unknown
`local_discount`	Unknown
`local_refunded`	Unknown
`local_subtotal`	Unknown
`local_tax`	Unknown
`local_total`	Unknown
`local_unit_price`	Unknown
`quantity`	Unknown
`quantity_refunded`	Unknown
`refunded`	Unknown
`sku`	Unknown
`subtotal`	Unknown
`tax`	Unknown
`total`	Unknown
`unit_price`	Unknown
`variant_id`	Unknown

orders

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`channel`	Unknown
`coupon_code`	Unknown
`currency`	Unknown
`discount`	Unknown
`grand_total`	Unknown
`ip_address`	Unknown
`is_valid`	Unknown
`payment_method`	Unknown
`shipping`	Unknown
`shipping_method`	Unknown
`status`	Unknown
`store`	Unknown
`subtotal`	Unknown
`tax`	Unknown
`time_stamp`	Unknown
`total_refunded`	Unknown
`total_unit_quantity`	Unknown
`total_unit_quantity_refunded`	Unknown
`web_id`	Unknown
`custom_`

error

Column	Type	Keys
`record_id`	Unknown	PK
`request_id`	Unknown	PK
`customer_id`	Unknown	FK
`account`	Unknown
`message_error`	Unknown
`message_error_path`	Unknown
`record_type`	Unknown
`source`	Unknown
`time_stamp`	Unknown
`timestamp_acquired`	Unknown

list

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`public_id`	Unknown
`size`	Unknown
`status`	Unknown
`timestamp_created`	Unknown
`timestamp_last_refreshed`	Unknown
`timestamp_stats_updated`	Unknown
`title`	Unknown
`total_orders`	Unknown
`total_revenue`	Unknown
`type`	Unknown

data_anonymisation_request

Column	Type	Keys
`_fivetran_id`	String	PK
`gdpr_related_data_anonymisation_request_id`	Unknown	FK
`hashed_email`	Unknown

gdpr_related_data_anonymisation_request

Column	Type	Keys
`id`	Unknown	PK
`action`	Unknown
`comment`	Unknown
`source_api_request_id`	Unknown
`source_origin`	Unknown
`summary`	Unknown
`timestamp_completed`	Unknown
`timestamp_created`	Unknown
`user_email`	Unknown
`user_name`	Unknown