test2

Tables (3)

board

  • 게시판id (boardId) — int — Primary key — NOT NULL — 게시판id
  • title — varchar(100)
  • content — text
  • memberId — char(100) — NOT NULL

buy

  • Key — int — Primary key — NOT NULL
  • memberId2 — char(100) — Foreign key → member.memberId — NOT NULL
  • productName — varchar(100)
  • price — int

member

  • memberId — char(100) — Primary key — NOT NULL
  • pw — char(10)
  • name — varchar(100) — NOT NULL — 회원이름
  • tel — varchar(100)