PASS TREND

Tables (14)

advertisement

  • id — bigint — Primary key — NOT NULL
  • cp_group_id — bigint
  • title — varchar(200)
  • media — varchar(20)
  • tab_name — varchar(20)
  • category — varchar(40)
  • started_at — datetime
  • ended_at — datetime
  • hashtag — longtext
  • marketing_phrase — varchar(200)
  • button_name — varchar(40)
  • button_url — varchar(200)
  • is_content_all_add — bit(1)
  • status — varchar(20)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • created_by — bigint
  • last_modified_by — bigint

advertisement_content

  • id — bigint — Primary key — NOT NULL
  • advertisement_id — bigint
  • img_key — varchar(255)
  • title — varchar(255)
  • description — varchar(255)
  • link — varchar(255)
  • link_type — varchar(20)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • created_by — bigint
  • last_modified_by — bigint

advertisement_news

  • id — bigint — Primary key — NOT NULL
  • advertisement_id — bigint
  • news_order — int
  • title — varchar(255)
  • original_link — varchar(255)
  • link — varchar(255)
  • description — varchar(255)
  • pub_date — datetime
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • created_by — bigint
  • last_modified_by — bigint

category

  • category_seq — int — Primary key — NOT NULL — 카테고리 순번
  • code — varchar(20) — 코드
  • parent_code — varchar(20) — 상위 코드
  • category_name — varchar(20) — 코드명
  • description — varchar(30) — 설명
  • disp_ord — int — 순번
  • status — varchar(2) — 상태
  • created_at — datetime — 생성일
  • updated_at — datetime — 수정일
  • deleted_at — datetime — 삭제일
  • created_by — bigint — 등록자
  • last_modified_by — bigint — 최종수정자

cp_code

  • id — bigint — Primary key — NOT NULL
  • cp_group_id — bigint — NOT NULL
  • code — varchar(20) — NOT NULL
  • name — varchar(30)
  • phone_number — varchar(30)
  • skt_cp_type — varchar(10)
  • lgu_cp_type — varchar(10)
  • kt_cp_type — varchar(10)
  • type — varchar(20)
  • created_at — datetime
  • updated_at — datetime
  • created_by — bigint
  • last_modified_by — datetime
  • deleted_at — datetime

cp_group

  • id — bigint — Primary key — NOT NULL
  • code — varchar(30) — NOT NULL
  • name — varchar(30) — NOT NULL
  • url — varchar(200)
  • category — char(30)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • last_modified_by — bigint
  • created_by — bigint
  • blind — bit(1)
  • blind_kt — bit(1)
  • blind_skt — bit(1)
  • blind_lgu — bit(1)

naver_news

  • id — bigint — Primary key — NOT NULL
  • pass_trend_ranking_pure_id — bigint
  • pass_trend_ranking_id — bigint
  • query — varchar(30) — NOT NULL
  • executed — bit(1)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • last_modified_by — bigint
  • created_by — bigint

naver_news_item

  • id — bigint — Primary key — NOT NULL
  • naver_news_id — bigint — NOT NULL
  • title — text — NOT NULL
  • original_link — text — NOT NULL
  • link — text — NOT NULL
  • description — text — NOT NULL
  • pub_date — datetime — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • created_by — bigint
  • last_modified_by — datetime
  • deleted_at — datetime

pass_trend_ranking

  • id — bigint — Primary key — NOT NULL
  • media — varchar(20)
  • group_id — bigint
  • title — varchar(100)
  • company — varchar(100)
  • category — varchar(20)
  • cp_group_id — bigint
  • ranking — int
  • gap_code — varchar(100)
  • gap_value — varchar(100)
  • tag — longtext
  • hashtag — longtext
  • url — varchar(200)
  • land_url — varchar(200)
  • count — int
  • count_difference — mediumtext
  • percentage — double
  • status — char(10)
  • released_at — datetime
  • analytics_at — datetime
  • created_by — bigint
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • last_modified_by — bigint

pass_trend_ranking_contents

  • id — bigint — Primary key — NOT NULL
  • pass_trend_ranking_id — bigint
  • title — varchar(255)
  • content — varchar(255)
  • url — varchar(255)
  • img_key — varchar(255)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • created_by — bigint
  • last_modified_by — bigint

pass_trend_ranking_news

  • id — bigint — Primary key — NOT NULL
  • pass_trend_ranking_id — bigint
  • naver_news_item_id — bigint
  • naver_news_order — int
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • created_by — bigint
  • last_modified_by — bigint

pass_trend_ranking_pure

  • id — bigint — Primary key — NOT NULL
  • media — char(3)
  • cp_code_id — bigint — fk 설정 불가, 없는 코드가 들어오는 케이스 존재
  • ctn — char(20)
  • user_safeguard_id — bigint
  • count — bigint
  • analytics_at — datetime
  • created_by — bigint
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • last_modified_by — bigint

pass_trend_ranking_recalculated

  • id — bigint — Primary key — NOT NULL
  • pass_trend_ranking_id — bigint
  • group_id — bigint — NOT NULL
  • cp_group_id — bigint
  • ranking — int
  • recalculated_count — int
  • gap_code — varchar(255)
  • gap_value — int
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • created_by — bigint
  • last_modified_by — bigint

user_safeguard

  • id — bigint — Primary key — NOT NULL
  • media — char(3)
  • phone_number — char(20) — NOT NULL
  • gender — char(2) — NOT NULL
  • birth — date — NOT NULL
  • status — char(2)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • last_modified_by — bigint
  • created_by — bigint