test

Tables (3)

member (회원)

  • 아이디 (id) — bigint — Primary key — NOT NULL — auto_increment
  • 회원이름 (member_name) — varchar(255) — NOT NULL
  • 회원연령 (member_age) — varchar(3) — NOT NULL
  • Field

member_product (회원제품)

  • 아이디 (id) — bigint — Foreign key → member.아이디 — NOT NULL — auto_increment
  • 제품번호 (id2) — Foreign key → product.제품번호 — NOT NULL
  • Field
  • Field2

product (제품)

  • 제품번호 (id) — bigint — Primary key — NOT NULL
  • 제품명 (product_id) — NOT NULL
  • 제품가격 (product_price) — NOT NULL
  • Field