Query

database.sqlite — execution_metadata

SQL

CREATE TABLE "execution_metadata"  (
  "id" integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  "executionId" integer NOT NULL,
  "key" varchar(255) NOT NULL,
  "value" text NOT NULL,
  CONSTRAINT "FK_31d0b4c93fb85ced26f6005cda3" FOREIGN KEY ("executionId") REFERENCES "execution_entity" ("id") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
executionId INTEGER Rename | Drop
key varchar(255) Rename | Drop
value TEXT Rename | Drop

Foreign Keys

Column Destination
executionId execution_entity.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_cec8eea3bf49551482ccb4933e
  • executionId
  • key
 ✓ SQL 
CREATE UNIQUE INDEX "IDX_cec8eea3bf49551482ccb4933e"
ON "execution_metadata" ("executionId", "key")
Drop