tmp-lingring
Tables (8)
call_analyses
- id — BIGINT — Primary key — NOT NULL
- call_id — BIGINT — NOT NULL
- user_id — BIGINT — 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 — NOT NULL
- user_id — BIGINT — 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
calls
- id — BIGINT — Primary key — NOT NULL
- user_a_id — BIGINT — Foreign key → users.id — NOT NULL
- user_b_id — BIGINT — Foreign key → users.id — NOT NULL
- room_id — BINARY(16) — 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 — NOT NULL
- blocked_user_id — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- INDEX — idx_user_block_user_id
user_report
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT
- reported_user_id — BIGINT — 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
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