Databases > Northwind > Tables > Products

Northwind

Products

Created: Modified:

Columns

  • ProductID
    [int] IDENTITY (1,1) NOT NULL
  • ProductName
    [nvarchar](40) NOT NULL
  • SupplierID
    [int] NULL
  • CategoryID
    [int] NULL
  • QuantityPerUnit
    [nvarchar](20) NULL
  • UnitPrice
    [money] NULL DEFAULT ((0))
    //
    CONSTRAINT
    ([UnitPrice]>=(0))
  • UnitsInStock
    [smallint] NULL DEFAULT ((0))
    //
    CONSTRAINT
    ([UnitsInStock]>=(0))
  • UnitsOnOrder
    [smallint] NULL DEFAULT ((0))
    //
    CONSTRAINT
    ([UnitsOnOrder]>=(0))
  • ReorderLevel
    [smallint] NULL DEFAULT ((0))
    //
    CONSTRAINT
    ([ReorderLevel]>=(0))
  • Discontinued
    [bit] NOT NULL DEFAULT ((0))

Indexes

  • PK_Products
    UNIQUE CLUSTERED
    ProductID
  • CategoriesProducts
    NONCLUSTERED
    CategoryID
  • CategoryID
    NONCLUSTERED
    CategoryID
  • ProductName
    NONCLUSTERED
    ProductName
  • SupplierID
    NONCLUSTERED
    SupplierID
  • SuppliersProducts
    NONCLUSTERED
    SupplierID

Foreign Keys

  • FK_Products_Categories
    Categories
    CategoryID ⥱ CategoryID
  • FK_Products_Suppliers
    Suppliers
    SupplierID ⥱ SupplierID

Sample Data

ProductID
ProductName
SupplierID
CategoryID
QuantityPerUnit
UnitPrice
UnitsInStock
UnitsOnOrder
ReorderLevel
Discontinued
1
Chai
1
1
10 boxes x 20 bags
18
39
NULL
10
NULL
2
Chang
1
1
24 - 12 oz bottles
19
17
40
25
NULL
3
Aniseed Syrup
1
2
12 - 550 ml bottles
10
13
70
25
NULL
4
Chef Anton's Cajun Seasoning
2
2
48 - 6 oz jars
22
53
NULL
NULL
NULL
5
Chef Anton's Gumbo Mix
2
2
36 boxes
21.35
NULL
NULL
NULL
true
6
Grandma's Boysenberry Spread
3
2
12 - 8 oz jars
25
120
NULL
25
NULL
7
Uncle Bob's Organic Dried Pears
3
7
12 - 1 lb pkgs.
30
15
NULL
10
NULL
8
Northwoods Cranberry Sauce
3
2
12 - 12 oz jars
40
6
NULL
NULL
NULL
9
Mishi Kobe Niku
4
6
18 - 500 g pkgs.
97
29
NULL
NULL
true
10
Ikura
4
8
12 - 200 ml jars
31
31
NULL
NULL
NULL
11
Queso Cabrales
5
4
1 kg pkg.
21
22
30
30
NULL
12
Queso Manchego La Pastora
5
4
10 - 500 g pkgs.
38
86
NULL
NULL
NULL
13
Konbu
6
8
2 kg box
6
24
NULL
5
NULL
14
Tofu
6
7
40 - 100 g pkgs.
23.25
35
NULL
NULL
NULL
15
Genen Shouyu
6
2
24 - 250 ml bottles
15.5
39
NULL
5
NULL
16
Pavlova
7
3
32 - 500 g boxes
17.45
29
NULL
10
NULL
17
Alice Mutton
7
6
20 - 1 kg tins
39
NULL
NULL
NULL
true
18
Carnarvon Tigers
7
8
16 kg pkg.
62.5
42
NULL
NULL
NULL
19
Teatime Chocolate Biscuits
8
3
10 boxes x 12 pieces
9.2
25
NULL
5
NULL
20
Sir Rodney's Marmalade
8
3
30 gift boxes
81
40
NULL
NULL
NULL
21
Sir Rodney's Scones
8
3
24 pkgs. x 4 pieces
10
3
40
5
NULL
22
Gustaf's Knäckebröd
9
5
24 - 500 g pkgs.
21
104
NULL
25
NULL
23
Tunnbröd
9
5
12 - 250 g pkgs.
9
61
NULL
25
NULL
24
Guaraná Fantástica
10
1
12 - 355 ml cans
4.5
20
NULL
NULL
true
25
NuNuCa Nuß-Nougat-Creme
11
3
20 - 450 g glasses
14
76
NULL
30
NULL