This is an implementation of an ebay-like site written for a uni class
CREATE DATABASE ebay_ted; use ebay_ted. . script_path
[{"name":"bed bath and beyond","items":[{"id":1,"currently":15,"buyPrice":25,"firstBid":10,"numberOfBids":4,"country":"France","started":1441005239000,"ends":1441005241000,"description":"Super comfy pillow","bids":[],"categories":["bed bath and beyond",{"name":"comfy","items":[1]}],"location":null,"name":"pillow"}]},{"name":"chewable","items":[{"id":4,"currently":2,"buyPrice":1,"firstBid":1,"numberOfBids":2,"country":"Taiwan","started":1441021146000,"ends":1441021148000,"description":"chew","bids":[],"categories":["chewable"],"location":null,"name":"gum"}]},"comfy",{"name":"drinks","items":[{"id":2,"currently":10,"buyPrice":20,"firstBid":4,"numberOfBids":2,"country":"Greece","started":1441005274000,"ends":1441005276000,"description":"Extreme bug spray","bids":[],"categories":["drinks",{"name":"weapon","items":[2,{"id":5,"currently":100,"buyPrice":200,"firstBid":50,"numberOfBids":10,"country":"Japan","started":1441021175000,"ends":1441021177000,"description":"ninja","bids":[],"categories":["weapon"],"location":null,"name":"katana"}]}],"location":{"itemId":2,"name":"My House","longitude":12.4,"latitude":566.21,"item":2},"name":"bug spray"}]},{"name":"nerdy","items":[{"id":3,"currently":1000,"buyPrice":2000,"firstBid":100,"numberOfBids":80,"country":"Japan","started":1441021099000,"ends":1441021101000,"description":"Super rare anime dvd","bids":[],"categories":["nerdy"],"location":null,"name":"attack on titan season 2"}]},"weapon"]