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