취업준비반 1

테이블 (4)

member (Untitled)

  • member_id (Key) — 기본 키 — NOT NULL
  • password (Field)
  • name (Field2)
  • phone (Field3)
  • address (Field4)
  • admin (Field5)

order_information (Untitled4)

  • product_id (Key3) — 외래 키 → product.product_id — NOT NULL
  • order_id (Key) — 외래 키 → order_list.order_id — NOT NULL
  • quantity (Field)

order_list (Untitled2)

  • order_id (Key) — 기본 키 — NOT NULL
  • member_id (Key2) — 외래 키 → member.member_id — NOT NULL
  • name (Field2)
  • order_date (Field3)
  • total_cost (Field4)

product (Untitled3)

  • product_id (Key) — 기본 키 — NOT NULL
  • company (Field)
  • item_name (Field2)
  • item_describe (Field3)
  • size (Field4)
  • color (Field5)
  • image (Field6)
  • price (Field7)
  • category (Field8)