zone


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('system.zone_id_seq'::regclass)
notification_all.zone_id fk_notification_zone C
collector.zone_id fk_collector_zone R
notificationsubscription.zone_id fk_nsubscription_zone C
attribute.zone_id fk_attr_zone R
attribute_cidr.zone_id fk_attrcidr_zone R
certificate.zone_id fk_certificate_zone R
certificatepath.zone_id fk_certificatepath_zone R
cloudalias.zone_id fk_cloudalias_zone R
config.zone_id fk_zconfig_zone R
device.zone_id fk_device_zone R
device_attribute.zone_id fk_devattr_zone R
device_cloudalias.zone_id fk_device_cloud_alias_zone R
device_match.zone_id fk_device_match_zone R
device_pattern.zone_id fk_device_pattern_zone C
device_ports.zone_id fk_device_ports_zone R
device_response.zone_id fk_device_response_zone R
device_snmpalias.zone_id fk_device_alias_zone R
device_values.zone_id fk_devval_zone R
device_wmialias.zone_id fk_device_wmi_alias_zone R
edge.zone_id fk_me_zone R
iftable.zone_id fk_iftable_zone R
iftable_vlan.zone_id fk_iftvl_zone R
interface.zone_id fk_interface_zone R
interface_address.zone_id fk_ifaddr_zone R
interface_host.zone_id fk_ifha_zone R
interface_route.zone_id fk_intf_route_zone R
link.zone_id fk_link_zone R
linkset.zone_id fk_linkset_zone R
mapnode.zone_id fk_mapnode_zone R
nackcandidate.zone_id fk_nackcandidate_zone R
path.zone_id fk_trace_zone R
profile_translation.zone_id fk_profile_translate_zone R
profiledata.zone_id fk_profiledata_zone R
response_decision.zone_id fk_rspdscn_zone R
route.zone_id fk_route_zone R
snmpalias.zone_id fk_snmpalias_zone R
target.zone_id fk_target_zone R
target_highpriority.zone_id fk_target_hp_zone R
wmialias.zone_id fk_wmialias_zone R
name varchar 40 null
description text 2147483647 √ null
organization_id int4 10 null
organization.id fk_zone_org R
updatenotes hstore 2147483647 √ null

Table contained 1 rows

Indexes

Constraint Name Type Sort Column(s)
pk_zone Primary key Asc id
idx_zone_name Performance Asc name
idx_zone_org_id Performance Asc organization_id
uk_zone_name Must be unique Asc/Asc organization_id + name

Relationships

Close relationships within degrees of separation