SQL
CREATE TABLE "execution_annotation_tags" (
"annotationId" integer NOT NULL,
"tagId" varchar(24) NOT NULL,
CONSTRAINT "FK_c1519757391996eb06064f0e7c8" FOREIGN KEY ("annotationId") REFERENCES "execution_annotations" ("id") ON DELETE CASCADE,
CONSTRAINT "FK_a3697779b366e131b2bbdae2976" FOREIGN KEY ("tagId") REFERENCES "annotation_tag_entity" ("id") ON DELETE CASCADE,
PRIMARY KEY ("annotationId", "tagId")
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
annotationId |
INTEGER |
✓ | Rename | Drop | |
tagId |
varchar(24) |
✓ | Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
tagId |
annotation_tag_entity.id |
annotationId |
execution_annotations.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| IDX_a3697779b366e131b2bbdae297 |
tagId
|
SQL | Drop | |
| IDX_c1519757391996eb06064f0e7c |
annotationId
|
SQL | Drop | |
| sqlite_autoindex_execution_annotation_tags_1 |
|
✓ | SQL | Drop |