Grokking the System Design Interview, Volume II
Vote

0% completed

​

Google Calendar: Database Schema

Step 6: Database Schema

The schema below is for a SQL-compatible relational database that backs the calendar system. It holds several calendars per user, events with recurrence and exceptions, invitations and RSVPs, room bookings, and sharing permissions. It also handles time zones and reminder notifications.

We list each table below, with its columns, data types, and what each field means.

Users

The Users table stores account information. Each user can own several calendars and receive invitations to events.

.....

.....

.....

Like the course? Get enrolled and start learning!

Reading Progress

0%

Vote for new content