Jump to content

Database Examples/Northwind/Products

From Wikiversity

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
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