데이터 분석
테이블 (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