Database Examples/Northwind/Orders

Fields edit

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

Data edit

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