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