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 |
|
|
{“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 |