Query

event_store.db — effects

SQL

CREATE TABLE effects  (
  id TEXT PRIMARY KEY,
  action_id TEXT NOT NULL,
  type TEXT NOT NULL,
  payload TEXT NOT NULL,
  idempotency_key TEXT NOT NULL,
  applied_at TEXT NOT NULL,
  FOREIGN KEY (action_id) REFERENCES actions(id) ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
action_id TEXT Rename | Drop
type TEXT Rename | Drop
payload TEXT Rename | Drop
idempotency_key TEXT Rename | Drop
applied_at TEXT Rename | Drop

Foreign Keys

Column Destination
action_id actions.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_effects_action action_id SQL 
CREATE INDEX idx_effects_action
ON effects (action_id)
Drop
idx_effects_idempotency idempotency_key ✓ SQL 
CREATE UNIQUE INDEX idx_effects_idempotency
ON effects (idempotency_key)
Drop
sqlite_autoindex_effects_1 id ✓ SQL
-- no sql found --
 Drop