IF Commons GitHub

passkey

concept

A passkey: the public half of a key pair whose private half never leaves the person's device

Model identity. Written in commons/data/models/identity/concepts.ts:168. Identified by credential.

Governance: attributes

aaguidtextoptional

What kind of authenticator it is

Becomes the column aaguid of passkey.

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

attestationFormattextoptional

The form of the proof of what made it

Becomes the column attestation_format of passkey.

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

backedUpbooleanrequired

Whether it has been

Becomes the column backed_up of passkey.

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

backupEligiblebooleanrequired

Whether the key can be backed up

Becomes the column backup_eligible of passkey.

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

credentialIdValuebinaryrequired

What the authenticator calls the key, unique

Becomes the column credential_id_value of passkey.

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

publicKeybinaryrequired

The public key, in COSE form

Becomes the column public_key of passkey.

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

signCountintegerrequired

How many times the authenticator says it has signed

Becomes the column sign_count of passkey.

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

transportstextmany

How the authenticator can be reached

Becomes the column transports of passkey.

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

userVerifiedbooleanrequired

Whether the person was verified when it was made

Becomes the column user_verified of passkey.

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

Governance: relationships

credentialone

The credential it is To credential. Written at commons/data/models/identity/concepts.ts:168

Logical: the table

Projects to the table passkey with the primary key credential_id.

ColumnTypeNullRoleFrom
aaguidtexttrueattributepasskey.aaguid
attestation_formattexttrueattributepasskey.attestationFormat
backed_upbooleanfalseattributepasskey.backedUp
backup_eligiblebooleanfalseattributepasskey.backupEligible
credential_idtextfalsereferencepasskey.credential
credential_id_valuebytesfalseattributepasskey.credentialIdValue
public_keybytesfalseattributepasskey.publicKey
sign_countintegerfalseattributepasskey.signCount
user_verifiedbooleanfalseattributepasskey.userVerified

Physical: SQL

CREATE TABLE IF NOT EXISTS "passkey" (
    "credential_id" VARCHAR NOT NULL PRIMARY KEY,
    "credential_id_value" BLOB NOT NULL,
    "public_key" BLOB NOT NULL,
    "sign_count" INTEGER NOT NULL,
    "aaguid" VARCHAR,
    "backup_eligible" BOOLEAN NOT NULL,
    "backed_up" BOOLEAN NOT NULL,
    "user_verified" BOOLEAN NOT NULL,
    "attestation_format" VARCHAR,
    CONSTRAINT "passkey_credential_id_fk" FOREIGN KEY ("credential_id") REFERENCES "credential" ("credential_id"),
    CONSTRAINT "passkey_credential_id_value_uq" UNIQUE ("credential_id_value")
);

Physical: the typed table

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

const rows = await from(passkey).select((s) => ({ credentialId: s.passkey.credentialId, credentialIdValue: s.passkey.credentialIdValue })).run(runner);

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