delegationoneThe delegation To delegation. Written at commons/data/models/identity-delegation/mod.ts:60
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.
delegationoneThe delegation To delegation. Written at commons/data/models/identity-delegation/mod.ts:60
permissiononeThe permission To permission. Written at commons/data/models/identity-delegation/mod.ts:60
Projects to the table delegation_permission with the primary key delegation_id, permission_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
delegation_id | text | false | reference | delegationPermission.delegation |
permission_id | text | false | reference | delegationPermission.permission |
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")
);CREATE TABLE IF NOT EXISTS "delegation_permission" (
"delegation_id" TEXT NOT NULL,
"permission_id" TEXT 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")
);CREATE TABLE IF NOT EXISTS "delegation_permission" (
"delegation_id" TEXT NOT NULL,
"permission_id" TEXT 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")
);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);