LingRing-v2

Tables (12)

call_analyses

  • id — BIGINT — Primary key — NOT NULL
  • call_id — BIGINT — Foreign key → calls.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • model_identifier — VARCHAR(128)
  • result — JSON
  • requested — BOOLEAN — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

call_recordings

  • id — BIGINT — Primary key — NOT NULL
  • call_id — BIGINT — Foreign key → calls.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • recording_key — VARCHAR(512) — NOT NULL
  • content_type — VARCHAR(100) — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • INDEX — idx_call_recordings_call_id
  • INDEX — idx_call_recordings_user_id

call_transcripts

  • id — BIGINT — Primary key — NOT NULL
  • call_id — BIGINT — Foreign key → calls.id — NOT NULL
  • content — JSON
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

calls

  • id — BIGINT — Primary key — NOT NULL
  • room_id — BINARY(16) — NOT NULL
  • user_a_id — BIGINT — Foreign key → users.id — NOT NULL
  • user_b_id — BIGINT — Foreign key → users.id — NOT NULL
  • started_at — DATETIME(6) — NOT NULL
  • ended_at — DATETIME(6)
  • duration_sec — BIGINT
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

icebreaker

  • id — BIGINT — Primary key — NOT NULL
  • expression — VARCHAR(500) — NOT NULL
  • meaning — VARCHAR(500) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

recommended_expression

  • id — BIGINT — Primary key — NOT NULL
  • expression — VARCHAR(500) — NOT NULL
  • meaning — VARCHAR(500) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

user_block

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • blocked_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • INDEX — idx_user_block_user_id

user_expression

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • expression — VARCHAR(500) — NOT NULL
  • meaning — VARCHAR(500) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • INDEX — idx_user_expression_user_created

user_report

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id
  • reported_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • reason — VARCHAR(255) — NOT NULL
  • description — VARCHAR(200) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • INDEX — idx_user_report_user_id
  • INDEX — idx_user_report_reported_user_id

user_stats

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • level — VARCHAR(255) — NOT NULL
  • manner_temperature — DECIMAL(4,1) — NOT NULL
  • total_call_count — INT — NOT NULL
  • current_streak_days — INT — NOT NULL
  • expression_count — INT — NOT NULL
  • last_study_date — DATE
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • provider — VARCHAR(255) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • profile_image — VARCHAR(500)
  • agreed_terms_version — VARCHAR(20)
  • agreed_at — DATETIME(6)
  • apple_refresh_token — VARCHAR(1024)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

withdrawal_log

  • id — BIGINT — Primary key — NOT NULL
  • reason — VARCHAR(255) — NOT NULL
  • description — VARCHAR(200)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL