objectTypetextrequiredThe kind of object
Becomes the column object_type of permission_relation.
Written at commons/data/models/identity-rebac/mod.ts:53
What holding a relation on an object of a type grants: the join between relationships and the permissions every kind of access shares
Model identityRebac. Written in commons/data/models/identity-rebac/mod.ts:53. Identified by permission, objectType.
objectTypetextrequiredThe kind of object
Becomes the column object_type of permission_relation.
Written at commons/data/models/identity-rebac/mod.ts:53
relationtextrequiredThe relation that grants the permission
Becomes the column relation of permission_relation.
Written at commons/data/models/identity-rebac/mod.ts:53
permissiononeThe permission granted To permission. Written at commons/data/models/identity-rebac/mod.ts:53
Projects to the table permission_relation with the primary key permission_id, object_type.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
object_type | text | false | attribute | permissionRelation.objectType |
permission_id | text | false | reference | permissionRelation.permission |
relation | text | false | attribute | permissionRelation.relation |
CREATE TABLE IF NOT EXISTS "permission_relation" (
"permission_id" VARCHAR NOT NULL,
"object_type" VARCHAR NOT NULL,
"relation" VARCHAR NOT NULL,
PRIMARY KEY ("permission_id", "object_type"),
CONSTRAINT "permission_relation_permission_id_fk" FOREIGN KEY ("permission_id") REFERENCES "permission" ("permission_id")
);CREATE TABLE IF NOT EXISTS "permission_relation" (
"permission_id" TEXT NOT NULL,
"object_type" TEXT NOT NULL,
"relation" TEXT NOT NULL,
PRIMARY KEY ("permission_id", "object_type"),
CONSTRAINT "permission_relation_permission_id_fk" FOREIGN KEY ("permission_id") REFERENCES "permission" ("permission_id")
);CREATE TABLE IF NOT EXISTS "permission_relation" (
"permission_id" TEXT NOT NULL,
"object_type" TEXT NOT NULL,
"relation" TEXT NOT NULL,
PRIMARY KEY ("permission_id", "object_type"),
CONSTRAINT "permission_relation_permission_id_fk" FOREIGN KEY ("permission_id") REFERENCES "permission" ("permission_id")
);Read and written from TypeScript with the types the model gives: import { permissionRelation } from "@intellectual-frontiers/data/sql/typed/models". Generated in commons/data/sql/typed/models/identity-rebac.auto.ts: do not edit.
import { from } from "@intellectual-frontiers/data/sql/typed";
import { permissionRelation } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(permissionRelation).select((s) => ({ permissionId: s.permissionRelation.permissionId, objectType: s.permissionRelation.objectType })).run(runner);