미니 쇼핑몰

테이블 (7)

cart (Untitled6)

  • id (Key2) — 기본 키 — NOT NULL
  • member_id (Key) — 외래 키 → member.id — NOT NULL
  • created_by (Field)
  • reg_time (Field2)
  • modified_by (Field3)
  • update_time (Field4)

cart_item (Untitled7)

  • cart_item_id (Key) — 기본 키 — NOT NULL
  • cart_id (Key2) — 외래 키 → cart.id — NOT NULL
  • item_id (Key3) — 외래 키 → item.id — NOT NULL
  • count (Field)
  • created_by (Field2)
  • reg_time (Field3)
  • modified_by (Field4)
  • update_time (Field5)

item (Untitled4)

  • id (Key) — 기본 키 — NOT NULL
  • item_nm (Field)
  • price (Field2)
  • item_detail (Field3)
  • item_sell_status (Field4)
  • created_by (Field5)
  • reg_time (Field6)
  • modified_by (Field7)
  • update_time (Field8)

item_img (Untitled5)

  • item_img_id (Key) — 기본 키 — NOT NULL
  • item_id (Key2) — 외래 키 → item.id — NOT NULL
  • item_name (Field)
  • ori_img_name (Field2)
  • img_url (Field3)
  • rep_img_yn (Field4)
  • created_by (Field5)
  • reg_time (Field6)
  • modified_by (Field7)
  • update_time (Field8)

member (Untitled)

  • id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • email (Field2)
  • password (Field3)
  • address (Field4)
  • role (Field5)
  • created_by (Field6)
  • reg_time (Field7)
  • modified_by (Field8)
  • update_time (Field9)

order (Untitled2)

  • id (Key) — 기본 키 — NOT NULL
  • member_id (Key2) — 외래 키 → member.id — NOT NULL
  • order_date (Field)
  • order_state (Field2)
  • created_by (Field3)
  • reg_time (Field4)
  • modified_by (Field5)
  • update_time (Field6)

order_item (Untitled3)

  • id (Key2) — 기본 키 — NOT NULL
  • order_id (Key) — 외래 키 → order.id — NOT NULL
  • item_id (Key3) — 외래 키 → item.id — NOT NULL
  • order_price (Field)
  • count (Field2)
  • created_by (Field3)
  • reg_time (Field4)
  • modified_by (Field5)
  • update_time (Field6)