IF Commons GitHub

sessionPolicy

concept

The rules for sessions

Model identity. Written in commons/data/models/identity/concepts.ts:404. Identified by sessionPolicyId.

Governance: attributes

absoluteMinutesintegerrequired

How long it lasts at most

Becomes the column absolute_minutes of session_policy.

Written at commons/data/models/identity/concepts.ts:409

bindToDevicebooleanrequired

Whether 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

concurrentSessionLimitintegeroptional

How 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

idleMinutesintegerrequired

How long a session lasts unused

Becomes the column idle_minutes of session_policy.

Written at commons/data/models/identity/concepts.ts:408

sessionPolicyIdidentifierrequired

What 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

stepUpMinutesintegerrequired

How long a second proof counts for

Becomes the column step_up_minutes of session_policy.

Written at commons/data/models/identity/concepts.ts:412

Governance: relationships

tenantoptional

The 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

Logical: the table

Projects to the table session_policy with the primary key session_policy_id.

ColumnTypeNullRoleFrom
absolute_minutesintegerfalseattributesessionPolicy.absoluteMinutes
bind_to_devicebooleanfalseattributesessionPolicy.bindToDevice
concurrent_session_limitintegertrueattributesessionPolicy.concurrentSessionLimit
idle_minutesintegerfalseattributesessionPolicy.idleMinutes
session_policy_idtextfalseattributesessionPolicy.sessionPolicyId
step_up_minutesintegerfalseattributesessionPolicy.stepUpMinutes
tenant_idtexttruereferencesessionPolicy.tenant

Physical: SQL

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")
);

Physical: the typed table

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);

Titles, headings, exports, tables, columns and requirements. Esc closes.