From the course: Build with AI: Create a Follow-Up App with React, Supabase, and Cursor
Unlock this course with a free trial
Join today to access over 24,900 courses taught by industry experts.
Tables and relationships
From the course: Build with AI: Create a Follow-Up App with React, Supabase, and Cursor
Tables and relationships
- [Narrator] Now that your Supabase project and basic schema are in place, it is now important to understand each table, what it does, how they communicate with one another, and how it impacts your application. In your table editor, you should now have the following tables, followups, leads, roles, and users. The leads table stores the contact information and form responses of the leads, which is the public form. The users table is mainly for the admins, it has the super admin, which can be you or your manager, then the sub-admin, which can be your staff or your digital leads manager. This table stores their basic information. The roles. Now, this table defines either you're a super admin or you're a sub-admin. That's all. While the followups is just for you to log each email or each follow-up that is being sent out to a lead. In the roles table, the roles ID and roles name let us categorize each admin effectively.…