통계DB
테이블 (4)
adsite
- site_code — varchar(32) — 기본 키 — NOT NULL
- userid — varchar(20) — NOT NULL
- site_name — varchar(40)
- site_url — varchar(2083)
- site_title — varchar(200)
- site_desc — varchar(300)
- site_etc — varchar(500)
- view_cnt — int(10)
- click_cnt — int(10)
- state — char(1)
- cate — varchar(20)
- cate2 — varchar(3)
- del_fg — char(1) — NOT NULL
- gubun — varchar(2) — NOT NULL
- usemoney — int(11)
- use_f_day — varchar(8)
- use_t_day — varchar(8)
- sun — varchar(1)
- mon — varchar(1)
- tue — varchar(1)
- wed — varchar(1)
- thu — varchar(1)
- fri — varchar(1)
- sat — varchar(1)
- reg_date — datetime
- modi_date — datetime
- mediacnt — int(11)
- popgb — varchar(1)
- upseq — varchar(20)
- imgname — varchar(100)
- imgname2 — varchar(100)
- imgname3 — varchar(100)
- imgname4 — varchar(100)
- imgname5 — varchar(100)
- imgname6 — varchar(100)
- imgname7 — varchar(100)
- imgname8 — varchar(100)
- imgname9 — varchar(100)
- imgname10 — varchar(100)
- imgname11 — varchar(100)
- imgname12 — varchar(100)
- imgname13 — varchar(100)
- imgname14 — varchar(100)
- imgname15 — varchar(100) — 970 * 100
- imgname16 — varchar(100) — 720 * 120
- imgname17 — varchar(100) — 300 * 250
- imgname18 — varchar(100) — 200*200
- usedmoney — int(11)
- site_code_s — varchar(32)
- url_style — varchar(1)
- shoplink — varchar(200)
- sales_url — varchar(200)
- sales_prdno — varchar(20)
- recom_ad — char(1)
- svc_type — varchar(20)
- dispo_sex — varchar(30)
- dispo_age — varchar(30)
- ad_rhour — varchar(50)
- adweight — float(3, 1)
- cate_select — varchar(30) — 카테고
- … +11
adsite_mobile
- site_code — varchar(32) — 기본 키 — NOT NULL
- atype — char(1) — 기본 키 — NOT NULL — b:배너, s:브랜드링크
- site_code (site_code2) — varchar(32) — 외래 키 → adsite.site_code — NOT NULL
- state — char(1) — 모바일게재상태
- site_desc — varchar(300)
- site_url — varchar(2083)
- site_etc — varchar(500)
- banner_path1 — varchar(255)
- banner_path2 — varchar(255)
- banner_path3 — varchar(255)
- banner_path4 — varchar(255)
- banner_path5 — varchar(255)
- upseq — varchar(20)
- freq_weight — int(11) — 캠페인의 광고소비자별 송출횟수 가중치
- freq_coverage — int(11) — 캐페인 프리퀀시 보장률
- c_price — int(11) — 캠페인별 단가
iadsite
- site_code — varchar(32) — 기본 키 — NOT NULL
- userid — varchar(20) — NOT NULL
- site_name — varchar(40)
- site_url — varchar(2083)
- site_title — varchar(200)
- site_desc — varchar(300)
- site_desc1 — varchar(1000) — 브랜드박스 사이트 문구
- site_etc — varchar(500)
- view_cnt — int(10)
- click_cnt — int(10)
- state — char(1)
- cate — varchar(20)
- cate2 — varchar(3)
- del_fg — char(1) — NOT NULL
- gubun — varchar(2) — NOT NULL
- usemoney — int(11)
- use_f_day — varchar(8)
- use_t_day — varchar(8)
- sun — varchar(1)
- mon — varchar(1)
- tue — varchar(1)
- wed — varchar(1)
- thu — varchar(1)
- fri — varchar(1)
- sat — varchar(1)
- reg_date — datetime
- modi_date — datetime
- mediacnt — int(11)
- popgb — varchar(1)
- upseq — varchar(20)
- imgname — varchar(100)
- imgname2 — varchar(100)
- imgname3 — varchar(100)
- imgname4 — varchar(100)
- imgname5 — varchar(100)
- usedmoney — int(11)
- site_code_s — varchar(32)
- pop_style — char(255)
- url_style — varchar(1)
- shoplink — varchar(200)
- sales_url — varchar(200)
- sales_prdno — varchar(20)
- svc_type — varchar(20)
- recom_ad — char(1)
- dispo_sex — varchar(30)
- dispo_age — varchar(30)
- ad_rhour — varchar(50)
- adweight — float(3, 1)
- cate_select — varchar(30) — 카테고
- 부분선택 — 저장부분', — 캠페인의 광고소비자별 송출횟수 가중치
- freq_coverage — int(11) — 캠페인 프리퀀시 보장률
- c_price — int(11) — 캠페인별 단가
- important_yn — char(1) — 중요캠페인
- ADVRTS_STLE_TP_CODE — varchar(2) — 광고형태구분코드|광고형태 구분 코드|MOBON_COM_CODE.ADVRTS_STLE_TP_CODE|
- ALL_USE_YN — varchar(1) — NOT NULL
- KWRD_ADIT_YN — varchar(1) — NOT NULL — 키워드추가여부|키워드 자동저장 여부, 기본값:N|Y:자동추가, N:수동 추가|
media_script
- no — int
- mediasite_no — int
- userid — varchar
- sdate — varchar
- regdate — datetime
- ad_type — varchar
- state — varchar
- h_type — varchar
- h_banner — text
- accept_sr — char
- accept_rc — char
- accept_rm — char
- accept_um — char
- accept_kl — char
- accept_ad — char
- accept_st — char
- accept_sp — char
- accept_cc — char
- accept_sa — char
- accept_cw — char
- accept_hu — char
- accept_pm — char
- accept_pb — char
- accept_sj — char
- accept_mm — char
- accept_kb — char
- accept_ib — char
- accept_km — char
- accept_ik — char
- accept_mk — char
- accept_cm — char
- accept_mr — char
- accept_au — char
- weight_pct — int
- bid_price — int
- price_type — varchar
- product_type — char
- w_type — char
- s_type — char
- i_gubun — varchar
- del_fg — char
- weight_type — varchar
- frameRtb_YN — varchar
- m_bacon_yn — char
- cpi_yn — char
- cpi_gubun — varchar
- r_gubun — varchar
- ms_icover_useyn — char
- ms_icover_time — float
- pb_weight — int
- two_yn — varchar
- mcover_type — varchar
- psb_url — text
- valid_click_yn — char
- MEDIA_ITL_TP_CODE — varchar
- ADVRTS_STLE_TP_CODE — varchar
- PASS_YN — varchar
- CHRG_FOM_TP_CODE — varchar
- FQ_SETUP_MM — int
- CHRG_SECT_TP_CODE — varchar
- … +3