This is a working progress, but should allow the generation of a sample database to build some data pipelines with.
- Tables:
- Customer:
- ID
- Name
- DOB
- Customer_Address:
- ID
- Customer ID
- Address Line
- City
- State
- Zip
- Order:
- ID
- Customer ID
- Address ID
- Order Date
- Order Paid Amount
- Order Status:
- ID
- Order ID
- Status
- Status Date
- Order_Line_Item:
- ID
- Order ID
- Stock ID
- Quantity
- Paid Amount
- Stock:
- ID
- Name
- Quantity
- Price
- Customer: