Step 6: Database Schema

A weekly meeting with no end date would need an unlimited number of rows if each occurrence were stored. The schema avoids that by storing a recurring series as one event plus one rule, with an extra row only for a date that differs from the rule. The rest of the schema is conventional: users, calendars, invitations, rooms, notifications, and sharing permissions, all in a relational database.

Each table below lists its columns, their types, and what each one holds.

Users

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