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)