+----------+---------------+------+-----+---------+-------+
| Field    | Type          | Null | Key | Default | Extra |
+----------+---------------+------+-----+---------+-------+
| COF_NAME | varchar(32)   | NO   | PRI | NULL    |       |
| SUP_ID   | int           | NO   | MUL | NULL    |       |
| PRICE    | decimal(10,2) | NO   |     | NULL    |       |
| SALES    | int           | NO   |     | NULL    |       |
| TOTAL    | int           | NO   |     | NULL    |       |
+----------+---------------+------+-----+---------+-------+