device_certificate


Description

This table contains a mapping of all certificates discovered for all devices in a zone. It is parent table that is partitioned over zone schema. Example: Certificates discovered for devices for zone id 2 will reside in zone_0002.device_certificate. This table resolves many to many relationship between zone.device and zone.certificate.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
zone_id int4 10 null

Zone Id of a device_certificate record. It maps to zone.id column
device_id int4 10 null
device.id fk_dev_cert_dev C

Id for device record. It maps to zone.device.id
certificate_id int4 10 null
certificate.id fk_dev_cert_cert C

Unique identifier for certificat record. It maps to zone.certificate.id
last_update timestamp 29,6 √ now()

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_dev_cert Primary key Asc/Asc device_id + certificate_id
idx_device_certificate_certificate_id Performance Asc certificate_id
idx_device_certificate_device_id Performance Asc device_id

Relationships

Close relationships within degrees of separation