MyBoard
Tables (3)
COMMENT
- 댓글ID (comment_id) — BIGINT — Primary key — NOT NULL
- 유저ID (writer_id) — BIGINT — Foreign key → MEMBER.유저ID — NOT NULL
- 생성시간 (created_date) — TIMESTAMP — NOT NULL
- 최종수정날짜 (last_modified_date) — TIMESTAMP — NOT NULL
- content — CLOB — NOT NULL
- is_removed — TINYINT — NOT NULL
- post_id — BIGINT — NOT NULL
- 댓글ID (parent_id) — BIGINT — Foreign key → COMMENT.댓글ID — NOT NULL
MEMBER (Member)
- 유저ID (member_id) — BIGINT — Primary key — NOT NULL
- 생성시간 (created_date) — TIMESTAMP — NOT NULL
- 최종수정날짜 (last_modified_date) — TIMESTAMP — NOT NULL
- 나이 (Field) — INT — NOT NULL
- 이름 (Field2) — VARCHAR(30) — NOT NULL
- 닉네임 (nick_name) — VARCHAR(30) — NOT NULL
- 아이디 (username) — VARCHAR(30) — NOT NULL
- 비밀번호 (password) — VARCHAR(255) — NOT NULL
- 권한 (role) — VARCHAR(15) — NOT NULL
- 리프레쉬토큰 (refresh_token) — VARCHAR(1000) — NOT NULL
POST
- 게시물ID (post_id) — BIGINT — Primary key — NOT NULL
- 유저ID (writer_id) — BIGINT — Foreign key → MEMBER.유저ID — NOT NULL
- 생성시간 (created_date) — TIMESTAMP — NOT NULL
- 최종수정날짜 (last_modified_date) — TIMESTAMP — NOT NULL
- content — CLOB — NOT NULL
- file_path — VARCHAR(255)
- title — VARCHAR(40) — NOT NULL