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)