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