🍀 Supabase Database

Create a Supabase Project (if you haven’t already)

1. Go to Supabase  and create a new project (or use your existing project).
2. Fill out your project name and database password (Make it a password you’ll remember).
3. Click “Create new project”.

Navigate to Database

In the Supabase Console, go to the left-hand side and click on Database.

Create and Insert User Data

1. Click on Create a new table to create a table inside Supabase for your users.
2. Name the table “users”.
3. Scroll down and create/replace with two columns:

• Second named “uid” with the type “text” (Make this the primary key)
• First named “email” with the type “text”

4. Save the table

Create and Insert Payment/Customer Data

1. Navigate to Database > Tables
2. Click on New table to create a table inside Supabase for your payments.
3. Name the table “customers”.
4. Scroll down and create/replace with three columns:

• First named “email” with the type “text” (Make this the primary key)
• Second named “name” with the type “text”
• Third named “paid” with the type “boolean”

4. Save the table