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