acceptedAtinstantoptionalWhen it was taken up
Becomes the column accepted_at of invitation.
Written at commons/data/models/identity/concepts.ts:323
An invitation to join a tenant
Model identity. Written in commons/data/models/identity/concepts.ts:315. Identified by invitationId.
acceptedAtinstantoptionalWhen it was taken up
Becomes the column accepted_at of invitation.
Written at commons/data/models/identity/concepts.ts:323
emailtextrequiredpersonal dataThe address it was sent to
Becomes the column email of invitation.
Annotations: privacy.personal={"category":"EmailAddress","purposes":["invite the person"]}
Written at commons/data/models/identity/concepts.ts:319
expiresAtinstantrequiredWhen it stops being valid
Becomes the column expires_at of invitation.
Written at commons/data/models/identity/concepts.ts:322
invitationIdidentifierrequiredWhat identifies the invitation, made by the application
Becomes the column invitation_id of invitation.
Written at commons/data/models/identity/concepts.ts:318
messagetextoptionalWhat the inviter wrote
Becomes the column message of invitation.
Written at commons/data/models/identity/concepts.ts:324
statuscode of invitationStatusrequiredWhere it is
Becomes the column status of invitation.
Written at commons/data/models/identity/concepts.ts:321
tokenHashtextrequiredThe hash of the secret in the link
Becomes the column token_hash of invitation.
Written at commons/data/models/identity/concepts.ts:320
acceptedByoptionalWho took it up To userAccount. Written at commons/data/models/identity/concepts.ts:330
invitedByoneWho invited To principal. Written at commons/data/models/identity/concepts.ts:329
tenantoneThe tenant the person is invited to To tenant. Written at commons/data/models/identity/concepts.ts:328
Projects to the table invitation with the primary key invitation_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
accepted_at | timestamp | true | attribute | invitation.acceptedAt |
accepted_by_user_account_principal_id | text | true | reference | invitation.acceptedBy |
email | text | false | attribute | invitation.email |
expires_at | timestamp | false | attribute | invitation.expiresAt |
invitation_id | text | false | attribute | invitation.invitationId |
invited_by_principal_id | text | false | reference | invitation.invitedBy |
message | text | true | attribute | invitation.message |
status | text | false | attribute | invitation.status |
tenant_id | text | false | reference | invitation.tenant |
token_hash | text | false | attribute | invitation.tokenHash |
CREATE TABLE IF NOT EXISTS "invitation" (
"invitation_id" VARCHAR NOT NULL PRIMARY KEY,
"email" VARCHAR NOT NULL,
"token_hash" VARCHAR NOT NULL,
"status" VARCHAR NOT NULL,
"expires_at" TIMESTAMPTZ NOT NULL,
"accepted_at" TIMESTAMPTZ,
"message" VARCHAR,
"tenant_id" VARCHAR NOT NULL,
"invited_by_principal_id" VARCHAR NOT NULL,
"accepted_by_user_account_principal_id" VARCHAR,
CONSTRAINT "invitation_tenant_id_fk" FOREIGN KEY ("tenant_id") REFERENCES "tenant" ("tenant_id"),
CONSTRAINT "invitation_invited_by_principal_id_fk" FOREIGN KEY ("invited_by_principal_id") REFERENCES "principal" ("principal_id"),
CONSTRAINT "invitation_accepted_by_user_account_principal_id_fk" FOREIGN KEY ("accepted_by_user_account_principal_id") REFERENCES "user_account" ("principal_id"),
CONSTRAINT "invitation_status_ck" CHECK ("status" IN ('pending', 'accepted', 'expired', 'revoked'))
);CREATE TABLE IF NOT EXISTS "invitation" (
"invitation_id" TEXT NOT NULL PRIMARY KEY,
"email" TEXT NOT NULL,
"token_hash" TEXT NOT NULL,
"status" TEXT NOT NULL,
"expires_at" TIMESTAMPTZ NOT NULL,
"accepted_at" TIMESTAMPTZ,
"message" TEXT,
"tenant_id" TEXT NOT NULL,
"invited_by_principal_id" TEXT NOT NULL,
"accepted_by_user_account_principal_id" TEXT,
CONSTRAINT "invitation_tenant_id_fk" FOREIGN KEY ("tenant_id") REFERENCES "tenant" ("tenant_id"),
CONSTRAINT "invitation_invited_by_principal_id_fk" FOREIGN KEY ("invited_by_principal_id") REFERENCES "principal" ("principal_id"),
CONSTRAINT "invitation_accepted_by_user_account_principal_id_fk" FOREIGN KEY ("accepted_by_user_account_principal_id") REFERENCES "user_account" ("principal_id"),
CONSTRAINT "invitation_status_ck" CHECK ("status" IN ('pending', 'accepted', 'expired', 'revoked'))
);CREATE TABLE IF NOT EXISTS "invitation" (
"invitation_id" TEXT NOT NULL PRIMARY KEY,
"email" TEXT NOT NULL,
"token_hash" TEXT NOT NULL,
"status" TEXT NOT NULL,
"expires_at" TEXT NOT NULL,
"accepted_at" TEXT,
"message" TEXT,
"tenant_id" TEXT NOT NULL,
"invited_by_principal_id" TEXT NOT NULL,
"accepted_by_user_account_principal_id" TEXT,
CONSTRAINT "invitation_tenant_id_fk" FOREIGN KEY ("tenant_id") REFERENCES "tenant" ("tenant_id"),
CONSTRAINT "invitation_invited_by_principal_id_fk" FOREIGN KEY ("invited_by_principal_id") REFERENCES "principal" ("principal_id"),
CONSTRAINT "invitation_accepted_by_user_account_principal_id_fk" FOREIGN KEY ("accepted_by_user_account_principal_id") REFERENCES "user_account" ("principal_id"),
CONSTRAINT "invitation_status_ck" CHECK ("status" IN ('pending', 'accepted', 'expired', 'revoked'))
);Read and written from TypeScript with the types the model gives: import { invitation } from "@intellectual-frontiers/data/sql/typed/models". Generated in commons/data/sql/typed/models/identity.auto.ts: do not edit.
import { from } from "@intellectual-frontiers/data/sql/typed";
import { invitation } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(invitation).select((s) => ({ invitationId: s.invitation.invitationId, email: s.invitation.email })).run(runner);