Grokking the System Design Interview, Volume II
Vote

0% completed

​

Google Calendar: Database Schema

Step 6: Database Schema

The following schema defines a SQL-compatible relational database for a calendar system. It supports multiple user calendars, event scheduling (including recurring events with exceptions), invitations/RSVPs, resource booking (rooms), and sharing with permissions, while handling time zones and notifications for reminders.

Each table is outlined below with its columns, data types, and descriptions:

Users

Stores user account information. Each user can own calendars and receive event invitations.

.....

.....

.....

Like the course? Get enrolled and start learning!