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