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