Columns
-
ProductID[int] NOT NULL
-
ProductName[nvarchar](40) NOT NULL
-
SupplierID[int] NULL
-
CategoryID[int] NULL
-
QuantityPerUnit[nvarchar](20) NULL
-
UnitPrice[money] NULL
-
UnitsInStock[smallint] NULL
-
UnitsOnOrder[smallint] NULL
-
ReorderLevel[smallint] NULL
-
Discontinued[bit] NOT NULL
-
CategoryName[nvarchar](15) NOT NULL
Definition
Sample Data
ProductID
ProductName
SupplierID
CategoryID
QuantityPerUnit
UnitPrice
UnitsInStock
UnitsOnOrder
ReorderLevel
Discontinued
CategoryName
1
Chai
1
1
10 boxes x 20 bags
18
39
NULL
10
NULL
Beverages
2
Chang
1
1
24 - 12 oz bottles
19
17
40
25
NULL
Beverages
3
Aniseed Syrup
1
2
12 - 550 ml bottles
10
13
70
25
NULL
Condiments
4
Chef Anton's Cajun Seasoning
2
2
48 - 6 oz jars
22
53
NULL
NULL
NULL
Condiments
6
Grandma's Boysenberry Spread
3
2
12 - 8 oz jars
25
120
NULL
25
NULL
Condiments
7
Uncle Bob's Organic Dried Pears
3
7
12 - 1 lb pkgs.
30
15
NULL
10
NULL
Produce
8
Northwoods Cranberry Sauce
3
2
12 - 12 oz jars
40
6
NULL
NULL
NULL
Condiments
10
Ikura
4
8
12 - 200 ml jars
31
31
NULL
NULL
NULL
Seafood
11
Queso Cabrales
5
4
1 kg pkg.
21
22
30
30
NULL
Dairy Products
12
Queso Manchego La Pastora
5
4
10 - 500 g pkgs.
38
86
NULL
NULL
NULL
Dairy Products
13
Konbu
6
8
2 kg box
6
24
NULL
5
NULL
Seafood
14
Tofu
6
7
40 - 100 g pkgs.
23.25
35
NULL
NULL
NULL
Produce
15
Genen Shouyu
6
2
24 - 250 ml bottles
15.5
39
NULL
5
NULL
Condiments
16
Pavlova
7
3
32 - 500 g boxes
17.45
29
NULL
10
NULL
Confections
18
Carnarvon Tigers
7
8
16 kg pkg.
62.5
42
NULL
NULL
NULL
Seafood
19
Teatime Chocolate Biscuits
8
3
10 boxes x 12 pieces
9.2
25
NULL
5
NULL
Confections
20
Sir Rodney's Marmalade
8
3
30 gift boxes
81
40
NULL
NULL
NULL
Confections
21
Sir Rodney's Scones
8
3
24 pkgs. x 4 pieces
10
3
40
5
NULL
Confections
22
Gustaf's Knäckebröd
9
5
24 - 500 g pkgs.
21
104
NULL
25
NULL
Grains/Cereals
23
Tunnbröd
9
5
12 - 250 g pkgs.
9
61
NULL
25
NULL
Grains/Cereals
25
NuNuCa Nuß-Nougat-Creme
11
3
20 - 450 g glasses
14
76
NULL
30
NULL
Confections
26
Gumbär Gummibärchen
11
3
100 - 250 g bags
31.23
15
NULL
NULL
NULL
Confections
27
Schoggi Schokolade
11
3
100 - 100 g pieces
43.9
49
NULL
30
NULL
Confections
30
Nord-Ost Matjeshering
13
8
10 - 200 g glasses
25.89
10
NULL
15
NULL
Seafood
31
Gorgonzola Telino
14
4
12 - 100 g pkgs
12.5
NULL
70
20
NULL
Dairy Products