device_certificate


Columns

Column Type Size Nulls Auto Default Children Parents Comments
zone_id int4 10 null
device_id int4 10 null
device.id fk_dev_cert_dev C
certificate_id int4 10 null
certificate.id fk_dev_cert_cert C
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