BOARD

Tables (3)

BOARD (게시판)

  • 게시글아이디 (boardId) — INTEGER — Primary key — NOT NULL
  • 작성자 (boardWriter) — INTEGER — Foreign key → MEMBERS.회원아이디 — NOT NULL
  • 제목 (boardTitle) — VARCHAR(100)
  • 내용 (boardContent) — VARCHAR(255)

COMMENT (댓글)

  • 댓글아이디 (commentId) — SERIAL — Primary key — NOT NULL
  • 회원아이디 (commentWriter) — INTEGER — Foreign key → MEMBERS.회원아이디 — NOT NULL
  • 게시글아이디 (boardId) — INTEGER — Foreign key → BOARD.게시글아이디 — NOT NULL
  • 내용 (commentContent) — varchar(100)

MEMBERS (회원)

  • 회원아이디 (memberId) — serial — Primary key — NOT NULL
  • 아이디 (id) — VARCHAR(50)
  • 비밀번호 (password) — VARCHAR(255)
  • 이름 (memberName) — VARCHAR(40)
  • 나이 (memberAge) — TIMESTAMP
  • 주소 (memberAddress) — varchar(255)