newsight_new
테이블 (22)
raw_article 기반 공통 기사 (origin_article)
- org_article_seq — bigint — 기본 키 — NOT NULL
- raw_article_id — bigint — 외래 키 → 기사 원문.raw_article_id — NOT NULL
- id_seq — integer
- company_name — varchar(200)
- company_names — text
- publish_datetime — timestamp — NOT NULL
- title — varchar(500) — NOT NULL
- prev_contents — text
- origin_link — varchar(1000) — NOT NULL
- link — varchar(1000)
- publisher — varchar(200)
- is_target_company_article_tag — boolean
- is_target_company_article_keyword — boolean
- klue_ner_og_keywords — text
- input_text — text
- contents — text
- emotion_score — numeric(10,3)
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp — NOT NULL
step_h
- step_code (step_code2) — varchar(50) — 외래 키 → 파이프라인 단계 관리.step_code — NOT NULL
- hist_seq — bigint — NOT NULL
- step_nm — varchar(100) — NOT NULL
- step_group — varchar(50) — NOT NULL
- is_client_step — boolean — NOT NULL
- sort_order — integer — NOT NULL
- is_active — boolean — NOT NULL
- change_type — varchar(30) — NOT NULL
- changed_reason — text
- created_datetime — timestamp — NOT NULL
step별 상세 로그/이벤트 (pipeline_event_l)
- event_seq — bigint — 기본 키 — NOT NULL
- id_seq — integer
- run_id — varchar(20) — NOT NULL
- run_type — varchar(50) — NOT NULL
- step_code — varchar(50) — NOT NULL
- client_id — varchar(50)
- publish_date — date
- event_type — varchar(50) — NOT NULL
- status — varchar(30)
- metric_code — varchar(50) — 실무자가 찍고 싶은 지표의 이름
- metric_value — numeric(18,3) — 실무자가 찍고 싶은 지표의 값
- message — text
- created_datetime — timestamp — NOT NULL
고객 일자 단위 별 후속 처리 추적 (client_daily_pipeline_state)
- state_seq — bigint — 기본 키 — NOT NULL
- run_id — bigint — NOT NULL
- client_id — varchar(50) — NOT NULL
- publish_date — date — NOT NULL
- summary_expected_count — integer — NOT NULL
- summary_success_count — integer — NOT NULL
- summary_failed_count — integer — NOT NULL
- summary_skipped_count — integer — NOT NULL
- email_prepare_status — varchar(30)
- email_send_status — varchar(30)
- report_status — varchar(30)
- pipeline_status — varchar(30) — NOT NULL
- last_step_code — varchar(50)
- last_error_msg — text
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp — NOT NULL
고객관리 (client_m)
- client_id — varchar(50) — 기본 키 — NOT NULL
- client_code — varchar(100) — NOT NULL
- client_nm — varchar(200) — NOT NULL
- is_active — boolean — NOT NULL
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp — NOT NULL
고객별 대상 기업 매핑 (client_target_m)
- client_id — varchar(50) — 외래 키 → 고객관리.client_id — NOT NULL
- id_seq — integer
- crn — varchar(20)
- enr — varchar(20)
- company_name — varchar(200) — NOT NULL
- insert_date — date
- std_date — date
- is_report_target — boolean — NOT NULL
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp — NOT NULL
고객별 전문 적재 원본 테이블 (new_target)
- ns_seq — integer — 기본 키 — NOT NULL
- client_id (client_id2) — varchar(50) — 외래 키 → 고객별 대상 기업 매핑.client_id — NOT NULL
- crn — varchar(20)
- enr — varchar(20)
- company_name — varchar(200) — NOT NULL
- company_names — text
- insert_date — date
- std_date — date
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp — NOT NULL
고객별 판단 결과 기사 (similar_article)
- sim_article_seq — bigint — 기본 키 — NOT NULL
- id_seq — integer
- client_id — varchar(50) — 외래 키 → 고객관리.client_id — NOT NULL
- org_article_seq — bigint — 외래 키 → raw_article 기반 공통 기사.org_article_seq — NOT NULL
- company_name — varchar(200)
- summary — text
- negative_keywords — text
- is_not_corp_article — boolean
- is_not_negative — boolean
- llm_valid_score — numeric(10,3)
- llm_valid_opinion — text
- llm_negative_opinion — text
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp — NOT NULL
고객별 프롬프트 매핑 (client_prmt_m)
- step_code — varchar(50) — 기본 키 — NOT NULL
- client_id — varchar(50) — 외래 키 → 고객관리.client_id — NOT NULL
- prmt_seq (prmt_seq2) — bigint — 외래 키 → 프롬프트 관리.prmt_seq — NOT NULL
- is_active — boolean — NOT NULL
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp — NOT NULL
고객별 프롬프트 변경 이력 (client_prmt_h)
- hist_seq — bigint — 기본 키 — NOT NULL
- client_id — varchar(50) — 외래 키 → 고객관리.client_id — NOT NULL
- step_code — varchar(50) — NOT NULL
- prmt_seq — bigint — 외래 키 → 프롬프트 관리.prmt_seq — NOT NULL
- is_active — boolean — NOT NULL
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp — NOT NULL
공통 step 상태 추적 간소화 ver (target_pipeline_state)
- state_seq — bigint — 기본 키 — NOT NULL
- run_id — bigint — NOT NULL
- id_seq — integer — NOT NULL
- publish_date — date — NOT NULL
- pipeline_status — varchar(30) — NOT NULL
- last_step_code — varchar(50)
- last_error_msg — text
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp — NOT NULL
기사 원문 (raw_article)
- raw_article_id — bigint — 기본 키 — NOT NULL
- publish_datetime — timestamp — NOT NULL
- title — varchar(500) — NOT NULL
- origin_link — varchar(1000) — NOT NULL
- article_seq — varchar(100)
- source — varchar(100)
- news_id — varchar(100)
- link — varchar(1000)
- publisher — varchar(200)
- prev_contents — text
- author — varchar(200)
- company_name — varchar(200)
- call_url — varchar(1000)
- is_valid_publisher — boolean
- publish_date — date
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp — NOT NULL
기업별 요약 상태 추적 (client_target_pipeline_state)
- state_seq — bigint — 기본 키 — NOT NULL
- run_id — bigint — NOT NULL
- client_id — varchar(50) — NOT NULL
- id_seq — integer — NOT NULL
- publish_date — date — NOT NULL
- summary_status — varchar(30)
- last_step_code — varchar(50)
- last_error_msg — text
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp — NOT NULL
리포팅 대상 공통 기업(기존 newsight_target) (target_m)
- seq — integer — 기본 키 — NOT NULL
- id_seq — integer — NOT NULL
- enr — varchar(20)
- crn — varchar(20)
- company_name — varchar(200) — NOT NULL
- company_names — text
- standard_date — date
- exclude_names — text
- added_clue — text
- is_temp_target — boolean — NOT NULL
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp — NOT NULL
발행일별 기업 공통 감성점수 (newsight_zscore)
- publish_date — date — 기본 키 — NOT NULL
- id_seq — integer
- article_cnt_by_date — integer — NOT NULL
- avg_emotion_score_by_date — numeric(10,3) — NOT NULL
- emotion_zscore — numeric(10,3)
- is_priority_company — boolean — NOT NULL
- mean_180 — numeric(10,3)
- std_180 — numeric(10,3)
- window_days_count — integer
- article_cnt_by_180 — integer
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp — NOT NULL
배치 관리 (run_m)
- run_id — varchar(20) — 기본 키 — NOT NULL — guid 형식으로 P + 발행 날짜(sss) + random 3 D + 발행 날짜(sss) + random 3 L + 발행 날짜(sss) + random 3
- run_type — varchar(50) — NOT NULL
- base_publish_date — date
- from_publish_date — date
- to_publish_date — date
- status — varchar(30) — NOT NULL
- target_steps — jsonb
- started_datetime — timestamp
- ended_datetime — timestamp
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp — NOT NULL
실행 종류 관리 (run_type_m)
- run_type — varchar(50) — 기본 키 — NOT NULL
- run_type_nm — varchar(100) — NOT NULL
- description — text
- is_active — boolean — NOT NULL
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp — NOT NULL
알람 관리 (alert_h)
- alert_seq — bigint — 기본 키 — NOT NULL
- step_code — varchar(50) — NOT NULL
- run_id — bigint
- client_id — varchar(50)
- id_seq — integer
- publish_date — date
- alert_channel — varchar(50) — NOT NULL
- alert_result — varchar(30) — NOT NULL
- alert_message — text
- created_datetime — timestamp — NOT NULL
재처리 관리 (retry_h)
- retry_seq — bigint — 기본 키 — NOT NULL
- step_code (step_code2) — varchar(50) — 외래 키 → 파이프라인 단계 관리.step_code — NOT NULL
- run_id — bigint
- client_id — varchar(50)
- id_seq — integer
- publish_date — date
- retry_count — integer — NOT NULL
- before_status — varchar(30)
- after_status — varchar(30)
- retry_reason — text
- result_message — text
- created_datetime — timestamp — NOT NULL
전문 배치 진행률 (input_batch_progress)
- batch_id — bigint — 기본 키 — NOT NULL
- run_id — bigint — 외래 키 → 배치 관리.run_id — NOT NULL
- client_id — varchar(50) — NOT NULL
- batch_type — varchar(50) — NOT NULL
- publish_month — varchar(7) — NOT NULL
- file_name — varchar(500)
- total_count — integer
- inserted_count — integer
- excluded_count — integer
- manual_count — integer
- applied_count — integer
- failed_count — integer
- status — varchar(30) — NOT NULL
- started_datetime — timestamp
- ended_datetime — timestamp
- duration_ms — integer
- last_error_msg — text
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp — NOT NULL
파이프라인 단계 관리 (step_m)
- step_code — varchar(50) — 기본 키 — NOT NULL
- step_nm — varchar(100) — NOT NULL
- step_group — varchar(50) — NOT NULL
- is_client_step — boolean — NOT NULL
- sort_order — integer — NOT NULL
- is_active — boolean — NOT NULL
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp — NOT NULL
프롬프트 관리 (prmt_m)
- prmt_seq — bigint — 기본 키 — NOT NULL
- step_code — varchar(50) — NOT NULL
- prmt_nm — varchar(200) — NOT NULL
- prmt_text — text — NOT NULL
- api_mdl_nm — varchar(100)
- api_mdl_config — text
- is_active — boolean — NOT NULL
- created_datetime — timestamp — NOT NULL
- updated_datetime — timestamp — NOT NULL