Database-design.md

@@ -2,7 +2,8 @@ CREATE SCHEMA `FreshOnline` ;
 
 `stocked_goods`: (id:int,  name:varchar, type: tinyint, price: decimal2, storage: decimal2, sales: decimal2, description: text(NULL), onsale: tinyint, sale_price: decimal2(NULL), rate: float(NULL), rate_count: int(DEFAULT 0), brand: varchar, category_id: int, isnew: tinyint, pic: varchar500(多值属性 NULL)) type==0:discrete,type==1:weight
 
-`category`: (id:int, name: varchar, parent_id:int)
+`category`: (id:int, name: varchar, parent_id:int, level:int) 
+//level分三级1 2 3, 默认1级level的parent_id是0
 
 `saled_goods`: (order_id, goods_id, price:decimal2, count:decimal2, comment: text(NULL), rate: int(NULL))