# Ordergroove schema ERD

Table and field reference for the Fivetran Ordergroove connector.

## Table & Field Reference

### payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| billing_address | Unknown |  |
| cc_exp_date | Unknown |  |
| cc_holder | Unknown |  |
| cc_number_ending | Unknown |  |
| cc_type | Unknown |  |
| created | Unknown |  |
| label | Unknown |  |
| last_updated | Unknown |  |
| live | Unknown |  |
| payment_method | Unknown |  |
| token_id | Unknown |  |

### offer_profile_offer_id

| Column | Type | Keys |
| --- | --- | --- |
| offer_id | Unknown | PK |
| offer_profile_id | Unknown | PK, FK |

### offer_profile_initial_coupon_discount

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| offer_profile_id | Unknown | PK, FK |
| coupon | Unknown |  |
| field | Unknown |  |
| has_condition | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| threshold_field | Unknown |  |
| threshold_value | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### offer_profile_recurring_coupon_discount

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| offer_profile_id | Unknown | PK, FK |
| coupon | Unknown |  |
| field | Unknown |  |
| has_condition | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| threshold_field | Unknown |  |
| threshold_value | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### offer_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| initial_coupon_code | Unknown |  |
| initial_coupon_has_condition | Unknown |  |
| initial_coupon_name | Unknown |  |
| initial_coupon_public_id | Unknown |  |
| live | Unknown |  |
| merchant | Unknown |  |
| name | Unknown |  |
| recurring_coupon_code | Unknown |  |
| recurring_coupon_has_condition | Unknown |  |
| recurring_coupon_name | Unknown |  |
| recurring_coupon_public_id | Unknown |  |
| weight | Unknown |  |

### item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| offer_id | Unknown | FK |
| order_id | Unknown | FK |
| product_id | Unknown | FK |
| subscription_id | Unknown | FK |
| component | Json |  |
| extra_cost | Unknown |  |
| first_placed | Unknown |  |
| frozen | Unknown |  |
| one_time | Unknown |  |
| order_placed_end_date | Unknown |  |
| order_placed_start_date | Unknown |  |
| price | Unknown |  |
| product_attribute | Unknown |  |
| quantity | Unknown |  |
| subscription_component | Unknown |  |
| total_price | Unknown |  |

### product_group

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| product_id | Unknown | PK, FK |
| group_type | Unknown |  |
| name | Unknown |  |

### product_selection_rule_element

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| product_selection_rule_id | Unknown | PK, FK |
| starting_date | Unknown |  |

### product_selection_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| selection_rule_type | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| autoship_by_default | Unknown |  |
| autoship_enabled | Unknown |  |
| created | Unknown |  |
| detail_url | Unknown |  |
| discontinued | Unknown |  |
| every | Unknown |  |
| every_period | Unknown |  |
| extra_data | Json |  |
| image_url | Unknown |  |
| incentive_group | Unknown |  |
| last_update | Unknown |  |
| live | Unknown |  |
| merchant | Unknown |  |
| name | Unknown |  |
| offer_profile | Unknown |  |
| premier_enabled | Unknown |  |
| prepaid_eligible | Unknown |  |
| price | Unknown |  |
| product_type | Unknown |  |
| sku | Unknown |  |

### address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| address | Unknown |  |
| address_2 | Unknown |  |
| city | Unknown |  |
| company_name | Unknown |  |
| country_code | Unknown |  |
| created | Unknown |  |
| fax | Unknown |  |
| first_name | Unknown |  |
| label | Unknown |  |
| last_name | Unknown |  |
| live | Unknown |  |
| phone | Unknown |  |
| state_province_code | Unknown |  |
| store_public_id | Unknown |  |
| token_id | Unknown |  |
| zip_postal_code | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created | Unknown |  |
| email | Unknown |  |
| extra_data | Unknown |  |
| first_name | Unknown |  |
| last_login | Unknown |  |
| last_name | Unknown |  |
| last_updated | Unknown |  |
| live | Unknown |  |
| locale | Unknown |  |
| merchant | Unknown |  |
| phone_number | Unknown |  |
| phone_type | Unknown |  |
| price_code | Unknown |  |
| session_id | Unknown |  |
| user_token_id | Unknown |  |

### incentive

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| order_id | Unknown | FK |
| created | Unknown |  |
| description | Unknown |  |
| discount_type | Unknown |  |
| expires | Unknown |  |
| external_code | Unknown |  |
| field | Unknown |  |
| item | Unknown |  |
| last_updated | Unknown |  |
| merchant | Unknown |  |
| name | Unknown |  |
| public_id | Unknown |  |
| stacking_type | Unknown |  |
| target | Unknown |  |
| threshold_field | Unknown |  |
| threshold_value | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### merchant_cancel_reason

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| application | Unknown |  |
| cancel_reason | Unknown |  |

### subscription_component

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscription_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| quantity | Unknown |  |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| payment_id | Unknown | FK |
| product_id | Unknown | FK |
| shipping_address | Unknown | FK |
| cancel_reason | Unknown |  |
| cancel_reason_code | Unknown |  |
| cancelled | Unknown |  |
| club | Unknown |  |
| created | Unknown |  |
| currency_code | Unknown |  |
| customer_rep | Unknown |  |
| every | Unknown |  |
| every_period | Unknown |  |
| external_id | Unknown |  |
| extra_data_commitment_committed | Unknown |  |
| extra_data_commitment_version | Unknown |  |
| extra_data_migration_sub_id | Unknown |  |
| extra_data_shopify_contract_id | Unknown |  |
| frequency_days | Unknown |  |
| iteration | Unknown |  |
| live | Unknown |  |
| merchant | Unknown |  |
| merchant_order_id | Unknown |  |
| offer | Unknown |  |
| prepaid_subscription_context | Unknown |  |
| price | Unknown |  |
| product_attribute | Unknown |  |
| quantity | Unknown |  |
| raw_subscription_type | Unknown |  |
| reminder_days | Unknown |  |
| sequence | Unknown |  |
| session_id | Unknown |  |
| start_date | Unknown |  |
| subscription_type | Unknown |  |
| updated | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| payment_id | Unknown | FK |
| shipping_address | Unknown | FK |
| cancelled | Unknown |  |
| created | Unknown |  |
| currency_code | Unknown |  |
| discount_total | Unknown |  |
| extra_data | Unknown |  |
| generic_error_count | Unknown |  |
| locked | Unknown |  |
| merchant | Unknown |  |
| oos_free_shipping | Unknown |  |
| order_merchant_id | Unknown |  |
| place | Unknown |  |
| rejected_message | Unknown |  |
| shipping_total | Unknown |  |
| status | Unknown |  |
| sub_total | Unknown |  |
| tax_total | Unknown |  |
| total | Unknown |  |
| tries | Unknown |  |
| type | Unknown |  |
| updated | Unknown |  |

### subscription_discount

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| subscription_id | Unknown | PK, FK |
| title | Unknown |  |

## Relationships

- payment(customer_id) → customer(id)
- offer_profile_offer_id(offer_profile_id) → offer_profile(id)
- offer_profile_initial_coupon_discount(offer_profile_id) → offer_profile(id)
- offer_profile_recurring_coupon_discount(offer_profile_id) → offer_profile(id)
- item(product_id) → product(id)
- item(subscription_id) → subscription(id)
- item(order_id) → orders(id)
- item(offer_id) → offer_profile(id)
- product_group(product_id) → product(id)
- product_selection_rule_element(product_selection_rule_id) → product_selection_rule(id)
- product_selection_rule_element(product_id) → product_selection_rule(product_id)
- product_selection_rule(product_id) → product(id)
- address(customer_id) → customer(id)
- incentive(order_id) → orders(id)
- incentive(customer_id) → customer(id)
- subscription_component(product_id) → product(id)
- subscription_component(subscription_id) → subscription(id)
- subscription(product_id) → product(id)
- subscription(payment_id) → payment(id)
- subscription(customer_id) → customer(id)
- subscription(shipping_address) → address(id)
- orders(payment_id) → payment(id)
- orders(customer_id) → customer(id)
- orders(shipping_address) → address(id)
- subscription_discount(subscription_id) → subscription(id)