repos / pico

20260305_add_forms_table.sql

 1CREATE TABLE IF NOT EXISTS form_entries (
 2  id uuid NOT NULL DEFAULT uuid_generate_v4(),
 3  user_id uuid NOT NULL,
 4  name VARCHAR(255) NOT NULL,
 5  data jsonb NOT NULL,
 6  created_at timestamp without time zone NOT NULL DEFAULT NOW(),
 7  CONSTRAINT form_entries_pkey PRIMARY KEY (id),
 8  CONSTRAINT fk_form_entries_users
 9    FOREIGN KEY(user_id)
10    REFERENCES app_users(id)
11    ON DELETE CASCADE
12);
13
14CREATE INDEX IF NOT EXISTS idx_form_entries_user ON form_entries(user_id);
15CREATE INDEX IF NOT EXISTS idx_form_entries_name ON form_entries(name);