링크다-추가데이터

테이블 (7)

Ad Banner (ban)

  • banner value id (id) — NOT NULL — 기본 키 — NOT NULL
  • banner start date (ban_start_date) — NULL
  • banner end date (ban_end_date) — ULL
  • bng_id — NOT NULL — 외래 키 → Ad Banner Group.bng_id — NOT NULL
  • ban_name (bng_name) — NOT NULL
  • banner title (ban_title) — NOT NULL
  • banner URL (ban_url) — NOT NULL
  • ban width length (ban_width) — NOT NULL
  • ban height length (ban_height) — NOT NULL
  • banner total counted / Clicked total (accumulated) (ban_hit) — NOT NULL
  • ban_order — NOT NULL
  • banner image path (ban_img) — NOT NULL
  • ban activated (ban_activated) — NOT NULL
  • ban datetime (ban_datetime) — NULL
  • banner ip for whom uploaded (ban_ip)
  • mem_id — NOT NULL — 외래 키 → mem(링크다 기존 유저데이터로 대체).mem_id — NOT NULL

Ad Banner Group (bng)

  • bng_id — NOT NULL — 기본 키 — NOT NULL
  • banner group name (only master can edit this) (bng_name) — NOT NULL

Ad Viewd Data Analysis (ad)

  • Auto-increase / id value (ad_id) — NOT NULL — 기본 키 — NOT NULL
  • Single value added as soon as an user approaches (ad_ban_viewd) — NOT NULL
  • Time counted as soon as bannert loaded (ad_ban_view_time) — NOT NULL
  • Counted when certain ban has clicked by users (ad_ban_clicked) — NULL
  • Activated / targeted banner value id (ban_id) — NOT NULL — 외래 키 → Ad Banner.banner value id — NOT NULL
  • users_id_Array (user_id_Array) — NOT NULL
  • mem_id — NOT NULL — 외래 키 → mem(링크다 기존 유저데이터로 대체).mem_id — NOT NULL

Banner Spot (bs)

  • bs_id (banner spot) (bs_id) — NOT NULL — 기본 키 — NOT NULL
  • counting-tranding analysis based on spot (bs_viewed) — NOT NULL
  • clieck counting-tranding anlysis based on spot (bs_clicked) — NOT NULL
  • banner value ids / Array (ban_id_array) — NOT NULL — 외래 키 → Ad Banner.banner value id — NOT NULL
  • bng_id — NOT NULL — 외래 키 → Ad Banner Group.bng_id — NOT NULL
  • mem_id — NOT NULL — 외래 키 → mem(링크다 기존 유저데이터로 대체).mem_id — NOT NULL

Prd Viewd Data Analysis (pd)

  • Auto-increase / id value (pd_id) — NOT NULL — 기본 키 — NOT NULL
  • Single value added as soon as an user approaches (pd_viewd) — NOT NULL
  • Time counted as soon as prdloaded (pd_view_time) — NOT NULL
  • Counted when certain prd thumbnail has clicked by an user (pd_clicked) — NULL
  • users_id_Array (user_id_Array) — NOT NULL
  • mem_id — NOT NULL — 외래 키 → mem(링크다 기존 유저데이터로 대체).mem_id — NOT NULL
  • prd_id — NOT NULL — 외래 키 → Products(기존데이터).prd_id — NOT NULL

Products(기존데이터) (prd)

  • prd_id — NOT NULL — 기본 키 — NOT NULL

mem(링크다 기존 유저데이터로 대체) (mem)

  • mem_id — NOT NULL — 기본 키 — NOT NULL