Query

event_store.db — constraints

SQL

CREATE TABLE constraints  (
  entity_id TEXT PRIMARY KEY,
  applies_to TEXT NOT NULL,
  condition TEXT NOT NULL,
  enforcement_level TEXT NOT NULL,
  action_tier TEXT,
  exceptions TEXT,
  rationale 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
applies_to TEXT Rename | Drop
condition TEXT Rename | Drop
enforcement_level TEXT Rename | Drop
action_tier TEXT ✓ Rename | Drop
exceptions TEXT ✓ Rename | Drop
rationale 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_constraints_1 entity_id ✓ SQL
-- no sql found --
 Drop