# Prive schema ERD

Table and field reference for the Fivetran Prive connector.

## Table & Field Reference

### one_time_add_on

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

### subscription_gift

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscription_id | Unknown | PK, FK |
| created_at | Unknown |  |
| email | Unknown |  |
| gift_to | Unknown |  |
| is_opened | Unknown |  |
| is_prepaid | Unknown |  |
| message | Unknown |  |
| number_of_deliveries | Unknown |  |
| updated_at | Unknown |  |

### subscription_recipient

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

### subscription_custom_attribute

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| subscription_id | Unknown | PK, FK |
| value | Unknown |  |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscriber_id | Unknown | FK |
| billing_address_1 | Unknown |  |
| billing_address_2 | Unknown |  |
| billing_cadence_count | Unknown |  |
| billing_cadence_unit | Unknown |  |
| billing_city | Unknown |  |
| billing_country | Unknown |  |
| billing_first_name | Unknown |  |
| billing_last_name | Unknown |  |
| billing_province | Unknown |  |
| billing_zip | Unknown |  |
| cancel_date | Unknown |  |
| cancel_reason | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| delivery_address_1 | Unknown |  |
| delivery_address_2 | Unknown |  |
| delivery_cadence_count | Unknown |  |
| delivery_cadence_unit | Unknown |  |
| delivery_city | Unknown |  |
| delivery_company | Unknown |  |
| delivery_country | Unknown |  |
| delivery_first_name | Unknown |  |
| delivery_last_name | Unknown |  |
| delivery_phone | Unknown |  |
| delivery_price | Unknown |  |
| delivery_province | Unknown |  |
| delivery_shipping_option | Unknown |  |
| delivery_zip | Unknown |  |
| external_id | Unknown |  |
| friendly_id | Unknown |  |
| is_prepaid | Unknown |  |
| next_billing_date | Unknown |  |
| next_delivery_date | Unknown |  |
| payment_method_brand | Unknown |  |
| payment_method_email | Unknown |  |
| payment_method_expiry_month | Unknown |  |
| payment_method_expiry_year | Unknown |  |
| payment_method_external_id | Unknown |  |
| payment_method_last_4_digit | Unknown |  |
| payment_method_name | Unknown |  |
| payment_method_type | Unknown |  |
| purchase_date | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### billing_attempt

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| subscription_id | Unknown | FK |
| created_at | Unknown |  |
| error_code | Unknown |  |
| error_msg | Unknown |  |
| external_id | Unknown |  |
| updated_at | Unknown |  |

### subscription_discount_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscription_id | Unknown | FK |
| code | Unknown |  |
| created_at | Unknown |  |
| discount_code_external_id | Unknown |  |
| updated_at | Unknown |  |

### subscription_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscription_id | Unknown | FK |
| subscription_offer_option_id | Unknown | FK |
| variant_id | Unknown | FK |
| created_at | Unknown |  |
| current_price | Unknown |  |
| custom_attribute | Unknown |  |
| external_id | Unknown |  |
| quantity | Unknown |  |
| selling_plan_id | Unknown |  |
| updated_at | Unknown |  |

### base_order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| base_order_id | Unknown | FK |
| variant_id | Unknown | FK |
| created_at | Unknown |  |
| current_price | Unknown |  |
| is_add_on_one_time | Unknown |  |
| quantity | Unknown |  |
| updated_at | Unknown |  |

### entry_point_visibility

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| swap_and_add_on_option_id | Unknown | PK, FK |
| entry_point_visibility | Unknown |  |

### variant_entry_point_visibility

| Column | Type | Keys |
| --- | --- | --- |
| variant_external_id | Unknown | PK |
| swap_and_add_on_option_id | Unknown | PK, FK |
| entry_point_visibility | Json |  |

### swap_and_add_on_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| subscription_offer_id | Unknown | FK |
| created_at | Unknown |  |
| one_time_add_on_discount | Unknown |  |
| one_time_add_on_discount_modifier_type | Unknown |  |
| updated_at | Unknown |  |

### product_variant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| current_price | Unknown |  |
| external_id | Unknown |  |
| sku | Unknown |  |
| variant_title | Unknown |  |

### product_subscription_offer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| description | Unknown |  |
| external_id | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### product_subscription_offer_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_subscription_offer_id | Unknown | PK, FK |
| archived | Unknown |  |
| billing_cadence_count | Unknown |  |
| billing_cadence_unit | Unknown |  |
| created_at | Unknown |  |
| delivery_cadence_count | Unknown |  |
| delivery_cadence_unit | Unknown |  |
| discount | Unknown |  |
| discount_modifier | Unknown |  |
| external_id | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscription_offer_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| external_id | Unknown |  |
| image_url | Unknown |  |
| product_title | Unknown |  |
| updated_at | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| base_order_id | Unknown | FK |
| subscriber_id | Unknown | FK |
| charged_amount | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| delivery_amount | Unknown |  |
| external_id | Unknown |  |
| is_skipped | Unknown |  |
| purchase_date | Unknown |  |
| scheduled_date | Unknown |  |
| status | Unknown |  |
| subscription_charged_amount | Unknown |  |
| tax | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| subscription_id | Unknown | FK |
| variant_id | Unknown | FK |
| created_at | Unknown |  |
| discount_allocation_total_amount | Unknown |  |
| external_id | Unknown |  |
| price_total | Unknown |  |
| price_total_discounted | Unknown |  |
| price_total_tax_with_discounts | Unknown |  |
| product_title | Unknown |  |
| quantity | Unknown |  |
| updated_at | Unknown |  |

### base_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscription_contract_id | Unknown | FK |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| is_skipped | Unknown |  |
| scheduled_date | Unknown |  |
| sequence_number | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### subscriber

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| email | Unknown |  |
| external_id | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| phone | Unknown |  |
| phone_country_code | Unknown |  |
| updated_at | Unknown |  |

### subscription_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscription_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| event_timestamp | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| users | Unknown |  |

## Relationships

- one_time_add_on(variant_id) → product_variant(id)
- one_time_add_on(subscription_id) → subscription(id)
- subscription_gift(subscription_id) → subscription(id)
- subscription_recipient(id) → subscriber(id)
- subscription_recipient(subscription_id) → subscription(id)
- subscription_custom_attribute(subscription_id) → subscription(id)
- subscription(subscriber_id) → subscriber(id)
- billing_attempt(subscription_id) → subscription(id)
- billing_attempt(order_id) → orders(id)
- subscription_discount_code(subscription_id) → subscription(id)
- subscription_line(subscription_id) → subscription(id)
- subscription_line(subscription_offer_option_id) → product_subscription_offer_option(id)
- subscription_line(variant_id) → product_variant(id)
- base_order_line_item(base_order_id) → base_order(id)
- base_order_line_item(variant_id) → product_variant(id)
- entry_point_visibility(swap_and_add_on_option_id) → swap_and_add_on_option(id)
- variant_entry_point_visibility(swap_and_add_on_option_id) → swap_and_add_on_option(id)
- swap_and_add_on_option(subscription_offer_id) → product_subscription_offer(id)
- swap_and_add_on_option(product_id) → product(id)
- product_variant(product_id) → product(id)
- product_subscription_offer_option(product_subscription_offer_id) → product_subscription_offer(id)
- product(subscription_offer_id) → product_subscription_offer(id)
- orders(subscriber_id) → subscriber(id)
- orders(base_order_id) → base_order(id)
- order_line_item(subscription_id) → subscription(id)
- order_line_item(variant_id) → product_variant(id)
- order_line_item(order_id) → orders(id)
- base_order(subscription_contract_id) → subscription(id)
- subscription_activity(subscription_id) → subscription(id)