# Database Examples/Northwind/Orders
## Fields

| Field Name | Field Type | 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 | |

## Data

| 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 |