V-shift
Tables (7)
channels
- user_id — BIGINT — Foreign key → users.user_id
- channel_key — VARCHAR(100) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- visibility — ENUM('PUBLIC', 'UNLISTED', 'PRIVATE') — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
chat_messages
- message_id — BIGINT
- channel_id — BIGINT — NOT NULL
- session_id — BIGINT
- user_id — BIGINT
- message_type — ENUM('TEXT', 'SYSTEM') — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- INDEX — idx_chat_channel_created
- INDEX — idx_chat_session_created
session_participants
- participant_id — BIGINT
- session_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- role — ENUM('HOST', 'MODERATOR') — NOT NULL
- joined_at — TIMESTAMP — NOT NULL
- left_at — TIMESTAMP
- leave_reason — VARCHAR(255)
- kicked — BOOLEAN — NOT NULL
- INDEX — idx_participants_session
- INDEX — idx_participants_user
stream_sessions
- session_id — BIGINT — Primary key
- status — ENUM('STARTING', 'LIVE', 'ENDED', 'FAILED') — NOT NULL
- started_at — TIMESTAMP
- ended_at — TIMESTAMP
- stop_reason — VARCHAR(255)
- media_server_id — VARCHAR(100)
- pipeline_id — VARCHAR(120)
- viewer_peak — INT — NOT NULL
- viewer_total — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- host_user_id (owner_user_id) — BIGINT — Foreign key → channels.user_id
stream_voice_configs
- config_id — BIGINT
- session_id — BIGINT — NOT NULL
- voice_model_id — BIGINT — NOT NULL
- rvc_enabled — BOOLEAN — NOT NULL
- transpose — INT — NOT NULL
- index_rate — FLOAT — NOT NULL
- protect_rate — FLOAT — NOT NULL
- rms_mix_rate — FLOAT — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- INDEX — idx_voice_cfg_model
users
- user_id — BIGINT — Primary key
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- nickname — VARCHAR(50) — NOT NULL
- role — ENUM('HOST', 'ADMIN') — NOT NULL
- status — ENUM('ACTIVE', 'BLOCKED', 'DELETED') — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
voice_models
- voice_model_id — BIGINT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- storage_uri — VARCHAR(500) — NOT NULL
- sample_uri — VARCHAR(500)
- created_by_user_id — BIGINT — NOT NULL
- is_public — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- INDEX — idx_voice_models_creator