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