The orders table contains information about orders placed by the customers of the distributor. Table 13 shows the columns of the orders table.
| Column Name | Data Type | Description |
|---|---|---|
| order_num | SERIAL(1001) | System-generated order number |
| order_date | DATE | Date order entered |
| customer_num | INTEGER | Customer number (foreign key to customer table) |
| ship_instruct | CHAR(40) | Special shipping instructions |
| backlog | CHAR(1) | Indicates order cannot be filled because the
item is backlogged:
y = yes n = no |
| po_num | CHAR(10) | Customer purchase order number |
| ship_date | DATE | Shipping date |
| ship_weight | DECIMAL(8,2) | Shipping weight |
| ship_charge | MONEY(6) | Shipping charge |
| paid_date | DATE | Date order paid |