Query

database.sqlite — role_scope

Add Column

Cancel

Current Schema

CREATE TABLE role_scope  (
  "roleSlug" VARCHAR(128) NOT NULL,
  "scopeSlug" VARCHAR(128) NOT NULL,
  CONSTRAINT "PK_role_scope" PRIMARY KEY ("roleSlug", "scopeSlug"),
  CONSTRAINT "FK_role" FOREIGN KEY ("roleSlug") REFERENCES role ("slug") ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT "FK_scope" FOREIGN KEY ("scopeSlug") REFERENCES "scope" ("slug") ON DELETE CASCADE ON UPDATE CASCADE
)