kakao1

테이블 (5)

comment_likes

  • ID (id) — BIGINT — 기본 키 — NOT NULL
  • userId (user_id) — BIGINT — 외래 키 → 회원.id — NOT NULL
  • commentId (comment_id) — BIGINT — 외래 키 → 댓글.id — NOT NULL
  • created_at — DATETIME(3) — NOT NULL

post_likes

  • ID (id) — BIGINT — 기본 키 — NOT NULL
  • userId (user_id) — BIGINT — 외래 키 → 회원.id — NOT NULL
  • postId (post_id) — BIGINT — 외래 키 → 게시글.id — NOT NULL
  • created_at — DATETIME(3) — NOT NULL

게시글 (posts)

  • id — BIGINT — 기본 키 — NOT NULL
  • userId (user_id) — BIGINT — 외래 키 → 회원.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — MEDIUMTEXT — NOT NULL
  • status — ENUM('PUBLISHED','DRAFT','HIDDEN','DELETED') — NOT NULL
  • like_count — INT — NOT NULL
  • view_count — INT — NOT NULL
  • comment_count — INT — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • deleted_at — DATETIME(3) — NOT NULL

댓글 (comments)

  • id — BIGINT — 기본 키 — NOT NULL
  • postId (post_id) — BIGINT — 외래 키 → 게시글.id — NOT NULL
  • c_comment_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • status — ENUM('PUBLISHED','HIDDEN','DELETED') — NOT NULL
  • like_count — INT — NOT NULL
  • view_count — INT — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • deleted_at — DATETIME(3) — NOT NULL

회원 (users)

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • role — ENUM('USER','ADMIN') — NOT NULL
  • status — ENUM('ACTIVE','BANNED','DELETED') — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • last_login_at — DATETIME(3)