kakao1
테이블 (5)
comment_likes
- ID (id) — BIGINT — 기본 키 — NOT NULL
- userId (user_id) — BIGINT — 외래 키 → 회원.id — NOT NULL
- commentId (comment_id) — BIGINT — 외래 키 → 댓글.id — NOT NULL
- created_at — DATETIME(3) — NOT NULL
post_likes
- ID (id) — BIGINT — 기본 키 — NOT NULL
- userId (user_id) — BIGINT — 외래 키 → 회원.id — NOT NULL
- postId (post_id) — BIGINT — 외래 키 → 게시글.id — NOT NULL
- created_at — DATETIME(3) — NOT NULL
게시글 (posts)
- id — BIGINT — 기본 키 — NOT NULL
- userId (user_id) — BIGINT — 외래 키 → 회원.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — MEDIUMTEXT — NOT NULL
- status — ENUM('PUBLISHED','DRAFT','HIDDEN','DELETED') — NOT NULL
- like_count — INT — NOT NULL
- view_count — INT — NOT NULL
- comment_count — INT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
- deleted_at — DATETIME(3) — NOT NULL
댓글 (comments)
- id — BIGINT — 기본 키 — NOT NULL
- postId (post_id) — BIGINT — 외래 키 → 게시글.id — NOT NULL
- c_comment_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- status — ENUM('PUBLISHED','HIDDEN','DELETED') — NOT NULL
- like_count — INT — NOT NULL
- view_count — INT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
- deleted_at — DATETIME(3) — NOT NULL
회원 (users)
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- role — ENUM('USER','ADMIN') — NOT NULL
- status — ENUM('ACTIVE','BANNED','DELETED') — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
- last_login_at — DATETIME(3)