4

Tables (15)

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
  • 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 — JSON
  • occurred_at — DATETIME — NOT NULL
  • resolved_at — DATETIME
  • resolved_by_user_id — BIGINT

batch_job

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

  • 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)
  • critical_driver — VARCHAR(80)
  • params — JSON
  • created_at — DATETIME — NOT NULL

batch_step_def

  • 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_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)
  • timezone — VARCHAR(40) — NOT NULL
  • min_article_count — INT — NOT NULL
  • window_start — TIME
  • window_end — TIME
  • required_fields — JSON
  • dedupe_rule — JSON
  • parse_rule — JSON
  • status — VARCHAR(20) — NOT NULL
  • updated_at — DATETIME — NOT NULL

econ_knowledge

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

issue_digest

  • digest_id — BIGINT
  • period_type — VARCHAR(20) — NOT NULL
  • period_start — DATE — NOT NULL
  • period_end — DATE — NOT NULL
  • keyword — VARCHAR(200) — NOT NULL
  • summary_text — TEXT — NOT NULL
  • source_meta — JSON
  • created_by_user_id — BIGINT
  • created_at — DATETIME — NOT NULL

login_log

  • login_id — BIGINT
  • user_id — BIGINT
  • username_input — VARCHAR(50) — NOT NULL
  • success — BOOLEAN — NOT NULL
  • fail_count_snapshot — INT
  • ip — VARCHAR(45)
  • user_agent — VARCHAR(255)
  • occurred_at — DATETIME — NOT NULL

news_ref

  • news_id — VARCHAR(80)
  • published_date — DATE
  • url — VARCHAR(600)
  • press — VARCHAR(120)
  • title — VARCHAR(500)
  • created_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
  • 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 — JSON
  • occurred_at — DATETIME — NOT NULL

users

  • user_id — BIGINT
  • username — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100)
  • email — VARCHAR(255)
  • phone — VARCHAR(30)
  • birth_date — DATE
  • gender — VARCHAR(20)
  • knowledge_level — TINYINT
  • status — VARCHAR(20) — NOT NULL
  • login_fail_count — INT — NOT NULL
  • locked_until — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL