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