애드티브

테이블 (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