biometric_device_keys


Description

{“what”:“Public keys for biometric authenticators (e.g., fingerprint, face) bound to an account.”,“why”:“Without it, biometric authentication cannot verify a device’s signature or revoke a lost device.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:00.976547968+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('biometric_device_keys_id_seq'::regclass)

{“what”:“Unique integer ID for this device key record.”,“why”:“Without it, there is no way to target a specific device key for revocation or update.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:00.993134633+00:00”}

account_id int4 10 null
biometric_accounts.id biometric_device_keys_account_id_fkey R

{“what”:“Integer ID of the user account this key belongs to.”,“why”:“Without it, we cannot determine which account a device key authorizes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:01.009539760+00:00”}

device_name text 2147483647 null

{“what”:“Human-readable label for the device, e.g., ‘iPhone 12’.”,“why”:“Without it, users cannot distinguish multiple devices in account settings.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:01.050837834+00:00”}

key_type text 2147483647 'secure_enclave'::text

{“what”:“Type of key storage, e.g., ‘secure_enclave’ or ‘tpm’.”,“why”:“Without it, we cannot enforce platform-specific key handling or security policies.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:01.063988244+00:00”}

public_key_der bytea 2147483647 null

{“what”:“DER-encoded public key bytes used for signature verification.”,“why”:“Without it, the server cannot verify a biometric device’s cryptographic proof.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:01.083104540+00:00”}

registered_at timestamptz 35,6 now()

{“what”:“Date and time (with time zone) when this key was added.”,“why”:“Without it, we cannot track device enrollment history or enforce key rotation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:01.098272719+00:00”}

last_auth_at timestamptz 35,6 √ null

{“what”:“Timestamp of the last successful authentication using this key, with time zone.”,“why”:“Without it, we cannot identify inactive devices for security review or user notification.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:01.124100683+00:00”}

Indexes

Constraint Name Type Sort Column(s)
biometric_device_keys_pkey Primary key Asc id
biometric_device_keys_account_id_device_name_key Must be unique Asc/Asc account_id + device_name
biometric_device_keys_public_key_der_key Must be unique Asc public_key_der

Relationships