.
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