3
Tables (6)
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_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
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
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
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