board

Tables (5)

Comment_Like (댓글 좋아요)

  • comment_ratinf_id (댓글별점id) — INT — Primary key — NOT NULL
  • user_id (사용자id) — INT — Foreign key → Users.user_id — NOT NULL
  • comment_id (댓글id) — INT — Foreign key → Comments.comment_id — NOT NULL
  • created_at (생성시간) — DATETIME

Comments (댓글)

  • comment_id (댓글id) — INT — Primary key — NOT NULL
  • post_id (게시물id) — INT — Foreign key → Posts.post_id — NOT NULL
  • user_id (사용자id) — INT — Foreign key → Users.user_id — NOT NULL
  • content (댓글) — TEXT
  • is_anonyous (익명여부) — BOOLEAN
  • like_count (좋아요 수) — INT
  • deleted_at (Soft Delete) — DATETIME
  • created_at (생성시간) — DATETIME
  • updated_at (수정시간) — DATETIME

Post_Rating (게시글 별점)

  • post_rating_id (게시글별점id) — INT — Primary key — NOT NULL
  • user_id (사용자id) — INT — Foreign key → Users.user_id — NOT NULL
  • post_id (게시물id) — INT — Foreign key → Posts.post_id — NOT NULL
  • rating (별점) — Float
  • created_at (생성시간) — DATETIME
  • updated_at (수정 시간) — DATETIME

Posts (게시글)

  • post_id (게시물id) — INT — Primary key — NOT NULL
  • user_id (사용자id) — INT — Foreign key → Users.user_id — NOT NULL
  • title (제목) — VARCHAR(200)
  • content (댓글) — TEXT
  • view_count (조회수) — INT
  • average_rating (평균 별점(캐싱용))
  • ratinf_ciount (별점 개수) — INT
  • deleted_at (Soft Delete) — DATETIME
  • created_at (생성시간) — DATETIME
  • updated_at (수정시간) — DATETIME

Users (사용자)

  • user_id (사용자id) — INT — Primary key — NOT NULL