Outcome1

Tables (10)

ad (Untitled4)

  • 광고id (ad_id) — Primary key — NOT NULL
  • 생성시간 (created_at) — NOT NULL

ad_rev (Untitled7)

  • ad_rev_id (Key) — Primary key — NOT NULL
  • 날 (Date)
  • 광고정산 (ad_revenue)
  • 광고목록id (video_ad_id) — Foreign key → video_ad.광고목록id — NOT NULL
  • 광고목록id (video_ad_id2) — Foreign key → video_ad.광고목록id — NOT NULL
  • 동영상id (vid_id) — Foreign key → video_ad.동영상id — NOT NULL
  • 광고id (ad_id2) — Foreign key → video_ad.광고id — NOT NULL

ad_stats (Untitled8)

  • ad_stats_id (Key) — Primary key — NOT NULL
  • 날 (Date)
  • 광고뷰 (ad_view)
  • 광고목록id (video_ad_id) — Foreign key → video_ad.광고목록id — NOT NULL

adview (Untitled2)

  • Key — Primary key — NOT NULL
  • 생성시간 (created_at)
  • 광고목록id (ad_view_id) — Foreign key → video_ad.광고목록id — NOT NULL

user (Untitled)

  • 유저 id (user_id) — Primary key — NOT NULL
  • 이메일 (email) — NOT NULL
  • 이름 (username) — NOT NULL
  • 비밀번호 (password) — NOT NULL
  • 등급 (type) — NOT NULL
  • 권한 (role) — NOT NULL

video (Untitled3)

  • 동영상id (vid_id) — Primary key — NOT NULL
  • 유저 id (user_id) — Foreign key → user.유저 id — NOT NULL
  • 동영상길이 (vid_length)
  • 조회수 (total_video_view) — NOT NULL
  • 수정시간 (updated_at)
  • 생성시간 (created_at) — NOT NULL

video_ad (동영상별 광고목록)

  • 광고목록id (video_ad_id) — Primary key — NOT NULL
  • 동영상id (vid_id) — Foreign key → video.동영상id — NOT NULL
  • 광고id (ad_id) — Foreign key → ad.광고id — NOT NULL
  • 광고누적조회 (total_ad_view)
  • 광고저장위치 (ad_position)

video_rev (Untitled6)

  • 비디오정산id (Key) — Primary key — NOT NULL
  • 날 (Date)
  • 영상정산 (video_revenue)
  • 동영상id (vid_id) — Foreign key → video.동영상id — NOT NULL

video_stats (일별)

  • 비디오통계id (video_stats_id) — Primary key — NOT NULL
  • 날 (date)
  • 동영상조회수 (video_view)
  • 총재생시간 (play_time)
  • 동영상id (vid_id) — Foreign key → video.동영상id

video_view (Untitled5)

  • 재생기록 (vidview_id) — Primary key — NOT NULL
  • 유저 id (user_id) — Foreign key → user.유저 id — NOT NULL
  • 동영상id (vid_id) — Foreign key → video.동영상id — NOT NULL
  • 재생시점 (last_played)
  • 생성시간 (created_at)
  • 재생시간용 (watched_at)
  • 재생시간 (duration)