Description
Product names, suppliers, prices, and units in stock.
Fields
| Name | Type | Attributes | Default | Description |
|---|---|---|---|---|
 ProductID |
int | Auto Increment |
Number automatically assigned to new product. | |
 ProductName |
nvarchar(40) | |||
| SupplierID |
int | Nullable |
Same entry as in Suppliers table. | |
| CategoryID |
int | Nullable |
Same entry as in Categories table. | |
| QuantityPerUnit |
nvarchar(20) | Nullable |
(e.g., 24-count case, 1-liter bottle). | |
| UnitPrice |
money | Nullable |
0 | |
| UnitsInStock |
smallint | Nullable |
0 | |
| UnitsOnOrder |
smallint | Nullable |
0 | |
| ReorderLevel |
smallint | Nullable |
0 | Minimum units to maintain in stock. |
| Discontinued |
bit | 0 | Yes means item is no longer available. |
Indexes
| Name | Columns | Unique |
|---|---|---|
 CategoriesProducts |
CategoryID | no |
| CategoryID |
CategoryID | no |
| ProductName |
ProductName, ProductID | no |
| SupplierID |
SupplierID | no |
| SuppliersProducts |
SupplierID | no |
Relationships
| Master | Detail | ||
|---|---|---|---|
| Table | Columns | Table | Columns |
| Products | ProductID | Order Details | ProductID |
| Categories | CategoryID | Products | CategoryID |
| Suppliers | SupplierID | Products | SupplierID |