Board
Tables (3)
Board
- 게시판아이디 (board_id) — BIGINT — Primary key — NOT NULL
- 멤버아이디 (member_id) — BIGINT — Foreign key → Member.멤버아이디 — NOT NULL
- 제목 (title) — VERCHAR
- 내용 (content) — VERCHAR
- 해시태그 (hashtag) — VERCHAR
- 생성일 (created_date) — DATETIME
- 수정일 (modified_date) — DATETIME
Comment
- 댓글아이디 (comment_id) — BIGINT — Primary key — NOT NULL
- 멤버아이디 (member_id) — BIGINT — Foreign key → Member.멤버아이디 — NOT NULL
- 게시판아이디 (board_id) — BIGINT — Foreign key → Board.게시판아이디 — NOT NULL
- 댓글내용 (content) — VERCHAR
- 생성일 (created_date) — DATETIME
- 수정일 (modified_date) — DATETIME
Member
- 멤버아이디 (member_id) — BIGINT — Primary key — NOT NULL
- 이메일 (email) — VERCHAR
- 비밀번호 (password) — VERCHAR
- 닉네임 (nickname) — VERCHAR
- 생성일 (created_date) — DATETIME
- 수정일 (modified_date) — DATETIME