order

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('Insights.order_id_seq'::regclass)
budget_usage_history.used_with_order_id fk_budget_usage_history_used_with_order_id_order_id R
order_checkout_attribute_mapping.order_id fk_order_checkout_attribute_mapping_order_id_order_id C
orderline.order_id fk_orderline_order_id_order_id R
reward_points_history.used_with_order_id fk_reward_points_history_used_with_order_id_order_id R
shipping_method varchar 200 √ null
shipping_method_code varchar 200 √ null
customer_currency_code varchar 100 √ null
payment_method varchar 200 √ null
tax_rates varchar 100 √ null
checkout_attributes_info text 2147483647 √ null
payment_status varchar 100 √ null
shipping_status varchar 100 √ null
status varchar 100 √ null
purchase_order_number varchar 2000 √ null
tracking_number varchar 2000 √ null
discount_id int4 10 √ null
order_discount.id fk_order_discount_id_order_discount_id R
customer_id int4 10 null
customer.id fk_order_customer_id_customer_id R
impersonating_customer_id int4 10 √ null
customer.id fk_order_impersonating_customer_id_customer_id R
billing_address_id int4 10 null
address.id fk_order_billing_address_id_address_id R
shipping_address_id int4 10 √ null
address.id fk_order_shipping_address_id_address_id R
storefront_id int4 10 null
storefront.id fk_order_storefront_id_storefront_id C
total numeric 18,4 null
discount numeric 18,4 null
subtotal_incl_tax numeric 18,4 null
sub_total_discount_incl_tax numeric 18,4 null
shipping_incl_tax numeric 18,4 null
shipping_excl_tax numeric 18,4 null
order_tax numeric 18,4 null
tax_rate numeric 18,4 null
created_date timestamp 29,6 null
shipped_date timestamp 29,6 √ null
deliver_by timestamp 29,6 √ null
dispatch_by timestamp 29,6 √ null
order_guid uuid 2147483647 null
weight numeric 18,4 null
currency_rate numeric 18,4 null
timestamp 29,6 √ null
external_ref uuid 2147483647 null
source_id int4 10 null
department_id int4 10 √ null
department.id fk_order_department_id_department_id R
uid varchar 200 √ null
delivery_method_id int4 10 √ null
delivery_method.id fk_order_delivery_method_id_delivery_method_id R

Indexes

Constraint Name Type Sort Column(s)
PK_order Primary key Asc id
ixInsights_order_created_date_storefront_total Performance Asc/Asc/Asc/Asc/Asc/Asc status + created_date + storefront_id + total + shipping_excl_tax + order_tax
ixInsights_order_shipping_status Performance Asc/Asc status + shipping_status
ixInsights_order_status Performance Asc status
ixInsights_order_uid Performance Asc uid
ixorder_billing_address_id Performance Asc billing_address_id
ixorder_customer_id Performance Asc customer_id
ixorder_discount_id Performance Asc discount_id
ixorder_impersonating_customer_id Performance Asc impersonating_customer_id
ixorder_shipping_address_id Performance Asc shipping_address_id
ixorder_storefront_id Performance Asc storefront_id

Relationships

Close relationships within degrees of separation