Query

event_store.db — commitments

SQL

CREATE TABLE commitments  (
  entity_id TEXT PRIMARY KEY,
  scope TEXT,
  desired_outcome TEXT,
  constraints TEXT,
  deadline TEXT,
  recurrence TEXT,
  importance REAL DEFAULT 0.0,
  acceptance_criteria TEXT,
  status TEXT,
  created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  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
scope TEXT ✓ Rename | Drop
desired_outcome TEXT ✓ Rename | Drop
constraints TEXT ✓ Rename | Drop
deadline TEXT ✓ Rename | Drop
recurrence TEXT ✓ Rename | Drop
importance REAL ✓ Rename | Drop
acceptance_criteria TEXT ✓ Rename | Drop
status TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop

Foreign Keys

Column Destination
entity_id entities.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_commitments_1 entity_id ✓ SQL
-- no sql found --
 Drop