absoluteExpiresAtinstantrequiredWhen it ends whatever
Becomes the column absolute_expires_at of login_session.
Written at commons/data/models/identity/concepts.ts:272
A principal's being signed in, from a device, for a time
Model identity. Written in commons/data/models/identity/concepts.ts:265. Identified by sessionId.
absoluteExpiresAtinstantrequiredWhen it ends whatever
Becomes the column absolute_expires_at of login_session.
Written at commons/data/models/identity/concepts.ts:272
assuranceLevelcode of assuranceLevelrequiredHow sure it is of who it is for
Becomes the column assurance_level of login_session.
Written at commons/data/models/identity/concepts.ts:273
authMethodscode of authMethodmanyHow it was authenticated
Becomes the column auth_methods of login_session.
Written at commons/data/models/identity/concepts.ts:274
authenticatedAtinstantrequiredWhen the principal proved who they are
Becomes the column authenticated_at of login_session.
Written at commons/data/models/identity/concepts.ts:269
federatedProvidertextoptionalThe identity provider it was signed in through, where it was
Becomes the column federated_provider of login_session.
Written at commons/data/models/identity/concepts.ts:275
idleExpiresAtinstantrequiredWhen it ends if it is not used
Becomes the column idle_expires_at of login_session.
Written at commons/data/models/identity/concepts.ts:271
iptextrequiredpersonal dataWhere it came from
Becomes the column ip of login_session.
Annotations: privacy.personal={"category":"IPAddress","purposes":["spot a session used from somewhere new"]}
Written at commons/data/models/identity/concepts.ts:276
lastSeenAtinstantrequiredWhen the session was last used
Becomes the column last_seen_at of login_session.
Written at commons/data/models/identity/concepts.ts:270
revokedAtinstantoptionalWhen it was ended early
Becomes the column revoked_at of login_session.
Written at commons/data/models/identity/concepts.ts:279
revokedReasoncode of revokedReasonoptionalWhy it was ended early
Becomes the column revoked_reason of login_session.
Written at commons/data/models/identity/concepts.ts:280
sessionIdidentifierrequiredWhat identifies the session, made by the application
Becomes the column session_id of login_session.
Written at commons/data/models/identity/concepts.ts:268
statuscode of sessionStatusrequiredWhere the session is
Becomes the column status of login_session.
Written at commons/data/models/identity/concepts.ts:278
stepUpAtinstantoptionalWhen the principal last proved who they are again
Becomes the column step_up_at of login_session.
Written at commons/data/models/identity/concepts.ts:281
userAgenttextrequiredpersonal dataWhat the browser says it is
Becomes the column user_agent of login_session.
Annotations: privacy.personal={"category":"UserAgent","purposes":["show the user where they are signed in"]}
Written at commons/data/models/identity/concepts.ts:277
knownBrowseroptionalThe browser or app it is on To knownBrowser. Written at commons/data/models/identity/concepts.ts:287
principaloneWho is signed in To principal. Written at commons/data/models/identity/concepts.ts:285
tenantoptionalThe tenant the session is working in To tenant. Written at commons/data/models/identity/concepts.ts:286
Projects to the table login_session with the primary key session_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
absolute_expires_at | timestamp | false | attribute | loginSession.absoluteExpiresAt |
assurance_level | text | false | attribute | loginSession.assuranceLevel |
authenticated_at | timestamp | false | attribute | loginSession.authenticatedAt |
federated_provider | text | true | attribute | loginSession.federatedProvider |
idle_expires_at | timestamp | false | attribute | loginSession.idleExpiresAt |
ip | text | false | attribute | loginSession.ip |
known_browser_id | text | true | reference | loginSession.knownBrowser |
last_seen_at | timestamp | false | attribute | loginSession.lastSeenAt |
principal_id | text | false | reference | loginSession.principal |
revoked_at | timestamp | true | attribute | loginSession.revokedAt |
revoked_reason | text | true | attribute | loginSession.revokedReason |
session_id | text | false | attribute | loginSession.sessionId |
status | text | false | attribute | loginSession.status |
step_up_at | timestamp | true | attribute | loginSession.stepUpAt |
tenant_id | text | true | reference | loginSession.tenant |
user_agent | text | false | attribute | loginSession.userAgent |
CREATE TABLE IF NOT EXISTS "login_session" (
"session_id" VARCHAR NOT NULL PRIMARY KEY,
"authenticated_at" TIMESTAMPTZ NOT NULL,
"last_seen_at" TIMESTAMPTZ NOT NULL,
"idle_expires_at" TIMESTAMPTZ NOT NULL,
"absolute_expires_at" TIMESTAMPTZ NOT NULL,
"assurance_level" VARCHAR NOT NULL,
"federated_provider" VARCHAR,
"ip" VARCHAR NOT NULL,
"user_agent" VARCHAR NOT NULL,
"status" VARCHAR NOT NULL,
"revoked_at" TIMESTAMPTZ,
"revoked_reason" VARCHAR,
"step_up_at" TIMESTAMPTZ,
"principal_id" VARCHAR NOT NULL,
"tenant_id" VARCHAR,
"known_browser_id" VARCHAR,
CONSTRAINT "login_session_principal_id_fk" FOREIGN KEY ("principal_id") REFERENCES "principal" ("principal_id"),
CONSTRAINT "login_session_tenant_id_fk" FOREIGN KEY ("tenant_id") REFERENCES "tenant" ("tenant_id"),
CONSTRAINT "login_session_known_browser_id_fk" FOREIGN KEY ("known_browser_id") REFERENCES "known_browser" ("known_browser_id"),
CONSTRAINT "login_session_assurance_level_ck" CHECK ("assurance_level" IN ('aal_1', 'aal_2', 'aal_3')),
CONSTRAINT "login_session_status_ck" CHECK ("status" IN ('active', 'expired', 'revoked', 'signed_out')),
CONSTRAINT "login_session_revoked_reason_ck" CHECK ("revoked_reason" IN ('user', 'admin', 'reuse_detected', 'policy', 'password_change', 'risk'))
);CREATE TABLE IF NOT EXISTS "login_session" (
"session_id" TEXT NOT NULL PRIMARY KEY,
"authenticated_at" TIMESTAMPTZ NOT NULL,
"last_seen_at" TIMESTAMPTZ NOT NULL,
"idle_expires_at" TIMESTAMPTZ NOT NULL,
"absolute_expires_at" TIMESTAMPTZ NOT NULL,
"assurance_level" TEXT NOT NULL,
"federated_provider" TEXT,
"ip" TEXT NOT NULL,
"user_agent" TEXT NOT NULL,
"status" TEXT NOT NULL,
"revoked_at" TIMESTAMPTZ,
"revoked_reason" TEXT,
"step_up_at" TIMESTAMPTZ,
"principal_id" TEXT NOT NULL,
"tenant_id" TEXT,
"known_browser_id" TEXT,
CONSTRAINT "login_session_principal_id_fk" FOREIGN KEY ("principal_id") REFERENCES "principal" ("principal_id"),
CONSTRAINT "login_session_tenant_id_fk" FOREIGN KEY ("tenant_id") REFERENCES "tenant" ("tenant_id"),
CONSTRAINT "login_session_known_browser_id_fk" FOREIGN KEY ("known_browser_id") REFERENCES "known_browser" ("known_browser_id"),
CONSTRAINT "login_session_assurance_level_ck" CHECK ("assurance_level" IN ('aal_1', 'aal_2', 'aal_3')),
CONSTRAINT "login_session_status_ck" CHECK ("status" IN ('active', 'expired', 'revoked', 'signed_out')),
CONSTRAINT "login_session_revoked_reason_ck" CHECK ("revoked_reason" IN ('user', 'admin', 'reuse_detected', 'policy', 'password_change', 'risk'))
);CREATE TABLE IF NOT EXISTS "login_session" (
"session_id" TEXT NOT NULL PRIMARY KEY,
"authenticated_at" TEXT NOT NULL,
"last_seen_at" TEXT NOT NULL,
"idle_expires_at" TEXT NOT NULL,
"absolute_expires_at" TEXT NOT NULL,
"assurance_level" TEXT NOT NULL,
"federated_provider" TEXT,
"ip" TEXT NOT NULL,
"user_agent" TEXT NOT NULL,
"status" TEXT NOT NULL,
"revoked_at" TEXT,
"revoked_reason" TEXT,
"step_up_at" TEXT,
"principal_id" TEXT NOT NULL,
"tenant_id" TEXT,
"known_browser_id" TEXT,
CONSTRAINT "login_session_principal_id_fk" FOREIGN KEY ("principal_id") REFERENCES "principal" ("principal_id"),
CONSTRAINT "login_session_tenant_id_fk" FOREIGN KEY ("tenant_id") REFERENCES "tenant" ("tenant_id"),
CONSTRAINT "login_session_known_browser_id_fk" FOREIGN KEY ("known_browser_id") REFERENCES "known_browser" ("known_browser_id"),
CONSTRAINT "login_session_assurance_level_ck" CHECK ("assurance_level" IN ('aal_1', 'aal_2', 'aal_3')),
CONSTRAINT "login_session_status_ck" CHECK ("status" IN ('active', 'expired', 'revoked', 'signed_out')),
CONSTRAINT "login_session_revoked_reason_ck" CHECK ("revoked_reason" IN ('user', 'admin', 'reuse_detected', 'policy', 'password_change', 'risk'))
);Read and written from TypeScript with the types the model gives: import { loginSession } 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 { loginSession } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(loginSession).select((s) => ({ sessionId: s.loginSession.sessionId, authenticatedAt: s.loginSession.authenticatedAt })).run(runner);