aaguidtextoptionalWhat kind of authenticator it is
Becomes the column aaguid of passkey.
Written at commons/data/models/identity/concepts.ts:174
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.
aaguidtextoptionalWhat kind of authenticator it is
Becomes the column aaguid of passkey.
Written at commons/data/models/identity/concepts.ts:174
attestationFormattextoptionalThe form of the proof of what made it
Becomes the column attestation_format of passkey.
Written at commons/data/models/identity/concepts.ts:179
backedUpbooleanrequiredWhether it has been
Becomes the column backed_up of passkey.
Written at commons/data/models/identity/concepts.ts:177
backupEligiblebooleanrequiredWhether the key can be backed up
Becomes the column backup_eligible of passkey.
Written at commons/data/models/identity/concepts.ts:176
credentialIdValuebinaryrequiredWhat the authenticator calls the key, unique
Becomes the column credential_id_value of passkey.
Written at commons/data/models/identity/concepts.ts:171
publicKeybinaryrequiredThe public key, in COSE form
Becomes the column public_key of passkey.
Written at commons/data/models/identity/concepts.ts:172
signCountintegerrequiredHow many times the authenticator says it has signed
Becomes the column sign_count of passkey.
Written at commons/data/models/identity/concepts.ts:173
transportstextmanyHow the authenticator can be reached
Becomes the column transports of passkey.
Written at commons/data/models/identity/concepts.ts:175
userVerifiedbooleanrequiredWhether the person was verified when it was made
Becomes the column user_verified of passkey.
Written at commons/data/models/identity/concepts.ts:178
credentialoneThe credential it is To credential. Written at commons/data/models/identity/concepts.ts:168
Projects to the table passkey with the primary key credential_id.
| Column | Type | Null | Role | From |
|---|---|---|---|---|
aaguid | text | true | attribute | passkey.aaguid |
attestation_format | text | true | attribute | passkey.attestationFormat |
backed_up | boolean | false | attribute | passkey.backedUp |
backup_eligible | boolean | false | attribute | passkey.backupEligible |
credential_id | text | false | reference | passkey.credential |
credential_id_value | bytes | false | attribute | passkey.credentialIdValue |
public_key | bytes | false | attribute | passkey.publicKey |
sign_count | integer | false | attribute | passkey.signCount |
user_verified | boolean | false | attribute | passkey.userVerified |
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")
);CREATE TABLE IF NOT EXISTS "passkey" (
"credential_id" TEXT NOT NULL PRIMARY KEY,
"credential_id_value" BYTEA NOT NULL,
"public_key" BYTEA NOT NULL,
"sign_count" INTEGER NOT NULL,
"aaguid" TEXT,
"backup_eligible" BOOLEAN NOT NULL,
"backed_up" BOOLEAN NOT NULL,
"user_verified" BOOLEAN NOT NULL,
"attestation_format" TEXT,
CONSTRAINT "passkey_credential_id_fk" FOREIGN KEY ("credential_id") REFERENCES "credential" ("credential_id"),
CONSTRAINT "passkey_credential_id_value_uq" UNIQUE ("credential_id_value")
);CREATE TABLE IF NOT EXISTS "passkey" (
"credential_id" TEXT NOT NULL PRIMARY KEY,
"credential_id_value" BLOB NOT NULL,
"public_key" BLOB NOT NULL,
"sign_count" INTEGER NOT NULL,
"aaguid" TEXT,
"backup_eligible" INTEGER NOT NULL,
"backed_up" INTEGER NOT NULL,
"user_verified" INTEGER NOT NULL,
"attestation_format" TEXT,
CONSTRAINT "passkey_credential_id_fk" FOREIGN KEY ("credential_id") REFERENCES "credential" ("credential_id"),
CONSTRAINT "passkey_credential_id_value_uq" UNIQUE ("credential_id_value")
);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);