create view public.user_profiles as
select
u.first_name,
u.last_name,
u.role,
u.created_at,
u.customer_id,
a.email,
a.last_sign_in_at as last_login_date
from
users u
join auth.users a using (id);
create view public.user_profiles as
select
u.first_name,
u.last_name,
u.role,
u.created_at,
u.customer_id,
a.email,
a.last_sign_in_at as last_login_date
from
users u
join auth.users a using (id);