SQL
CREATE TABLE "evaluation_config" (
"id" varchar(36) PRIMARY KEY NOT NULL,
"workflowId" varchar(36) NOT NULL,
"name" varchar(128) NOT NULL,
"status" varchar(16) NOT NULL DEFAULT ('valid'),
"invalidReason" varchar(64),
"datasetSource" varchar(32) NOT NULL,
"datasetRef" text NOT NULL,
"startNodeName" varchar(255) NOT NULL,
"endNodeName" varchar(255) NOT NULL,
"metrics" text 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 "UQ_3c3c99a712e971835c52292e44c" UNIQUE ("workflowId", "name"),
CONSTRAINT "FK_fd7542bb123074760285dc1bbf3" FOREIGN KEY ("workflowId") REFERENCES "workflow_entity" ("id") ON DELETE CASCADE
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
id |
varchar(36) |
✓ | Rename | Drop | |
workflowId |
varchar(36) |
Rename | Drop | ||
name |
varchar(128) |
Rename | Drop | ||
status |
varchar(16) |
Rename | Drop | ||
invalidReason |
varchar(64) |
✓ | Rename | Drop | |
datasetSource |
varchar(32) |
Rename | Drop | ||
datasetRef |
TEXT |
Rename | Drop | ||
startNodeName |
varchar(255) |
Rename | Drop | ||
endNodeName |
varchar(255) |
Rename | Drop | ||
metrics |
TEXT |
Rename | Drop | ||
createdAt |
datetime(3) |
Rename | Drop | ||
updatedAt |
datetime(3) |
Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
workflowId |
workflow_entity.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| IDX_fd7542bb123074760285dc1bbf |
workflowId
|
SQL | Drop | |
| sqlite_autoindex_evaluation_config_1 |
id
|
✓ | SQL | Drop |
| sqlite_autoindex_evaluation_config_2 |
|
✓ | SQL | Drop |