| Next |
|
The table COFFEES
| Includes coffee names, their prices, the number of pounds sold the current week, and the number of pounds sold to date. |
COF_NAME
Colombian
French_Roast
Espresso
Colombian_Decaf
French_Roast_Decaf
COF_NAME:
| SQL type: VARCHAR, maximum length: 32 characters, Primary Key. |
SUP_ID:
| SQL type: INTEGER. |
PRICE:
| SQL type: FLOAT (for compatibility over many DBMSs and JDBC - normally in SQL type DECIMAL or NUMERIC) |
SALES:
| SQL type: INTEGER |
TOTAL:
| SQL type: INTEGER |
The table SUPPLIERS
SUP_ID |
|||||
|---|---|---|---|---|---|