How to setup relationship with auth.users and other public tables using drizzle

[mkappworks]

I am working on a nextjs app with supabase auth, db and drizzle ORM.
I am looking for a method to define relationship between auth.users and other public tables using drizzle.

I think we can use a trigger to duplicate the user table into profile table as per guide https://supabase.com/docs/guides/auth/managing-user-data

My question is there a way to define this sql in drizzle. I think the real question is how to get a reference of auth.users in drizzle schema?

create table public.profiles (
  id uuid not null references auth.users on delete cascade,
  first_name text,
  last_name text,

  primary key (id)
);

alter table public.profiles enable row level security;

[imMatheus]

I have the same thought

[Adrian333Dev]

@mkappworks @imMatheus any updates on this topic?

[Adrian333Dev]

This looks like a good solution: supabase/supabase#19883 (comment)