SQL
CREATE TABLE "role_mapping_rule_project" (
"roleMappingRuleId" varchar(16) NOT NULL,
"projectId" varchar(36) NOT NULL,
CONSTRAINT "FK_dd7ce4dfa09e95b36a626bd9de3" FOREIGN KEY ("roleMappingRuleId") REFERENCES "role_mapping_rule" ("id") ON DELETE CASCADE,
CONSTRAINT "FK_35a78869286c65d9330d02b88f5" FOREIGN KEY ("projectId") REFERENCES "project" ("id") ON DELETE CASCADE,
PRIMARY KEY ("roleMappingRuleId", "projectId")
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
roleMappingRuleId |
varchar(16) |
✓ | Rename | Drop | |
projectId |
varchar(36) |
✓ | Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
projectId |
project.id |
roleMappingRuleId |
role_mapping_rule.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| IDX_35a78869286c65d9330d02b88f |
projectId
|
SQL | Drop | |
| sqlite_autoindex_role_mapping_rule_project_1 |
|
✓ | SQL | Drop |