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
|