project
Tables (15)
analysis_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
analysis_rerun_request
- request_id — BIGINT
- requested_by_user_id — BIGINT
- category — VARCHAR(30) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- executed_run_id — BIGINT
- created_at — DATETIME — NOT NULL
asset_store
- asset_id — BIGINT
- asset_type — VARCHAR(30) — NOT NULL
- keyword — VARCHAR(200)
- period_start — DATE
- period_end — DATE
- file_path — VARCHAR(500) — NOT NULL
- created_by_user_id — BIGINT
- created_at — DATETIME — NOT NULL
batch_error_log
- error_id — BIGINT
- run_id — BIGINT — NOT NULL
- step_run_id — BIGINT
- step_code — VARCHAR(20)
- job_name — VARCHAR(80)
- news_id — VARCHAR(80)
- error_code — VARCHAR(60)
- message — TEXT
- fail_reason — VARCHAR(120)
- payload — JSON
- occurred_at — DATETIME — NOT NULL
- resolved_at — DATETIME
- resolved_by_user_id — BIGINT
batch_run
- run_id — BIGINT
- job_name — VARCHAR(80) — NOT NULL
- trigger_type — VARCHAR(20) — NOT NULL
- requested_by_user_id — BIGINT
- 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)
- created_at — DATETIME — NOT NULL
batch_step_run
- step_run_id — BIGINT
- run_id — BIGINT — NOT NULL
- step_code — VARCHAR(20) — NOT NULL
- step_name — VARCHAR(120)
- 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
economic_term
- term_id — BIGINT
- term — VARCHAR(200) — NOT NULL
- description — TEXT
- status — VARCHAR(20) — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
fail_reason_agg
- agg_id — BIGINT
- run_id — BIGINT — NOT NULL
- step_code — VARCHAR(20) — NOT NULL
- fail_reason — VARCHAR(120) — NOT NULL
- cnt — INT — NOT NULL
login_attempt
- attempt_id — BIGINT
- user_id — BIGINT
- username_input — VARCHAR(50)
- fail_count — INT — NOT NULL
- success — BOOLEAN — NOT NULL
- state — VARCHAR(30)
- ip — VARCHAR(45)
- user_agent — VARCHAR(255)
- occurred_at — DATETIME — NOT NULL
page_log
- page_log_id — BIGINT
- user_id — BIGINT
- session_id — VARCHAR(100)
- prev_page — VARCHAR(255)
- next_page — VARCHAR(255)
- occurred_at — DATETIME — NOT NULL
user_keyword_log
- log_id — BIGINT
- user_id — BIGINT
- keyword — VARCHAR(200) — NOT NULL
- keyword_date — DATE
- period_type — VARCHAR(20)
- occurred_at — DATETIME — NOT NULL
user_news_log
- log_id — BIGINT
- user_id — BIGINT
- keyword — VARCHAR(200)
- keyword_date — DATE
- news_id — VARCHAR(80) — NOT NULL
- occurred_at — DATETIME — NOT NULL
user_summary_log
- log_id — BIGINT
- user_id — BIGINT
- keyword — VARCHAR(200)
- keyword_date — DATE
- news_id — VARCHAR(80) — NOT NULL
- summary_type — VARCHAR(30)
- occurred_at — DATETIME — NOT NULL
user_term_bookmark
- bookmark_id — BIGINT
- user_id — BIGINT — NOT NULL
- term_id — BIGINT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_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
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL