RdsDiagram
Customers
customer_id: BIGINT
customer_first_name: VARCHAR(20)
customer_last_name: VARCHAR(20)
customer_phone: VARCHAR(20)
customer_email: VARCHAR(20)
other_customer_details: VARCHAR(300)
CustomerOrders
order_id: BIGINT
customer_id: BIGINT
customer_payment_method_id: BIGINT
order_status_code: VARCHAR(10)
date_order_placed: DATE
date_order_paid: DATE
der_order_price: NUMERIC(9,2)
other_order_details: VARCHAR(200)
CustomerOrdersDelivery
order_id: BIGINT
date_reported: DATE
delivery_status_code: VARCHAR(10)
Product_Price_History_effectiveStartDate: DATE
RefDeliveryStatusCodes
delivery_status_code: VARCHAR(10)
delivery_status_description: VARCHAR(100)
CustomerAddresses
customer_id: BIGINT
address_id: BIGINT
date_from: DATE
date_to: DATE
address_type_code: VARCHAR(10)
Addresses
address_id: BIGINT
line1_street_name: VARCHAR(60)
line2_street_no: VARCHAR(10)
line3_building_no: INTEGER
city: VARCHAR(40)
zip_code: INTEGER
state_province_county: VARCHAR(20)
other_address_details: VARCHAR(200)
RefAddressType
address_type_code: VARCHAR(10)
address_type_description: VARCHAR(10)
CustomerOrdersProducts
order_id: BIGINT
product_id: BIGINT
quantity: INTEGER
comments: VARCHAR(200)
Products
product_id: BIGINT
product_type_code: VARCHAR(10)
supplier_id: BIGINT
product_price: NUMERIC(9,2)
other_product_details: VARCHAR(200)
Suppliers
supplier_id: BIGINT
supplier_name: VARCHAR(60)
other_supplier_details: VARCHAR(200)
RefProductType
product_type_code: VARCHAR(10)
parent_product_type_code: VARCHAR(10)
product_type_description: VARCHAR(200)
RefOrderStatusCodes
order_satus_code: VARCHAR(10)
order_status_description: VARCHAR(300)
CustomersPaymentMethods
customer_payment_method_id: BIGINT
customer_id: BIGINT
payment_method_code: VARCHAR(10)
card_number: BIGINT
date_from: DATE
date_to: DATE
other_details: VARCHAR(300)
RefPaymentMethods
payment_method_code: VARCHAR(10)
payment_method_description: VARCHAR(200)
Product_Price_History
history_id: BIGINT
product_id: BIGINT
product_price: NUMERIC(9,2)
effectiveStartDate: DATE