test
Tables (16)
banners
- banner_id — CHAR(36) — Primary key — NOT NULL
- type — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- position — VARCHAR(30)
- is_active — BOOLEAN — NOT NULL
- style — JSON
- created_at — DATETIME — NOT NULL
- studio_id — CHAR(36) — NOT NULL
clips
- clip_id — CHAR(36) — Primary key — NOT NULL
- recording_id — CHAR(36) — NOT NULL
- title — VARCHAR(150) — NOT NULL
- start_time_sec — INT — NOT NULL
- end_time_sec — INT — NOT NULL
- duration_sec — INT — NOT NULL
- format — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- url — VARCHAR(500)
- thumbnail_url — VARCHAR(500)
- srt_url — VARCHAR(500)
- created_at — TIMESTAMP — NOT NULL
- expires_at — TIMESTAMP
connected_destinations
- destination_id — CHAR(36) — Primary key — NOT NULL
- platform — VARCHAR(20) — NOT NULL
- channel_id — VARCHAR(100) — NOT NULL
- channel_name — VARCHAR(100) — NOT NULL
- profile_image_url — VARCHAR(500)
- is_connected — BOOLEAN — NOT NULL
- connected_at — DATETIME — NOT NULL
- user_id — CHAR(36) — NOT NULL
markers
- marker_id — CHAR(36) — Primary key — NOT NULL
- timestamp_sec — INT — NOT NULL
- label — VARCHAR(100)
- color — VARCHAR(10) — NOT NULL
- created_by_user_id — CHAR(36) — NOT NULL
- created_at — DATETIME — NOT NULL
- studio_id — CHAR(36) — NOT NULL
- recording_id — CHAR(36) — NOT NULL
member_invites
- invite_id — CHAR(36) — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- expires_at — DATETIME
- created_at — DATETIME — NOT NULL
- studio_id — CHAR(36) — NOT NULL
publish_destinations
- publish_destination_id — BIGINT — Primary key — NOT NULL
- publish_id — CHAR(36)
- platform — VARCHAR(20) — NOT NULL
- channel_name — VARCHAR(100)
- rtmp_url — VARCHAR(500) — NOT NULL
- stream_key — VARCHAR(255) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- connected_at — TIMESTAMP
- disconnected_at — TIMESTAMP
- error_message — TEXT
publish_sessions
- publish_id — CHAR(36) — Primary key — NOT NULL
- studio_id — CHAR(36) — NOT NULL
- requested_by_user_id — CHAR(36) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- started_at — TIMESTAMP
- stopped_at — TIMESTAMP
- error_message — TEXT
- created_at — TIMESTAMP — NOT NULL
recordings
- recording_id — CHAR(36) — Primary key — NOT NULL
- studio_id — CHAR(36) — NOT NULL
- owner_user_id — CHAR(36) — NOT NULL
- publish_id — CHAR(36)
- title — VARCHAR(100) — NOT NULL
- quality — VARCHAR(20) — NOT NULL
- storage — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- duration_sec — INT
- file_size — BIGINT
- url — VARCHAR(500)
- thumbnail_url — VARCHAR(500)
- created_at — TIMESTAMP — NOT NULL
- started_at — TIMESTAMP
- stopped_at — TIMESTAMP
refresh_token
- token_id — CHAR(36) — Primary key — NOT NULL
- refresh_token — VARCHAR(500)
- expires_at — DATETIME
- revoked — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- user_id — CHAR(36) — NOT NULL
scene_sources
- source_id — CHAR(36) — Primary key — NOT NULL
- type — VARCHAR(20) — NOT NULL
- position — JSON — NOT NULL
- meta — JSON
- scene_id — CHAR(36) — NOT NULL
scenes
- scene_id — CHAR(36) — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- layout — VARCHAR(20) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- studio_id — CHAR(36) — NOT NULL
studio
- studio_id — CHAR(36) — Primary key — NOT NULL
- title — VARCHAR(100)
- description — TEXT
- status — VARCHAR(20) — upcoming/live/ended
- scheduled_at — DATETIME — NOT NULL
- started_at — DATETIME
- ended_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- owner_user_id — CHAR(36) — NOT NULL
studio_destination_map
- map_id — CHAR(36) — Primary key — NOT NULL
- destination_id — CHAR(36) — NOT NULL
- studio_id — CHAR(36) — NOT NULL
studio_members
- member_id — CHAR(36) — Primary key — NOT NULL
- role — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- joined_at — DATETIME — NOT NULL
- studio_id — CHAR(36) — NOT NULL
- user_id — CHAR(36) — NOT NULL
users
- user_id — CHAR(36) — Primary key — NOT NULL
- id — VARCHAR(255)
- password — VARCHAR(255)
- name — VARCHAR(50)
- nickname — VARCHAR(50)
- profile_image_url — VARCHAR(500)
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
webrtc_sessions
- session_id — CHAR(36) — Primary key — NOT NULL
- studio_id — CHAR(36) — NOT NULL
- user_id — CHAR(36) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- token — VARCHAR(500) — NOT NULL
- server_url — VARCHAR(255) — NOT NULL
- expires_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP — NOT NULL