fix kakao1
Tables (5)
comment_likes
- id — BIGINT
- user_id — BIGINT — NOT NULL
- comment_id — BIGINT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
comments
- id — BIGINT
- post_id — BIGINT — NOT NULL
- author_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
post_likes
- id — BIGINT
- user_id — BIGINT — NOT NULL
- post_id — BIGINT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
posts
- id — BIGINT
- author_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — MEDIUMTEXT — NOT NULL
- image — VARCHAR(255)
- like_count — BIGINT — NOT NULL
- view_count — BIGINT — NOT NULL
- comment_count — BIGINT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
users
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_image — VARCHAR(255)
- 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)