Query

event_store.db — decisions

SQL

CREATE TABLE decisions  (
  entity_id TEXT PRIMARY KEY,
  question TEXT NOT NULL,
  options TEXT NOT NULL,
  status TEXT,
  chosen TEXT,
  rationale TEXT,
  tradeoffs TEXT,
  date TEXT NOT NULL,
  reversible INTEGER DEFAULT 1,
  review_at TEXT,
  resolved_at TEXT,
  FOREIGN KEY (entity_id) REFERENCES entities(id) ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
entity_id TEXT ✓ ✓ Rename | Drop
question TEXT Rename | Drop
options TEXT Rename | Drop
status TEXT ✓ Rename | Drop
chosen TEXT ✓ Rename | Drop
rationale TEXT ✓ Rename | Drop
tradeoffs TEXT ✓ Rename | Drop
date TEXT Rename | Drop
reversible INTEGER ✓ Rename | Drop
review_at TEXT ✓ Rename | Drop
resolved_at TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
entity_id entities.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_decisions_status status SQL 
CREATE INDEX idx_decisions_status
ON decisions (status)
Drop
sqlite_autoindex_decisions_1 entity_id ✓ SQL
-- no sql found --
 Drop