Community ERD

Tables (5)

Comments (댓글)

  • PK (comment_id) — BIGINT — Primary key — NOT NULL
  • FK (user_id) — BIGINT — Foreign key → Users.PK — NOT NULL
  • FK (post_id) — BIGINT — Foreign key → Posts.PK — NOT NULL
  • 내용 (content) — TEXT — NOT NULL
  • 작성일 (created_at) — DATETIME — NOT NULL
  • 수정일 (updated_at) — DATETIME

Post_images (게시글 사진)

  • PK (post_image_id) — BIGINT — Primary key — NOT NULL
  • FK (post_id) — BIGINT — Foreign key → Posts.PK — NOT NULL
  • 사진 (image) — VARCHAR(500) — NOT NULL
  • 업로드시간 (created_at) — DATETIME — NOT NULL
  • 수정일 (updated_at) — DATETIME

Post_likes (좋아요)

  • PK (like_id) — BIGINT — Primary key — NOT NULL
  • FK (user_id) — BIGINT — Foreign key → Users.PK — NOT NULL
  • FK (post_id) — BIGINT — Foreign key → Posts.PK — NOT NULL
  • 좋아요를 누른 시간 (created_at) — DATETIME — NOT NULL

Posts (게시글)

  • PK (post_id) — BIGINT — Primary key — NOT NULL
  • FK (user_id) — BIGINT — Foreign key → Users.PK — NOT NULL
  • 내용 (content) — TEXT — NOT NULL
  • 제목 (title) — VARCHAR(100) — NOT NULL
  • 조회수 (view_count) — INT — NOT NULL
  • 작성일 (created_at) — DATETIME — NOT NULL
  • 수정일 (updated_at) — DATETIME
  • 팀 (team) — VARCHAR(50)

Users (회원)

  • PK (user_id) — BIGINT — Primary key — NOT NULL
  • 이메일 (email) — VARCHAR(255) — NOT NULL
  • 비밀번호 (password) — VARCHAR(255)
  • 닉네임 (nickname) — VARCHAR(50) — NOT NULL
  • 응원팀 (favorite_team) — VARCHAR(50)
  • 프로필사진 (profile_image) — VARCHAR(500)
  • 가입일 (created_at) — DATETIME — NOT NULL
  • 수정일 (updated_at) — DATETIME
  • 회원탈퇴 (deleted) — BOOLEAN