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