테스트

테이블 (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