|
Key
|
ID
|
Name
|
Data Type
|
Size(Precision,Scale)
|
Nulls
|
Default
|
|
|
ProductID
|
int
|
0
|
|
|
| |
The primary key for each product.
|
|
|
|
ProductName
|
nvarchar
|
40
|
|
|
| |
The product's name.
|
|
|
|
SupplierID
|
int
|
0
|
|
|
| |
The product's supplier.
|
|
|
|
CategoryID
|
int
|
0
|
|
|
| |
The product's category.
|
|
|
|
QuantityPerUnit
|
nvarchar
|
20
|
|
|
| |
The quantity for each unit of this product.
|
|
|
|
UnitPrice
|
money
|
0
|
|
(0)
|
| |
The price per unit of the product.
|
|
|
|
UnitsInStock
|
smallint
|
0
|
|
(0)
|
| |
The number of units currently in stock for this product.
|
|
|
|
UnitsOnOrder
|
smallint
|
0
|
|
(0)
|
| |
The number of units currently on order for this product.
|
|
|
|
ReorderLevel
|
smallint
|
0
|
|
(0)
|
| |
The level at which an automatic re-order of this product should take place.
|
|
|
|
Discontinued
|
bit
|
0
|
|
(0)
|
| |
A flag indicating if this product has been discontinued.
|
Products (Created 8/6/2000 1:34:07 AM)