API tools faq
paste
Advertisement
FrostScapallion

Transport.js

FrostScapallion
Nov 14th, 2020
616
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 61.49 KB | None | 0 0
raw download clone embed print report
  1.  
  2. db.transport.insert ( {"TRUCK": { "registration":"GFT008", "capacity":"40000", "weight":"15000", "status":"AVAILABLE"} }
  3. );
  4.  
  5. db.transport.insert ( {"TRUCK": { "registration":"KKK007", "capacity":"10000", "weight":"3000", "status":"MAINTAINED"} }
  6. );
  7.  
  8. db.transport.insert ( {"TRUCK": { "registration":"LUCY01", "capacity":"100", "weight":"300", "status":"AVAILABLE"} } );
  9. db.transport.insert ( {"TRUCK": { "registration":"LUCY02", "capacity":"43000", "weight":"3000", "status":"AVAILABLE"} }
  10. );
  11.  
  12. db.transport.insert ( {"TRUCK": { "registration":"PKR008", "capacity":"22000", "weight":"8800", "status":"AVAILABLE"} }
  13. );
  14.  
  15. db.transport.insert ( {"TRUCK": { "registration":"PKR768", "capacity":"1234", "weight":"3000", "status":"AVAILABLE"} } )
  16. ;
  17.  
  18. db.transport.insert ( {"TRUCK": { "registration":"QRT834", "capacity":"5550", "weight":"400", "status":"USED"} } );
  19. db.transport.insert ( {"TRUCK": { "registration":"SST005", "capacity":"12000", "weight":"50000", "status":"USED"} } );
  20. db.transport.insert ( {"TRUCK": { "registration":"SYF777", "capacity":"3333", "weight":"4566", "status":"MAINTAINED"} }
  21. );
  22.  
  23. db.transport.insert ( {"TRUCK": { "registration":"XCF003", "capacity":"30000", "weight":"10000", "status":"AVAILABLE"} }
  24. );
  25.  
  26.  
  27. db.transport.insert ( {"EMPLOYEE": { "e#":"1", "name":"John Smith", "dob":"", "address":"42 Victoria St. Hurstville, NSW 2456", "hiredate":"12-JAN-99","position":"driver","licence":"10001","status":"AVAILABLE","trips":[{ "trip number":"1", "registration":"PKR768", "trip date":"12-JAN-95", "legs":["Sydney","Melbourne","Adelaide","Sydney"] },{ "trip number":"3", "registration":"KKK007", "trip date":"12-MAR-95", "legs":["Sydney","Melbourne","Adelaide","Sydney"] },{ "trip number":"8", "registration":"PKR768", "trip date":"30-JUN-95", "legs":["Sydney","Newcastle","Brisbane","Rockhampton"] },{ "trip number":"18", "registration":"KKK007", "trip date":"16-DEC-97", "legs":["Melbourne","Sydney","Adelaide","Sydney"] },{ "trip number":"21", "registration":"QRT834", "trip date":"23-APR-97", "legs":["Wollongong","Sydney","Adelaide","Sydney"] },{ "trip number":"25", "registration":"PKR768", "trip date":"12-JAN-97", "legs":["Melbourne","Sydney","Perth","Sydney","Brisbane"] },{ "trip number":"26", "registration":"SYF777", "trip date":"20-FEB-97", "legs":["Brisbane","Sydney","Perth","Sydney"] },{ "trip number":"29", "registration":"QRT834", "trip date":"17-SEP-97", "legs":["Sydney","Melbourne","Perth","Sydney"] },{ "trip number":"35", "registration":"PKR768", "trip date":"24-MAY-98", "legs":["Sydney","Melbourne","Adelaide","Perth","Sydney"] },{ "trip number":"37", "registration":"PKR768", "trip date":"12-JAN-98", "legs":["Sydney","Melbourne","Hobart","Perth","Adelaide","Wollongong"] },{ "trip number":"39", "registration":"KKK007", "trip date":"12-MAR-98", "legs":["Sydney","Newcastle","Brisbane","Rockhampton"] },{ "trip number":"44", "registration":"PKR768", "trip date":"29-JUN-99", "legs":["Melbourne","Sydney","Perth","Sydney","Brisbane"] },{ "trip number":"54", "registration":"KKK007", "trip date":"15-DEC-00", "legs":[] },{ "trip number":"57", "registration":"QRT834", "trip date":"23-APR-00", "legs":["Sydney","Melbourne","Adelaide","Perth","Sydney"] },{ "trip number":"61", "registration":"PKR768", "trip date":"12-JAN-01", "legs":["Sydney","Melbourne","Adelaide","Perth","Sydney"] },{ "trip number":"62", "registration":"SYF777", "trip date":"20-FEB-01", "legs":["Sydney","Newcastle","Brisbane","Rockhampton"] },{ "trip number":"65", "registration":"QRT834", "trip date":"17-SEP-01", "legs":["Sydney","Melbourne","Adelaide","Perth","Sydney"] },{ "trip number":"71", "registration":"PKR768", "trip date":"05-JUL-02", "legs":["Sydney","Melbourne","Hobart","Perth","Adelaide","Wollongong"] },{ "trip number":"73", "registration":"PKR768", "trip date":"07-JUL-02", "legs":["Sydney","Newcastle","Brisbane","Rockhampton"] },{ "trip number":"75", "registration":"KKK007", "trip date":"09-JUL-02", "legs":["Sydney","Melbourne","Hobart","Perth","Adelaide","Wollongong"] },{ "trip number":"80", "registration":"PKR768", "trip date":"14-JUL-02", "legs":["Sydney","Melbourne","Hobart","Perth","Adelaide","Wollongong"] },{ "trip number":"90", "registration":"KKK007", "trip date":"24-JUL-02", "legs":["Sydney","Melbourne","Adelaide","Perth","Sydney"] },{ "trip number":"93", "registration":"QRT834", "trip date":"27-JUL-02", "legs":["Sydney","Melbourne","Hobart","Perth","Adelaide","Wollongong"] },{ "trip number":"97", "registration":"PKR768", "trip date":"02-AUG-02", "legs":["Sydney","Melbourne","Hobart","Perth","Adelaide","Wollongong"] },{ "trip number":"98", "registration":"SYF777", "trip date":"05-AUG-02", "legs":["Sydney","Melbourne","Adelaide","Perth","Sydney"] },{ "trip number":"101", "registration":"QRT834", "trip date":"07-AUG-02", "legs":["Melbourne","Sydney","Perth","Sydney","Brisbane"] },{ "trip number":"107", "registration":"PKR768", "trip date":"25-AUG-02", "legs":["Melbourne","Sydney","Perth","Melbourne"] }]} } );
  28. db.transport.insert ( {"EMPLOYEE": { "e#":"2", "name":"Peter Taylor", "dob":"12-JAN-60", "address":"42 Victoria St. Hurstville, NSW 2456", "hiredate":"12-JAN-99","position":"mechanic","licence":"10345","status":"AVAILABLE","experience":"EXPERT","maintenances":[{"registration":"QRT834","time":"40","maintenance date":"14-JUN-99"},{"registration":"QRT834","time":"40","maintenance date":"16-JUN-96"},{"registration":"SYF777","time":"200","maintenance date":"04-AUG-96"},{"registration":"PKR768","time":"200","maintenance date":"30-JUL-00"},{"registration":"PKR768","time":"600","maintenance date":"24-AUG-01"},{"registration":"SST005","time":"250","maintenance date":"30-SEP-01"},{"registration":"PKR768","time":"20","maintenance date":"30-JUL-02"},{"registration":"PKR768","time":"600","maintenance date":"24-AUG-02"},{"registration":"SST005","time":"850","maintenance date":"30-AUG-02"}]} } );
  29. db.transport.insert ( {"EMPLOYEE": { "e#":"3", "name":"John Doe", "dob":"23-MAR-56", "address":"12 Station St. Dapto, NSW 2530", "hiredate":"12-JAN-89","position":"driver","licence":"10002","status":"AVAILABLE","trips":[{ "trip number":"2", "registration":"SYF777", "trip date":"20-FEB-95", "legs":["Sydney","Melbourne","Adelaide","Sydney"] },{ "trip number":"9", "registration":"QRT834", "trip date":"17-SEP-95", "legs":["Sydney","Melbourne"] },{ "trip number":"12", "registration":"PKR768", "trip date":"12-MAR-96", "legs":["Melbourne","Sydney","Melbourne"] },{ "trip number":"30", "registration":"KKK007", "trip date":"15-DEC-97", "legs":["Melbourne","Sydney","Melbourne"] },{ "trip number":"38", "registration":"SYF777", "trip date":"20-FEB-98", "legs":["Sydney","Melbourne","Adelaide","Perth","Sydney"] },{ "trip number":"45", "registration":"QRT834", "trip date":"17-SEP-99", "legs":["Sydney","Melbourne","Hobart","Perth","Adelaide","Wollongong"] },{ "trip number":"48", "registration":"PKR768", "trip date":"12-MAR-99", "legs":["Melbourne","Sydney","Perth","Sydney","Brisbane"] },{ "trip number":"66", "registration":"KKK007", "trip date":"15-JUL-01", "legs":["Sydney","Newcastle","Brisbane","Rockhampton"] },{ "trip number":"74", "registration":"SYF777", "trip date":"08-JUL-02", "legs":["Melbourne","Sydney","Perth","Sydney","Brisbane"] },{ "trip number":"81", "registration":"QRT834", "trip date":"15-JUL-02", "legs":["Sydney","Melbourne","Adelaide","Perth","Sydney"] },{ "trip number":"84", "registration":"PKR768", "trip date":"18-JUL-02", "legs":[] },{ "trip number":"102", "registration":"KKK007", "trip date":"11-AUG-02", "legs":["Sydney","Melbourne","Perth","Melbourne"] }]} } );
  30. db.transport.insert ( {"EMPLOYEE": { "e#":"4", "name":"John Gray", "dob":"05-MAY-78", "address":"16 Station St. Dapto, NSW 2530", "hiredate":"12-JAN-97","position":"mechanic","licence":"10452","status":"AVAILABLE","experience":"STANDARD","maintenances":[{"registration":"QRT834","time":"50","maintenance date":"25-JUN-01"},{"registration":"PKR008","time":"300","maintenance date":"27-MAR-01"},{"registration":"QRT834","time":"50","maintenance date":"25-AUG-02"},{"registration":"PKR008","time":"50","maintenance date":"27-JUN-02"}]} } );
  31. db.transport.insert ( {"EMPLOYEE": { "e#":"5", "name":"Adam Taylor", "dob":"01-JAN-70", "address":"42 Church St. City, NSW 2300", "hiredate":"12-JAN-91","position":"driver","licence":"10003","status":"ON LEAVE","trips":[{ "trip number":"4", "registration":"PKR768", "trip date":"29-JUN-95", "legs":["Sydney","Melbourne","Adelaide","Sydney"] },{ "trip number":"11", "registration":"SST005", "trip date":"23-JAN-96", "legs":["Melbourne","Sydney"] },{ "trip number":"20", "registration":"PKR768", "trip date":"12-MAR-97", "legs":["Sydney","Melbourne","Adelaide","Sydney"] },{ "trip number":"23", "registration":"PKR768", "trip date":"25-MAY-97", "legs":["Wollongong","Sydney","Adelaide","Sydney"] },{ "trip number":"31", "registration":"SST005", "trip date":"23-JAN-98", "legs":["Sydney","Melbourne","Perth","Sydney"] },{ "trip number":"36", "registration":"SST005", "trip date":"02-AUG-98", "legs":["Sydney","Melbourne"] },{ "trip number":"40", "registration":"PKR768", "trip date":"29-JUN-98", "legs":["Sydney","Melbourne","Hobart","Perth","Adelaide","Wollongong"] },{ "trip number":"47", "registration":"SST005", "trip date":"23-JAN-99", "legs":["Sydney","Newcastle","Brisbane","Rockhampton"] },{ "trip number":"56", "registration":"PKR768", "trip date":"12-MAR-00", "legs":["Sydney","Melbourne","Hobart","Perth","Adelaide","Wollongong"] },{ "trip number":"59", "registration":"PKR768", "trip date":"25-MAY-00", "legs":["Melbourne","Sydney","Perth","Sydney","Brisbane"] },{ "trip number":"67", "registration":"SST005", "trip date":"01-JUL-01", "legs":["Melbourne","Sydney","Perth","Sydney","Brisbane"] },{ "trip number":"72", "registration":"SST005", "trip date":"06-JUL-02", "legs":["Sydney","Melbourne","Adelaide","Perth","Sydney","Wollongong","Canberra","Perth","Adelaide"] },{ "trip number":"76", "registration":"PKR768", "trip date":"10-JUL-02", "legs":["Sydney","Melbourne","Adelaide","Perth","Sydney"] },{ "trip number":"83", "registration":"SST005", "trip date":"17-JUL-02", "legs":["Melbourne","Sydney","Perth","Sydney","Brisbane"] },{ "trip number":"92", "registration":"PKR768", "trip date":"26-JUL-02", "legs":["Melbourne","Sydney","Perth","Sydney","Brisbane"] },{ "trip number":"95", "registration":"PKR768", "trip date":"29-JUL-02", "legs":["Sydney","Newcastle","Brisbane","Rockhampton"] },{ "trip number":"103", "registration":"SST005", "trip date":"14-AUG-02", "legs":["Sydney","Melbourne","Perth","Melbourne"] },{ "trip number":"108", "registration":"SST005", "trip date":"31-AUG-02", "legs":["Melbourne","Sydney","Perth","Melbourne"] }]} } );
  32. db.transport.insert ( {"EMPLOYEE": { "e#":"6", "name":"Michael Jones", "dob":"05-OCT-65", "address":"23 Waterloo Ave. Surry Hills, NSW 2502", "hiredate":"12-JAN-93","position":"mechanic","licence":"7773","status":"ON_LEAVE","experience":"STANDARD","maintenances":[{"registration":"QRT834","time":"40","maintenance date":"12-JUN-99"},{"registration":"QRT834","time":"40","maintenance date":"15-JUN-98"},{"registration":"SYF777","time":"30","maintenance date":"01-AUG-98"},{"registration":"SYF777","time":"30","maintenance date":"05-AUG-95"},{"registration":"SYF777","time":"30","maintenance date":"06-AUG-00"},{"registration":"LUCY01","time":"200","maintenance date":"12-MAR-97"},{"registration":"SYF777","time":"30","maintenance date":"02-AUG-00"},{"registration":"PKR768","time":"200","maintenance date":"12-AUG-00"},{"registration":"QRT834","time":"200","maintenance date":"30-JUN-00"},{"registration":"SYF777","time":"300","maintenance date":"02-AUG-02"},{"registration":"PKR768","time":"460","maintenance date":"12-AUG-02"},{"registration":"LUCY01","time":"40","maintenance date":"29-JUL-02"},{"registration":"QRT834","time":"40","maintenance date":"30-JUN-02"}]} } );
  33. db.transport.insert ( {"EMPLOYEE": { "e#":"7", "name":"Frederic Jones", "dob":"28-FEB-73", "address":"23 Victoria St. Redfern, NSW 2420", "hiredate":"12-JAN-99","position":"driver","licence":"20002","status":"BUSY","trips":[{ "trip number":"5", "registration":"PKR768", "trip date":"13-JAN-95", "legs":["Melbourne","Sydney","Adelaide","Sydney"] },{ "trip number":"13", "registration":"QRT834", "trip date":"23-APR-96", "legs":["Sydney","Melbourne","Sydney"] },{ "trip number":"14", "registration":"PKR008", "trip date":"23-APR-96", "legs":["Wollongong","Sydney"] },{ "trip number":"24", "registration":"SST005", "trip date":"02-AUG-97", "legs":["Sydney","Melbourne","Adelaide","Sydney"] },{ "trip number":"27", "registration":"KKK007", "trip date":"12-MAR-97", "legs":["Sydney","Wollongong","Perth","Sydney"] },{ "trip number":"32", "registration":"PKR768", "trip date":"12-MAR-98", "legs":["Sydney","Melbourne","Perth","Sydney"] },{ "trip number":"41", "registration":"PKR768", "trip date":"12-JAN-99", "legs":["Sydney","Melbourne","Adelaide","Perth","Sydney"] },{ "trip number":"49", "registration":"QRT834", "trip date":"23-APR-99", "legs":["Sydney","Melbourne","Hobart","Perth","Adelaide","Wollongong"] },{ "trip number":"50", "registration":"PKR008", "trip date":"23-APR-99", "legs":["Sydney","Melbourne","Adelaide","Perth","Sydney"] },{ "trip number":"60", "registration":"SST005", "trip date":"02-AUG-01", "legs":["Sydney","Melbourne","Hobart","Perth","Adelaide","Wollongong"] },{ "trip number":"63", "registration":"KKK007", "trip date":"12-MAR-01", "legs":["Melbourne","Sydney","Perth","Sydney","Brisbane"] },{ "trip number":"68", "registration":"PKR768", "trip date":"02-JUL-01", "legs":["Sydney","Melbourne","Hobart","Perth","Adelaide","Wollongong"] },{ "trip number":"77", "registration":"PKR768", "trip date":"11-JUL-02", "legs":["Sydney","Newcastle","Brisbane","Rockhampton"] },{ "trip number":"85", "registration":"QRT834", "trip date":"19-JUL-02", "legs":["Sydney","Melbourne","Hobart","Perth","Adelaide","Wollongong"] },{ "trip number":"86", "registration":"PKR008", "trip date":"20-JUL-02", "legs":["Sydney","Melbourne","Adelaide","Perth","Sydney"] },{ "trip number":"96", "registration":"SST005", "trip date":"01-AUG-02", "legs":["Melbourne","Sydney","Perth","Sydney","Brisbane"] },{ "trip number":"99", "registration":"KKK007", "trip date":"04-AUG-02", "legs":["Sydney","Newcastle","Brisbane","Rockhampton"] },{ "trip number":"104", "registration":"PKR768", "trip date":"18-AUG-02", "legs":["Sydney","Melbourne","Perth","Melbourne"] }]} } );
  34. db.transport.insert ( {"EMPLOYEE": { "e#":"8", "name":"Peter O'Brien", "dob":"28-FEB-73", "address":"19 Lucas Dr. Horsley, NSW 2530", "hiredate":"12-JAN-99","position":"mechanic","licence":"23302","status":"BUSY","experience":"BEGINNER","maintenances":[{"registration":"KKK007","time":"300","maintenance date":"20-AUG-00"},{"registration":"KKK007","time":"500","maintenance date":"20-AUG-02"}]} } );
  35. db.transport.insert ( {"EMPLOYEE": { "e#":"9", "name":"John Lucas", "dob":"16-DEC-56", "address":"20 Huxley St. Horsley, NSW 2530", "hiredate":"12-JAN-96","position":"driver","licence":"30005","status":"BUSY","trips":[{ "trip number":"6", "registration":"SYF777", "trip date":"21-FEB-95", "legs":["Melbourne","Sydney","Adelaide","Sydney"] },{ "trip number":"10", "registration":"KKK007", "trip date":"15-DEC-95", "legs":["Sydney","Wollongong"] },{ "trip number":"16", "registration":"SST005", "trip date":"02-AUG-96", "legs":["Sydney","Wollongong","Adelaide","Sydney"] },{ "trip number":"17", "registration":"QRT834", "trip date":"17-SEP-96", "legs":["Sydney","Wollongong","Sydney"] },{ "trip number":"28", "registration":"PKR768", "trip date":"29-JUN-97", "legs":["Sydney","Melbourne","Perth","Sydney"] },{ "trip number":"33", "registration":"QRT834", "trip date":"23-APR-98", "legs":["Sydney","Melbourne","Perth","Sydney"] },{ "trip number":"42", "registration":"SYF777", "trip date":"20-FEB-99", "legs":["Sydney","Newcastle","Sydney","Perth"] },{ "trip number":"46", "registration":"KKK007", "trip date":"15-DEC-99", "legs":["Sydney","Melbourne","Adelaide","Perth","Sydney"] },{ "trip number":"52", "registration":"SST005", "trip date":"02-AUG-00", "legs":["Melbourne","Sydney","Perth","Sydney","Brisbane"] },{ "trip number":"53", "registration":"QRT834", "trip date":"17-SEP-00", "legs":[] },{ "trip number":"64", "registration":"PKR768", "trip date":"29-JUN-01", "legs":["Sydney","Melbourne","Hobart","Perth","Adelaide","Wollongong"] },{ "trip number":"69", "registration":"QRT834", "trip date":"03-JUL-01", "legs":["Sydney","Melbourne","Adelaide","Perth","Sydney"] },{ "trip number":"78", "registration":"SYF777", "trip date":"12-JUL-02", "legs":["Melbourne","Sydney","Perth","Sydney"] },{ "trip number":"82", "registration":"KKK007", "trip date":"16-JUL-02", "legs":["Sydney","Newcastle","Brisbane","Rockhampton"] },{ "trip number":"88", "registration":"SST005", "trip date":"22-JUL-02", "legs":["Melbourne","Sydney","Perth","Sydney","Brisbane"] },{ "trip number":"89", "registration":"QRT834", "trip date":"23-JUL-02", "legs":["Sydney","Melbourne","Hobart","Perth","Adelaide","Wollongong"] },{ "trip number":"100", "registration":"PKR768", "trip date":"06-AUG-02", "legs":[] },{ "trip number":"105", "registration":"QRT834", "trip date":"20-AUG-02", "legs":["Sydney","Melbourne","Perth","Melbourne"] }]} } );
  36. db.transport.insert ( {"EMPLOYEE": { "e#":"10", "name":"John Fox", "dob":"25-OCT-65", "address":"18 Victoria St. Hurstville, NSW 2456", "hiredate":"12-JAN-94","position":"mechanic","licence":"22205","status":"BUSY","experience":"EXPERT","maintenances":[{"registration":"LUCY01","time":"200","maintenance date":"03-JUN-94"},{"registration":"LUCY01","time":"200","maintenance date":"29-JUL-00"},{"registration":"KKK007","time":"250","maintenance date":"28-JUL-01"},{"registration":"QRT834","time":"50","maintenance date":"29-APR-01"},{"registration":"PKR768","time":"20","maintenance date":"28-MAR-01"},{"registration":"KKK007","time":"400","maintenance date":"28-JUL-02"},{"registration":"QRT834","time":"50","maintenance date":"29-JUN-02"},{"registration":"PKR768","time":"50","maintenance date":"28-AUG-02"}]} } );
  37. db.transport.insert ( {"EMPLOYEE": { "e#":"11", "name":"Adam Fox", "dob":"04-MAY-70", "address":"45 Victoria St. Hurstville, NSW 2456", "hiredate":"12-JAN-99","position":"driver","licence":"20005","status":"ON LEAVE","trips":[{ "trip number":"7", "registration":"KKK007", "trip date":"13-MAR-95", "legs":["Melbourne","Sydney","Adelaide","Sydney"] },{ "trip number":"15", "registration":"PKR768", "trip date":"24-MAY-96", "legs":["Sydney","Melbourne","Adelaide"] },{ "trip number":"19", "registration":"SST005", "trip date":"23-JAN-97", "legs":["Melbourne","Sydney","Adelaide","Sydney"] },{ "trip number":"22", "registration":"PKR008", "trip date":"23-APR-97", "legs":["Melbourne","Sydney","Adelaide","Sydney"] },{ "trip number":"34", "registration":"PKR008", "trip date":"23-APR-98", "legs":["Wollongong","Sydney","Perth","Sydney"] },{ "trip number":"43", "registration":"KKK007", "trip date":"12-MAR-99", "legs":["Newcastle","Brisbane","Rockhampton","Brisbane"] },{ "trip number":"51", "registration":"PKR768", "trip date":"24-MAY-00", "legs":["Sydney","Newcastle","Brisbane","Rockhampton"] },{ "trip number":"55", "registration":"SST005", "trip date":"23-JAN-00", "legs":[] },{ "trip number":"58", "registration":"PKR008", "trip date":"23-APR-00", "legs":["Sydney","Newcastle","Brisbane","Rockhampton"] },{ "trip number":"70", "registration":"PKR008", "trip date":"04-JUL-01", "legs":["Sydney","Newcastle","Brisbane","Rockhampton"] },{ "trip number":"79", "registration":"KKK007", "trip date":"13-JUL-02", "legs":["Sydney","Brisbane"] },{ "trip number":"87", "registration":"PKR768", "trip date":"21-JUL-02", "legs":["Sydney","Newcastle","Brisbane","Rockhampton"] },{ "trip number":"91", "registration":"SST005", "trip date":"25-JUL-02", "legs":["Sydney","Newcastle","Brisbane","Rockhampton"] },{ "trip number":"94", "registration":"PKR008", "trip date":"28-JUL-02", "legs":["Sydney","Melbourne","Adelaide","Perth","Sydney"] },{ "trip number":"106", "registration":"PKR008", "trip date":"23-AUG-02", "legs":["Melbourne","Sydney","Perth","Melbourne"] }]} } );
  38. db.transport.insert ( {"EMPLOYEE": { "e#":"12", "name":"Phillip Cox", "dob":"12-DEC-74", "address":"5 The Avenue, Rockdale, NSW 2300", "hiredate":"12-JAN-00","position":"mechanic","licence":"10005","status":"AVAILABLE","experience":"BEGINNER","maintenances":[{"registration":"SST005","time":"30","maintenance date":"27-JUL-01"},{"registration":"SST005","time":"30","maintenance date":"27-JUL-02"}]} } );
  39. db.transport.insert ( {"EMPLOYEE": { "e#":"13", "name":"Andrew K. Smith", "dob":"04-APR-59", "address":"42 Bambaramba Ave. Pennant Hills, NSW 2556", "hiredate":"12-JAN-01","position":"driver","licence":"10008","status":"ON LEAVE","trips":[]} } );
  40. db.transport.insert ( {"EMPLOYEE": { "e#":"14", "name":"Andrew R. Smith", "dob":"01-APR-83", "address":"67 King Cr. Hurstville, NSW 2456", "hiredate":"12-JAN-00","position":"mechanic","licence":"10000","status":"AVAILABLE","experience":"BEGINNER","maintenances":[]} } );
  41. db.transport.insert ( {"EMPLOYEE": { "e#":"15", "name":"Michael Potter", "dob":"01-APR-85", "address":"568 Bong Bong St. Horsley, NSW 2530", "hiredate":"12-JAN-93","position":"driver","licence":"10009","status":"ON LEAVE","trips":[]} } );
  42.  
  43.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!