SQL
CREATE TABLE "workflows_tags" (
"workflowId" varchar(36) NOT NULL,
"tagId" integer NOT NULL,
CONSTRAINT "FK_workflows_tags_workflow_entity" FOREIGN KEY ("workflowId") REFERENCES "workflow_entity" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
CONSTRAINT "FK_workflows_tags_tag_entity" FOREIGN KEY ("tagId") REFERENCES "tag_entity" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
PRIMARY KEY ("workflowId", "tagId")
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
workflowId |
varchar(36) |
✓ | Rename | Drop | |
tagId |
INTEGER |
✓ | Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
tagId |
tag_entity.id |
workflowId |
workflow_entity.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| idx_workflows_tags_tag_id |
tagId
|
SQL | Drop | |
| idx_workflows_tags_workflow_id |
workflowId
|
SQL | Drop | |
| sqlite_autoindex_workflows_tags_1 |
|
✓ | SQL | Drop |