Home | Previous Page | Next Page   Appendix A. The stores_demo Database > Structure of the Tables >

The manufact Table

Information about the nine manufacturers whose sporting goods are handled by the distributor is stored in the manufact table. Table 23 shows the columns of the manufact table.

Table 23. The manufact Table
Column Name Data Type Description
manu_code CHAR(3) Manufacturer code
manu_name CHAR(15) Name of manufacturer
lead_time INTERVAL DAY(3) TO DAY Lead time for shipment of orders
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]