2nd,Create Tables In Supabase

create Profile table to save user's general info

as we have setup Google Auth in the last step, we need a table to save user's info

CREATE TABLE
  public.profiles (
    id UUID NOT NULL PRIMARY KEY,
    bio TEXT NULL,
    avatar_url TEXT NULL,
    created_at TIMESTAMP WITH TIME ZONE NULL DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT profiles_id_key UNIQUE (id)
  ) TABLESPACE pg_default;

And we need an table to save user's submission.

People need to submit their closing test info by these 4 fields

you can easily add these four fields on Supabase.

Attention

before you writing or fetching data into Supabase, don't forget to set RLS policy of your table, normally we set "only authenticated user can read and write"