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