링크다-추가데이터
테이블 (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