Jump to content
Database Examples/Northwind/Orders
| Field Name
|
Field Type
|
Length
|
Index
|
Constraint
|
Default
|
| OrderID
|
Integer
|
|
Primary Key
|
Not Null
|
|
| CustomerID
|
Integer
|
|
Yes
|
Foreign Key
|
|
| EmployeeID
|
Integer
|
|
Yes
|
Foreign Key
|
|
| OrderDate
|
Date
|
|
Yes
|
|
Today
|
| ShipperID
|
Integer
|
|
Yes
|
Foreign Key
|
|
| OrderID
|
CustomerID
|
EmployeeID
|
OrderDate
|
ShipperID
|
| 10248
|
90
|
5
|
1996-07-04
|
3
|
| 10249
|
81
|
6
|
1996-07-05
|
1
|
| 10250
|
34
|
4
|
1996-07-08
|
2
|
| 10251
|
84
|
3
|
1996-07-08
|
1
|
| 10252
|
76
|
4
|
1996-07-09
|
2
|
| 10253
|
34
|
3
|
1996-07-10
|
2
|
| 10254
|
14
|
5
|
1996-07-11
|
2
|
| 10255
|
68
|
9
|
1996-07-12
|
3
|
| 10256
|
88
|
3
|
1996-07-15
|
2
|
| 10257
|
35
|
4
|
1996-07-16
|
3
|
| 10258
|
20
|
1
|
1996-07-17
|
1
|
| 10259
|
13
|
4
|
1996-07-18
|
3
|
| 10260
|
55
|
4
|
1996-07-19
|
1
|
| 10261
|
61
|
4
|
1996-07-19
|
2
|
| 10262
|
65
|
8
|
1996-07-22
|
3
|
| 10263
|
20
|
9
|
1996-07-23
|
3
|
| 10264
|
24
|
6
|
1996-07-24
|
3
|
| 10265
|
7
|
2
|
1996-07-25
|
1
|
| 10266
|
87
|
3
|
1996-07-26
|
3
|
| 10267
|
25
|
4
|
1996-07-29
|
1
|
| 10268
|
33
|
8
|
1996-07-30
|
3
|
| 10269
|
89
|
5
|
1996-07-31
|
1
|
| 10270
|
87
|
1
|
1996-08-01
|
1
|
| 10271
|
75
|
6
|
1996-08-01
|
2
|
| 10272
|
65
|
6
|
1996-08-02
|
2
|
| 10273
|
63
|
3
|
1996-08-05
|
3
|
| 10274
|
85
|
6
|
1996-08-06
|
1
|
| 10275
|
49
|
1
|
1996-08-07
|
1
|
| 10276
|
80
|
8
|
1996-08-08
|
3
|
| 10277
|
52
|
2
|
1996-08-09
|
3
|
| 10278
|
5
|
8
|
1996-08-12
|
2
|
| 10279
|
44
|
8
|
1996-08-13
|
2
|
| 10280
|
5
|
2
|
1996-08-14
|
1
|
| 10281
|
69
|
4
|
1996-08-14
|
1
|
| 10282
|
69
|
4
|
1996-08-15
|
1
|
| 10283
|
46
|
3
|
1996-08-16
|
3
|
| 10284
|
44
|
4
|
1996-08-19
|
1
|
| 10285
|
63
|
1
|
1996-08-20
|
2
|
| 10286
|
63
|
8
|
1996-08-21
|
3
|
| 10287
|
67
|
8
|
1996-08-22
|
3
|
| 10288
|
66
|
4
|
1996-08-23
|
1
|
| 10289
|
11
|
7
|
1996-08-26
|
3
|
| 10290
|
15
|
8
|
1996-08-27
|
1
|
| 10291
|
61
|
6
|
1996-08-27
|
2
|
| 10292
|
81
|
1
|
1996-08-28
|
2
|
| 10293
|
80
|
1
|
1996-08-29
|
3
|
| 10294
|
65
|
4
|
1996-08-30
|
2
|
| 10295
|
85
|
2
|
1996-09-02
|
2
|
| 10296
|
46
|
6
|
1996-09-03
|
1
|
| 10297
|
7
|
5
|
1996-09-04
|
2
|
| 10298
|
37
|
6
|
1996-09-05
|
2
|
| 10299
|
67
|
4
|
1996-09-06
|
2
|
| 10300
|
49
|
2
|
1996-09-09
|
2
|
| 10301
|
86
|
8
|
1996-09-09
|
2
|
| 10302
|
76
|
4
|
1996-09-10
|
2
|
| 10303
|
30
|
7
|
1996-09-11
|
2
|
| 10304
|
80
|
1
|
1996-09-12
|
2
|
| 10305
|
55
|
8
|
1996-09-13
|
3
|
| 10306
|
69
|
1
|
1996-09-16
|
3
|
| 10307
|
48
|
2
|
1996-09-17
|
2
|
| 10308
|
2
|
7
|
1996-09-18
|
3
|
| 10309
|
37
|
3
|
1996-09-19
|
1
|
| 10310
|
77
|
8
|
1996-09-20
|
2
|
| 10311
|
18
|
1
|
1996-09-20
|
3
|
| 10312
|
86
|
2
|
1996-09-23
|
2
|
| 10313
|
63
|
2
|
1996-09-24
|
2
|
| 10314
|
65
|
1
|
1996-09-25
|
2
|
| 10315
|
38
|
4
|
1996-09-26
|
2
|
| 10316
|
65
|
1
|
1996-09-27
|
3
|
| 10317
|
48
|
6
|
1996-09-30
|
1
|
| 10318
|
38
|
8
|
1996-10-01
|
2
|
| 10319
|
80
|
7
|
1996-10-02
|
3
|
| 10320
|
87
|
5
|
1996-10-03
|
3
|
| 10321
|
38
|
3
|
1996-10-03
|
2
|
| 10322
|
58
|
7
|
1996-10-04
|
3
|
| 10323
|
39
|
4
|
1996-10-07
|
1
|
| 10324
|
71
|
9
|
1996-10-08
|
1
|
| 10325
|
39
|
1
|
1996-10-09
|
3
|
| 10326
|
8
|
4
|
1996-10-10
|
2
|
| 10327
|
24
|
2
|
1996-10-11
|
1
|
| 10328
|
28
|
4
|
1996-10-14
|
3
|
| 10329
|
75
|
4
|
1996-10-15
|
2
|
| 10330
|
46
|
3
|
1996-10-16
|
1
|
| 10331
|
9
|
9
|
1996-10-16
|
1
|
| 10332
|
51
|
3
|
1996-10-17
|
2
|
| 10333
|
87
|
5
|
1996-10-18
|
3
|
| 10334
|
84
|
8
|
1996-10-21
|
2
|
| 10335
|
37
|
7
|
1996-10-22
|
2
|
| 10336
|
60
|
7
|
1996-10-23
|
2
|
| 10337
|
25
|
4
|
1996-10-24
|
3
|
| 10338
|
55
|
4
|
1996-10-25
|
3
|
| 10339
|
51
|
2
|
1996-10-28
|
2
|
| 10340
|
9
|
1
|
1996-10-29
|
3
|
| 10341
|
73
|
7
|
1996-10-29
|
3
|
| 10342
|
25
|
4
|
1996-10-30
|
2
|
| 10343
|
44
|
4
|
1996-10-31
|
1
|
| 10344
|
89
|
4
|
1996-11-01
|
2
|
| 10345
|
63
|
2
|
1996-11-04
|
2
|
| 10346
|
65
|
3
|
1996-11-05
|
3
|
| 10347
|
21
|
4
|
1996-11-06
|
3
|
| 10348
|
86
|
4
|
1996-11-07
|
2
|
| 10349
|
75
|
7
|
1996-11-08
|
1
|
| 10350
|
41
|
6
|
1996-11-11
|
2
|
| 10351
|
20
|
1
|
1996-11-11
|
1
|
| 10352
|
28
|
3
|
1996-11-12
|
3
|
| 10353
|
59
|
7
|
1996-11-13
|
3
|
| 10354
|
58
|
8
|
1996-11-14
|
3
|
| 10355
|
4
|
6
|
1996-11-15
|
1
|
| 10356
|
86
|
6
|
1996-11-18
|
2
|
| 10357
|
46
|
1
|
1996-11-19
|
3
|
| 10358
|
41
|
5
|
1996-11-20
|
1
|
| 10359
|
72
|
5
|
1996-11-21
|
3
|
| 10360
|
7
|
4
|
1996-11-22
|
3
|
| 10361
|
63
|
1
|
1996-11-22
|
2
|
| 10362
|
9
|
3
|
1996-11-25
|
1
|
| 10363
|
17
|
4
|
1996-11-26
|
3
|
| 10364
|
19
|
1
|
1996-11-26
|
1
|
| 10365
|
3
|
3
|
1996-11-27
|
2
|
| 10366
|
29
|
8
|
1996-11-28
|
2
|
| 10367
|
83
|
7
|
1996-11-28
|
3
|
| 10368
|
20
|
2
|
1996-11-29
|
2
|
| 10369
|
75
|
8
|
1996-12-02
|
2
|
| 10370
|
14
|
6
|
1996-12-03
|
2
|
| 10371
|
41
|
1
|
1996-12-03
|
1
|
| 10372
|
62
|
5
|
1996-12-04
|
2
|
| 10373
|
37
|
4
|
1996-12-05
|
3
|
| 10374
|
91
|
1
|
1996-12-05
|
3
|
| 10375
|
36
|
3
|
1996-12-06
|
2
|
| 10376
|
51
|
1
|
1996-12-09
|
2
|
| 10377
|
72
|
1
|
1996-12-09
|
3
|
| 10378
|
24
|
5
|
1996-12-10
|
3
|
| 10379
|
61
|
2
|
1996-12-11
|
1
|
| 10380
|
37
|
8
|
1996-12-12
|
3
|
| 10381
|
46
|
3
|
1996-12-12
|
3
|
| 10382
|
20
|
4
|
1996-12-13
|
1
|
| 10383
|
4
|
8
|
1996-12-16
|
3
|
| 10384
|
5
|
3
|
1996-12-16
|
3
|
| 10385
|
75
|
1
|
1996-12-17
|
2
|
| 10386
|
21
|
9
|
1996-12-18
|
3
|
| 10387
|
70
|
1
|
1996-12-18
|
2
|
| 10388
|
72
|
2
|
1996-12-19
|
1
|
| 10389
|
10
|
4
|
1996-12-20
|
2
|
| 10390
|
20
|
6
|
1996-12-23
|
1
|
| 10391
|
17
|
3
|
1996-12-23
|
3
|
| 10392
|
59
|
2
|
1996-12-24
|
3
|
| 10393
|
71
|
1
|
1996-12-25
|
3
|
| 10394
|
36
|
1
|
1996-12-25
|
3
|
| 10395
|
35
|
6
|
1996-12-26
|
1
|
| 10396
|
25
|
1
|
1996-12-27
|
3
|
| 10397
|
60
|
5
|
1996-12-27
|
1
|
| 10398
|
71
|
2
|
1996-12-30
|
3
|
| 10399
|
83
|
8
|
1996-12-31
|
3
|
| 10400
|
19
|
1
|
1997-01-01
|
3
|
| 10401
|
65
|
1
|
1997-01-01
|
1
|
| 10402
|
20
|
8
|
1997-01-02
|
2
|
| 10403
|
20
|
4
|
1997-01-03
|
3
|
| 10404
|
49
|
2
|
1997-01-03
|
1
|
| 10405
|
47
|
1
|
1997-01-06
|
1
|
| 10406
|
62
|
7
|
1997-01-07
|
1
|
| 10407
|
56
|
2
|
1997-01-07
|
2
|
| 10408
|
23
|
8
|
1997-01-08
|
1
|
| 10409
|
54
|
3
|
1997-01-09
|
1
|
| 10410
|
10
|
3
|
1997-01-10
|
3
|
| 10411
|
10
|
9
|
1997-01-10
|
3
|
| 10412
|
87
|
8
|
1997-01-13
|
2
|
| 10413
|
41
|
3
|
1997-01-14
|
2
|
| 10414
|
21
|
2
|
1997-01-14
|
3
|
| 10415
|
36
|
3
|
1997-01-15
|
1
|
| 10416
|
87
|
8
|
1997-01-16
|
3
|
| 10417
|
73
|
4
|
1997-01-16
|
3
|
| 10418
|
63
|
4
|
1997-01-17
|
1
|
| 10419
|
68
|
4
|
1997-01-20
|
2
|
| 10420
|
88
|
3
|
1997-01-21
|
1
|
| 10421
|
61
|
8
|
1997-01-21
|
1
|
| 10422
|
27
|
2
|
1997-01-22
|
1
|
| 10423
|
31
|
6
|
1997-01-23
|
3
|
| 10424
|
51
|
7
|
1997-01-23
|
2
|
| 10425
|
41
|
6
|
1997-01-24
|
2
|
| 10426
|
29
|
4
|
1997-01-27
|
1
|
| 10427
|
59
|
4
|
1997-01-27
|
2
|
| 10428
|
66
|
7
|
1997-01-28
|
1
|
| 10429
|
37
|
3
|
1997-01-29
|
2
|
| 10430
|
20
|
4
|
1997-01-30
|
1
|
| 10431
|
10
|
4
|
1997-01-30
|
2
|
| 10432
|
75
|
3
|
1997-01-31
|
2
|
| 10433
|
60
|
3
|
1997-02-03
|
3
|
| 10434
|
24
|
3
|
1997-02-03
|
2
|
| 10435
|
16
|
8
|
1997-02-04
|
2
|
| 10436
|
7
|
3
|
1997-02-05
|
2
|
| 10437
|
87
|
8
|
1997-02-05
|
1
|
| 10438
|
79
|
3
|
1997-02-06
|
2
|
| 10439
|
51
|
6
|
1997-02-07
|
3
|
| 10440
|
71
|
4
|
1997-02-10
|
2
|
| 10441
|
55
|
3
|
1997-02-10
|
2
|
| 10442
|
20
|
3
|
1997-02-11
|
2
|
| 10443
|
66
|
8
|
1997-02-12
|
1
|
