recaps
Tables (6)
ban_list
- id — BIGSERIAL
- identifier_hash — VARCHAR(255) — NOT NULL
- ban_type — VARCHAR(10) — SOFT
- reason — TEXT
- created_at — TIMESTAMP
captcha_images
- id — BIGSERIAL
- minio_path — VARCHAR(500) — NOT NULL
- type — VARCHAR(20) — NOT NULL — 3d_hint
- animal — VARCHAR(30) — NOT NULL — 동물
- is_active — BOOLEAN — FALSE면
- created_at — TIMESTAMP
captcha_missions
- id — BIGSERIAL
- session_uuid — UUID — Foreign key → captcha_sessions.session_uuid — NOT NULL
- attempt_number — INTEGER — NOT NULL
- hint_image_ids — JSONB — NOT NULL — 힌트
- hint_animals — JSONB — NOT NULL — 힌트
- grid_image_ids — JSONB — NOT NULL — 선택지
- answer_sequence — JSONB — NOT NULL — 정답
- is_active — BOOLEAN — NOT NULL — 현재
- created_at — TIMESTAMP
- Key — Foreign key → captcha_sessions.Key — NOT NULL
captcha_sessions
- id — BIGSERIAL
- user_id — BIGINT — Foreign key — NOT NULL
- session_uuid — UUID — NOT NULL
- status — VARCHAR(20) — NOT NULL — PENDING
- risk_score — INTEGER — 행동
- attempts — INTEGER — 현재까지
- max_attempts — INTEGER — 최대
- expires_at — TIMESTAMP — NOT NULL — 세션
- created_at — TIMESTAMP
- Key — Foreign key → users.id — NOT NULL
mouse_patterns
- id — BIGSERIAL
- user_id — BIGINT — Foreign key
- session_id — VARCHAR(100) — captcha_sessions.session_uuid
- vector — vector(128) — 128차원
- label — VARCHAR(10) — human
- risk_score — INTEGER — 해당
- raw_data — JSONB — 원본
- created_at — TIMESTAMP
- Key — Foreign key → users.id — NOT NULL
users
- id (Key) — BIGSERIAL — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL — 이메일
- nickname — VARCHAR(50)
- password_hash — VARCHAR(255)
- status — VARCHAR(20) — NOT NULL — ACTIVE
- trust_score — INTEGER — 신뢰도
- profile_image_url — VARCHAR(500)
- is_deleted — BOOLEAN
- created_at — TIMESTAMP