SQL
CREATE TABLE "workflow_review_request_authors" (
"workflowReviewRequestId" varchar(36) NOT NULL,
"userId" varchar NOT NULL,
CONSTRAINT "FK_c255ae5087010c1ab73ac8684af" FOREIGN KEY ("workflowReviewRequestId") REFERENCES "workflow_review_request" ("id") ON DELETE CASCADE,
CONSTRAINT "FK_a9c79ab0c352aa0496c39ea56a4" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON DELETE CASCADE,
PRIMARY KEY ("workflowReviewRequestId", "userId")
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
workflowReviewRequestId |
varchar(36) |
✓ | Rename | Drop | |
userId |
varchar |
✓ | Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
userId |
user.id |
workflowReviewRequestId |
workflow_review_request.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_workflow_review_request_authors_1 |
|
✓ | SQL | Drop |