Shop

Tables (8)

cart (Untitled)

  • cart_id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → member.member_id — NOT NULL

cart_item (Untitled3)

  • cart_item_id (Key) — Primary key — NOT NULL
  • cart_id (Key2) — Foreign key → cart.cart_id — NOT NULL
  • count (Field)
  • item_id (Key3) — Foreign key → item.item_id — NOT NULL

item (Untitled4)

  • item_id (Key) — Primary key — NOT NULL
  • itemNm (Field)
  • price (Field2)
  • stockNumber (Field3)
  • itemDetail (Field4)
  • itemSellStatus (Field5)

item_img (Untitled8)

  • item_img_id (Key) — Primary key — NOT NULL
  • imgName (Field)
  • oriImgName (Field2)
  • imgUrl (Field3)
  • repimgYn (Field4)
  • item_id (Key2) — Foreign key → item.item_id — NOT NULL

member (Untitled2)

  • member_id (Key) — Primary key — NOT NULL
  • name (Field)
  • email (Field2)
  • password (Field3)
  • address (Field4)
  • role (Field5)

member_item (Untitled7)

  • member_item_id (Key) — Primary key — NOT NULL
  • Field
  • member_id (Key2) — Foreign key → member.member_id — NOT NULL
  • item_id (Key3) — Foreign key → item.item_id — NOT NULL

order_item (Untitled6)

  • order_item_id (Key) — Primary key — NOT NULL
  • orderPrice (Field)
  • count (Field2)
  • order_id (Key2) — Foreign key → orders.order_id — NOT NULL
  • item_id (Key3) — Foreign key → item.item_id — NOT NULL

orders (Untitled5)

  • order_id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → member.member_id — NOT NULL
  • order_date (Field)
  • order_status (Field2)