Country Marketplace OrderRequest ProductCatalogue

id SERIAL 1 id SERIAL 1 1 id SERIAL 1 id SERIAL 1

name VARCHAR(255) name VARCHAR(255) order_number VARCHAR(255) sku_name VARCHAR(255)

code VARCHAR(10) * country_id INT * marketplace_id INT description TEXT

created_at TIMESTAMP

status VARCHAR(50)
OrderRequestItem Packaging BoxSKU
awb_number VARCHAR(255)
id SERIAL id SERIAL 1 id SERIAL
shipping_invoice VARCHAR(255)
order_request_id INT * order_request_id INT * * box_id INT
export_invoice VARCHAR(255)
product_catalogue_id INT * created_at TIMESTAMP product_catalogue_id INT *

quantity INT quantity INT

Box

id SERIAL 1

* packaging_id INT

length DECIMAL(10,2)

width DECIMAL(10,2)

height DECIMAL(10,2)

weight DECIMAL(10,2)

volumetric_weight DECIMAL(10,2)

label_pdf TEXT
Country Marketplace OrderRequest ProductCatalogue

id SERIAL 1 id SERIAL 1 1 id SERIAL 1 id SERIAL 1

name VARCHAR(255) name VARCHAR(255) order_number VARCHAR(255) sku_name VARCHAR(255)

code VARCHAR(10) * country_id INT * marketplace_id INT description TEXT

created_at TIMESTAMP

status VARCHAR(50)
OrderRequestItem Packaging BoxSKU
awb_number VARCHAR(255)
id SERIAL id SERIAL 1 id SERIAL
shipping_invoice VARCHAR(255)
order_request_id INT * order_request_id INT * * box_id INT
export_invoice VARCHAR(255)
product_catalogue_id INT * created_at TIMESTAMP product_catalogue_id INT *

quantity INT quantity INT

Box

id SERIAL 1

* packaging_id INT

length DECIMAL(10,2)

width DECIMAL(10,2)

height DECIMAL(10,2)

weight DECIMAL(10,2)

volumetric_weight DECIMAL(10,2)

label_pdf TEXT