IF Commons GitHub

invitationRole

concept

A role that an invitation grants when it is accepted

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

Governance: attributes

Governance: relationships

invitationone

The invitation To invitation. Written at commons/data/models/identity-access/concepts.ts:136

roleone

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

Logical: the table

Projects to the table invitation_role with the primary key invitation_id, role_access_role_role_id.

ColumnTypeNullRoleFrom
invitation_idtextfalsereferenceinvitationRole.invitation
role_access_role_role_idtextfalsereferenceinvitationRole.role

Physical: SQL

CREATE TABLE IF NOT EXISTS "invitation_role" (
    "invitation_id" VARCHAR NOT NULL,
    "role_access_role_role_id" VARCHAR NOT NULL,
    PRIMARY KEY ("invitation_id", "role_access_role_role_id"),
    CONSTRAINT "invitation_role_invitation_id_fk" FOREIGN KEY ("invitation_id") REFERENCES "invitation" ("invitation_id"),
    CONSTRAINT "invitation_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 { invitationRole } 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 { invitationRole } from "@intellectual-frontiers/data/sql/typed/models";

const rows = await from(invitationRole).select((s) => ({ invitationId: s.invitationRole.invitationId, roleAccessRoleRoleId: s.invitationRole.roleAccessRoleRoleId })).run(runner);

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