cloudalias


Description

This table contains unique cloud credentials that are configured for a zone. It is the parent table that is partitioned over zone schema.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('zone.cloudalias_id_seq'::regclass)
device_cloudalias.cloudalias_id fk_device_cloud_alias_alias C

unique identifier for cloudalias record
zone_id int4 10 null
zone.id fk_cloudalias_zone R

Zone Id for cloudalias record. It maps to system.zone.id
collector_id int4 10 null
collector.id fk_cloudalias_collector R

Collector Id for cloudalias record. It maps to system.collector.id
alias text 2147483647 null

Alias given for this credentials. This is the value that gets displayed on UI
credential text 2147483647 √ null

Credentials for cloudalias record. Credentials are stored in following format: <cloud provider for credential(aws)>:alias name:encoded credentials.
aliasorder bigserial 19 √ √ nextval('zone.cloudalias_collector_order_seq'::regclass)

Used to order aliases, use the default, do not write directly

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_cloudalias Primary key Asc id
cloudcollector_alias_order_idx Must be unique Asc/Asc collector_id + aliasorder
idx_cloudalias_alias Performance Asc alias
uk_cloudalias Must be unique Asc/Asc/Asc zone_id + collector_id + alias

Relationships

Close relationships within degrees of separation