IF Commons GitHub

delegationPermission

concept

A permission that a delegation passes on: a subset of what the delegator held, and of what the delegation above it passed on

Model identityDelegation. Written in commons/data/models/identity-delegation/mod.ts:60. Identified by delegation, permission.

Governance: attributes

Governance: relationships

delegationone

The delegation To delegation. Written at commons/data/models/identity-delegation/mod.ts:60

permissionone

The permission To permission. Written at commons/data/models/identity-delegation/mod.ts:60

Logical: the table

Projects to the table delegation_permission with the primary key delegation_id, permission_id.

ColumnTypeNullRoleFrom
delegation_idtextfalsereferencedelegationPermission.delegation
permission_idtextfalsereferencedelegationPermission.permission

Physical: SQL

CREATE TABLE IF NOT EXISTS "delegation_permission" (
    "delegation_id" VARCHAR NOT NULL,
    "permission_id" VARCHAR NOT NULL,
    PRIMARY KEY ("delegation_id", "permission_id"),
    CONSTRAINT "delegation_permission_delegation_id_fk" FOREIGN KEY ("delegation_id") REFERENCES "delegation" ("delegation_id"),
    CONSTRAINT "delegation_permission_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 { delegationPermission } from "@intellectual-frontiers/data/sql/typed/models". Generated in commons/data/sql/typed/models/identity-delegation.auto.ts: do not edit.

import { from } from "@intellectual-frontiers/data/sql/typed";
import { delegationPermission } from "@intellectual-frontiers/data/sql/typed/models";

const rows = await from(delegationPermission).select((s) => ({ delegationId: s.delegationPermission.delegationId, permissionId: s.delegationPermission.permissionId })).run(runner);

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