IF Commons GitHub

knownBrowser

conceptpersonal data

A browser or app that a principal signs in from, recognised by a hash of what it says it is

Model identity. Written in commons/data/models/identity/concepts.ts:249. Identified by knownBrowserId.

Governance: attributes

fingerprintHashtextrequiredpersonal data

A hash of what the browser says it is

Becomes the column fingerprint_hash of known_browser.

Annotations: privacy.personal={"category":"BrowserFingerprint","purposes":["recognise a device the user has used"]}

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

firstSeenAtinstantrequired

When it was first seen

Becomes the column first_seen_at of known_browser.

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

knownBrowserIdidentifierrequired

What identifies the browser, made by the application

Becomes the column known_browser_id of known_browser.

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

labeltextoptional

What the person calls it

Becomes the column label of known_browser.

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

lastSeenAtinstantrequired

When it was last seen

Becomes the column last_seen_at of known_browser.

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

trustedUntilinstantoptional

Until when it is trusted not to be asked for a second factor

Becomes the column trusted_until of known_browser.

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

Governance: relationships

principalone

Whose it is To principal. Written at commons/data/models/identity/concepts.ts:285

Logical: the table

Projects to the table known_browser with the primary key known_browser_id.

ColumnTypeNullRoleFrom
fingerprint_hashtextfalseattributeknownBrowser.fingerprintHash
first_seen_attimestampfalseattributeknownBrowser.firstSeenAt
known_browser_idtextfalseattributeknownBrowser.knownBrowserId
labeltexttrueattributeknownBrowser.label
last_seen_attimestampfalseattributeknownBrowser.lastSeenAt
principal_idtextfalsereferenceknownBrowser.principal
trusted_untiltimestamptrueattributeknownBrowser.trustedUntil

Physical: SQL

CREATE TABLE IF NOT EXISTS "known_browser" (
    "known_browser_id" VARCHAR NOT NULL PRIMARY KEY,
    "fingerprint_hash" VARCHAR NOT NULL,
    "label" VARCHAR,
    "first_seen_at" TIMESTAMPTZ NOT NULL,
    "last_seen_at" TIMESTAMPTZ NOT NULL,
    "trusted_until" TIMESTAMPTZ,
    "principal_id" VARCHAR NOT NULL,
    CONSTRAINT "known_browser_principal_id_fk" FOREIGN KEY ("principal_id") REFERENCES "principal" ("principal_id")
);

Physical: the typed table

Read and written from TypeScript with the types the model gives: import { knownBrowser } 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 { knownBrowser } from "@intellectual-frontiers/data/sql/typed/models";

const rows = await from(knownBrowser).select((s) => ({ knownBrowserId: s.knownBrowser.knownBrowserId, fingerprintHash: s.knownBrowser.fingerprintHash })).run(runner);

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