n8n/docs/generated/sqlite-schema/data_table_mutation_event.md

data_table_mutation_event

Description

Table Definition

CREATE TABLE "data_table_mutation_event" ("id" varchar PRIMARY KEY NOT NULL, "dataTableId" varchar(36) NOT NULL, "rowId" integer NOT NULL, "event" varchar(20) NOT NULL, "payload" text NOT NULL, "occurredAt" datetime(3) NOT NULL, "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), CONSTRAINT "CHK_data_table_mutation_event_event" CHECK ("event" IN ('rowInserted', 'rowDeleted', 'columnUpdated')), CONSTRAINT "FK_7c5ffce6d8884e133346c02cd4f" FOREIGN KEY ("dataTableId") REFERENCES "data_table" ("id") ON DELETE CASCADE)

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
createdAt	datetime(3)	STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')	false
dataTableId	varchar(36)		false		data_table
event	varchar(20)		false
id	varchar		false	data_table_trigger_delivery
occurredAt	datetime(3)		false
payload	TEXT		false
rowId	INTEGER		false
updatedAt	datetime(3)	STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')	false

Constraints

Name	Type	Definition
-	CHECK	CHECK ("event" IN ('rowInserted', 'rowDeleted', 'columnUpdated'))
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (dataTableId) REFERENCES data_table (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
id	PRIMARY KEY	PRIMARY KEY (id)
sqlite_autoindex_data_table_mutation_event_1	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
IDX_360aead58201e2b383dd3f2eef	CREATE INDEX "IDX_360aead58201e2b383dd3f2eef" ON "data_table_mutation_event" ("dataTableId", "occurredAt")
sqlite_autoindex_data_table_mutation_event_1	PRIMARY KEY (id)

Relations

erDiagram

"data_table_mutation_event" }o--|| "data_table" : "FOREIGN KEY (dataTableId) REFERENCES data_table (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"data_table_trigger_delivery" }o--|| "data_table_mutation_event" : "FOREIGN KEY (eventId) REFERENCES data_table_mutation_event (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"data_table_mutation_event" {
  datetime_3_ createdAt
  varchar_36_ dataTableId FK
  varchar_20_ event
  varchar id PK
  datetime_3_ occurredAt
  TEXT payload
  INTEGER rowId
  datetime_3_ updatedAt
}
"data_table" {
  datetime_3_ createdAt
  varchar_36_ id PK
  TEXT metadata
  varchar_128_ name
  varchar_36_ projectId FK
  datetime_3_ updatedAt
}
"data_table_trigger_delivery" {
  smallint attempts
  varchar_36_ claimedBy
  datetime_3_ createdAt
  datetime_3_ dispatchedAt
  TEXT error
  varchar eventId FK
  bigint executionId
  datetime_3_ finishedAt
  varchar id PK
  INTEGER leaseEpoch
  datetime_3_ leaseExpiresAt
  datetime_3_ nextAttemptAt
  varchar_36_ nodeId
  varchar_20_ status
  datetime_3_ updatedAt
  varchar_36_ workflowId FK
}

---

Generated by tbls