The customer table contains information about the retail stores that place orders from the distributor. Table 16 shows the columns of the customer table.
The zipcode column in Table 16 is indexed and allows duplicate values.
| Column Name | Data Type | Description |
|---|---|---|
| customer_num | SERIAL(101) | System-generated customer number |
| fname | CHAR(15) | First name of store representative |
| lname | CHAR(15) | Last name of store representative |
| company | CHAR(20) | Name of store |
| address1 | CHAR(20) | First line of store address |
| address2 | CHAR(20) | Second line of store address |
| city | CHAR(15) | City |
| state | CHAR(2) | State (foreign key to state table) |
| zipcode | CHAR(5) | Zipcode |
| phone | CHAR(18) | Telephone number |