Database Examples/Northwind/Products
Jump to navigation
Jump to search
Fields[edit | edit source]
Field Name | Field Type | Length | Index | Constraint | Default |
---|---|---|---|---|---|
ProductID | Integer | Primary Key | Not Null | ||
ProductName | Text | 50 | Yes | Not Null | |
SupplierID | Integer | Yes | Foreign Key | ||
CategoryID | Integer | Yes | Foreign Key | ||
Unit | Text | 25 | |||
Price | Decimal | >= 0 |
Data[edit | edit source]
ProductID | ProductName | SupplierID | CategoryID | Unit | Price |
---|---|---|---|---|---|
1 | Chais | 1 | 1 | 10 boxes x 20 bags | 18.00 |
2 | Chang | 1 | 1 | 24 - 12 oz bottles | 19.00 |
3 | Aniseed Syrup | 1 | 2 | 12 - 550 ml bottles | 10.00 |
4 | Chef Anton's Cajun Seasoning | 2 | 2 | 48 - 6 oz jars | 22.00 |
5 | Chef Anton's Gumbo Mix | 2 | 2 | 36 boxes | 21.35 |
6 | Grandma's Boysenberry Spread | 3 | 2 | 12 - 8 oz jars | 25.00 |
7 | Uncle Bob's Organic Dried Pears | 3 | 7 | 12 - 1 lb pkgs. | 30.00 |
8 | Northwoods Cranberry Sauce | 3 | 2 | 12 - 12 oz jars | 40.00 |
9 | Mishi Kobe Niku | 4 | 6 | 18 - 500 g pkgs. | 97.00 |
10 | Ikura | 4 | 8 | 12 - 200 ml jars | 31.00 |
11 | Queso Cabrales | 5 | 4 | 1 kg pkg. | 21.00 |
12 | Queso Manchego La Pastora | 5 | 4 | 10 - 500 g pkgs. | 38.00 |
13 | Konbu | 6 | 8 | 2 kg box | 6.00 |
14 | Tofu | 6 | 7 | 40 - 100 g pkgs. | 23.25 |
15 | Genen Shouyu | 6 | 2 | 24 - 250 ml bottles | 15.50 |
16 | Pavlova | 7 | 3 | 32 - 500 g boxes | 17.45 |
17 | Alice Mutton | 7 | 6 | 20 - 1 kg tins | 39.00 |
18 | Carnarvon Tigers | 7 | 8 | 16 kg pkg. | 62.50 |
19 | Teatime Chocolate Biscuits | 8 | 3 | 10 boxes x 12 pieces | 9.20 |
20 | Sir Rodney's Marmalade | 8 | 3 | 30 gift boxes | 81.00 |
21 | Sir Rodney's Scones | 8 | 3 | 24 pkgs. x 4 pieces | 10.00 |
22 | Gustaf's Knäckebröd | 9 | 5 | 24 - 500 g pkgs. | 21.00 |
23 | Tunnbröd | 9 | 5 | 12 - 250 g pkgs. | 9.00 |
24 | Guaraná Fantástica | 10 | 1 | 12 - 355 ml cans | 4.50 |
25 | NuNuCa Nuß-Nougat-Creme | 11 | 3 | 20 - 450 g glasses | 14.00 |
26 | Gumbär Gummibärchen | 11 | 3 | 100 - 250 g bags | 31.23 |
27 | Schoggi Schokolade | 11 | 3 | 100 - 100 g pieces | 43.90 |
28 | Rössle Sauerkraut | 12 | 7 | 25 - 825 g cans | 45.60 |
29 | Thüringer Rostbratwurst | 12 | 6 | 50 bags x 30 sausgs. | 123.79 |
30 | Nord-Ost Matjeshering | 13 | 8 | 10 - 200 g glasses | 25.89 |
31 | Gorgonzola Telino | 14 | 4 | 12 - 100 g pkgs | 12.50 |
32 | Mascarpone Fabioli | 14 | 4 | 24 - 200 g pkgs. | 32.00 |
33 | Geitost | 15 | 4 | 500 g | 2.50 |
34 | Sasquatch Ale | 16 | 1 | 24 - 12 oz bottles | 14.00 |
35 | Steeleye Stout | 16 | 1 | 24 - 12 oz bottles | 18.00 |
36 | Inlagd Sill | 17 | 8 | 24 - 250 g jars | 19.00 |
37 | Gravad lax | 17 | 8 | 12 - 500 g pkgs. | 26.00 |
38 | Côte de Blaye | 18 | 1 | 12 - 75 cl bottles | 263.50 |
39 | Chartreuse verte | 18 | 1 | 750 cc per bottle | 18.00 |
40 | Boston Crab Meat | 19 | 8 | 24 - 4 oz tins | 18.40 |
41 | Jack's New England Clam Chowder | 19 | 8 | 12 - 12 oz cans | 9.65 |
42 | Singaporean Hokkien Fried Mee | 20 | 5 | 32 - 1 kg pkgs. | 14.00 |
43 | Ipoh Coffee | 20 | 1 | 16 - 500 g tins | 46.00 |
44 | Gula Malacca | 20 | 2 | 20 - 2 kg bags | 19.45 |
45 | Røgede sild | 21 | 8 | 1k pkg. | 9.50 |
46 | Spegesild | 21 | 8 | 4 - 450 g glasses | 12.00 |
47 | Zaanse koeken | 22 | 3 | 10 - 4 oz boxes | 9.50 |
48 | Chocolade | 22 | 3 | 10 pkgs. | 12.75 |
49 | Maxilaku | 23 | 3 | 24 - 50 g pkgs. | 20.00 |
50 | Valkoinen suklaa | 23 | 3 | 12 - 100 g bars | 16.25 |
51 | Manjimup Dried Apples | 24 | 7 | 50 - 300 g pkgs. | 53.00 |
52 | Filo Mix | 24 | 5 | 16 - 2 kg boxes | 7.00 |
53 | Perth Pasties | 24 | 6 | 48 pieces | 32.80 |
54 | Tourtière | 25 | 6 | 16 pies | 7.45 |
55 | Pâté chinois | 25 | 6 | 24 boxes x 2 pies | 24.00 |
56 | Gnocchi di nonna Alice | 26 | 5 | 24 - 250 g pkgs. | 38.00 |
57 | Ravioli Angelo | 26 | 5 | 24 - 250 g pkgs. | 19.50 |
58 | Escargots de Bourgogne | 27 | 8 | 24 pieces | 13.25 |
59 | Raclette Courdavault | 28 | 4 | 5 kg pkg. | 55.00 |
60 | Camembert Pierrot | 28 | 4 | 15 - 300 g rounds | 34.00 |
61 | Sirop d'érable | 29 | 2 | 24 - 500 ml bottles | 28.50 |
62 | Tarte au sucre | 29 | 3 | 48 pies | 49.30 |
63 | Vegie-spread | 7 | 2 | 15 - 625 g jars | 43.90 |
64 | Wimmers gute Semmelknödel | 12 | 5 | 20 bags x 4 pieces | 33.25 |
65 | Louisiana Fiery Hot Pepper Sauce | 2 | 2 | 32 - 8 oz bottles | 21.05 |
66 | Louisiana Hot Spiced Okra | 2 | 2 | 24 - 8 oz jars | 17.00 |
67 | Laughing Lumberjack Lager | 16 | 1 | 24 - 12 oz bottles | 14.00 |
68 | Scottish Longbreads | 8 | 3 | 10 boxes x 8 pieces | 12.50 |
69 | Gudbrandsdalsost | 15 | 4 | 10 kg pkg. | 36.00 |
70 | Outback Lager | 7 | 1 | 24 - 355 ml bottles | 15.00 |
71 | Fløtemysost | 15 | 4 | 10 - 500 g pkgs. | 21.50 |
72 | Mozzarella di Giovanni | 14 | 4 | 24 - 200 g pkgs. | 34.80 |
73 | Röd Kaviar | 17 | 8 | 24 - 150 g jars | 15.00 |
74 | Longlife Tofu | 4 | 7 | 5 kg pkg. | 10.00 |
75 | Rhönbräu Klosterbier | 12 | 1 | 24 - 0.5 l bottles | 7.75 |
76 | Lakkalikööri | 23 | 1 | 500 ml | 18.00 |
77 | Original Frankfurter grüne Soße | 12 | 2 | 12 boxes | 13.00 |