c

Tables (6)

ban_list

  • id — BIGSERIAL — Primary key — NOT NULL
  • identifier_hash — VARCHAR(255) — NOT NULL
  • ban_type — VARCHAR(10)
  • reason — TEXT
  • created_at — TIMESTAMP

captcha_images

  • id — BIGSERIAL — Primary key — NOT NULL
  • 이미지 주소 (minio_path) — VARCHAR(500) — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • animal — VARCHAR(30) — NOT NULL
  • is_active — BOOLEAN
  • created_at — TIMESTAMP

captcha_missions

  • id — BIGSERIAL — Primary key — NOT NULL
  • session_uuid — UUID — Foreign key → captcha_sessions.아이디 — NOT NULL
  • hint_image_ids — JSONB — NOT NULL
  • grid_image_ids — JSONB — NOT NULL
  • answer_sequence — JSONB — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP

captcha_sessions

  • 아이디 — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • session_uuid — UUID — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • risk_score — INTEGER
  • attempts — INTEGER
  • max_attempts — INTEGER
  • expires_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP

mouse_patterns

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key
  • session_id — VARCHAR(100)
  • vector — vector(128)
  • label — VARCHAR(10)
  • risk_score — INTEGER
  • raw_data — JSONB
  • created_at — TIMESTAMP

users

  • id — BIGSERIAL — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(50)
  • password_hash — VARCHAR(255)
  • status — VARCHAR(20) — NOT NULL
  • trust_score — INTEGER
  • profile_image_url — VARCHAR(500)
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP