create table if not exists observations ( id bigserial primary key, dept text not null, priority text default 'mid', source text default 'field', obs_date date, added timestamptz default now(), short text not null, full_text text default '', status text default 'pending', action text default '', deadline date ); alter table observations enable row level security; create policy "open_access" on observations for all using (true) with check (true);