KCS - 커뮤니티 ERD

테이블 (4)

게시글 (post)

  • post_id — BIGINT — 기본 키 — NOT NULL — AUTO_INCREMENT
  • owner_id — BIGINT — 외래 키 → 회원.member_id — NOT NULL — REFERENCES member (member_id)
  • title — VARCHAR(255) — NOT NULL
  • contents — LONGTEXT — NOT NULL
  • thumbnail — VARCHAR(255)
  • is_visible — BOOLEAN
  • created_at — DATETIME(6)

댓글 (comment)

  • comment_id — BIGINT — 기본 키 — NOT NULL — AUTO_INCREMENT
  • owner_id — BIGINT — 외래 키 → 회원.member_id — NOT NULL — REFERENCES member (member_id)
  • post_id — BIGINT — 외래 키 → 게시글.post_id — NOT NULL — REFERENCES post (post_id)
  • contents — LONGTEXT — NOT NULL
  • is_visible — BOOLEAN
  • created_at — DATETIME(6)

세션 (sessions)

  • session_id — VARCHAR(128) — 기본 키 — NOT NULL
  • expires — INT(11) — NOT NULL
  • data — TEXT

회원 (member)

  • member_id — BIGINT — 기본 키 — NOT NULL — AUTO_INCREMENT
  • email — VARCHAR(255) — NOT NULL — UNIQUE
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL — UNIQUE
  • profile_image — VARCHAR(255)
  • is_active — BOOLEAN
  • created_at — DATETIME(6)