test

Tables (3)

CART (Untitled2)

  • cart_id — varchar(20) — Primary key — NOT NULL
  • member_id (Key) — varchar(20) — Foreign key → members.member_id — NOT NULL
  • product_id — Foreign key → product.product_id — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

members (Untitled)

  • member_id (Key) — varchar(20) — Primary key — NOT NULL
  • email — varchar(20)
  • password — varchar(20)
  • name — varchar(15)
  • phone — varchar(15)

product

  • product_id — Primary key — NOT NULL
  • product_name
  • price
  • product_cnt
  • category
  • Field
  • create_date
  • update_date