Device Repository

The Device Repository is the relational store behind the Device Registry. It holds the durable facts about every device: its identity, the certificates it presents, and the groups it belongs to for targeting and access control.

Storage profile

PostgreSQL, single logical database with read replicas. Device records are kept for the lifetime of the device (including retired) for audit and warranty traceability.

Data model

The schema is intentionally small — identity, certificates and grouping. The ERD is embedded on the Overview tab.

Notes

CERTIFICATE.fingerprint is unique and is the value ingestion matches on at connect time.
A device can hold more than one certificate during rotation; exactly one is active at a time.
Grouping (DEVICE_GROUP) feeds OTA cohort targeting and dashboard filters.

Device Repository

Storage profile

PostgreSQL, single logical database with read replicas. Device records are kept for the lifetime of the device (including retired) for audit and warranty traceability.

Data model

The schema is intentionally small — identity, certificates and grouping. The ERD is embedded on the Overview tab.

Notes

CERTIFICATE.fingerprint is unique and is the value ingestion matches on at connect time.
A device can hold more than one certificate during rotation; exactly one is active at a time.
Grouping (DEVICE_GROUP) feeds OTA cohort targeting and dashboard filters.