Cannot create public.users

Hello, I'm trying to create a public table that contains few columns from auth.users, I do not understand this SQL error and supabase AI cannot debug it :

CREATE TABLE public.users (
    id uuid PRIMARY KEY,
    user_id uuid REFERENCES auth.users (id) UNIQUE,
    email text REFERENCES auth.users (email) UNIQUE,
    created_at timestamp with time zone REFERENCES auth.users (created_at),
    updated_at timestamp with time zone REFERENCES auth.users (updated_at)
);

ERROR:  42830: there is no unique constraint matching given keys for referenced table "users"

CREATE TABLE public.users (
    id uuid PRIMARY KEY,
    user_id uuid REFERENCES auth.users (id) UNIQUE,
    email text REFERENCES auth.users (email) UNIQUE,
    created_at timestamp with time zone REFERENCES auth.users (created_at),
    updated_at timestamp with time zone REFERENCES auth.users (updated_at)
);

ERROR:  42830: there is no unique constraint matching given keys for referenced table "users"

CREATE TABLE public.users (
    id uuid PRIMARY KEY,
    user_id uuid REFERENCES auth.users (id) UNIQUE,
    email text REFERENCES auth.users (email) UNIQUE,
    created_at timestamp with time zone REFERENCES auth.users (created_at),
    updated_at timestamp with time zone REFERENCES auth.users (updated_at)
);

ERROR:  42830: there is no unique constraint matching given keys for referenced table "users"

CREATE TABLE public.users (
    id uuid PRIMARY KEY,
    user_id uuid REFERENCES auth.users (id) UNIQUE,
    email text REFERENCES auth.users (email) UNIQUE,
    created_at timestamp with time zone REFERENCES auth.users (created_at),
    updated_at timestamp with time zone REFERENCES auth.users (updated_at)
);

ERROR:  42830: there is no unique constraint matching given keys for referenced table "users"

How to solve it ?

Cannot create public.users

Similar Threads

Similar Threads

Similar Threads