logo
ExamplesEditorPricingDocs
37.1kSign in

Zoom video meetings database schema

How a video meeting platform models its data: accounts and assigned licences, a meeting series separated from its materialised occurrences, registrations, participant join and leave intervals, breakout rooms, recordings, in-meeting chat and waiting room admissions.

Zoom ER diagram

Zoom video meetings database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 accounts idBIGINT nameVARCHAR plan_tierVARCHAR seat_countINTEGER default_timezoneVARCHAR storage_quota_mbBIGINT created_atTIMESTAMP users idBIGINT account_idBIGINT emailVARCHAR full_nameVARCHAR personal_meeting_…VARCHAR timezoneVARCHAR roleVARCHAR statusVARCHAR created_atTIMESTAMP licenses idBIGINT account_idBIGINT assigned_user_idBIGINT kindVARCHAR max_participantsINTEGER max_duration_minu…INTEGER assigned_atTIMESTAMP expires_atTIMESTAMP meetings idBIGINT account_idBIGINT host_user_idBIGINT topicVARCHAR agendaTEXT meeting_numberVARCHAR passcode_hashVARCHAR recurrence_ruleVARCHAR timezoneVARCHAR duration_minutesINTEGER waiting_room_enab…BOOLEAN join_before_hostBOOLEAN auto_recordVARCHAR created_atTIMESTAMP meeting_occurrences idBIGINT meeting_idBIGINT occurrence_keyVARCHAR scheduled_start_atTIMESTAMP scheduled_end_atTIMESTAMP statusVARCHAR actual_start_atTIMESTAMP actual_end_atTIMESTAMP host_user_idBIGINT participant_peakINTEGER registrations idBIGINT occurrence_idBIGINT user_idBIGINT emailVARCHAR full_nameVARCHAR join_tokenVARCHAR statusVARCHAR registered_atTIMESTAMP participants idBIGINT occurrence_idBIGINT user_idBIGINT registration_idBIGINT display_nameVARCHAR join_methodVARCHAR joined_atTIMESTAMP left_atTIMESTAMP leave_reasonVARCHAR is_hostBOOLEAN audio_minutesINTEGER waiting_room_admiss… idBIGINT occurrence_idBIGINT display_nameVARCHAR user_idBIGINT participant_idBIGINT decisionVARCHAR decided_by_user_idBIGINT requested_atTIMESTAMP decided_atTIMESTAMP breakout_rooms idBIGINT occurrence_idBIGINT nameVARCHAR room_indexSMALLINT opened_atTIMESTAMP closed_atTIMESTAMP breakout_room_membe… idBIGINT breakout_room_idBIGINT participant_idBIGINT entered_atTIMESTAMP exited_atTIMESTAMP recordings idBIGINT occurrence_idBIGINT started_by_user_idBIGINT storageVARCHAR kindVARCHAR object_urlVARCHAR size_bytesBIGINT duration_secondsINTEGER passcode_hashVARCHAR statusVARCHAR started_atTIMESTAMP expires_atTIMESTAMP meeting_chat_messag… idBIGINT occurrence_idBIGINT sender_participan…BIGINT recipient_partici…BIGINT bodyVARCHAR sent_atTIMESTAMP

Related database schemas

PostgreSQL
Productivity

Calendar and scheduling database schema

How a calendar app models its data: calendars and sharing, events with their own time zones, RRULE recurrence with exception dates and per-occurrence overrides, attendees and RSVP, reminders, working hours and a free-busy index.

PostgreSQL
Communication

Discord chat platform database schema

How a community chat platform models its data: servers with nested channels, roles carrying permission bitfields, three-state per-channel overwrites, per-server nicknames, messages and threads, reactions, attachments, invites and voice sessions.

PostgreSQL
Communication

Email & mailbox service database schema

How a webmail service models its data: labels applied many-to-many instead of IMAP folders, one stored copy per message, conversation threading, attachments deduplicated by content hash, delivery filters, drafts, read state, spam scoring and quota.

MySQL
Communication

Discussion forum and community database schema

The phpBB and Discourse shape rather than the Reddit one: curated categories and boards, threads bumped by replies, flat numbered posts with quoting, reputation and badges, a report-driven moderation queue and private messages.