device_cloudalias


Description

This table contains reference information for all the cloud aliases a device has responded to. It is parent table that is partitioned over zone schema. A device can have as many records as received unique responses for each profiledata type in this table. One device can have zero to many records.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
zone_id int4 10 null
zone.id fk_device_cloud_alias_zone R

Zone Id of a device_cloudalias record. It maps to zone.id
device_id int4 10 null
device.id fk_device_cloud_alias_device C

Id of a device this record belongs to. It maps to device.id
cloudalias_id int4 10 null
cloudalias.id fk_device_cloud_alias_alias C

Id of a cloudalias this record belongs to. It maps to zone.cloudalias.id
last_update timestamp 29,6 √ now()

The most recent time when a device has responded with given cloud alias. It gets updated with current timestamp everytime a device response for cloud discovery is received for an alias.

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_device_cloud_alias Primary key Asc/Asc device_id + cloudalias_id

Relationships

Close relationships within degrees of separation