ㅅㄷㄴㅅ
테이블 (7)
users (사용자)
- user_id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(320) — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- profile_image_url — TEXT
- bio — VARCHAR(200)
- toss_verified — BOOLEAN — NOT NULL
- role — ENUM('USER','ADMIN','MODERATOR') — NOT NULL
- status — ENUM('ACTIVE','SUSPENDED','DELETED') — NOT NULL
- last_login_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
게시글 (posts)
- post_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- board_id — INT — 외래 키 → 기업.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — LONGTEXT — NOT NULL
- type — ENUM('GENERAL','QUESTION','POLL','NOTICE') — NOT NULL
- status — ENUM('DRAFT','PUBLISHED','HIDDEN','DELETED') — NOT NULL
- is_pinned — BOOLEAN — NOT NULL
- is_anonymous — BOOLEAN — NOT NULL
- view_count — INT — NOT NULL
- like_count — INT — NOT NULL
- comment_count — INT — NOT NULL
- bookmark_count — INT — NOT NULL
- published_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
게시글 이미지 (post_images)
- image_id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — 외래 키 → 게시글.post_id — NOT NULL
- url — TEXT — NOT NULL
- width — INT
- height — INT
- size_bytes — INT
- sort_order — INT — NOT NULL
게시글 좋아요 (post_likes)
- like_id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — 외래 키 → 게시글.post_id — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
기업 (company)
- id (company_id) — INT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- description — TEXT
- icon_url — TEXT
- is_active — BOOLEAN — NOT NULL
댓글 (comments)
- comment_id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — 외래 키 → 게시글.post_id — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- parent_comment_id — BIGINT — 외래 키 → 댓글.comment_id — 대댓글 (최대 2depth)
- content — TEXT — NOT NULL
- is_anonymous — BOOLEAN — NOT NULL
- like_count — INT — NOT NULL
- depth — TINYINT — NOT NULL — 0: 댓글, 1: 대댓글
- status — ENUM('VISIBLE', 'HIDDEN', 'DELETED') — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
댓글 좋아요 (comment_likes)
- like_id — BIGINT — 기본 키 — NOT NULL
- comment_id — BIGINT — 외래 키 → 댓글.comment_id — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL