SalesOrders (Sales Orders)
Description
This table records all sales orders placed by customers.
Columns
| Name | Title | Datatype | Nullable | Other | Description | Last edit |
|---|---|---|---|---|---|---|
| sales_order_id | int(11) | NO | auto_increment | 1 year ago | ||
| customer_id | int(11) | YES | 1 year ago | |||
| order_date | Date of the order | date | NO | 1 year ago | ||
| shipment_date | Date when the package was shipped | date | YES | 1 year ago | ||
| status | String status | enum('Pending','Shipped','Completed','Cancelled') | NO | enum('Pending','Shipped','Completed','Cancelled') | 1 year ago |