orderline

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('Insights.orderline_id_seq'::regclass)
orderline_approver_history.orderline_id fk_orderline_approver_history_orderline_id_orderline_id R
orderline_attribute_mapping.orderline_id fk_orderline_attribute_mapping_orderline_id_orderline_id C
orderline_status_history.orderline_id fk_orderline_status_history_orderline_id_orderline_id C
attributes_info text 2147483647 √ null
status varchar 500 null
order_id int4 10 null
order.id fk_orderline_order_id_order_id R
product_id int4 10 null
product.id fk_orderline_product_id_product_id R
delivery_type varchar 200 √ null
storefront_id int4 10 null
storefront.id fk_orderline_storefront_id_storefront_id C
job_reference text 2147483647 √ null
record_count int4 10 √ null
page_count int4 10 √ null
weight numeric 18,4 √ null
ordered_date timestamp 29,6 √ null
unit_price_excl_tax numeric 18,4 null
unit_price_incl_tax numeric 18,4 null
price_incl_tax numeric 18,4 null
price_excl_tax numeric 18,4 null
quantity int4 10 null
sales_tax numeric 18,4 null
tier_price_part_1 numeric 18,4 √ null
tier_price_part_2 numeric 18,4 √ null
tier_price_part_3 numeric 18,4 √ null
tier_price_part_4 numeric 18,4 √ null
sku text 2147483647 √ null
external_ref uuid 2147483647 null
source_id int4 10 null
custom_job_name varchar 1000 √ null
uid varchar 200 √ null
attribute_combination_id int4 10 √ null
attribute_combination.id fk_orderline_attribute_combination_id_attribute_combination_id N
download_count int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_orderline Primary key Asc id
ixorderline_order_id Performance Asc order_id
ixorderline_product_id Performance Asc product_id
ixorderline_storefront_id Performance Asc storefront_id

Relationships

Close relationships within degrees of separation