IF Commons GitHub

separationRuleRole

concept

A role that a separation rule is about

Model identityAccess. Written in commons/data/models/identity-access/concepts.ts:86. Identified by rule, role.

Governance: attributes

Governance: relationships

roleone

The role To accessRole. Written at commons/data/models/identity-access/concepts.ts:112

ruleone

The rule To separationRule. Written at commons/data/models/identity-access/concepts.ts:86

Logical: the table

Projects to the table separation_rule_role with the primary key rule_separation_rule_id, role_access_role_role_id.

ColumnTypeNullRoleFrom
role_access_role_role_idtextfalsereferenceseparationRuleRole.role
rule_separation_rule_idtextfalsereferenceseparationRuleRole.rule

Physical: SQL

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

Physical: the typed table

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

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