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