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