커뮤니티 DB
테이블 (8)
comments
- comment_id — INT — 기본 키 — NOT NULL
- comment_content — VARCHAR(600) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- comment_status — ENUM('ACTIVE', 'DELETED') — NOT NULL
- post_id (post_id2) — INT — 외래 키 → posts.post_id — NOT NULL
- user_id (user_id2) — INT — 외래 키 → users.user_id — NOT NULL
images
- image_id — INT — 기본 키 — NOT NULL
- image_url — VARCHAR(2048) — NOT NULL
- file_size — INT
- original_filename — VARCHAR(255)
- created_at — TIMESTAMP — NOT NULL
post_images
- image_id (image_id2) — INT — 외래 키 → images.image_id — NOT NULL
- post_id — INT — 외래 키 → posts.post_id — NOT NULL
- display_order — TINYINT — NOT NULL
post_likes
- like_id (lkie_id) — INT — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- user_id (user_id2) — INT — 외래 키 → users.user_id — NOT NULL
- post_id (post_id2) — INT — 외래 키 → posts.post_id — NOT NULL
post_stats
- post_id (post_id2) — INT — 외래 키 → posts.post_id — NOT NULL
- like_count — INT — NOT NULL
- comment_count — INT — NOT NULL
- view_count — INT — NOT NULL
- last_updated — TIMESTAMP — NOT NULL
posts
- post_id — INT — 기본 키 — NOT NULL
- post_title — VARCHAR(100) — NOT NULL
- post_content — LONGTEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- post_status — ENUM('ACTIVE', 'DELETED', 'DRAFT') — NOT NULL
- user_id — INT
user_tokens
- user_token_id — INT — 기본 키 — NOT NULL
- token — VARCHAR(512) — NOT NULL
- expires_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- user_agent — VARCHAR(255)
- ip_address — VARCHAR(45)
- user_id (user_id2) — INT — 외래 키 → users.user_id — NOT NULL
users
- user_id — INT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- role — ENUM('USER', 'ADMIN') — NOT NULL
- user_status — ENUM('ACTIVE', 'INACTIVE','DELETED') — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- image_id (image_id2) — INT — 외래 키 → images.image_id — NOT NULL