The Core Tables: Users and Organizations

At the heart of our application are two primary tables: the Users table and the Organizations table. These tables are connected by an intermediary table called Organization Users, which not only links users to organizations but also defines each user's role within the organization. Roles include members and administrators, and these roles dictate what actions a user can perform.

User-Specific Data

We need to store additional user-specific data besides linking users to organizations to ensure a seamless experience. This includes: