마이페이지v1.16

-- cretop_reports 테이블 생성
create table if not exists cretop_reports (
  id uuid primary key default gen_random_uuid(),
  member_id text not null,
  consultant_id uuid,
  company_name text not null,
  biz_no text,
  fiscal_date date,
  credit_grade text,
  parsed_json jsonb,
  manual_input jsonb,
  calc_result jsonb,
  ai_comments jsonb,
  tax_base jsonb,
  version text default 'v1.15',
  created_at timestamptz default now(),
  updated_at timestamptz default now()
);

create index if not exists cretop_reports_member_idx on cretop_reports(member_id);
create index if not exists cretop_reports_updated_idx on cretop_reports(updated_at desc);

-- RLS 활성화
alter table cretop_reports enable row level security;

-- 본인 보고서만 읽기
create policy "read own reports" on cretop_reports
  for select using (member_id = current_setting('request.jwt.claims', true)::json->>'sub');

-- 본인 보고서만 쓰기
create policy "insert own reports" on cretop_reports
  for insert with check (member_id = current_setting('request.jwt.claims', true)::json->>'sub');

create policy "update own reports" on cretop_reports
  for update using (member_id = current_setting('request.jwt.claims', true)::json->>'sub');

create policy "delete own reports" on cretop_reports
  for delete using (member_id = current_setting('request.jwt.claims', true)::json->>'sub');