absoluteMinutesintegerrequiredHow long it lasts at most
Becomes the column absolute_minutes of session_policy.
Written at commons/data/models/identity/concepts.ts:409
The rules for sessions
Model identity. Written in commons/data/models/identity/concepts.ts:404. Identified by sessionPolicyId.
absoluteMinutesintegerrequiredHow long it lasts at most
Becomes the column absolute_minutes of session_policy.
Written at commons/data/models/identity/concepts.ts:409
bindToDevicebooleanrequiredWhether a session is tied to the device it began on
Becomes the column bind_to_device of session_policy.
Written at commons/data/models/identity/concepts.ts:411
concurrentSessionLimitintegeroptionalHow many a principal may have at once
Becomes the column concurrent_session_limit of session_policy.
Written at commons/data/models/identity/concepts.ts:410
idleMinutesintegerrequiredHow long a session lasts unused
Becomes the column idle_minutes of session_policy.
Written at commons/data/models/identity/concepts.ts:408
sessionPolicyIdidentifierrequiredWhat identifies the policy, made by the application
Becomes the column session_policy_id of session_policy.
Written at commons/data/models/identity/concepts.ts:407
stepUpMinutesintegerrequiredHow long a second proof counts for
Becomes the column step_up_minutes of session_policy.
Written at commons/data/models/identity/concepts.ts:412
tenantoptionalThe tenant the policy is for; empty for the platform's, which a tenant's replaces To tenant. Written at commons/data/models/identity/concepts.ts:466
Projects to the table session_policy with the primary key session_policy_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
absolute_minutes | integer | false | attribute | sessionPolicy.absoluteMinutes |
bind_to_device | boolean | false | attribute | sessionPolicy.bindToDevice |
concurrent_session_limit | integer | true | attribute | sessionPolicy.concurrentSessionLimit |
idle_minutes | integer | false | attribute | sessionPolicy.idleMinutes |
session_policy_id | text | false | attribute | sessionPolicy.sessionPolicyId |
step_up_minutes | integer | false | attribute | sessionPolicy.stepUpMinutes |
tenant_id | text | true | reference | sessionPolicy.tenant |
CREATE TABLE IF NOT EXISTS "session_policy" (
"session_policy_id" VARCHAR NOT NULL PRIMARY KEY,
"idle_minutes" INTEGER NOT NULL,
"absolute_minutes" INTEGER NOT NULL,
"concurrent_session_limit" INTEGER,
"bind_to_device" BOOLEAN NOT NULL,
"step_up_minutes" INTEGER NOT NULL,
"tenant_id" VARCHAR,
CONSTRAINT "session_policy_tenant_id_fk" FOREIGN KEY ("tenant_id") REFERENCES "tenant" ("tenant_id")
);CREATE TABLE IF NOT EXISTS "session_policy" (
"session_policy_id" TEXT NOT NULL PRIMARY KEY,
"idle_minutes" INTEGER NOT NULL,
"absolute_minutes" INTEGER NOT NULL,
"concurrent_session_limit" INTEGER,
"bind_to_device" BOOLEAN NOT NULL,
"step_up_minutes" INTEGER NOT NULL,
"tenant_id" TEXT,
CONSTRAINT "session_policy_tenant_id_fk" FOREIGN KEY ("tenant_id") REFERENCES "tenant" ("tenant_id")
);CREATE TABLE IF NOT EXISTS "session_policy" (
"session_policy_id" TEXT NOT NULL PRIMARY KEY,
"idle_minutes" INTEGER NOT NULL,
"absolute_minutes" INTEGER NOT NULL,
"concurrent_session_limit" INTEGER,
"bind_to_device" INTEGER NOT NULL,
"step_up_minutes" INTEGER NOT NULL,
"tenant_id" TEXT,
CONSTRAINT "session_policy_tenant_id_fk" FOREIGN KEY ("tenant_id") REFERENCES "tenant" ("tenant_id")
);Read and written from TypeScript with the types the model gives: import { sessionPolicy } 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 { sessionPolicy } from "@intellectual-frontiers/data/sql/typed/models";
const rows = await from(sessionPolicy).select((s) => ({ sessionPolicyId: s.sessionPolicy.sessionPolicyId, idleMinutes: s.sessionPolicy.idleMinutes })).run(runner);