streaming

Tables (5)

Untitled (video_history)

  • history_id — PK — Primary key — NOT NULL
  • video_id — FK — Foreign key → video.video_id — NOT NULL
  • user_id — FK — Foreign key → video.id — NOT NULL
  • last_play_time (마지막으로 재생된 시간) — Not Null
  • current_position — Not Null

ad

  • ad_id — PK — Primary key — NOT NULL
  • ad_name (광고제목) — Not Null
  • ad_play_count (광고재생횟수) — Not Null

user

  • id — PK — Primary key — NOT NULL
  • kakao_id — Not Null
  • password — Not Null
  • role — Not Null

video

  • video_id (영상id) — PK — Primary key — NOT NULL
  • id (user_id) — FK — Foreign key → user.id — NOT NULL
  • title (영상제목) — Not Null
  • views (조회수) — Not Null
  • play_time (재생시간) — Not Null
  • play_count (재생횟수) — Not Null
  • status (영상상태) — Not Null

video_ad

  • id — PK — Primary key — NOT NULL
  • video_id — FK — Foreign key → video.video_id — NOT NULL
  • ad_id — FK — Foreign key → ad.ad_id — NOT NULL