test

Tables (4)

EVENT_COUNT_MAP

  • IDX — int(11) — Primary key — NOT NULL — 인덱스
  • EVENTGROUP_IDX — int(11) — NOT NULL — 카테고리 그룹 번호
  • EVENT_COUNT — int(11) — 이벤트 수
  • CREATED — timestamp(3) — 생성일
  • UPDATED — timestamp(3) — 수정일

event_test

  • num — int(11) — Primary key — NOT NULL
  • type — varchar(30) — NOT NULL
  • title — varchar(128) — NOT NULL
  • profileurl — varchar(512) — NOT NULL
  • id_id — varchar(128) — NOT NULL
  • nickname_nickname — varchar(256) — NOT NULL
  • platformname_num — int(11) — NOT NULL
  • platformname_name — varchar(64) — NOT NULL
  • community_title — varchar(256) — NOT NULL
  • community_url — varchar(512) — NOT NULL
  • category_name — varchar(50) — NOT NULL
  • categorygroup_num — int(11) — NOT NULL — scheduler guide 삭제시
  • categorygroup_name — varchar(64) — NOT NULL
  • date — date — NOT NULL
  • bannernum — int(11) — NOT NULL
  • url — varchar(512) — NOT NULL
  • expectdate — date
  • posteddate — date
  • prev_deleteddate — date
  • last_deleteddate — date
  • deleted_count — int(11)
  • statusadmincheck — int(11) — NOT NULL — 0:대기, 1:최종승인, 2:재수정
  • eventcode — int(10) — NOT NULL
  • eventtag — varchar(1024) — NOT NULL
  • isbackup — tinyint(1) — NOT NULL
  • isdelete — tinyint(1) — NOT NULL

favorite

  • idx — int(11) — Primary key — NOT NULL — 인덱스
  • nickname — varchar(128) — NOT NULL — 닉네임
  • platform_number — int(11) — NOT NULL — 플렛폼 번호
  • company_number — int(11) — NOT NULL — 회사 번호
  • created — datetime(3) — 생성일
  • updated — datetime(3) — 수정일

highrank

  • idx — int(11) — Primary key — NOT NULL — 인덱스
  • campaignnum — mediumint(9) — NOT NULL — 캠페인
  • date — date — 캡쳐날짜
  • id — varchar(200) — NOT NULL — 아이디
  • url — varchar(200) — NOT NULL — url
  • keyword — varchar(200) — NOT NULL — 키워드
  • platform — tinyint(3) — NOT NULL — 플랫폼
  • page — tinyint(3) — NOT NULL — 페이지
  • post — smallint(5) — NOT NULL — post
  • count — smallint(5) — NOT NULL — 같이 캡쳐된 수
  • img_path — varchar(1000) — NOT NULL — 이미지경로
  • created — datetime(3) — NOT NULL — 생성일
  • updated — datetime(3) — NOT NULL — 수정일
  • etc1 — tinyint(4) — NOT NULL
  • etc2 — tinyint(4) — NOT NULL