joinedAtinstantoptionalWhen the user became a member
Becomes the column joined_at of membership.
Written at commons/data/models/identity/concepts.ts:104
A user's place in a tenant
Model identity. Written in commons/data/models/identity/concepts.ts:98. Identified by membershipId.
joinedAtinstantoptionalWhen the user became a member
Becomes the column joined_at of membership.
Written at commons/data/models/identity/concepts.ts:104
membershipIdidentifierrequiredWhat identifies the membership, made by the application
Becomes the column membership_id of membership.
Written at commons/data/models/identity/concepts.ts:101
removedAtinstantoptionalWhen the membership ended
Becomes the column removed_at of membership.
Written at commons/data/models/identity/concepts.ts:105
sourcecode of membershipSourcerequiredHow the user came to be a member
Becomes the column source of membership.
Written at commons/data/models/identity/concepts.ts:103
statuscode of membershipStatusrequiredWhere the membership is
Becomes the column status of membership.
Written at commons/data/models/identity/concepts.ts:102
tenantoneThe tenant To tenant. Written at commons/data/models/identity/concepts.ts:286
userAccountoneThe user To userAccount. Written at commons/data/models/identity/concepts.ts:98
Projects to the table membership with the primary key membership_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
joined_at | timestamp | true | attribute | membership.joinedAt |
membership_id | text | false | attribute | membership.membershipId |
removed_at | timestamp | true | attribute | membership.removedAt |
source | text | false | attribute | membership.source |
status | text | false | attribute | membership.status |
tenant_id | text | false | reference | membership.tenant |
user_account_principal_id | text | false | reference | membership.userAccount |
CREATE TABLE IF NOT EXISTS "membership" (
"membership_id" VARCHAR NOT NULL PRIMARY KEY,
"status" VARCHAR NOT NULL,
"source" VARCHAR NOT NULL,
"joined_at" TIMESTAMPTZ,
"removed_at" TIMESTAMPTZ,
"user_account_principal_id" VARCHAR NOT NULL,
"tenant_id" VARCHAR NOT NULL,
CONSTRAINT "membership_user_account_principal_id_fk" FOREIGN KEY ("user_account_principal_id") REFERENCES "user_account" ("principal_id"),
CONSTRAINT "membership_tenant_id_fk" FOREIGN KEY ("tenant_id") REFERENCES "tenant" ("tenant_id"),
CONSTRAINT "membership_user_account_principal_id_tenant_id_uq" UNIQUE ("user_account_principal_id", "tenant_id"),
CONSTRAINT "membership_status_ck" CHECK ("status" IN ('invited', 'active', 'suspended', 'removed')),
CONSTRAINT "membership_source_ck" CHECK ("source" IN ('invited', 'directory', 'domain_capture', 'self_join', 'admin'))
);CREATE TABLE IF NOT EXISTS "membership" (
"membership_id" TEXT NOT NULL PRIMARY KEY,
"status" TEXT NOT NULL,
"source" TEXT NOT NULL,
"joined_at" TIMESTAMPTZ,
"removed_at" TIMESTAMPTZ,
"user_account_principal_id" TEXT NOT NULL,
"tenant_id" TEXT NOT NULL,
CONSTRAINT "membership_user_account_principal_id_fk" FOREIGN KEY ("user_account_principal_id") REFERENCES "user_account" ("principal_id"),
CONSTRAINT "membership_tenant_id_fk" FOREIGN KEY ("tenant_id") REFERENCES "tenant" ("tenant_id"),
CONSTRAINT "membership_user_account_principal_id_tenant_id_uq" UNIQUE ("user_account_principal_id", "tenant_id"),
CONSTRAINT "membership_status_ck" CHECK ("status" IN ('invited', 'active', 'suspended', 'removed')),
CONSTRAINT "membership_source_ck" CHECK ("source" IN ('invited', 'directory', 'domain_capture', 'self_join', 'admin'))
);CREATE TABLE IF NOT EXISTS "membership" (
"membership_id" TEXT NOT NULL PRIMARY KEY,
"status" TEXT NOT NULL,
"source" TEXT NOT NULL,
"joined_at" TEXT,
"removed_at" TEXT,
"user_account_principal_id" TEXT NOT NULL,
"tenant_id" TEXT NOT NULL,
CONSTRAINT "membership_user_account_principal_id_fk" FOREIGN KEY ("user_account_principal_id") REFERENCES "user_account" ("principal_id"),
CONSTRAINT "membership_tenant_id_fk" FOREIGN KEY ("tenant_id") REFERENCES "tenant" ("tenant_id"),
CONSTRAINT "membership_user_account_principal_id_tenant_id_uq" UNIQUE ("user_account_principal_id", "tenant_id"),
CONSTRAINT "membership_status_ck" CHECK ("status" IN ('invited', 'active', 'suspended', 'removed')),
CONSTRAINT "membership_source_ck" CHECK ("source" IN ('invited', 'directory', 'domain_capture', 'self_join', 'admin'))
);Read and written from TypeScript with the types the model gives: import { membership } 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 { membership } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(membership).select((s) => ({ membershipId: s.membership.membershipId, status: s.membership.status })).run(runner);