An order can include one or more items. One row exists in the items table for each item in an order. Table 18 shows the columns of the items table.
| Column Name | Data Type | Description |
|---|---|---|
| item_num | SMALLINT | Sequentially assigned item number for an order |
| order_num | INTEGER | Order number (foreign key to orders table) |
| stock_num | SMALLINT | Stock number for item (foreign key to stock table) |
| manu_code | CHAR(3) | Manufacturer code for item ordered (foreign key to manufact table) |
| quantity | SMALLINT | Quantity ordered (value must be > 1) |
| total_price | MONEY(8) | Quantity ordered * unit price = total price of item |