Query

app.db — form_fields

SQL

CREATE TABLE form_fields  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  form_id INTEGER NOT NULL,
  field_name TEXT NOT NULL,
  field_type TEXT NOT NULL,
  label TEXT NOT NULL,
  placeholder TEXT,
  is_required INTEGER DEFAULT 0,
  validation_rules TEXT,
  options TEXT,
  default_value TEXT,
  field_order INTEGER DEFAULT 0,
  created_at TEXT NOT NULL,
  FOREIGN KEY (form_id) REFERENCES forms(id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
form_id INTEGER Rename | Drop
field_name TEXT Rename | Drop
field_type TEXT Rename | Drop
label TEXT Rename | Drop
placeholder TEXT ✓ Rename | Drop
is_required INTEGER ✓ Rename | Drop
validation_rules TEXT ✓ Rename | Drop
options TEXT ✓ Rename | Drop
default_value TEXT ✓ Rename | Drop
field_order INTEGER ✓ Rename | Drop
created_at TEXT Rename | Drop

Foreign Keys

Column Destination
form_id forms.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_form_fields_form_id form_id SQL 
CREATE INDEX idx_form_fields_form_id
ON form_fields(form_id)
Drop