Adocasts Plus Timed Exclusive

Please check back in 12 days. Get immediate access to this lesson and more by joining Adocasts Plus for $8.00/mo or signing into your existing Adocasts Plus account.

Join for $8.00/mo Sign in
robot mascot smiling
Previous
Sign Up to Track Progress

Overview of our Database Schema

In this lesson, we'll take a high level look at our database's schema so that we have an understanding at the entities and models at play and how they relate to one another within our application.

Tom Gobich
Author
Tom Gobich
Published
Apr 18
Duration
2m 22s

Developer, dog lover, and burrito eater. Currently teaching AdonisJS, a fully featured NodeJS framework, and running Adocasts where I post new lessons weekly. Professionally, I work with JavaScript, .Net C#, and SQL Server.

Adocasts

Burlington, KY

Visit Website

Get the Code

Download or explore the source code for this lesson on GitHub

Repository
PlotMyCourse Database Schema

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:

Adocasts Plus Timed Exclusive

Please check back in 12 days. Get immediate access to this lesson and more by joining Adocasts Plus for $8.00/mo or signing into your existing Adocasts Plus account.

Join for $8.00/mo Sign in

Join The Discussion! (0 Comments)

Please sign in or sign up for free to join in on the dicussion.

robot comment bubble

Be the first to Comment!