애드티브
테이블 (7)
Banner_Click (CopyOfUntitled22)
- no (Key) — int(11) unsigned — 기본 키 — NOT NULL
- ym (Field) — int(6) unsigned
- day (Field2) — tinyint(2) unsigned zerofill
- hour (Field3) — tinyint(2) unsigned zerofill
- minute (Field4) — tinyint(2) unsigned zerofill
- cpno (Field5) — int(11) unsigned
- mzno (Field6) — int(11) unsigned
- mtno (Field14) — int(11) unsigned
- ad_kind (Field7) — char(1)
- user_plf (Field8) — char(1)
- user_os (Field9) — char(1)
- user_brws (Field10) — char(1)
- clk_url (Field11) — varchar(200)
- client_ip (Field12) — varchar(15)
- server_no (Field13) — tinyint(2) unsigned zerofill
- zone_plf (Field15) — char(1)
- charged (Field16) — int(11) unsigned
- clk_mktime (Field17) — int(11) unsigned
- is_rtg (Field18) — bigint(20) unsigned
PV (CopyOfCopyOfUntitled22)
- no (Key) — int(11) unsigned — 기본 키 — NOT NULL
- ym (Field) — mediumint(6) unsigned
- ymd (Field14) — bigint(20) unsigned
- day (Field2) — tinyint(2) unsigned zerofill
- cpno (Field4) — int(11) unsigned
- mzno (Field5) — int(11) unsigned
- mtno (Field6) — int(11) unsigned
- ad_kind (Field7) — char(1)
- p_pv (Field8) — bigint(20) unsigned
- p_clk (Field9) — int(11) unsigned
- m_pv (Field10) — bigint(20) unsigned
- m_clk (Field11) — int(11) unsigned
- all_pv (Field12) — bigint(20) unsigned
- all_clk (Field13) — int(11) unsigned
Procuct_list (Untitled)
- mrtno (Key) — bigint(20) unsigned — 기본 키 — NOT NULL
- mno (Field) — bigint(20) unsigned
- mapid (Field2) — varchar(50)
- pname (Field3) — varchar(100)
- price (Field4) — int(11) unsigned
- pgurl (Field5) — varchar(255)
- pcurl (Field6) — varchar(255)
- mburl (Field7) — varchar(255)
- igurl (Field8) — varchar(255)
- cate1 (Field9) — varchar(50)
- cate2 (Field10) — varchar(50)
- cate3 (Field11) — varchar(50)
- cate4 (Field12) — varchar(50)
- caid1 (Field13) — varchar(32)
- caid2 (Field14) — varchar(32)
- caid3 (Field15) — varchar(32)
- caid4 (Field16) — varchar(32)
- depth (Field17) — tinyint(1) unsigned
- cthash (Field18) — char(32)
- soldout (Field19) — tinyint(1) unsigned
- utime (Field20) — datetime
- image (Field21) — varchar(40)
Retarget_mat (CopyOfUntitled)
- mrtno (Key) — bigint(20) unsigned — 기본 키 — NOT NULL
- api_key (Field22) — char(32)
- cpno (Field3) — int(11) unsigned
- mno (Field) — bigint(20) unsigned
- ad_kind (Field9) — bigint(20) unsigned
- ct_code (Field10) — bigint(20) unsigned
- mrt_phash_pc (Field12) — char(32)
- mrt_phash_mb (Field13) — char(32)
- mrt_dhash_pc (Field14) — char(32)
- mrt_dhash_mb (Field15) — char(32)
- mrt_chash (Field16) — char(32)
- mrt_scode (Field18) — char(32)
- mrt_stype (Field17) — tinyint(1) unsigned
- mrt_kind (Field19) — tinyint(2) unsigned
- mrt_price (Field20) — int(11) unsigned
- mrt_text (Field21) — varchar(100)
- mrt_img480 (Field2) — varchar(40)
- mrt_img640 (Field4) — varchar(40)
- mrt_img240 (Field5) — varchar(40)
- mrt_img280 (Field6) — carchar(40)
- mrt_img310 (Field7) — varchar(40)
- mrt_img600*120 (Field8) — varchar(40)
- mrt_img600*150 (Field11) — varchar(40)
- mrt_img300*250 (Field23) — varchar(40)
- mrt_img315*105 (Field24) — varchar(40)
- mrt_img120*600 (Field25) — varchar(40)
- mrt_img300*150 (Field26) — varchar(40)
- mrt_img250*140 (Field27) — varchar(40)
- mrt_img728*90 (Field28) — varchar(40)
- mrt_img160*600 (Field29) — varchar(40)
- mrt_url_land (Field30) — varchar(255)
- mrt_url_pc (Field31) — bigint(20) unsigned
- mrt_url_mb (Field32) — bigint(20) unsigned
- mrt_param_pc (Field33) — bigint(20) unsigned
- mrt_param_mb (Field34) — bigint(20) unsigned
- mrt_platform (Field35) — bigint(20) unsigned
- mrt_status (Field36) — bigint(20) unsigned
UID_PT_0 (Untitled3)
- uid (Key) — char(32) — 기본 키 — NOT NULL
- uip (Field) — varchar(15)
- reg_mktime (Field2) — int(11) unsigned
- last_mktime (Field3) — tinyint(1) unsigned
UID_mat_pt_0 (CopyOfUntitled2)
- utno (Key) — bigint(20) unsigned — 기본 키 — NOT NULL
- uid (Field) — char(32)
- mno (Field2) — int(11) unsigned
- mrtno (Field3) — int(11) unsigned
- ut_inflow_cnt (Field4) — int(11) unsigned
- ut_mktime_first (Field5) — int(11) unsigned
- ut_mktime_last (Field6) — int(11) unsigned
- ut_switch (Field7) — tinyint(1) unsigned
switch (Untitled2)
- no (Key) — int(11) unsigned — 기본 키 — NOT NULL
- ym (Field) — int(6) unsigned
- day (Field2) — tinyint(2) unsigned zerofill
- hour (Field3) — tinyint(2) unsigned zerofill
- minute (Field4) — tinyint(2) unsigned zerofill
- cpno (Field5) — int(11) unsigned
- mrtno (Field6) — int(11) unsigned
- uid (Field7) — char(32)
- uisno (Field8) — bigint(20) unsigned
- switch_url (Field9) — varchar(255)
- user_ip (Field10) — varchar(15)
- user_plf (Field11) — char(1)
- swt_kind (Field12) — char(1)
- swt_mktime (Field13) — int(11) unsigned
- swt_direct (Field14) — tinyint(1) unsigned
- swt_cnt (Field15) — int(11) unsigned
- swt_gaptime (Field16) — int(11) unsigned