# Purple Dot schema ERD

Table and field reference for the Fivetran Purple Dot connector.

## Table & Field Reference

### waitlist_variant

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| waitlist_id | Unknown | PK, FK |
| available | Unknown |  |
| buy_size | Unknown |  |
| committed | Unknown |  |
| sku | Unknown |  |
| variant_id | Unknown |  |

### waitlist

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| availability_product_available | Unknown |  |
| availability_product_buy_size | Unknown |  |
| availability_product_committed | Unknown |  |
| availability_product_id | Unknown |  |
| created_at | Unknown |  |
| earliest_ship_date | Unknown |  |
| labels | Json |  |
| latest_ship_date | Unknown |  |
| launch_date | Unknown |  |
| state | Unknown |  |
| updated_at_min | Unknown |  |

### pre_order_count_unit_sku

| Column | Type | Keys |
| --- | --- | --- |
| sku | Unknown | PK |
| at_time | Unknown |  |
| canceled_units | Unknown |  |
| exported_units | Unknown |  |
| open_units | Unknown |  |

### fullfillement_order_line_item_tax

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| fulfillment_order_id | Unknown | PK, FK |
| fulfillment_order_line_item_index | Unknown | PK, FK |
| price | Unknown |  |
| rate | Unknown |  |
| title | Unknown |  |

### fulfillment_order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| fulfillment_order_id | Unknown | PK, FK |
| id | Unknown |  |
| name | Unknown |  |
| price | Unknown |  |
| product_id | Unknown |  |
| quantity | Unknown |  |
| sku | Unknown |  |
| taxable | Unknown |  |
| total | Unknown |  |
| total_discount | Unknown |  |
| variant_id | Unknown |  |

### fullfillement_order_shipping_line_tax

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| fulfillment_order_id | Unknown | PK, FK |
| fulfillment_order_shipping_line_index | Unknown | PK, FK |
| price | Unknown |  |
| rate | Unknown |  |
| title | Unknown |  |

### fulfillment_order_shipping_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| fulfillment_order_id | Unknown | PK, FK |
| code | Unknown |  |
| id | Unknown |  |
| price | Unknown |  |
| title | Unknown |  |
| total | Unknown |  |

### fulfillment_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| currency | Unknown |  |
| customer_default_address_address_1 | Unknown |  |
| customer_default_address_address_2 | Unknown |  |
| customer_default_address_city | Unknown |  |
| customer_default_address_country | Unknown |  |
| customer_default_address_country_code | Unknown |  |
| customer_default_address_first_name | Unknown |  |
| customer_default_address_last_name | Unknown |  |
| customer_default_address_phone | Unknown |  |
| customer_default_address_postal_code | Unknown |  |
| customer_default_address_province_code | Unknown |  |
| customer_email | Unknown |  |
| customer_external_id | Unknown |  |
| customer_first_name | Unknown |  |
| customer_last_name | Unknown |  |
| customer_tags | Json |  |
| note | Unknown |  |
| purchased_at | Unknown |  |
| reference | Unknown |  |
| shipping_address_address_1 | Unknown |  |
| shipping_address_address_2 | Unknown |  |
| shipping_address_city | Unknown |  |
| shipping_address_country | Unknown |  |
| shipping_address_country_code | Unknown |  |
| shipping_address_first_name | Unknown |  |
| shipping_address_last_name | Unknown |  |
| shipping_address_phone | Unknown |  |
| shipping_address_postal_code | Unknown |  |
| shipping_address_province_code | Unknown |  |
| subtotal_price | Unknown |  |
| tax_included | Unknown |  |
| total_discounts | Unknown |  |
| total_price | Unknown |  |
| total_tax | Unknown |  |

### pre_order_line_item_tax

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pre_order_id | Unknown | PK, FK |
| pre_order_line_item_index | Unknown | PK, FK |
| inclusive | Unknown |  |
| price | Unknown |  |
| rate | Unknown |  |
| title | Unknown |  |

### pre_order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pre_order_id | Unknown | PK, FK |
| cancelled | Unknown |  |
| cancelled_at | Unknown |  |
| discount_allocations | Json |  |
| earliest_ship_date | Unknown |  |
| id | Unknown |  |
| latest_ship_date | Unknown |  |
| name | Unknown |  |
| price | Unknown |  |
| product_id | Unknown |  |
| quantity | Unknown |  |
| shopify_line_item_id | Unknown |  |
| sku | Unknown |  |
| taxable | Unknown |  |
| total | Unknown |  |
| total_discount | Unknown |  |
| unit_price | Unknown |  |
| unit_total | Unknown |  |
| variant_id | Unknown |  |

### pre_order_tax_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pre_order_id | Unknown | PK, FK |
| price | Unknown |  |
| rate | Unknown |  |
| title | Unknown |  |

### pre_order_shipping_line_discount_allocation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pre_order_id | Unknown | PK, FK |
| pre_order_shipping_line_index | Unknown | PK, FK |
| amount | Unknown |  |
| discount_application_index | Unknown |  |

### pre_order_shipping_line_tax

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pre_order_id | Unknown | PK, FK |
| pre_order_shipping_line_index | Unknown | PK, FK |
| inclusive | Unknown |  |
| price | Unknown |  |
| rate | Unknown |  |
| title | Unknown |  |

### pre_order_shipping_line_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pre_order_id | Unknown | PK, FK |
| pre_order_shipping_line_index | Unknown | PK, FK |
| line_item_id | Unknown |  |

### pre_order_shipping_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pre_order_id | Unknown | PK, FK |
| code | Unknown |  |
| price | Unknown |  |
| title | Unknown |  |
| total | Unknown |  |

### pre_order_exported_line_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pre_order_exported_index | Unknown | PK, FK |
| pre_order_id | Unknown | PK, FK |
| id | Unknown |  |
| line_item_id | Unknown |  |

### pre_order_exported

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pre_order_id | Unknown | PK, FK |
| created_at | Unknown |  |
| id | Unknown |  |
| order_number | Unknown |  |
| type | Unknown |  |

### pre_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cancel_reason | Unknown |  |
| cancelled_at | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| customer_email | Unknown |  |
| customer_external_id | Unknown |  |
| discount_applications | Json |  |
| discount_codes | Json |  |
| email | Unknown |  |
| number | Unknown |  |
| reference | Unknown |  |
| shipping_address_address_1 | Unknown |  |
| shipping_address_address_2 | Unknown |  |
| shipping_address_city | Unknown |  |
| shipping_address_country | Unknown |  |
| shipping_address_country_code | Unknown |  |
| shipping_address_first_name | Unknown |  |
| shipping_address_last_name | Unknown |  |
| shipping_address_phone | Unknown |  |
| shipping_address_postal_code | Unknown |  |
| shipping_address_province_code | Unknown |  |
| subtotal_price | Unknown |  |
| tax_included | Unknown |  |
| total_discounts | Unknown |  |
| total_price | Unknown |  |
| total_refunded | Unknown |  |
| total_tax | Unknown |  |
| updated_at_min | Unknown |  |

## Relationships

- waitlist_variant(waitlist_id) → waitlist(id)
- fullfillement_order_line_item_tax(fulfillment_order_id) → fulfillment_order(id)
- fullfillement_order_line_item_tax(fulfillment_order_line_item_index) → fulfillment_order_line_item(index)
- fulfillment_order_line_item(fulfillment_order_id) → fulfillment_order(id)
- fullfillement_order_shipping_line_tax(fulfillment_order_id) → fulfillment_order(id)
- fullfillement_order_shipping_line_tax(fulfillment_order_shipping_line_index) → fulfillment_order_shipping_line(index)
- fulfillment_order_shipping_line(fulfillment_order_id) → fulfillment_order(id)
- pre_order_line_item_tax(pre_order_id) → pre_order(id)
- pre_order_line_item_tax(pre_order_line_item_index) → pre_order_line_item(index)
- pre_order_line_item(pre_order_id) → pre_order(id)
- pre_order_tax_line(pre_order_id) → pre_order(id)
- pre_order_shipping_line_discount_allocation(pre_order_id) → pre_order(id)
- pre_order_shipping_line_discount_allocation(pre_order_shipping_line_index) → pre_order_shipping_line(index)
- pre_order_shipping_line_tax(pre_order_id) → pre_order(id)
- pre_order_shipping_line_tax(pre_order_shipping_line_index) → pre_order_shipping_line(index)
- pre_order_shipping_line_item(pre_order_id) → pre_order(id)
- pre_order_shipping_line_item(pre_order_shipping_line_index) → pre_order_shipping_line(index)
- pre_order_shipping_line(pre_order_id) → pre_order(id)
- pre_order_exported_line_item(pre_order_id) → pre_order(id)
- pre_order_exported_line_item(pre_order_exported_index) → pre_order_exported(index)
- pre_order_exported(pre_order_id) → pre_order(id)