.

Tables (27)

blocks

  • block_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.user_id — NOT NULL
  • target_user_id — UUID — Foreign key → users.user_id — NOT NULL
  • reason — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

call_checkpoint

  • id — UUID — Primary key — NOT NULL
  • match_history_id — UUID — Foreign key → match_history.id — NOT NULL
  • round — INT — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • triggered_at — TIMESTAMP — NOT NULL
  • resolved_at — TIMESTAMP
  • volunteer_user_id — UUID
  • resolution_type — VARCHAR(32)
  • version — BIGINT

call_participations

  • participation_id — BIGSERIAL — Primary key — NOT NULL
  • match_history_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • joined_at — TIMESTAMP — NOT NULL
  • left_at — TIMESTAMP
  • disconnect_reason — VARCHAR(50)
  • created_at — TIMESTAMP — NOT NULL

consents

  • consent_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.user_id
  • type — VARCHAR(50) — NOT NULL
  • version — VARCHAR(20) — NOT NULL
  • agreed — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

daily_metric_snapshots

  • metric_date — DATE — Primary key — NOT NULL
  • metric_key — VARCHAR(100) — Primary key — NOT NULL
  • dimension_key — VARCHAR(255) — Primary key — NOT NULL
  • metric_value — NUMERIC(30, 6) — NOT NULL
  • calculated_at — TIMESTAMP — NOT NULL
  • calculation_version — VARCHAR(30) — NOT NULL

device_tokens

  • device_token_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.user_id — NOT NULL
  • token — VARCHAR(500) — NOT NULL
  • device_type — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

hobbies

  • hobby_id — BIGSERIAL — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • sub_category — VARCHAR(30) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

iap_purchases

  • id — BIGSERIAL — Primary key — NOT NULL
  • version — BIGINT — NOT NULL
  • user_id — UUID — Foreign key → users.user_id — NOT NULL
  • purchase_token — VARCHAR(512) — NOT NULL
  • product_id — VARCHAR(100) — NOT NULL
  • order_id — VARCHAR(200)
  • purchase_state — VARCHAR(20) — NOT NULL
  • consume_state — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • tickets_granted — INT — NOT NULL
  • raw_response — TEXT
  • consume_retry_count — INT — NOT NULL
  • next_retry_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

likes

  • like_id — BIGSERIAL — Primary key — NOT NULL
  • liked_user_id — UUID — Foreign key → users.user_id — NOT NULL
  • like_user_id — UUID — Foreign key → users.user_id — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

match_attempts

  • attempt_id — UUID — Primary key — NOT NULL
  • client_request_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • requested_at — TIMESTAMP — NOT NULL
  • enqueued_at — TIMESTAMP
  • finished_at — TIMESTAMP
  • wait_ms — BIGINT
  • result — VARCHAR(20) — NOT NULL
  • failure_reason — VARCHAR(50)
  • match_mode — VARCHAR(20)
  • matched_phase — INT
  • match_history_id — UUID
  • created_at — TIMESTAMP — NOT NULL

match_history

  • id — UUID — Primary key — NOT NULL
  • user_a_id — UUID — Foreign key → users.user_id — NOT NULL
  • user_b_id — UUID — Foreign key → users.user_id — NOT NULL
  • matched_at — TIMESTAMP — NOT NULL
  • match_duration_ms — INT
  • room_id — UUID
  • call_ended_at — TIMESTAMP
  • call_force_ended — BOOLEAN — NOT NULL

match_proposals

  • proposal_id — UUID — Primary key — NOT NULL
  • actor_user_id — UUID — NOT NULL
  • target_user_id — UUID — NOT NULL
  • attempt_id — UUID — Foreign key → match_attempts.attempt_id
  • proposed_at — TIMESTAMP — NOT NULL
  • responded_at — TIMESTAMP
  • result — VARCHAR(20) — NOT NULL
  • reason — VARCHAR(50)
  • created_at — TIMESTAMP — NOT NULL

match_queue

  • queue_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • hobby_ids — BIGINT
  • location — VARCHAR(50)
  • birth_year — INT
  • gender — VARCHAR(10)
  • created_at — TIMESTAMP — NOT NULL

notifications

  • notification_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.user_id
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • sent_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

purchase_refunds

  • refund_id — BIGSERIAL — Primary key — NOT NULL
  • iap_purchase_id — BIGINT — NOT NULL
  • external_refund_id — VARCHAR(255)
  • refunded_amount_minor — BIGINT
  • currency_code — VARCHAR(3)
  • reason — VARCHAR(255)
  • refunded_at — TIMESTAMP — NOT NULL
  • raw_payload — TEXT
  • created_at — TIMESTAMP — NOT NULL

reports

  • report_id — BIGSERIAL — Primary key — NOT NULL
  • reporter_id — UUID — Foreign key → users.user_id — NOT NULL
  • target_user_id — UUID — Foreign key → users.user_id — NOT NULL
  • room_id — VARCHAR(255)
  • category — VARCHAR(32) — NOT NULL
  • reason_text — VARCHAR(1000)
  • status — VARCHAR(32) — NOT NULL
  • handled_at — TIMESTAMP
  • canceled_at — TIMESTAMP
  • handled_by — UUID — Foreign key → users.user_id
  • resolution — VARCHAR(1000)
  • action — VARCHAR(32)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

subscription_events

  • subscription_event_id — BIGSERIAL — Primary key — NOT NULL
  • subscription_id — BIGINT — Foreign key → subscriptions.subscription_id — NOT NULL
  • event_type — VARCHAR(40) — NOT NULL
  • occurred_at — TIMESTAMP — NOT NULL
  • external_event_id — VARCHAR(255)
  • raw_payload — TEXT
  • created_at — TIMESTAMP — NOT NULL

subscriptions

  • subscription_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • store — VARCHAR(20) — NOT NULL
  • product_id — VARCHAR(100) — NOT NULL
  • purchase_token — VARCHAR(512) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • started_at — TIMESTAMP — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • auto_renewing — BOOLEAN — NOT NULL
  • canceled_at — TIMESTAMP
  • refunded_at — TIMESTAMP
  • grace_period_until — TIMESTAMP
  • raw_response — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

terms

  • term_id — BIGSERIAL — Primary key — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • version — VARCHAR(20) — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content_url — VARCHAR(500)
  • is_required — BOOLEAN — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

ticket_ledger

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.user_id — NOT NULL
  • delta — INT — NOT NULL
  • reason — VARCHAR(30) — NOT NULL
  • ref_id — VARCHAR(200)
  • idempotency_key — VARCHAR(600) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

ticket_wallet

  • user_id — UUID — Foreign key → users.user_id — NOT NULL
  • balance — INT — NOT NULL
  • version — BIGINT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

user_activity_sessions

  • activity_session_id — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • device_id — VARCHAR(255) — NOT NULL
  • started_at — TIMESTAMP — NOT NULL
  • last_heartbeat_at — TIMESTAMP — NOT NULL
  • ended_at — TIMESTAMP
  • active_seconds — BIGINT — NOT NULL
  • end_reason — VARCHAR(30)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

user_daily_activity

  • user_id — UUID — Primary key — NOT NULL
  • activity_date — DATE — Primary key — NOT NULL
  • active_seconds — BIGINT — NOT NULL
  • calculated_at — TIMESTAMP — NOT NULL

user_hobbies

  • user_hobby_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.user_id — NOT NULL
  • hobby_id — BIGINT — Foreign key → hobbies.hobby_id — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

user_score_history

  • score_history_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • score_type — VARCHAR(30) — NOT NULL
  • delta — INT — NOT NULL
  • score_after — INT — NOT NULL
  • reason — VARCHAR(50) — NOT NULL
  • source_type — VARCHAR(50)
  • source_id — VARCHAR(255)
  • calculation_version — VARCHAR(30) — NOT NULL
  • occurred_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

user_scores

  • user_id — UUID — Primary key — NOT NULL
  • activity_score — INT — NOT NULL
  • reliability_score — INT — NOT NULL
  • manner_score — INT — NOT NULL
  • contribution_score — INT — NOT NULL
  • vip_score — INT — NOT NULL
  • total_score — INT — NOT NULL
  • calculation_version — VARCHAR(30) — NOT NULL
  • calculated_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • user_id — UUID — Primary key — NOT NULL
  • nickname — VARCHAR(20)
  • birth_date — DATE
  • gender — VARCHAR(20)
  • role — VARCHAR(20) — NOT NULL
  • region — VARCHAR(50)
  • phone_number — VARCHAR(20)
  • reputation — INT — NOT NULL
  • social_type — VARCHAR(20) — NOT NULL
  • social_id — VARCHAR(255)
  • status — VARCHAR(20) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • ci_hmac — VARCHAR(255)
  • identity_verified_at — TIMESTAMP
  • attendance_streak — INT — NOT NULL
  • last_attended_at — DATE
  • like_count — INT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP