Test1
Tables (5)
comment_likes
- user_id — BIGINT — Primary key — NOT NULL
- comment_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(3) — NOT NULL
comments
- id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — NOT NULL
- author_id — BIGINT — NOT NULL
- parent_comment_id — BIGINT
- content — TEXT — NOT NULL
- status — ENUM('PUBLISHED','HIDDEN','DELETED') — NOT NULL
- like_count — INT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
post_likes
- user_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(3) — NOT NULL
posts
- id — BIGINT — Primary key — NOT NULL
- author_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — MEDIUMTEXT — NOT NULL
- status — ENUM('PUBLISHED','DRAFT','HIDDEN','DELETED') — NOT NULL
- like_count — INT — NOT NULL
- comment_count — INT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
users
- id — BIGINT — Primary key — 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)