ㅅㄷㄴㅅ

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