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