knownBrowser concept personal 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: attributesfingerprintHashtext required personal 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
firstSeenAtinstant required When it was first seen
Becomes the column first_seen_at of known_browser.
Written at commons/data/models/identity/concepts.ts:255
knownBrowserIdidentifier required 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
What the person calls it
Becomes the column label of known_browser.
Written at commons/data/models/identity/concepts.ts:254
lastSeenAtinstant required When it was last seen
Becomes the column last_seen_at of known_browser.
Written at commons/data/models/identity/concepts.ts:256
trustedUntilinstant optional 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# Logical: the tableProjects to the table known_browser with the primary key known_browser_id.
# Physical: SQLduckdb postgres sqlite
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")
);CREATE TABLE IF NOT EXISTS "known_browser" (
"known_browser_id" TEXT NOT NULL PRIMARY KEY ,
"fingerprint_hash" TEXT NOT NULL ,
"label" TEXT ,
"first_seen_at" TIMESTAMPTZ NOT NULL ,
"last_seen_at" TIMESTAMPTZ NOT NULL ,
"trusted_until" TIMESTAMPTZ,
"principal_id" TEXT NOT NULL ,
CONSTRAINT "known_browser_principal_id_fk" FOREIGN KEY ("principal_id") REFERENCES "principal" ("principal_id")
);CREATE TABLE IF NOT EXISTS "known_browser" (
"known_browser_id" TEXT NOT NULL PRIMARY KEY ,
"fingerprint_hash" TEXT NOT NULL ,
"label" TEXT ,
"first_seen_at" TEXT NOT NULL ,
"last_seen_at" TEXT NOT NULL ,
"trusted_until" TEXT ,
"principal_id" TEXT NOT NULL ,
CONSTRAINT "known_browser_principal_id_fk" FOREIGN KEY ("principal_id") REFERENCES "principal" ("principal_id")
);# Physical: the typed tableRead 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);