PurchaseOrders (Purchase Orders)
Description
This table lists all purchase orders made to suppliers.
Columns
| Name | Title | Datatype | Nullable | Other | Description | Last edit |
|---|---|---|---|---|---|---|
| purchase_order_id | int(11) | NO | auto_increment | 1 month ago | ||
| supplier_id | int(11) | YES | 1 month ago | |||
| order_date | date | NO | 1 month ago | |||
| delivery_date | date | YES | 1 month ago | |||
| status | enum('Pending','Shipped','Completed','Cancelled') | NO | 1 month ago |