invitationoneThe invitation To invitation. Written at commons/data/models/identity-access/concepts.ts:136
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.
invitationoneThe invitation To invitation. Written at commons/data/models/identity-access/concepts.ts:136
roleoneThe role To accessRole. Written at commons/data/models/identity-access/concepts.ts:136
Projects to the table invitation_role with the primary key invitation_id, role_access_role_role_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
invitation_id | text | false | reference | invitationRole.invitation |
role_access_role_role_id | text | false | reference | invitationRole.role |
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")
);CREATE TABLE IF NOT EXISTS "invitation_role" (
"invitation_id" TEXT NOT NULL,
"role_access_role_role_id" TEXT 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")
);CREATE TABLE IF NOT EXISTS "invitation_role" (
"invitation_id" TEXT NOT NULL,
"role_access_role_role_id" TEXT 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")
);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);