roleoneThe role To accessRole. Written at commons/data/models/identity-access/concepts.ts:112
A role that a separation rule is about
Model identityAccess. Written in commons/data/models/identity-access/concepts.ts:86. Identified by rule, role.
roleoneThe role To accessRole. Written at commons/data/models/identity-access/concepts.ts:112
ruleoneThe rule To separationRule. Written at commons/data/models/identity-access/concepts.ts:86
Projects to the table separation_rule_role with the primary key rule_separation_rule_id, role_access_role_role_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
role_access_role_role_id | text | false | reference | separationRuleRole.role |
rule_separation_rule_id | text | false | reference | separationRuleRole.rule |
CREATE TABLE IF NOT EXISTS "separation_rule_role" (
"rule_separation_rule_id" VARCHAR NOT NULL,
"role_access_role_role_id" VARCHAR NOT NULL,
PRIMARY KEY ("rule_separation_rule_id", "role_access_role_role_id"),
CONSTRAINT "separation_rule_role_rule_separation_rule_id_fk" FOREIGN KEY ("rule_separation_rule_id") REFERENCES "separation_rule" ("separation_rule_id"),
CONSTRAINT "separation_rule_role_role_access_role_role_id_fk" FOREIGN KEY ("role_access_role_role_id") REFERENCES "access_role" ("role_id")
);CREATE TABLE IF NOT EXISTS "separation_rule_role" (
"rule_separation_rule_id" TEXT NOT NULL,
"role_access_role_role_id" TEXT NOT NULL,
PRIMARY KEY ("rule_separation_rule_id", "role_access_role_role_id"),
CONSTRAINT "separation_rule_role_rule_separation_rule_id_fk" FOREIGN KEY ("rule_separation_rule_id") REFERENCES "separation_rule" ("separation_rule_id"),
CONSTRAINT "separation_rule_role_role_access_role_role_id_fk" FOREIGN KEY ("role_access_role_role_id") REFERENCES "access_role" ("role_id")
);CREATE TABLE IF NOT EXISTS "separation_rule_role" (
"rule_separation_rule_id" TEXT NOT NULL,
"role_access_role_role_id" TEXT NOT NULL,
PRIMARY KEY ("rule_separation_rule_id", "role_access_role_role_id"),
CONSTRAINT "separation_rule_role_rule_separation_rule_id_fk" FOREIGN KEY ("rule_separation_rule_id") REFERENCES "separation_rule" ("separation_rule_id"),
CONSTRAINT "separation_rule_role_role_access_role_role_id_fk" FOREIGN KEY ("role_access_role_role_id") REFERENCES "access_role" ("role_id")
);Read and written from TypeScript with the types the model gives: import { separationRuleRole } 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 { separationRuleRole } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(separationRuleRole).select((s) => ({ ruleSeparationRuleId: s.separationRuleRole.ruleSeparationRuleId, roleAccessRoleRoleId: s.separationRuleRole.roleAccessRoleRoleId })).run(runner);