게시판
테이블 (6)
Comment
- comment_id — INT UNSIGNED — 기본 키
- content — TEXT
- created_at — DATETIME
- deleted_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- user_id — INT UNSIGNED — 외래 키 → User.user_id
- post_id — INT UNSIGNED — 외래 키 → Post.post_id — NOT NULL
Image
- image_id — INT UNSIGNED — 기본 키
- is_active — BOOLEAN
- created_at — DATETIME
- storage_path — VARCHAR(500)
- thumbnail_path — VARCHAR(500) — NOT NULL
- post_id — INT UNSIGNED — 외래 키 → Post.post_id — NOT NULL
- uploaded_by — INT UNSIGNED — 외래 키 → User.user_id
- user_id — INT UNSIGNED — 외래 키 → User.user_id
Likes
- post_id — INT UNSIGNED — 외래 키 → Post.post_id
- user_id — INT UNSIGNED — 외래 키 → User.user_id
- created_at — DATETIME
Post
- post_id — INT UNSIGNED — 기본 키 — NOT NULL
- title — VARCHAR(26)
- content — TEXT
- created_at — DATETIME
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME — NOT NULL
- view_count — INT UNSIGNED — NOT NULL
- user_id — INT UNSIGNED — 외래 키 → User.user_id
Refresh Token
- refresh_token_id — INT UNSIGNED — 기본 키
- refresh_token (Field2) — VARCHAR(255)
- expires_at — DATETIME
- created_at — DATETIME
- user_id — INT UNSIGNED — 외래 키 → User.user_id
User
- user_id — INT UNSIGNED — 기본 키
- email — VARCHAR(255)
- nickname — VARCHAR(255)
- password — VARCHAR(255)
- status — VARCHAR(20)
- created_at — DATETIME
- deleted_at — DATETIME