Query

database.sqlite — project_relation

SQL

CREATE TABLE "project_relation"  (
  "projectId" varchar(36) NOT NULL,
  "userId" varchar NOT NULL,
  "role" varchar NOT NULL,
  "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  CONSTRAINT "FK_5f0643f6717905a05164090dde7" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT "FK_61448d56d61802b5dfde5cdb002" FOREIGN KEY ("projectId") REFERENCES "project" ("id") ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT "FK_c6b99592dc96b0d836d7a21db91" FOREIGN KEY ("role") REFERENCES "role" ("slug"),
  PRIMARY KEY ("projectId", "userId")
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
projectId varchar(36) ✓ Rename | Drop
userId varchar ✓ Rename | Drop
role varchar Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
role role.slug
projectId project.id
userId user.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_5f0643f6717905a05164090dde userId SQL 
CREATE INDEX "IDX_5f0643f6717905a05164090dde"
ON "project_relation" ("userId")
Drop
IDX_61448d56d61802b5dfde5cdb00 projectId SQL 
CREATE INDEX "IDX_61448d56d61802b5dfde5cdb00"
ON "project_relation" ("projectId")
Drop
project_relation_role_idx role SQL 
CREATE INDEX "project_relation_role_idx"
ON "project_relation" ("role")
Drop
project_relation_role_project_idx
  • projectId
  • role
 SQL 
CREATE INDEX "project_relation_role_project_idx"
ON "project_relation" ("projectId", "role")
Drop
sqlite_autoindex_project_relation_1
  • projectId
  • userId
 ✓ SQL
-- no sql found --
 Drop