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