IF Commons GitHub

permissionRelation

concept

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.

Governance: attributes

objectTypetextrequired

The kind of object

Becomes the column object_type of permission_relation.

Written at commons/data/models/identity-rebac/mod.ts:53

relationtextrequired

The relation that grants the permission

Becomes the column relation of permission_relation.

Written at commons/data/models/identity-rebac/mod.ts:53

Governance: relationships

permissionone

The permission granted To permission. Written at commons/data/models/identity-rebac/mod.ts:53

Logical: the table

Projects to the table permission_relation with the primary key permission_id, object_type.

ColumnTypeNullRoleFrom
object_typetextfalseattributepermissionRelation.objectType
permission_idtextfalsereferencepermissionRelation.permission
relationtextfalseattributepermissionRelation.relation

Physical: SQL

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")
);

Physical: the typed table

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);

Titles, headings, exports, tables, columns and requirements. Esc closes.