4设计电子商务数据模型

数据库garden

products

{"_id":"4c4b1476238d3b4dd50003981","slug":"wheelbarrow-9092","sku":"9092","name":"Extra Large Wheelbarrow","description":"Heavy duty wheelbarrow...","details":{"weight":47,"weight_units":"lbs","manufacturer":"Acme","color":"Green"},"total_reviews":4,"average_review":4.5,"pricing":{"retail":589700,"sale":489700},"price_history":[{"retail":529700,"sale":429700},{"retail":529700,"sale":529700}],"primary_category":"6a5b1476238d3b4dd5000048","main_cat_id":"6a5b1476238d3b4dd5000048","category_ids":["6a5b1476238d3b4dd5000048","6a5b1476238d3b4dd5000049"],"tags":["tools","gardening","soil"]}

db.products.createIndex({slug:1});

categories

{"_id":"6a5b1476238d3b4dd5000048","slug":"gardening-tools","name":"Gardening Tools","description":"Gradening gadgets galore!","parent_id":"55804822812cb336b78728f9","ancestors":[{"name":"Home","_id":"558048f0812cb336b78728fa","slug":"home"},{"name":"Outdoors","_id":"55804822812cb336b78728f9","slug":"outdoors"}]}

orders

{"_id":"6a5b1476238d3b4dd5000048","user_id":"4c4b1476238d3b4dd5000001","state":"CART","line_items":[{"_id":"4c4b1476238d3b4dd50003981","sku":"9092","name":"Extra Large Wheelbarrow","quantity":1,"pricing":{"retail":5897,"sale":4897}},{"_id":"4c4b1476238d3b4dd50003982","sku":"10027","name":"Rubberized Work Glove,Black","quantity":2,"pricing":{"retail":1499,"sale":1299}}],"shipping_address":{"street":"588 5th Street","city":"Brooklyn","state":"NY","zip":11215},"sub_total":6196}

users

{"_id":"4c4b1476238d3b4dd5000001","username":"kbanker","email":"kylebanker@gmail.com","first_name":"Kyle","last_name":"Banker","hashed_password":"bd1cfa194c3a603e7186780824b04419","addresses":[{"name":"home","street":"588 5th Street","city":"Brooklyn","state":"NY","zip":11215},{"name":"work","street":"1 E.23rd Street","city":"New York","state":"NY","zip":10010}],"payment_methods":[{"name":"VISA","payment_token":"43fba1dfda6b8106dc7"}]}

reviews

{"_id":"4c4b1476238d3b4dd5000041","product_id":"4c4b1476238d3b4dd50003981","title":"Amazing","text":"Has a squeaky wheel, but still a darn good wheelbarrow.","rating":4,"user_id":"4c4b1476238d3b4dd5000042","username":"dgreenthumb","helpful_votes":3,"voter_ids":["4c4b1476238d3b4dd5000033","7a4f0376238d3b4dd5000003","92c21476238d3b4dd5000032"]}

来自为知笔记(Wiz)