프로젝트1

테이블 (13)

asset_store(워드클라우드 저장) (asset_store)

  • asset_id — BIGINT — 기본 키 — NOT NULL
  • created_by_user_id — BIGINT
  • asset_type — VARCHAR(30) — NOT NULL
  • keyword — VARCHAR(200)
  • period_start — DATE
  • period_end — DATE
  • file_path — VARCHAR(500) — NOT NULL
  • meta — TEXT
  • created_at — DATETIME — NOT NULL

batch_error_log(에러로그) (batch_error_log)

  • error_id — BIGINT — 기본 키 — NOT NULL
  • run_id — BIGINT — NOT NULL
  • step_run_id — BIGINT
  • step_id — BIGINT
  • category — VARCHAR(30)
  • news_id — VARCHAR(80)
  • missing_field — VARCHAR(40)
  • fail_reason — VARCHAR(120)
  • error_code — VARCHAR(60)
  • message — TEXT
  • payload — TEXT
  • occurred_at — DATETIME — NOT NULL
  • resolved_at — DATETIME
  • resolved_by_user_id — BIGINT

batch_job(배치작업) (batch_job)

  • job_id — BIGINT — 기본 키 — NOT NULL
  • job_code — VARCHAR(40) — NOT NULL
  • job_name — VARCHAR(120)
  • target_id — BIGINT
  • schedule_rule — VARCHAR(80)
  • status — VARCHAR(20) — NOT NULL
  • updated_at — DATETIME — NOT NULL

batch_run(배치실행) (batch_run)

  • run_id — BIGINT — 기본 키 — NOT NULL
  • job_id — BIGINT — NOT NULL
  • requested_by_user_id — BIGINT
  • trigger_type — VARCHAR(20) — NOT NULL
  • target_start_at — DATETIME
  • target_end_at — DATETIME
  • started_at — DATETIME
  • ended_at — DATETIME
  • status — VARCHAR(20) — NOT NULL
  • total_count — INT — NOT NULL
  • success_count — INT — NOT NULL
  • fail_count — INT — NOT NULL
  • fail_rate — DECIMAL(6,4)
  • params — TEXT
  • created_at — DATETIME — NOT NULL

batch_step_def(배치사항 1:1매핑) (batch_step_def)

  • step_id — BIGINT — 기본 키 — NOT NULL
  • job_id — BIGINT — NOT NULL
  • step_code — VARCHAR(20) — NOT NULL
  • step_order — INT — NOT NULL
  • step_name — VARCHAR(120)
  • input_ref — VARCHAR(80)
  • output_ref — VARCHAR(80)
  • status — VARCHAR(20) — NOT NULL

batch_step_run(배치실행단계별기록) (batch_step_run)

  • step_run_id — BIGINT — 기본 키 — NOT NULL
  • run_id — BIGINT — NOT NULL
  • step_id — BIGINT — NOT NULL
  • started_at — DATETIME
  • ended_at — DATETIME
  • status — VARCHAR(20) — NOT NULL
  • total_count — INT — NOT NULL
  • success_count — INT — NOT NULL
  • fail_count — INT — NOT NULL
  • error_code — VARCHAR(60)
  • message — TEXT

crawl_target(크롤링대상) (crawl_target)

  • target_id — BIGINT — 기본 키 — NOT NULL
  • target_name — VARCHAR(80) — NOT NULL
  • base_url — VARCHAR(500) — NOT NULL
  • query_template — VARCHAR(500)
  • timezone — VARCHAR(40) — NOT NULL
  • min_article_count — INT — NOT NULL
  • window_start — TIME
  • window_end — TIME
  • required_fields — TEXT
  • dedupe_rule — TEXT
  • parse_rule — TEXT
  • status — VARCHAR(20) — NOT NULL
  • updated_at — DATETIME — NOT NULL

econ_knowledge(경제지식 /용어 컨텐츠) (econ_knowledge)

  • knowledge_id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_by_user_id — BIGINT
  • updated_by_user_id — BIGINT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

news_ref(뉴스참조테이블) (news_ref)

  • news_id — VARCHAR(80) — 기본 키 — NOT NULL
  • published_date — DATE
  • url — VARCHAR(600)
  • press — VARCHAR(120)
  • title — VARCHAR(500)
  • created_at — DATETIME — NOT NULL

rerun_item(재실행 목록) (rerun_item)

  • item_id — BIGINT — 기본 키 — NOT NULL
  • request_id — BIGINT — NOT NULL
  • news_id — VARCHAR(80) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • message — TEXT
  • updated_at — DATETIME — NOT NULL

rerun_request(재실행 요청메인) (rerun_request)

  • request_id — BIGINT — 기본 키 — NOT NULL
  • requested_by_user_id — BIGINT
  • category — VARCHAR(30) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • params — TEXT
  • executed_run_id — BIGINT
  • created_at — DATETIME — NOT NULL

user_action_log(회원관리로그페이지) (user_action_log)

  • action_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT
  • action_type — VARCHAR(30) — NOT NULL
  • session_id — VARCHAR(100)
  • keyword — VARCHAR(200)
  • keyword_date — DATE
  • period_type — VARCHAR(20)
  • news_id — VARCHAR(80)
  • payload — TEXT
  • occurred_at — DATETIME — NOT NULL

users(회원기본정보) (users)

  • user_id — BIGINT — 기본 키 — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL