BlogAppication
테이블 (5)
게시판 (board)
- board_id — bigint — 기본 키 — NOT NULL
- created_time — datetime(6)
- last_modified_time — datetime(6)
- title — varchar(255)
- content — tinytext
- member_id (member_id2) — bigint — 외래 키 → 회원.member_id — NOT NULL
대댓글 (re_reply)
- id — bigint — 기본 키 — NOT NULL
- created_time — datetime(6)
- last_modified_time — datetime(6)
- content — varchar(255)
- member_id — bigint — 외래 키 → 회원.member_id — NOT NULL
- reply_id — bigint — 외래 키 → 댓글.reply_id — NOT NULL
댓글 (reply)
- reply_id — bigint — 기본 키 — NOT NULL
- is_deleted — bit — NOT NULL
- like_count — integer — NOT NULL
- re_reply_count — integer — NOT NULL
- created_time — datetime(6)
- last_modified_time — datetime(6)
- content — varchar(255)
- board_id — bigint — 외래 키 → 게시판.board_id — NOT NULL
- member_id — bigint — 외래 키 → 회원.member_id — NOT NULL
좋아요 로그 (reply_like_log)
- id — bigint — 기본 키 — NOT NULL
- member_id — bigint — 외래 키 → 회원.member_id — NOT NULL
- reply_id — bigint — 외래 키 → 댓글.reply_id — NOT NULL
회원 (member)
- member_id — bigint — 기본 키 — NOT NULL
- created_time — datetime(6)
- last_modified_time — datetime(6)
- account — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- role — enum