1

Tables (13)

asset_store

  • asset_id — BIGINT
  • 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 — JSON
  • created_at — DATETIME — NOT NULL

batch_error_log

  • error_id — BIGINT
  • run_id — BIGINT — NOT NULL
  • step_run_id — BIGINT
  • news_id — VARCHAR(80)
  • fail_reason — VARCHAR(120)
  • error_code — VARCHAR(60)
  • message — TEXT
  • payload — JSON
  • occurred_at — DATETIME — NOT NULL
  • resolved_at — DATETIME
  • resolved_by_user_id — BIGINT

batch_job

  • job_id — BIGINT
  • target_id — BIGINT
  • job_code — VARCHAR(40) — NOT NULL
  • schedule_rule — VARCHAR(80)
  • status — VARCHAR(20) — NOT NULL
  • updated_at — DATETIME — NOT NULL

batch_job_step

  • step_id — BIGINT
  • 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_run

  • run_id — BIGINT
  • 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 — JSON
  • created_at — DATETIME — NOT NULL

batch_step_run

  • step_run_id — BIGINT
  • 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

  • target_id — BIGINT
  • target_name — VARCHAR(80) — NOT NULL
  • base_url — VARCHAR(500) — NOT NULL
  • query_template — VARCHAR(500)
  • min_article_count — INT — NOT NULL
  • window_start — TIME
  • window_end — TIME
  • required_fields — JSON
  • dedupe_rule — JSON
  • status — VARCHAR(20) — NOT NULL
  • updated_at — DATETIME — NOT NULL

econ_term

  • term_id — BIGINT
  • term — VARCHAR(200) — NOT NULL
  • description — TEXT
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

econ_term_audit

  • audit_id — BIGINT
  • term_id — BIGINT — NOT NULL
  • user_id — BIGINT
  • action_type — VARCHAR(30) — NOT NULL
  • before_json — JSON
  • after_json — JSON
  • occurred_at — DATETIME — NOT NULL

rerun_item

  • item_id — BIGINT
  • 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

  • request_id — BIGINT
  • requested_by_user_id — BIGINT
  • category — VARCHAR(30) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • params — JSON
  • executed_run_id — BIGINT
  • created_at — DATETIME — NOT NULL

user_action_log

  • action_id — BIGINT
  • user_id — BIGINT
  • username_input — VARCHAR(50)
  • action_type — VARCHAR(30) — NOT NULL
  • session_id — VARCHAR(100)
  • keyword — VARCHAR(200)
  • keyword_date — DATE
  • news_id — VARCHAR(80)
  • success — BOOLEAN
  • payload — JSON
  • occurred_at — DATETIME — NOT NULL

users

  • user_id — BIGINT
  • 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