codingyo
Tables (10)
comment
- comment_id — bigint — Primary key — NOT NULL
- post_id — bigint — Foreign key → post.post_id — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- content — text
- creator — varchar(50)
- report_count — int
- like_count — int
- blocked — boolean
- created_at — timestamp
- updated_at — timestamp
comment_like
- comment_like_id — bigint — Primary key — NOT NULL
- comment_id — bigint — Foreign key → comment.comment_id — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- created_at — timestamp
- updated_at — timestamp
comment_report
- comment_report_id — bigint — Primary key — NOT NULL
- comment_id — bigint — Foreign key → comment.comment_id — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
playlist
- playlist_id — bigint — Primary key — NOT NULL — playlist 는 재생목록
- title — varchar(50)
- description — text
post
- post_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- title — varchar(50)
- content — text
- creator — varchar(50)
- like_count — int
- report_count — int
- blocked — boolean — 신고 횟수 n 회 누적시 block 처리를 위한 필드
- video_id — varchar(20)
- created_at — timestamp
- updated_at — timestamp
post_like
- post_like_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- post_id — bigint — Foreign key → post.post_id — NOT NULL
- created_at — timestamp
- updated_at — timestamp
post_playlist
- post_playlist_id — bigint — Primary key — NOT NULL
post_report
- post_report_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- post_id — bigint — Foreign key → post.post_id — NOT NULL
tag
- tag_id — bigint — Primary key — NOT NULL
- post_id — bigint — Foreign key → post.post_id — NOT NULL
- tag_name — varchar(10)
user
- user_id — bigint — Primary key — NOT NULL
- email — varchar(50)
- username — varchar(10)
- profile_url — varchar(255)
- role — enum('USER', 'ADMIN')
- created_at — timestamp
- updated_at — timestamp