My Family

Hubungkan Supabase

Ini starter yang disiapkan untuk database SQL PostgreSQL online. Supabase project perlu dibuat dan konfigurasi frontend diisi sebelum login/data online aktif. Gunakan hanya Project URL dan anon/public key—jangan pernah masukkan service_role key di frontend.

Masuk / daftar

Setiap akun hanya bisa mengakses data keluarga miliknya sendiri.

SQL untuk Supabase

Jalankan di Supabase → SQL Editor → New query. RLS memisahkan data tiap akun.

create table public.family_members (
  id bigint generated always as identity primary key,
  user_id uuid not null references auth.users(id) on delete cascade,
  name text not null,
  generation int not null default 1 check (generation between 1 and 7),
  birth_year int,
  relation text,
  created_at timestamptz not null default now()
);

alter table public.family_members enable row level security;

create policy "Read own family members"
on public.family_members for select to authenticated
using ((select auth.uid()) = user_id);

create policy "Add own family members"
on public.family_members for insert to authenticated
with check ((select auth.uid()) = user_id);

create policy "Update own family members"
on public.family_members for update to authenticated
using ((select auth.uid()) = user_id)
with check ((select auth.uid()) = user_id);

create policy "Delete own family members"
on public.family_members for delete to authenticated
using ((select auth.uid()) = user_id);