The catalog table describes each item in stock. Retail stores use this table when placing orders with the distributor. Table 20 shows the columns of the catalog table.
| Column Name | Data Type | Description |
|---|---|---|
| catalog_num | SERIAL(10001) | System-generated catalog number |
| stock_num | SMALLINT | Distributor stock number (foreign key to stock table) |
| manu_code | CHAR(3) | Manufacturer code (foreign key to manufact table) |
| cat_descr | TEXT | Description of item |
| cat_picture | BYTE | Picture of item (binary data) |
| cat_advert | VARCHAR(255, 65) | Tag line underneath picture |