Databases > Northwind > Tables > Order Details

Northwind

Order Details

Created: Modified:

Columns

  • OrderID
    [int] NOT NULL
  • ProductID
    [int] NOT NULL
  • UnitPrice
    [money] NOT NULL DEFAULT ((0))
    //
    CONSTRAINT
    ([UnitPrice]>=(0))
  • Quantity
    [smallint] NOT NULL DEFAULT ((1))
    //
    CONSTRAINT
    ([Quantity]>(0))
  • Discount
    [real] NOT NULL DEFAULT ((0))
    //
    CONSTRAINT
    ([Discount]>=(0) AND [Discount]<=(1))

Indexes

  • PK_Order_Details
    UNIQUE CLUSTERED
    OrderID , ProductID
  • OrderID
    NONCLUSTERED
    OrderID
  • OrdersOrder_Details
    NONCLUSTERED
    OrderID
  • ProductID
    NONCLUSTERED
    ProductID
  • ProductsOrder_Details
    NONCLUSTERED
    ProductID

Foreign Keys

  • FK_Order_Details_Orders
    Orders
    OrderID ⥱ OrderID
  • FK_Order_Details_Products
    Products
    ProductID ⥱ ProductID

Sample Data

OrderID
ProductID
UnitPrice
Quantity
Discount
10248
11
14
12
NULL
10248
42
9.8
10
NULL
10248
72
34.8
5
NULL
10249
14
18.6
9
NULL
10249
51
42.4
40
NULL
10250
41
7.7
10
NULL
10250
51
42.4
35
0.15000000596046448
10250
65
16.8
15
0.15000000596046448
10251
22
16.8
6
0.05000000074505806
10251
57
15.6
15
0.05000000074505806
10251
65
16.8
20
NULL
10252
20
64.8
40
0.05000000074505806
10252
33
2
25
0.05000000074505806
10252
60
27.2
40
NULL
10253
31
10
20
NULL
10253
39
14.4
42
NULL
10253
49
16
40
NULL
10254
24
3.6
15
0.15000000596046448
10254
55
19.2
21
0.15000000596046448
10254
74
8
21
NULL
10255
2
15.2
20
NULL
10255
16
13.9
35
NULL
10255
36
15.2
25
NULL
10255
59
44
30
NULL
10256
53
26.2
15
NULL