1
테이블 (5)
공급자
- License (Supplier_License) — varchar — 기본 키 — NOT NULL
- Addr (Supplier_Addr) — varchar
- Item (Supplier_Item) — varchar
구매이력
- Date (Purchased_Date) — datetime — 기본 키 — NOT NULL
- Payment (Purchased_Payment) — varchar
- Price (Purchased_price) — float
만족도
- Number (Review_Number) — int — 기본 키 — NOT NULL
- Individual (Review_Individual) — float(1,1)
- Average (Review_Average) — float(1,2)
- Content (Review_Content) — varchar
상품
- Code (Product_Code) — varchar — 기본 키 — NOT NULL
- Grade (Product_Grade) — varchar
- Price (Product_Price) — int
- Quantity — int
- Name (Product_Name) — varchar
- Point (Product_Point) — float
- Unit (Product_Unit) — varchar
장바구니
- Name (Product_Name) — varchar — 기본 키 — NOT NULL
- Grade (Product_Grade) — varchar
- Price (Product_Price) — int
- Quantity — int
- Name (Supplier_Name) — varchar