Jump to content
Database Examples/Northwind/OrderDetails
| Field Name
|
Field Type
|
Length
|
Index
|
Constraint
|
Default
|
| OrderDetailID
|
Integer
|
|
Primary Key
|
Not Null
|
|
| OrderID
|
Integer
|
|
Yes
|
Foreign Key
|
|
| ProductID
|
Integer
|
|
Yes
|
Foreign Key
|
|
| Quantity
|
Integer
|
|
|
> 0
|
|
| OrderDetailID
|
OrderID
|
ProductID
|
Quantity
|
| 1
|
10248
|
11
|
12
|
| 2
|
10248
|
42
|
10
|
| 3
|
10248
|
72
|
5
|
| 4
|
10249
|
14
|
9
|
| 5
|
10249
|
51
|
40
|
| 6
|
10250
|
41
|
10
|
| 7
|
10250
|
51
|
35
|
| 8
|
10250
|
65
|
15
|
| 9
|
10251
|
22
|
6
|
| 10
|
10251
|
57
|
15
|
| 11
|
10251
|
65
|
20
|
| 12
|
10252
|
20
|
40
|
| 13
|
10252
|
33
|
25
|
| 14
|
10252
|
60
|
40
|
| 15
|
10253
|
31
|
20
|
| 16
|
10253
|
39
|
42
|
| 17
|
10253
|
49
|
40
|
| 18
|
10254
|
24
|
15
|
| 19
|
10254
|
55
|
21
|
| 20
|
10254
|
74
|
21
|
| 21
|
10255
|
2
|
20
|
| 22
|
10255
|
16
|
35
|
| 23
|
10255
|
36
|
25
|
| 24
|
10255
|
59
|
30
|
| 25
|
10256
|
53
|
15
|
| 26
|
10256
|
77
|
12
|
| 27
|
10257
|
27
|
25
|
| 28
|
10257
|
39
|
6
|
| 29
|
10257
|
77
|
15
|
| 30
|
10258
|
2
|
50
|
| 31
|
10258
|
5
|
65
|
| 32
|
10258
|
32
|
6
|
| 33
|
10259
|
21
|
10
|
| 34
|
10259
|
37
|
1
|
| 35
|
10260
|
41
|
16
|
| 36
|
10260
|
57
|
50
|
| 37
|
10260
|
62
|
15
|
| 38
|
10260
|
70
|
21
|
| 39
|
10261
|
21
|
20
|
| 40
|
10261
|
35
|
20
|
| 41
|
10262
|
5
|
12
|
| 42
|
10262
|
7
|
15
|
| 43
|
10262
|
56
|
2
|
| 44
|
10263
|
16
|
60
|
| 45
|
10263
|
24
|
28
|
| 46
|
10263
|
30
|
60
|
| 47
|
10263
|
74
|
36
|
| 48
|
10264
|
2
|
35
|
| 49
|
10264
|
41
|
25
|
| 50
|
10265
|
17
|
30
|
| 51
|
10265
|
70
|
20
|
| 52
|
10266
|
12
|
12
|
| 53
|
10267
|
40
|
50
|
| 54
|
10267
|
59
|
70
|
| 55
|
10267
|
76
|
15
|
| 56
|
10268
|
29
|
10
|
| 57
|
10268
|
72
|
4
|
| 58
|
10269
|
33
|
60
|
| 59
|
10269
|
72
|
20
|
| 60
|
10270
|
36
|
30
|
| 61
|
10270
|
43
|
25
|
| 62
|
10271
|
33
|
24
|
| 63
|
10272
|
20
|
6
|
| 64
|
10272
|
31
|
40
|
| 65
|
10272
|
72
|
24
|
| 66
|
10273
|
10
|
24
|
| 67
|
10273
|
31
|
15
|
| 68
|
10273
|
33
|
20
|
| 69
|
10273
|
40
|
60
|
| 70
|
10273
|
76
|
33
|
| 71
|
10274
|
71
|
20
|
| 72
|
10274
|
72
|
7
|
| 73
|
10275
|
24
|
12
|
| 74
|
10275
|
59
|
6
|
| 75
|
10276
|
10
|
15
|
| 76
|
10276
|
13
|
10
|
| 77
|
10277
|
28
|
20
|
| 78
|
10277
|
62
|
12
|
| 79
|
10278
|
44
|
16
|
| 80
|
10278
|
59
|
15
|
| 81
|
10278
|
63
|
8
|
| 82
|
10278
|
73
|
25
|
| 83
|
10279
|
17
|
15
|
| 84
|
10280
|
24
|
12
|
| 85
|
10280
|
55
|
20
|
| 86
|
10280
|
75
|
30
|
| 87
|
10281
|
19
|
1
|
| 88
|
10281
|
24
|
6
|
| 89
|
10281
|
35
|
4
|
| 90
|
10282
|
30
|
6
|
| 91
|
10282
|
57
|
2
|
| 92
|
10283
|
15
|
20
|
| 93
|
10283
|
19
|
18
|
| 94
|
10283
|
60
|
35
|
| 95
|
10283
|
72
|
3
|
| 96
|
10284
|
27
|
15
|
| 97
|
10284
|
44
|
21
|
| 98
|
10284
|
60
|
20
|
| 99
|
10284
|
67
|
5
|
| 100
|
10285
|
1
|
45
|
| 101
|
10285
|
40
|
40
|
| 102
|
10285
|
53
|
36
|
| 103
|
10286
|
35
|
100
|
| 104
|
10286
|
62
|
40
|
| 105
|
10287
|
16
|
40
|
| 106
|
10287
|
34
|
20
|
| 107
|
10287
|
46
|
15
|
| 108
|
10288
|
54
|
10
|
| 109
|
10288
|
68
|
3
|
| 110
|
10289
|
3
|
30
|
| 111
|
10289
|
64
|
9
|
| 112
|
10290
|
5
|
20
|
| 113
|
10290
|
29
|
15
|
| 114
|
10290
|
49
|
15
|
| 115
|
10290
|
77
|
10
|
| 116
|
10291
|
13
|
20
|
| 117
|
10291
|
44
|
24
|
| 118
|
10291
|
51
|
2
|
| 119
|
10292
|
20
|
20
|
| 120
|
10293
|
18
|
12
|
| 121
|
10293
|
24
|
10
|
| 122
|
10293
|
63
|
5
|
| 123
|
10293
|
75
|
6
|
| 124
|
10294
|
1
|
18
|
| 125
|
10294
|
17
|
15
|
| 126
|
10294
|
43
|
15
|
| 127
|
10294
|
60
|
21
|
| 128
|
10294
|
75
|
6
|
| 129
|
10295
|
56
|
4
|
| 130
|
10296
|
11
|
12
|
| 131
|
10296
|
16
|
30
|
| 132
|
10296
|
69
|
15
|
| 133
|
10297
|
39
|
60
|
| 134
|
10297
|
72
|
20
|
| 135
|
10298
|
2
|
40
|
| 136
|
10298
|
36
|
40
|
| 137
|
10298
|
59
|
30
|
| 138
|
10298
|
62
|
15
|
| 139
|
10299
|
19
|
15
|
| 140
|
10299
|
70
|
20
|
| 141
|
10300
|
66
|
30
|
| 142
|
10300
|
68
|
20
|
| 143
|
10301
|
40
|
10
|
| 144
|
10301
|
56
|
20
|
| 145
|
10302
|
17
|
40
|
| 146
|
10302
|
28
|
28
|
| 147
|
10302
|
43
|
12
|
| 148
|
10303
|
40
|
40
|
| 149
|
10303
|
65
|
30
|
| 150
|
10303
|
68
|
15
|
| 151
|
10304
|
49
|
30
|
| 152
|
10304
|
59
|
10
|
| 153
|
10304
|
71
|
2
|
| 154
|
10305
|
18
|
25
|
| 155
|
10305
|
29
|
25
|
| 156
|
10305
|
39
|
30
|
| 157
|
10306
|
30
|
10
|
| 158
|
10306
|
53
|
10
|
| 159
|
10306
|
54
|
5
|
| 160
|
10307
|
62
|
10
|
| 161
|
10307
|
68
|
3
|
| 162
|
10308
|
69
|
1
|
| 163
|
10308
|
70
|
5
|
| 164
|
10309
|
4
|
20
|
| 165
|
10309
|
6
|
30
|
| 166
|
10309
|
42
|
2
|
| 167
|
10309
|
43
|
20
|
| 168
|
10309
|
71
|
3
|
| 169
|
10310
|
16
|
10
|
| 170
|
10310
|
62
|
5
|
| 171
|
10311
|
42
|
6
|
| 172
|
10311
|
69
|
7
|
| 173
|
10312
|
28
|
4
|
| 174
|
10312
|
43
|
24
|
| 175
|
10312
|
53
|
20
|
| 176
|
10312
|
75
|
10
|
| 177
|
10313
|
36
|
12
|
| 178
|
10314
|
32
|
40
|
| 179
|
10314
|
58
|
30
|
| 180
|
10314
|
62
|
25
|
| 181
|
10315
|
34
|
14
|
| 182
|
10315
|
70
|
30
|
| 183
|
10316
|
41
|
10
|
| 184
|
10316
|
62
|
70
|
| 185
|
10317
|
1
|
20
|
| 186
|
10318
|
41
|
20
|
| 187
|
10318
|
76
|
6
|
| 188
|
10319
|
17
|
8
|
| 189
|
10319
|
28
|
14
|
| 190
|
10319
|
76
|
30
|
| 191
|
10320
|
71
|
30
|
| 192
|
10321
|
35
|
10
|
| 193
|
10322
|
52
|
20
|
| 194
|
10323
|
15
|
5
|
| 195
|
10323
|
25
|
4
|
| 196
|
10323
|
39
|
4
|
| 197
|
10324
|
16
|
21
|
| 198
|
10324
|
35
|
70
|
| 199
|
10324
|
46
|
30
|
| 200
|
10324
|
59
|
40
|
| 201
|
10324
|
63
|
80
|
| 202
|
10325
|
6
|
6
|
| 203
|
10325
|
13
|
12
|
| 204
|
10325
|
14
|
9
|
| 205
|
10325
|
31
|
4
|
| 206
|
10325
|
72
|
40
|
| 207
|
10326
|
4
|
24
|
| 208
|
10326
|
57
|
16
|
| 209
|
10326
|
75
|
50
|
| 210
|
10327
|
2
|
25
|
| 211
|
10327
|
11
|
50
|
| 212
|
10327
|
30
|
35
|
| 213
|
10327
|
58
|
30
|
| 214
|
10328
|
59
|
9
|
| 215
|
10328
|
65
|
40
|
| 216
|
10328
|
68
|
10
|
| 217
|
10329
|
19
|
10
|
| 218
|
10329
|
30
|
8
|
| 219
|
10329
|
38
|
20
|
| 220
|
10329
|
56
|
12
|
| 221
|
10330
|
26
|
50
|
| 222
|
10330
|
72
|
25
|
| 223
|
10331
|
54
|
15
|
| 224
|
10332
|
18
|
40
|
| 225
|
10332
|
42
|
10
|
| 226
|
10332
|
47
|
16
|
| 227
|
10333
|
14
|
10
|
| 228
|
10333
|
21
|
10
|
| 229
|
10333
|
71
|
40
|
| 230
|
10334
|
52
|
8
|
| 231
|
10334
|
68
|
10
|
| 232
|
10335
|
2
|
7
|
| 233
|
10335
|
31
|
25
|
| 234
|
10335
|
32
|
6
|
| 235
|
10335
|
51
|
48
|
| 236
|
10336
|
4
|
18
|
| 237
|
10337
|
23
|
40
|
| 238
|
10337
|
26
|
24
|
| 239
|
10337
|
36
|
20
|
| 240
|
10337
|
37
|
28
|
| 241
|
10337
|
72
|
25
|
| 242
|
10338
|
17
|
20
|
| 243
|
10338
|
30
|
15
|
| 244
|
10339
|
4
|
10
|
| 245
|
10339
|
17
|
70
|
| 246
|
10339
|
62
|
28
|
| 247
|
10340
|
18
|
20
|
| 248
|
10340
|
41
|
12
|
| 249
|
10340
|
43
|
40
|
| 250
|
10341
|
33
|
8
|
| 251
|
10341
|
59
|
9
|
| 252
|
10342
|
2
|
24
|
| 253
|
10342
|
31
|
56
|
| 254
|
10342
|
36
|
40
|
| 255
|
10342
|
55
|
40
|
| 256
|
10343
|
64
|
50
|
| 257
|
10343
|
68
|
4
|
| 258
|
10343
|
76
|
15
|
| 259
|
10344
|
4
|
35
|
| 260
|
10344
|
8
|
70
|
| 261
|
10345
|
8
|
70
|
| 262
|
10345
|
19
|
80
|
| 263
|
10345
|
42
|
9
|
| 264
|
10346
|
17
|
36
|
| 265
|
10346
|
56
|
20
|
| 266
|
10347
|
25
|
10
|
| 267
|
10347
|
39
|
50
|
| 268
|
10347
|
40
|
4
|
| 269
|
10347
|
75
|
6
|
| 270
|
10348
|
1
|
15
|
| 271
|
10348
|
23
|
25
|
| 272
|
10349
|
54
|
24
|
| 273
|
10350
|
50
|
15
|
| 274
|
10350
|
69
|
18
|
| 275
|
10351
|
38
|
20
|
| 276
|
10351
|
41
|
13
|
| 277
|
10351
|
44
|
77
|
| 278
|
10351
|
65
|
10
|
| 279
|
10352
|
24
|
10
|
| 280
|
10352
|
54
|
20
|
| 281
|
10353
|
11
|
12
|
| 282
|
10353
|
38
|
50
|
| 283
|
10354
|
1
|
12
|
| 284
|
10354
|
29
|
4
|
| 285
|
10355
|
24
|
25
|
| 286
|
10355
|
57
|
25
|
| 287
|
10356
|
31
|
30
|
| 288
|
10356
|
55
|
12
|
| 289
|
10356
|
69
|
20
|
| 290
|
10357
|
10
|
30
|
| 291
|
10357
|
26
|
16
|
| 292
|
10357
|
60
|
8
|
| 293
|
10358
|
24
|
10
|
| 294
|
10358
|
34
|
10
|
| 295
|
10358
|
36
|
20
|
| 296
|
10359
|
16
|
56
|
| 297
|
10359
|
31
|
70
|
| 298
|
10359
|
60
|
80
|
| 299
|
10360
|
28
|
30
|
| 300
|
10360
|
29
|
35
|
| 301
|
10360
|
38
|
10
|
| 302
|
10360
|
49
|
35
|
| 303
|
10360
|
54
|
28
|
| 304
|
10361
|
39
|
54
|
| 305
|
10361
|
60
|
55
|
| 306
|
10362
|
25
|
50
|
| 307
|
10362
|
51
|
20
|
| 308
|
10362
|
54
|
24
|
| 309
|
10363
|
31
|
20
|
| 310
|
10363
|
75
|
12
|
| 311
|
10363
|
76
|
12
|
| 312
|
10364
|
69
|
30
|
| 313
|
10364
|
71
|
5
|
| 314
|
10365
|
11
|
24
|
| 315
|
10366
|
65
|
5
|
| 316
|
10366
|
77
|
5
|
| 317
|
10367
|
34
|
36
|
| 318
|
10367
|
54
|
18
|
| 319
|
10367
|
65
|
15
|
| 320
|
10367
|
77
|
7
|
| 321
|
10368
|
21
|
5
|
| 322
|
10368
|
28
|
13
|
| 323
|
10368
|
57
|
25
|
| 324
|
10368
|
64
|
35
|
| 325
|
10369
|
29
|
20
|
| 326
|
10369
|
56
|
18
|
| 327
|
10370
|
1
|
15
|
| 328
|
10370
|
64
|
30
|
| 329
|
10370
|
74
|
20
|
| 330
|
10371
|
36
|
6
|
| 331
|
10372
|
20
|
12
|
| 332
|
10372
|
38
|
40
|
| 333
|
10372
|
60
|
70
|
| 334
|
10372
|
72
|
42
|
| 335
|
10373
|
58
|
80
|
| 336
|
10373
|
71
|
50
|
| 337
|
10374
|
31
|
30
|
| 338
|
10374
|
58
|
15
|
| 339
|
10375
|
14
|
15
|
| 340
|
10375
|
54
|
10
|
| 341
|
10376
|
31
|
42
|
| 342
|
10377
|
28
|
20
|
| 343
|
10377
|
39
|
20
|
| 344
|
10378
|
71
|
6
|
| 345
|
10379
|
41
|
8
|
| 346
|
10379
|
63
|
16
|
| 347
|
10379
|
65
|
20
|
| 348
|
10380
|
30
|
18
|
| 349
|
10380
|
53
|
20
|
| 350
|
10380
|
60
|
6
|
| 351
|
10380
|
70
|
30
|
| 352
|
10381
|
74
|
14
|
| 353
|
10382
|
5
|
32
|
| 354
|
10382
|
18
|
9
|
| 355
|
10382
|
29
|
14
|
| 356
|
10382
|
33
|
60
|
| 357
|
10382
|
74
|
50
|
| 358
|
10383
|
13
|
20
|
| 359
|
10383
|
50
|
15
|
| 360
|
10383
|
56
|
20
|
| 361
|
10384
|
20
|
28
|
| 362
|
10384
|
60
|
15
|
| 363
|
10385
|
7
|
10
|
| 364
|
10385
|
60
|
20
|
| 365
|
10385
|
68
|
8
|
| 366
|
10386
|
24
|
15
|
| 367
|
10386
|
34
|
10
|
| 368
|
10387
|
24
|
15
|
| 369
|
10387
|
28
|
6
|
| 370
|
10387
|
59
|
12
|
| 371
|
10387
|
71
|
15
|
| 372
|
10388
|
45
|
15
|
| 373
|
10388
|
52
|
20
|
| 374
|
10388
|
53
|
40
|
| 375
|
10389
|
10
|
16
|
| 376
|
10389
|
55
|
15
|
| 377
|
10389
|
62
|
20
|
| 378
|
10389
|
70
|
30
|
| 379
|
10390
|
31
|
60
|
| 380
|
10390
|
35
|
40
|
| 381
|
10390
|
46
|
45
|
| 382
|
10390
|
72
|
24
|
| 383
|
10391
|
13
|
18
|
| 384
|
10392
|
69
|
50
|
| 385
|
10393
|
2
|
25
|
| 386
|
10393
|
14
|
42
|
| 387
|
10393
|
25
|
7
|
| 388
|
10393
|
26
|
70
|
| 389
|
10393
|
31
|
32
|
| 390
|
10394
|
13
|
10
|
| 391
|
10394
|
62
|
10
|
| 392
|
10395
|
46
|
28
|
| 393
|
10395
|
53
|
70
|
| 394
|
10395
|
69
|
8
|
| 395
|
10396
|
23
|
40
|
| 396
|
10396
|
71
|
60
|
| 397
|
10396
|
72
|
21
|
| 398
|
10397
|
21
|
10
|
| 399
|
10397
|
51
|
18
|
| 400
|
10398
|
35
|
30
|
| 401
|
10398
|
55
|
120
|
| 402
|
10399
|
68
|
60
|
| 403
|
10399
|
71
|
30
|
| 404
|
10399
|
76
|
35
|
| 405
|
10399
|
77
|
14
|
| 406
|
10400
|
29
|
21
|
| 407
|
10400
|
35
|
35
|
| 408
|
10400
|
49
|
30
|
| 409
|
10401
|
30
|
18
|
| 410
|
10401
|
56
|
70
|
| 411
|
10401
|
65
|
20
|
| 412
|
10401
|
71
|
60
|
| 413
|
10402
|
23
|
60
|
| 414
|
10402
|
63
|
65
|
| 415
|
10403
|
16
|
21
|
| 416
|
10403
|
48
|
70
|
| 417
|
10404
|
26
|
30
|
| 418
|
10404
|
42
|
40
|
| 419
|
10404
|
49
|
30
|
| 420
|
10405
|
3
|
50
|
| 421
|
10406
|
1
|
10
|
| 422
|
10406
|
21
|
30
|
| 423
|
10406
|
28
|
42
|
| 424
|
10406
|
36
|
5
|
| 425
|
10406
|
40
|
2
|
| 426
|
10407
|
11
|
30
|
| 427
|
10407
|
69
|
15
|
| 428
|
10407
|
71
|
15
|
| 429
|
10408
|
37
|
10
|
| 430
|
10408
|
54
|
6
|
| 431
|
10408
|
62
|
35
|
| 432
|
10409
|
14
|
12
|
| 433
|
10409
|
21
|
12
|
| 434
|
10410
|
33
|
49
|
| 435
|
10410
|
59
|
16
|
| 436
|
10411
|
41
|
25
|
| 437
|
10411
|
44
|
40
|
| 438
|
10411
|
59
|
9
|
| 439
|
10412
|
14
|
20
|
| 440
|
10413
|
1
|
24
|
| 441
|
10413
|
62
|
40
|
| 442
|
10413
|
76
|
14
|
| 443
|
10414
|
19
|
18
|
| 444
|
10414
|
33
|
50
|
| 445
|
10415
|
17
|
2
|
| 446
|
10415
|
33
|
20
|
| 447
|
10416
|
19
|
20
|
| 448
|
10416
|
53
|
10
|
| 449
|
10416
|
57
|
20
|
| 450
|
10417
|
38
|
50
|
| 451
|
10417
|
46
|
2
|
| 452
|
10417
|
68
|
36
|
| 453
|
10417
|
77
|
35
|
| 454
|
10418
|
2
|
60
|
| 455
|
10418
|
47
|
55
|
| 456
|
10418
|
61
|
16
|
| 457
|
10418
|
74
|
15
|
| 458
|
10419
|
60
|
60
|
| 459
|
10419
|
69
|
20
|
| 460
|
10420
|
9
|
20
|
| 461
|
10420
|
13
|
2
|
| 462
|
10420
|
70
|
8
|
| 463
|
10420
|
73
|
20
|
| 464
|
10421
|
19
|
4
|
| 465
|
10421
|
26
|
30
|
| 466
|
10421
|
53
|
15
|
| 467
|
10421
|
77
|
10
|
| 468
|
10422
|
26
|
2
|
| 469
|
10423
|
31
|
14
|
| 470
|
10423
|
59
|
20
|
| 471
|
10424
|
35
|
60
|
| 472
|
10424
|
38
|
49
|
| 473
|
10424
|
68
|
30
|
| 474
|
10425
|
55
|
10
|
| 475
|
10425
|
76
|
20
|
| 476
|
10426
|
56
|
5
|
| 477
|
10426
|
64
|
7
|
| 478
|
10427
|
14
|
35
|
| 479
|
10428
|
46
|
20
|
| 480
|
10429
|
50
|
40
|
| 481
|
10429
|
63
|
35
|
| 482
|
10430
|
17
|
45
|
| 483
|
10430
|
21
|
50
|
| 484
|
10430
|
56
|
30
|
| 485
|
10430
|
59
|
70
|
| 486
|
10431
|
17
|
50
|
| 487
|
10431
|
40
|
50
|
| 488
|
10431
|
47
|
30
|
| 489
|
10432
|
26
|
10
|
| 490
|
10432
|
54
|
40
|
| 491
|
10433
|
56
|
28
|
| 492
|
10434
|
11
|
6
|
| 493
|
10434
|
76
|
18
|
| 494
|
10435
|
2
|
10
|
| 495
|
10435
|
22
|
12
|
| 496
|
10435
|
72
|
10
|
| 497
|
10436
|
46
|
5
|
| 498
|
10436
|
56
|
40
|
| 499
|
10436
|
64
|
30
|
| 500
|
10436
|
75
|
24
|
| 501
|
10437
|
53
|
15
|
| 502
|
10438
|
19
|
15
|
| 503
|
10438
|
34
|
20
|
| 504
|
10438
|
57
|
15
|
| 505
|
10439
|
12
|
15
|
| 506
|
10439
|
16
|
16
|
| 507
|
10439
|
64
|
6
|
| 508
|
10439
|
74
|
30
|
| 509
|
10440
|
2
|
45
|
| 510
|
10440
|
16
|
49
|
| 511
|
10440
|
29
|
24
|
| 512
|
10440
|
61
|
90
|
| 513
|
10441
|
27
|
50
|
| 514
|
10442
|
11
|
30
|
| 515
|
10442
|
54
|
80
|
| 516
|
10442
|
66
|
60
|
| 517
|
10443
|
11
|
6
|
| 518
|
10443
|
28
|
12
|
