뼈다구

테이블 (3)

CART (CART1)

  • cart_id — varchar(20) — 기본 키 — NOT NULL
  • member_id (Key) — varchar(20) — 외래 키 → members.member_id — NOT NULL — members
  • product_id — varchar(20) — 외래 키 → product.product_id — NOT NULL
  • Field
  • Field2

members (members1)

  • member_id (Key) — varchar(20) — 기본 키 — NOT NULL — members
  • email — varchar(50)
  • password — varchar(20)
  • name — varchar(15)
  • phone — varchar(15)

product (product1)

  • product_id — varchar(20) — 기본 키 — NOT NULL
  • product_name — varchar(50)
  • price — varchar(50)
  • product_cnt — varchar(15)
  • category — varchar(20)
  • create_date
  • update_date