partyup
Tables (31)
admin_activity_logs
- id — BIGSERIAL
- admin_id — UUID — Foreign key → users.id — NOT NULL
- action — VARCHAR(100) — NOT NULL
- target_type — VARCHAR(30)
- target_id — UUID
- detail — JSONB
- ip_address — INET
- created_at — TIMESTAMPTZ — NOT NULL
behavior_embeddings
- id — UUID
- session_id — UUID — Foreign key → captcha_sessions.id — NOT NULL
- embedding — vector(15) — NOT NULL
- label — VARCHAR(10) — NOT NULL
- lstm_score — FLOAT
- sequence_length — INTEGER
- model_version — VARCHAR(50)
- created_at — TIMESTAMPTZ — NOT NULL
captcha_2fa_missions
- id — UUID
- session_id — UUID — Foreign key → captcha_sessions.id — NOT NULL
- mission_type — VARCHAR(30) — NOT NULL
- mission_data — JSONB — NOT NULL
- nonce — VARCHAR(255) — NOT NULL
- max_attempts — INTEGER — NOT NULL
- attempt_count — INTEGER — NOT NULL
- status — VARCHAR(20) — NOT NULL
- mission_score — FLOAT
- expires_at — TIMESTAMPTZ — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
captcha_final_results
- id — UUID
- session_id — UUID — Foreign key → captcha_sessions.id — NOT NULL
- behavior_score — FLOAT
- mission_score — FLOAT
- liveness_score — FLOAT
- final_score — FLOAT — NOT NULL
- result — VARCHAR(10) — NOT NULL
- jwt_token — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
captcha_hard_bans
- id — UUID
- ip_hash — VARCHAR(64) — NOT NULL
- ua_hash — VARCHAR(64)
- fingerprint_hash — VARCHAR(64)
- reason — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
captcha_sessions
- id — UUID
- client_ip — INET — NOT NULL
- user_agent — TEXT
- ja3_fingerprint — VARCHAR(255)
- behavior_score — FLOAT
- rule_score — FLOAT
- knn_score — FLOAT
- lstm_score — FLOAT
- score_breakdown — JSONB
- result — VARCHAR(20) — NOT NULL
- captcha_set_id — UUID — Foreign key → captcha_sets.id
- challenge_result — VARCHAR(20)
- solve_time_ms — INTEGER
- lstm_model_id — UUID — Foreign key → ml_models.id
- require_2fa — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- expires_at — TIMESTAMPTZ
captcha_sets
- id — UUID
- category — VARCHAR(50) — NOT NULL
- emoji_ids — UUID — NOT NULL
- photo_ids — UUID — NOT NULL
- answer_indices — INTEGER — NOT NULL
- difficulty — VARCHAR(10)
- usage_count — INTEGER — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
captcha_soft_bans
- id — UUID
- client_ip — INET — NOT NULL
- fingerprint — VARCHAR(255)
- fail_count — INTEGER — NOT NULL
- ban_count — INTEGER — NOT NULL
- locked_until — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
categories
- id — SERIAL
- name — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
chat_messages
- id — UUID
- party_id — UUID — Foreign key → parties.id — NOT NULL
- sender_id — UUID — Foreign key → users.id
- content — TEXT — NOT NULL
- msg_type — VARCHAR(20) — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
chat_moderation_logs
- id — BIGSERIAL
- message_id — UUID — Foreign key → chat_messages.id — NOT NULL
- party_id — UUID — Foreign key → parties.id — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- level — VARCHAR(10) — NOT NULL
- reason — TEXT
- confidence — FLOAT
- response_ms — INTEGER
- model_version — VARCHAR(100)
- created_at — TIMESTAMPTZ — NOT NULL
chat_room_logs
- id — BIGSERIAL
- party_id — UUID — Foreign key → parties.id — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- action — VARCHAR(10) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
dataset_images
- id — UUID
- category — VARCHAR(50) — NOT NULL
- image_key — VARCHAR(255) — NOT NULL
- source — VARCHAR(30) — NOT NULL
- yolo_confidence — FLOAT
- is_adversarial — BOOLEAN — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
emoji_images
- id — UUID
- category — VARCHAR(50) — NOT NULL
- image_key — VARCHAR(255) — NOT NULL
- difficulty — VARCHAR(10)
- clip_confidence — FLOAT
- ssim_score — FLOAT
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
error_logs
- id — BIGSERIAL
- error_type — VARCHAR(100) — NOT NULL
- error_message — TEXT
- stack_trace — TEXT
- request_method — VARCHAR(10)
- request_path — VARCHAR(500)
- user_id — UUID — Foreign key → users.id
- ip_address — INET
- created_at — TIMESTAMPTZ — NOT NULL
ml_models
- id — UUID
- model_name — VARCHAR(100) — NOT NULL
- model_type — VARCHAR(50) — NOT NULL
- model_path — VARCHAR(255) — NOT NULL
- version — INTEGER — NOT NULL
- accuracy — FLOAT
- precision_score — FLOAT
- recall_score — FLOAT
- is_active — BOOLEAN — NOT NULL
- training_samples — INTEGER
- config — JSONB
- created_at — TIMESTAMPTZ — NOT NULL
- activated_at — TIMESTAMPTZ
notifications
- id — UUID
- user_id — UUID — Foreign key → users.id — NOT NULL
- type — VARCHAR(50) — NOT NULL
- title — VARCHAR(200)
- message — TEXT — NOT NULL
- ref_type — VARCHAR(30)
- ref_id — UUID
- is_read — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
parties
- id — UUID
- leader_id — UUID — Foreign key → users.id — NOT NULL
- category_id — INTEGER — Foreign key → categories.id
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- max_members — INTEGER — NOT NULL
- amount — INTEGER — NOT NULL
- status — VARCHAR(20) — NOT NULL
- end_date — DATE
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
party_activity_logs
- id — BIGSERIAL
- party_id — UUID — Foreign key → parties.id — NOT NULL
- user_id — UUID — Foreign key → users.id
- action — VARCHAR(50) — NOT NULL
- detail — JSONB
- created_at — TIMESTAMPTZ — NOT NULL
party_members
- id — UUID
- party_id — UUID — Foreign key → parties.id — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- role — VARCHAR(20) — NOT NULL
- joined_at — TIMESTAMPTZ — NOT NULL
- left_at — TIMESTAMPTZ
payment_logs
- id — BIGSERIAL
- payment_id — UUID — Foreign key → payments.id — NOT NULL
- prev_status — VARCHAR(20)
- new_status — VARCHAR(20) — NOT NULL
- changed_by — UUID — Foreign key → users.id
- detail — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
payments
- id — UUID
- party_id — UUID — Foreign key → parties.id — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- amount — INTEGER — NOT NULL
- status — VARCHAR(20) — NOT NULL
- receipt_image — VARCHAR(500)
- ocr_result — JSONB
- ocr_amount — INTEGER
- reviewed_by — UUID — Foreign key → users.id
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
real_photos
- id — UUID
- category — VARCHAR(50) — NOT NULL
- image_key — VARCHAR(255) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
refresh_tokens
- id — UUID
- user_id — UUID — Foreign key → users.id — NOT NULL
- token — VARCHAR(500) — NOT NULL
- expires_at — TIMESTAMPTZ — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
report_analysis_logs
- id — BIGSERIAL
- report_id — UUID — Foreign key → reports.id — NOT NULL
- severity — VARCHAR(20) — NOT NULL
- category — VARCHAR(50)
- summary — TEXT
- action_suggest — TEXT
- model_version — VARCHAR(100)
- created_at — TIMESTAMPTZ — NOT NULL
reports
- id — UUID
- reporter_id — UUID — Foreign key → users.id — NOT NULL
- target_user_id — UUID — Foreign key → users.id
- target_party_id — UUID — Foreign key → parties.id
- target_msg_id — UUID — Foreign key → chat_messages.id
- report_type — VARCHAR(20) — NOT NULL
- reason — TEXT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- processed_by — UUID — Foreign key → users.id
- processed_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
settlements
- id — UUID
- party_id — UUID — Foreign key → parties.id — NOT NULL
- total_amount — INTEGER — NOT NULL
- status — VARCHAR(20) — NOT NULL
- processed_by — UUID — Foreign key → users.id
- processed_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
token_blacklist
- id — BIGSERIAL
- token_jti — VARCHAR(255) — NOT NULL
- expires_at — TIMESTAMPTZ — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
training_mouse_events
- id — BIGSERIAL
- session_id — UUID — Foreign key → captcha_sessions.id — NOT NULL
- events — JSONB — NOT NULL
- label — VARCHAR(10) — NOT NULL
- feature_hash — VARCHAR(64)
- is_exported — BOOLEAN — NOT NULL
- collected_at — TIMESTAMPTZ — NOT NULL
trust_score_logs
- id — BIGSERIAL
- user_id — UUID — Foreign key → users.id — NOT NULL
- prev_score — INTEGER — NOT NULL
- new_score — INTEGER — NOT NULL
- change — INTEGER — NOT NULL
- reason — VARCHAR(100) — NOT NULL
- ref_id — UUID
- created_at — TIMESTAMPTZ — NOT NULL
users
- id — UUID
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- nickname — VARCHAR(50) — NOT NULL
- bio — TEXT
- profile_image — VARCHAR(500)
- provider — VARCHAR(20) — NOT NULL
- provider_id — VARCHAR(255)
- role — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- trust_score — INTEGER — NOT NULL
- suspended_until — TIMESTAMPTZ
- last_login_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted_at — TIMESTAMPTZ