테스트
테이블 (10)
Untitled (ENP)
- Key (사원번호) — 기본 키 — NOT NULL
- Field (사원명)
- Field (담당업무)
- Field2 (입사일자)
- Field3 (급여)
- Field (보너스)
Untitled (부서)
- Key (부서번호) — 기본 키 — NOT NULL
- Field (부서명)
- Field (부서위치)
attachments
- attach_id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — 외래 키 → posts.post_id — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- attach_type — ENUM('image','background','file') — NOT NULL
- file_url — VARCHAR(500) — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- file_size — INT
- mime_type — VARCHAR(100)
- created_at — DATETIME — NOT NULL
boards
- board_id — INT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- slug — VARCHAR(100) — NOT NULL
- description — TEXT
- is_active — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
comment_votes
- vote_id — BIGINT — 기본 키 — NOT NULL
- comment_id — BIGINT — 외래 키 → comments.comment_id — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- vote_type — ENUM('like','dislike') — NOT NULL
- created_at — DATETIME — NOT NULL
comments
- comment_id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — 외래 키 → posts.post_id — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- parent_comment_id — BIGINT — 외래 키 → comments.comment_id — 대댓글이면 부모 comment_id
- content — TEXT — NOT NULL
- like_count — INT — NOT NULL
- dislike_count — INT — NOT NULL
- is_deleted — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
post_layouts
- layout_id — BIGINT — 기본 키 — NOT NULL
- post_id — BIGINT — 외래 키 → posts.post_id — NOT NULL
- bg_type — ENUM('color', 'image', 'gradient') — NOT NULL
- bg_value — VARCHAR(500) — 색상 코드 또는 이미지 URL
- text_color — VARCHAR(7)
- font_family — VARCHAR(100)
- font_size — SMALLINT
- custom_css — TEXT
- layout_data — JSON — 블록 레이아웃 JSON
- updated_at — DATETIME — NOT NULL
posts
- post_id — BIGINT — 기본 키 — NOT NULL
- board_id — INT — 외래 키 → boards.board_id — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — LONGTEXT — NOT NULL
- view_count — INT — NOT NULL
- is_deleted — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user_sessions
- session_id — VARCHAR(128) — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- ip_address — VARCHAR(45)
- user_agent — VARCHAR(500)
- expires_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
users
- user_id — BIGINT — 기본 키 — NOT NULL
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- avatar_url — VARCHAR(500)
- role — ENUM('admin','member','guest') — NOT NULL
- is_active — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL