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