CRUD
Tables (4)
BOARD
- 게시물아이디 (board_id) — NOT NULL — Primary key — NOT NULL
- 내용 (content) — NOT NULL
- 생성일자 (creatAt) — NOT NULL
- 수정일자 (modifiedAt) — NOT NULL
- 멤버아이디 (member_id) — NOT NULL — Foreign key → MEMBER.멤버아이디 — NOT NULL
COMMENT
- 댓글아이디 (comment_id) — NOT NULL — Primary key — NOT NULL
- 댓글내용 (reply) — NOT NULL
- 생성일자 (creatAt) — NOT NULL
- 수정일자 (modifiedAt) — NOT NULL
- 멤버아이디 (member_id) — NOT NULL — Foreign key → MEMBER.멤버아이디 — NOT NULL
- 게시물아이디 (board_id) — NOT NULL — Foreign key → BOARD.게시물아이디 — NOT NULL
LIKE
- 좋아요아이디 (like_id) — NOT NULL — Primary key — NOT NULL
- 멤버아이디 (member_id) — NOT NULL — Foreign key → MEMBER.멤버아이디 — NOT NULL
- 게시물아이디 (board_id) — NOT NULL — Foreign key → BOARD.게시물아이디 — NOT NULL
MEMBER
- 멤버아이디 (member_id) — NOT NULL — Primary key — NOT NULL
- 이메일 (email) — NOT NULL
- 비밀번호 (password) — NOT NULL
- 생성일자 (creatAt) — NOT NULL
- 수정일자 (modifiedAt) — NOT NULL
- 이름 (nickName) — NOT NULL