collector


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('system.collector_id_seq'::regclass)
attribute_cidr.collector_id fk_attrcidr_collector R
cloudalias.collector_id fk_cloudalias_collector R
config.collector_id fk_zconfig_collector R
device_response.collector_id fk_device_response_collector R
path.collector_id fk_trace_collector R
snmpalias.collector_id fk_snmpalias_collector R
target.collector_id fk_target_collector C
target_highpriority.collector_id fk_target_hp_collector C
wmialias.collector_id fk_wmialias_collector R
attribute_cidr.collector_id fk_attrcidr_collector R
cloudalias.collector_id fk_cloudalias_collector R
config.collector_id fk_zconfig_collector R
device_response.collector_id fk_device_response_collector R
path.collector_id fk_trace_collector R
snmpalias.collector_id fk_snmpalias_collector R
target.collector_id fk_target_collector C
target_highpriority.collector_id fk_target_hp_collector C
wmialias.collector_id fk_wmialias_collector R
zone_id int4 10 null
zone.id fk_collector_zone R
uuid uuid 2147483647 √ uuid_generate_v1()
name text 2147483647 null
ipv4 inet 2147483647 √ null
ipv6 inet 2147483647 √ null
interface_id int4 10 √ null
interface.id fk_collector_intf N
leakinterface_id int4 10 √ null
interface.id fk_collector_leakintf N
updatenotes hstore 2147483647 √ null
externaldnsinterface_id int4 10 √ null
interface.id fk_collector_extdnsintf N

Table contained 1 rows

Indexes

Constraint Name Type Sort Column(s)
pk_collector Primary key Asc id
uk_collector_name Must be unique Asc/Asc name + zone_id

Relationships

Close relationships within degrees of separation