test
Tables (10)
ad (Untitled2)
- ad_id — varchar — Primary key — NOT NULL
- title — varchar
- desc — varchar
- url — varchar
- create_dt — date
- update_dt — date
ad_daily_calc (Untitled9)
- calc_dt — date — Primary key — NOT NULL
- ad_list_id — varchar — Primary key
- amount — long
- create_dt — timestamp
ad_stat (Untitled7)
- stat_dt — date — Primary key — NOT NULL
- ad_list_id — varchar — Primary key — NOT NULL
- daily_view_cnt — long
- create_dt — timestamp
ad_watch_history (Untitled5)
- hist_dt — date — Primary key — NOT NULL
- ad_list_id — varchar — Foreign key → video_ad_list.ad_list_id — NOT NULL
- user_no — long
- create_dt — timestamp
user (Untitled10)
- user_no — long — Primary key — NOT NULL
- user_id — varchar — Primary key — NOT NULL
- password — varchar
- user_name — varchar
- create_dt — timestamp
- update_dt — timestamp
video (Untitled)
- video_id — varchar — Primary key — NOT NULL
- title — varchar — video의 고유 식별 값
- running_time — integer
- url — varchar
- desc — varchar
- total_view_cnt — long
- next_calc_date — date — STANDBY RUNNING DONE
- create_dt — timestamp
- update_dt — timestamp
video_ad_list (Untitled3)
- ad_list_id — varchar — Primary key — NOT NULL
- video_id — varchar — Foreign key → video.video_id — NOT NULL
- ad_id — varchar — Foreign key → ad.ad_id — NOT NULL
- total_view_cnt — long
- create_dt — date
- update_dt — date
video_daily_calc (Untitled8)
- calc_dt — date — Primary key — NOT NULL
- video_id (vedio_id) — varchar — Primary key
- amount — long
- create_dt — timestamp
video_stat (Untitled6)
- stat_dt — date — Primary key — NOT NULL
- video_id (vedio_id) — varchar — Primary key — NOT NULL
- daily_view_cnt — long
- create_dt — timestamp
video_watch_history (Untitled4)
- hist_dt — date — Primary key — NOT NULL
- video_id — varchar — Foreign key → video.video_id — NOT NULL
- user_no — long
- playback_timeline — integer
- create_dt — timestamp