permissiononeThe permission To permission. Written at commons/data/models/identity-access/concepts.ts:62
A permission that a role holds
Model identityAccess. Written in commons/data/models/identity-access/concepts.ts:62. Identified by role, permission.
permissiononeThe permission To permission. Written at commons/data/models/identity-access/concepts.ts:62
roleoneThe role To accessRole. Written at commons/data/models/identity-access/concepts.ts:112
Projects to the table role_permission with the primary key role_access_role_role_id, permission_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
permission_id | text | false | reference | rolePermission.permission |
role_access_role_role_id | text | false | reference | rolePermission.role |
CREATE TABLE IF NOT EXISTS "role_permission" (
"role_access_role_role_id" VARCHAR NOT NULL,
"permission_id" VARCHAR NOT NULL,
PRIMARY KEY ("role_access_role_role_id", "permission_id"),
CONSTRAINT "role_permission_role_access_role_role_id_fk" FOREIGN KEY ("role_access_role_role_id") REFERENCES "access_role" ("role_id"),
CONSTRAINT "role_permission_permission_id_fk" FOREIGN KEY ("permission_id") REFERENCES "permission" ("permission_id")
);CREATE TABLE IF NOT EXISTS "role_permission" (
"role_access_role_role_id" TEXT NOT NULL,
"permission_id" TEXT NOT NULL,
PRIMARY KEY ("role_access_role_role_id", "permission_id"),
CONSTRAINT "role_permission_role_access_role_role_id_fk" FOREIGN KEY ("role_access_role_role_id") REFERENCES "access_role" ("role_id"),
CONSTRAINT "role_permission_permission_id_fk" FOREIGN KEY ("permission_id") REFERENCES "permission" ("permission_id")
);CREATE TABLE IF NOT EXISTS "role_permission" (
"role_access_role_role_id" TEXT NOT NULL,
"permission_id" TEXT NOT NULL,
PRIMARY KEY ("role_access_role_role_id", "permission_id"),
CONSTRAINT "role_permission_role_access_role_role_id_fk" FOREIGN KEY ("role_access_role_role_id") REFERENCES "access_role" ("role_id"),
CONSTRAINT "role_permission_permission_id_fk" FOREIGN KEY ("permission_id") REFERENCES "permission" ("permission_id")
);Read and written from TypeScript with the types the model gives: import { rolePermission } from "@intellectual-frontiers/data/sql/typed/models". Generated in commons/data/sql/typed/models/identity-access.auto.ts: do not edit.
import { from } from "@intellectual-frontiers/data/sql/typed";
import { rolePermission } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(rolePermission).select((s) => ({ roleAccessRoleRoleId: s.rolePermission.roleAccessRoleRoleId, permissionId: s.rolePermission.permissionId })).run(runner);