데이터 분석

테이블 (5)

batch_error_log

  • error_id
  • job_name — VARCHAR(50) — NOT NULL
  • step — VARCHAR(30) — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL
  • target_id — VARCHAR(100)
  • error_code — VARCHAR(50) — NOT NULL
  • message — TEXT — NOT NULL
  • occurred_at — DATETIME — NOT NULL
  • context — JSON
  • Field
  • run_id (Key) — PK — 외래 키 → batch_run.run_id — NOT NULL

batch_run

  • run_id (Key) — PK — 기본 키 — NOT NULL
  • job_name — VARCHAR(50) — NOT NULL
  • trigger_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • started_at — DATETIME — NOT NULL
  • ended_at — DATETIME
  • range_start_at — DATETIME
  • range_end_at — DATETIME

login_log

  • login_log_id — BIGINT
  • fail_count — INT — NOT NULL
  • state — VARCHAR(20) — NOT NULL
  • last_attempt_at — DATETIME — NOT NULL
  • locked_until — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • user_id (Key) — 외래 키 → users.user_id — NOT NULL

user_page_log

  • user_id (Key) — 외래 키 → users.user_id — NOT NULL

users

  • user_id (Key) — 기본 키 — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • birth_date — DATE — NOT NULL