# Ometria schema ERD

Table and field reference for the Fivetran Ometria connector.

## 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 | PK, FK |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| collection_id | Unknown | PK, FK |
| 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 | PK, FK |
| profile_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |

### product_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| label | Unknown |  |
| type | Unknown |  |

### product_listing

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| store_id | Unknown | PK, FK |
| 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 | PK, FK |
| order_id | Unknown | PK, FK |
| label | Unknown |  |

### orders_line_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- contact_store_id(contact_id) → contact(id)
- contact(profile_id) → profile(id)
- contact(customer_id) → profile(customer_id)
- contact(collection_id) → collection(id)
- unsubscribed_contact(profile_id) → profile(id)
- list_change(profile_id) → profile(id)
- list_change(list_id) → list(id)
- custom_event(profile_id) → profile(id)
- profile_list(profile_id) → profile(id)
- list_member_store_id(list_member_id) → list_member(id)
- list_member(id) → collection(id)
- list_member(customer_id) → profile(customer_id)
- list_member(list_id) → list(id)
- product_store(product_id) → product(id)
- product_attribute(product_id) → product(id)
- product_listing(store_id) → product_store(store_id)
- product_listing(product_id) → product(id)
- orders_line_item_variant_option(index) → orders_line_item(index)
- orders_line_item_variant_option(order_id) → orders_line_item(order_id)
- orders_line_item(product_id) → product(id)
- orders_line_item(order_id) → orders(id)
- orders(customer_id) → profile(customer_id)
- error(customer_id) → profile(customer_id)
- data_anonymisation_request(gdpr_related_data_anonymisation_request_id) → gdpr_related_data_anonymisation_request(id)