logo
ExamplesEditorPricingDocs
37.1kSign in

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.

Calendar Scheduling ER diagram

Calendar and scheduling database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 users idBIGINT emailVARCHAR full_nameVARCHAR default_timezoneVARCHAR created_atTIMESTAMPTZ calendars idBIGINT owner_idBIGINT nameVARCHAR descriptionTEXT timezoneVARCHAR colorVARCHAR kindVARCHAR is_default_busyBOOLEAN created_atTIMESTAMPTZ calendar_shares calendar_idBIGINT grantee_idBIGINT roleVARCHAR granted_atTIMESTAMPTZ events idBIGINT calendar_idBIGINT uidVARCHAR organizer_idBIGINT titleVARCHAR descriptionTEXT locationVARCHAR starts_atTIMESTAMPTZ ends_atTIMESTAMPTZ timezoneVARCHAR is_all_dayBOOLEAN statusVARCHAR visibilityVARCHAR transparencyVARCHAR sequenceINTEGER created_atTIMESTAMPTZ updated_atTIMESTAMPTZ event_recurrences event_idBIGINT rruleVARCHAR freqVARCHAR interval_countSMALLINT until_atTIMESTAMPTZ occurrence_countINTEGER horizon_atTIMESTAMPTZ recurrence_exceptio… event_idBIGINT original_start_atTIMESTAMPTZ excluded_atTIMESTAMPTZ event_overrides idBIGINT event_idBIGINT original_start_atTIMESTAMPTZ starts_atTIMESTAMPTZ ends_atTIMESTAMPTZ titleVARCHAR locationVARCHAR descriptionTEXT statusVARCHAR updated_atTIMESTAMPTZ event_attendees idBIGINT event_idBIGINT override_idBIGINT user_idBIGINT emailVARCHAR display_nameVARCHAR roleVARCHAR rsvp_statusVARCHAR commentVARCHAR responded_atTIMESTAMPTZ event_reminders idBIGINT event_idBIGINT user_idBIGINT methodVARCHAR minutes_beforeINTEGER created_atTIMESTAMPTZ working_hours user_idBIGINT weekdaySMALLINT starts_at_localTIME ends_at_localTIME timezoneVARCHAR is_availableBOOLEAN busy_intervals idBIGINT user_idBIGINT event_idBIGINT occurrence_start_…TIMESTAMPTZ starts_atTIMESTAMPTZ ends_atTIMESTAMPTZ is_tentativeBOOLEAN

Related database schemas

SQLite
Productivity

Habit tracker app database schema

A small local-first SQLite schema for habit tracking: habits with date-versioned schedules, one row per completion, pauses that skip a streak instead of breaking it, reminders, and streaks derived from check-ins rather than stored as a counter.

PostgreSQL
Productivity

Dropbox-style file storage & sync database schema

How a cloud drive models its data: a folder tree, versioned files, content-addressed blocks that deduplicate identical uploads to a single copy, shares and expiring public links, per-device sync cursors, trash retention and quota accounting.

SQLite
Productivity

Note-taking app database schema with backlinks

A local-first SQLite notes database: notebooks and notes, wiki-style backlinks parsed from note bodies into a link graph, tags, attachments, a full-text search index, revision history and last-writer-wins sync with a conflict record.

PostgreSQL
Productivity

Notion workspace database schema

How a docs-and-databases workspace models its data: nested pages, a document stored as an ordered block tree, user-defined databases whose rows are pages, views with filters and sorts, inherited permissions and block-anchored comments.