Purple Dot
Explore the interactive ERD
Table & Field Reference
waitlist_variant
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
waitlist_id | Unknown | PKFK |
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 | PKFK |
fulfillment_order_line_item_index | Unknown | PKFK |
price | Unknown | |
rate | Unknown | |
title | Unknown |
fulfillment_order_line_item
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
fulfillment_order_id | Unknown | PKFK |
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 | PKFK |
fulfillment_order_shipping_line_index | Unknown | PKFK |
price | Unknown | |
rate | Unknown | |
title | Unknown |
fulfillment_order_shipping_line
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
fulfillment_order_id | Unknown | PKFK |
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 | PKFK |
pre_order_line_item_index | Unknown | PKFK |
inclusive | Unknown | |
price | Unknown | |
rate | Unknown | |
title | Unknown |
pre_order_line_item
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
pre_order_id | Unknown | PKFK |
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 | PKFK |
price | Unknown | |
rate | Unknown | |
title | Unknown |
pre_order_shipping_line_discount_allocation
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
pre_order_id | Unknown | PKFK |
pre_order_shipping_line_index | Unknown | PKFK |
amount | Unknown | |
discount_application_index | Unknown |
pre_order_shipping_line_tax
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
pre_order_id | Unknown | PKFK |
pre_order_shipping_line_index | Unknown | PKFK |
inclusive | Unknown | |
price | Unknown | |
rate | Unknown | |
title | Unknown |
pre_order_shipping_line_item
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
pre_order_id | Unknown | PKFK |
pre_order_shipping_line_index | Unknown | PKFK |
line_item_id | Unknown |
pre_order_shipping_line
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
pre_order_id | Unknown | PKFK |
code | Unknown | |
price | Unknown | |
title | Unknown | |
total | Unknown |
pre_order_exported_line_item
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
pre_order_exported_index | Unknown | PKFK |
pre_order_id | Unknown | PKFK |
id | Unknown | |
line_item_id | Unknown |
pre_order_exported
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
pre_order_id | Unknown | PKFK |
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 |