MingleRoom
Tables (21)
action_items
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — NOT NULL
- assignee_id — BIGINT
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- due_date — DATE
- status — ENUM('TODO','DOING','DONE') — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
- done_at — DATETIME(3)
attachments
- id — BIGINT — Primary key — NOT NULL
- uploader_id — BIGINT
- file_name — VARCHAR(255) — NOT NULL
- mime_type — VARCHAR(100) — NOT NULL
- file_size — BIGINT — NOT NULL
- storage_provider — ENUM('S3','GCS','LOCAL') — NOT NULL
- storage_key — VARCHAR(512) — NOT NULL
- public_url — VARCHAR(1024)
- created_at — DATETIME(3) — NOT NULL
audit_logs
- id — BIGINT — Primary key — NOT NULL
- actor_id — BIGINT
- workspace_id — BIGINT
- room_id — BIGINT
- action — VARCHAR(80) — NOT NULL
- metadata — JSON
- ip — VARCHAR(64)
- user_agent — VARCHAR(255)
- created_at — DATETIME(3) — NOT NULL
bookmarks
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — NOT NULL
- created_by — BIGINT
- label — VARCHAR(120) — NOT NULL
- at_ms — INT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
chat_messages
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- message_type — ENUM('TEXT','FILE','IMAGE','BOARD_SNAPSHOT') — NOT NULL
- content — LONGTEXT
- attachment_id — BIGINT
- parent_id — BIGINT
- is_pinned — TINYINT(1) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- edited_at — DATETIME(3)
- deleted_at — DATETIME(3)
notes
- room_id — BIGINT — Primary key — NOT NULL
- content — LONGTEXT — NOT NULL
- updated_by — BIGINT
- updated_at — DATETIME(3) — NOT NULL
- version — INT — NOT NULL
poll_options
- id — BIGINT — Primary key — NOT NULL
- poll_id — BIGINT — NOT NULL
- label — VARCHAR(150) — NOT NULL
- sort_order — INT — NOT NULL
poll_votes
- id — BIGINT — Primary key — NOT NULL
- poll_id — BIGINT — NOT NULL
- option_id — BIGINT — NOT NULL
- voter_id — BIGINT
- voter_session_key — VARCHAR(64)
- voter_key — VARCHAR(80) — NOT NULL
- voter_id) — ELSE
- voter_session_key) — END
- created_at — DATETIME(3) — NOT NULL
polls
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — NOT NULL
- created_by — BIGINT
- question — VARCHAR(255) — NOT NULL
- is_anonymous — TINYINT(1) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- closed_at — DATETIME(3)
reports
- id — BIGINT — Primary key — NOT NULL
- reporter_id — BIGINT
- target_type — ENUM('USER','ROOM','MESSAGE') — NOT NULL
- target_id — BIGINT — NOT NULL
- reason — VARCHAR(80) — NOT NULL
- detail — TEXT
- status — ENUM('OPEN','IN_REVIEW','RESOLVED','REJECTED') — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- resolved_at — DATETIME(3)
room_events
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — NOT NULL
- actor_id — BIGINT
- event_type — ENUM('JOIN','LEAVE','MUTE','KICK','ROLE_CHANGE','HAND_UP','REACTION','NOTICE_PIN','NOTICE_UNPIN') — NOT NULL
- payload — JSON
- created_at — DATETIME(3) — NOT NULL
room_invites
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — NOT NULL
- created_by — BIGINT
- token — VARCHAR(128) — NOT NULL
- invite_type — ENUM('LINK','EMAIL') — NOT NULL
- invite_email — VARCHAR(255)
- expires_at — DATETIME(3)
- max_uses — INT — NOT NULL
- used_count — INT — NOT NULL
- default_role_in_room — ENUM('HOST','PRESENTER','MEMBER') — NOT NULL
- is_revoked — TINYINT(1) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
room_members
- room_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Primary key — NOT NULL
- role_in_room — ENUM('HOST','PRESENTER','MEMBER') — NOT NULL
- joined_at — DATETIME(3) — NOT NULL
- last_seen_at — DATETIME(3)
- is_muted — TINYINT(1) — NOT NULL
- hand_raised — TINYINT(1) — NOT NULL
rooms
- id — BIGINT — Primary key — NOT NULL
- workspace_id — BIGINT
- host_id — BIGINT — NOT NULL
- title — VARCHAR(150) — NOT NULL
- visibility — ENUM('PUBLIC','PRIVATE','TEAM') — NOT NULL
- password_hash — VARCHAR(255)
- invite_policy — ENUM('LINK','EMAIL','PASSWORD','MIXED') — NOT NULL
- is_locked — TINYINT(1) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
- ended_at — DATETIME(3)
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- username — VARCHAR(50) — NOT NULL
- profile_img — VARCHAR(1024)
- role_global — ENUM('USER','ADMIN') — NOT NULL
- is_banned — TINYINT(1) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
- last_login_at — DATETIME(3)
whiteboard_docs
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — NOT NULL
- title — VARCHAR(150) — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
whiteboard_pages
- id — BIGINT — Primary key — NOT NULL
- doc_id — BIGINT — NOT NULL
- page_no — INT — NOT NULL
- title — VARCHAR(150)
- created_at — DATETIME(3) — NOT NULL
whiteboard_snapshots
- id — BIGINT — Primary key — NOT NULL
- page_id — BIGINT — NOT NULL
- version — INT — NOT NULL
- data_blob — JSON — NOT NULL
- created_by — BIGINT
- created_at — DATETIME(3) — NOT NULL
whiteboard_updates
- id — BIGINT — Primary key — NOT NULL
- page_id — BIGINT — NOT NULL
- seq — BIGINT — NOT NULL
- yjs_update — LONGBLOB — NOT NULL
- created_by — BIGINT
- created_at — DATETIME(3) — NOT NULL
workspace_members
- workspace_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Primary key — NOT NULL
- role_in_workspace — ENUM('OWNER','MEMBER') — NOT NULL
- joined_at — DATETIME(3) — NOT NULL
workspaces
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- owner_id — BIGINT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL