Databases > Northwind > Tables > Orders

Northwind

Orders

Created: Modified:

Columns

  • OrderID
    [int] IDENTITY (1,1) NOT NULL
  • CustomerID
    [nchar](5) NULL
  • EmployeeID
    [int] NULL
  • OrderDate
    [datetime] NULL
  • RequiredDate
    [datetime] NULL
  • ShippedDate
    [datetime] NULL
  • ShipVia
    [int] NULL
  • Freight
    [money] NULL DEFAULT ((0))
  • ShipName
    [nvarchar](40) NULL
  • ShipAddress
    [nvarchar](60) NULL
  • ShipCity
    [nvarchar](15) NULL
  • ShipRegion
    [nvarchar](15) NULL
  • ShipPostalCode
    [nvarchar](10) NULL
  • ShipCountry
    [nvarchar](15) NULL

Indexes

  • PK_Orders
    UNIQUE CLUSTERED
    OrderID
  • CustomerID
    NONCLUSTERED
    CustomerID
  • CustomersOrders
    NONCLUSTERED
    CustomerID
  • EmployeeID
    NONCLUSTERED
    EmployeeID
  • EmployeesOrders
    NONCLUSTERED
    EmployeeID
  • OrderDate
    NONCLUSTERED
    OrderDate
  • ShippedDate
    NONCLUSTERED
    ShippedDate
  • ShippersOrders
    NONCLUSTERED
    ShipVia
  • ShipPostalCode
    NONCLUSTERED
    ShipPostalCode

Foreign Keys

  • FK_Orders_Customers
    Customers
    CustomerID ⥱ CustomerID
  • FK_Orders_Employees
    Employees
    EmployeeID ⥱ EmployeeID
  • FK_Orders_Shippers
    Shippers
    ShipVia ⥱ ShipperID

Sample Data

OrderID
CustomerID
EmployeeID
OrderDate
RequiredDate
ShippedDate
ShipVia
Freight
ShipName
ShipAddress
ShipCity
ShipRegion
ShipPostalCode
ShipCountry
10248
VINET
5
3
32.38
Vins et alcools Chevalier
59 rue de l'Abbaye
Reims
NULL
51100
France
10249
TOMSP
6
1
11.61
Toms Spezialitäten
Luisenstr. 48
Münster
NULL
44087
Germany
10250
HANAR
4
2
65.83
Hanari Carnes
Rua do Paço, 67
Rio de Janeiro
RJ
05454-876
Brazil
10251
VICTE
3
1
41.34
Victuailles en stock
2, rue du Commerce
Lyon
NULL
69004
France
10252
SUPRD
4
2
51.3
Suprêmes délices
Boulevard Tirou, 255
Charleroi
NULL
B-6000
Belgium
10253
HANAR
3
2
58.17
Hanari Carnes
Rua do Paço, 67
Rio de Janeiro
RJ
05454-876
Brazil
10254
CHOPS
5
2
22.98
Chop-suey Chinese
Hauptstr. 31
Bern
NULL
3012
Switzerland
10255
RICSU
9
3
148.33
Richter Supermarkt
Starenweg 5
Genève
NULL
1204
Switzerland
10256
WELLI
3
2
13.97
Wellington Importadora
Rua do Mercado, 12
Resende
SP
08737-363
Brazil
10257
HILAA
4
3
81.91
HILARION-Abastos
Carrera 22 con Ave. Carlos Soublette #8-35
San Cristóbal
Táchira
5022
Venezuela
10258
ERNSH
1
1
140.51
Ernst Handel
Kirchgasse 6
Graz
NULL
8010
Austria
10259
CENTC
4
3
3.25
Centro comercial Moctezuma
Sierras de Granada 9993
México D.F.
NULL
05022
Mexico
10260
OTTIK
4
1
55.09
Ottilies Käseladen
Mehrheimerstr. 369
Köln
NULL
50739
Germany
10261
QUEDE
4
2
3.05
Que Delícia
Rua da Panificadora, 12
Rio de Janeiro
RJ
02389-673
Brazil
10262
RATTC
8
3
48.29
Rattlesnake Canyon Grocery
2817 Milton Dr.
Albuquerque
NM
87110
USA
10263
ERNSH
9
3
146.06
Ernst Handel
Kirchgasse 6
Graz
NULL
8010
Austria
10264
FOLKO
6
3
3.67
Folk och fä HB
Åkergatan 24
Bräcke
NULL
S-844 67
Sweden
10265
BLONP
2
1
55.28
Blondel père et fils
24, place Kléber
Strasbourg
NULL
67000
France
10266
WARTH
3
3
25.73
Wartian Herkku
Torikatu 38
Oulu
NULL
90110
Finland
10267
FRANK
4
1
208.58
Frankenversand
Berliner Platz 43
München
NULL
80805
Germany
10268
GROSR
8
3
66.29
GROSELLA-Restaurante
5ª Ave. Los Palos Grandes
Caracas
DF
1081
Venezuela
10269
WHITC
5
1
4.56
White Clover Markets
1029 - 12th Ave. S.
Seattle
WA
98124
USA
10270
WARTH
1
1
136.54
Wartian Herkku
Torikatu 38
Oulu
NULL
90110
Finland
10271
SPLIR
6
2
4.54
Split Rail Beer & Ale
P.O. Box 555
Lander
WY
82520
USA
10272
RATTC
6
2
98.03
Rattlesnake Canyon Grocery
2817 Milton Dr.
Albuquerque
NM
87110
USA