Files
ai-florist/supabase/schema.sql
Chaewon Lee 0414393be7 chore: QA fixes for edit, map, and result pages
* fix: align result cards with recipe and tighten bouquet edit prompts

* fix: improve masked area edits with aligned masks and inpainting prompts

* refactor: drop floristNote/finalize and add map description

* fix: prevent map page crash from marker effect loop

* chore: add eslint exception for KakaoMap shopMarkerMap
2026-06-16 00:01:27 +09:00

21 lines
704 B
SQL

create table if not exists public.flower_jobs (
id uuid primary key,
created_at timestamptz not null default now(),
user_input jsonb not null default '{}'::jsonb,
mood_analysis jsonb,
recipe jsonb,
image_prompt text,
images jsonb not null default '{}'::jsonb
);
alter table public.flower_jobs enable row level security;
create index if not exists flower_jobs_created_at_idx on public.flower_jobs (created_at desc);
grant usage on schema public to service_role;
grant select, insert, update, delete on public.flower_jobs to service_role;
insert into storage.buckets (id, name, public)
values ('flower-bouquets', 'flower-bouquets', true)
on conflict (id) do update set public = excluded.public;