Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
linkset Table hosts bool 1 √ null
device_wmialias Table wmialias_id int4 10 null
interface Table adminstatus int4 10 √ null
snmpalias Table alias text 2147483647 null
target Table last_target timestamp 29 √ null
mapnode Table device_id int4 10 √ null
target_shadow Table cidrval cidr 2147483647 null
interface_route Table last_update timestamp 29 √ now()
target Table scantype_id int4 10 null
target Table id serial 10 √ nextval('zone.target_id_seq'::regclass)
nackcandidate Table mac macaddr 2147483647 √ null
iftable_vlan Table iftable_id int4 10 null
attribute_cidr Table attribute_id int4 10 √ null
profile_translation Table pattern_id int4 10 null
target_hist Table collector_id int4 10 null
mapnode Table id serial 10 √ nextval('zone.mapnode_id_seq'::regclass)
targetm Table config text 2147483647 √ null
snmpalias Table id serial 10 √ nextval('zone.snmpalias_id_seq'::regclass)
certificate Table subject_id int4 10 √ null
map Table type text 2147483647 null
device_values Table hasresponses bool 1 √ false
device_certificate Table certificate_id int4 10 null
certificate Table certificatetype text 2147483647 √ null
profile_translation Table type_id int4 10 null
wmialias Table id serial 10 √ nextval('zone.wmialias_id_seq'::regclass)
target_hist Table scantype_id int4 10 null
updates Table fields hstore 2147483647 √ null
link Table linkset_id int4 10 null
route Table zone_id int4 10 null
interface Table name text 2147483647 √ null
device_cloudalias Table device_id int4 10 null
interface Table indconthash text 2147483647 √ null
path Table id serial 10 √ nextval('zone.path_id_seq'::regclass)
updates Table op text 2147483647 √ null
device_values Table l2hosts int4 10 √ 0
device_response Table ports _int4 10 √ null
targetm Table cidr_id int4 10 √ null
certificate Table issuer_id int4 10 √ null
mapnode Table tag text 2147483647 √ null
device_ports Table device_id int4 10 null
attribute_cidr Table timestamp timestamp 29 √ now()
updatetargetspace_log Table count int4 10 √ null
route Table trusted bool 1 √ null
device_values Table known bool 1 √ false
interface_route Table route cidr 2147483647 √ null
device_profiledata Table zone_id int4 10 null
route Table known bool 1 √ null
target_hist Table last_target timestamp 29 √ null
profiledata Table zone_id int4 10 null
interface Table opstatus int4 10 √ null
target_highpriority Table ordid float4 8 √ random()
device Table device_id int4 10 √ null
profiledata_pattern Table zone_id int4 10 null
target_highpriority Table target_id int4 10 √ null
wmialias Table collector_id int4 10 null
device_ports Table open _int4 10 √ null
certificate Table chainorder int4 10 √ null
interface Table infhash text 2147483647 √ null
interface Table index int4 10 √ null
iftable_vlan Table zone_id int4 10 √ null
mapnode Table zone_id int4 10 null
target Table zone_id int4 10 null
updates Table zone_id int4 10 √ null
route Table route cidr 2147483647 √ null
device_response Table id serial 10 √ nextval('zone.device_response_id_seq'::regclass)
route Table id serial 10 √ nextval('zone.route_id_seq'::regclass)
attribute Table attributetype_id int4 10 √ null
certificatepath_pattern Table certificatepath_id int4 10 null
interface_address Table zone_id int4 10 null
device_response Table collector_id int4 10 null
interface Table physicaladdress macaddr 2147483647 √ null
snmpalias Table aliasorder bigserial 19 √ √ nextval('zone.snmpalias_collector_order_seq'::regclass)
path Table collector_id int4 10 null
device_pattern Table zone_id int4 10 null
interface Table alias text 2147483647 √ null
linkset Table zone_id int4 10 √ null
device_snmpalias Table device_id int4 10 null
device_response Table time timestamp 29 √ null
linkset Table layer text 2147483647 √ null
certificatepath Table id serial 10 √ nextval('zone.certificatepath_id_seq'::regclass)
target_shadow Table detailsnew text 2147483647 √ null
updates Table time timestamp 29 √ now()
mapnode Table label text 2147483647 √ null
device_values Table l2peers int2 5 √ 0
device_profiledata Table type_id int4 10 null
target_hist Table device_id int4 10 √ null
device Table identity text 2147483647 √ null
device_certificate Table zone_id int4 10 null
wmialias Table aliasorder bigserial 19 √ √ nextval('zone.wmialias_collector_order_seq'::regclass)
target_hist Table batchid int4 10 √ null
device_attribute Table last_update timestamp 29 √ now()
nackcandidate Table collector_id int4 10 null
profile_translation Table id serial 10 √ nextval('zone.profile_translation_id_seq'::regclass)
targetm Table cidrval cidr 2147483647 √ null
cloudalias Table aliasorder bigserial 19 √ √ nextval('zone.cloudalias_collector_order_seq'::regclass)
target_shadow Table last_update timestamp 29 √ now()
wmialias Table credential text 2147483647 √ null
device_response Table scantype_id int4 10 null
attribute_cidr Table zone_id int4 10 null
interface_host Table interface_id int4 10 null
cloudalias Table id serial 10 √ nextval('zone.cloudalias_id_seq'::regclass)
device Table enterprise_id int4 10 √ null
device_pattern Table device_id int4 10 null
wmialias Table zone_id int4 10 null
cloudalias Table credential text 2147483647 √ null
nackcandidate Table ip inet 2147483647 √ null
target_shadow Table route_id int4 10 √ null
profiledata Table type_id int4 10 null
certificate Table port int4 10 √ null
profiledata_pattern Table profiledata_id int4 10 null
updatetargetspace_log Table action text 2147483647 √ null
certificate Table startdate timestamp 29 √ null
device_cloudalias Table zone_id int4 10 null
response_decision Table zone_id int4 10 null
certificate Table id serial 10 √ nextval('zone.certificate_id_seq'::regclass)
target Table batchid int4 10 √ null
profiledata Table rawdata text 2147483647 null
edge Table node_id1 int4 10 null
target_hist Table id serial 10 √ nextval('zone.target_hist_id_seq'::regclass)
device_profiledata Table profiledata_id int4 10 null
edge Table id serial 10 √ nextval('zone.edge_id_seq'::regclass)
device_values Table l3peers int2 5 √ 0
device_pattern Table port_match bool 1 √ null
acknowledgeddevice Table acknowledged bool 1 null
path Table zone_id int4 10 null
certificatepath_pattern Table pattern_id int4 10 null
target_highpriority Table id serial 10 √ nextval('zone.target_highpriority_id_seq'::regclass)
device_values Table snmpresponder bool 1 √ false
link Table device_id1 int4 10 null
device Table zone_id int4 10 null
profiledata Table hash text 2147483647 null
target_hist Table details text 2147483647 √ null
interface_address Table id serial 10 √ nextval('zone.interface_address_id_seq'::regclass)
config Table zone_id int4 10 √ null
interface_route Table id serial 10 √ nextval('zone.interface_route_id_seq'::regclass)
interface_route Table interface_id int4 10 null
edge Table interface_id2 int4 10 √ null
device_wmialias Table device_id int4 10 null
config Table key text 2147483647 √ null
path Table hops _inet 2147483647 √ null
targetm Table route_id int4 10 √ null
mapnode Table ycoord float4 8 √ null
device_pattern Table pattern_id int4 10 null
edge Table interface_id1 int4 10 √ null
nackcandidate Table id serial 10 √ nextval('zone.nackcandidate_id_seq'::regclass)
attribute_cidr Table hasresponses bool 1 √ false
device_match Table zone_id int4 10 null
interface Table voicevlan int4 10 √ null
target_hist Table zone_id int4 10 null
interface_host Table vlans _int4 10 null
certificatepath_pattern Table zone_id int4 10 null
device_values Table internal bool 1 √ false
device Table lastupdate text 2147483647 √ null
interface_route Table first_observed timestamptz 35 √ now()
target_hist Table route_id int4 10 √ null
mapnode Table action_items text 2147483647 √ null
profile_translation Table content_id int4 10 √ null
device_values Table target bool 1 √ false
device_certificate Table device_id int4 10 null
target_highpriority Table batchid int4 10 √ null
device_values Table version text 2147483647 √ null
interface_address Table ip inet 2147483647 √ null
device_attribute Table attributetype_id int4 10 null
mapnode Table height float4 8 √ null
iftable Table zone_id int4 10 null
device Table firstobserved timestamp 29 √ now()
targetm Table scantype_id int4 10 √ null
nackcandidate Table scantype_id int4 10 null
attribute Table id serial 10 √ nextval('zone.attribute_id_seq'::regclass)
mapnode Table acknowledged_time timestamp 29 √ now()
target_highpriority Table device_id int4 10 √ null
map Table user_id int4 10 null
device_ports Table closed_times hstore 2147483647 √ null
device_match Table attribute_id int4 10 null
interface_route Table withdrawn bool 1 √ false
response_decision Table sn text 2147483647 √ null
target_highpriority Table scantype_id int4 10 null
target_highpriority Table route_id int4 10 √ null
edge Table node_id2 int4 10 null
interface_route Table asnum int4 10 √ null
device_match Table confidence int4 10 null
target_shadow Table scantype_id int4 10 null
device_ports Table closed _int4 10 √ null
iftable_vlan Table vlan int4 10 null
mapnode Table xcoord float4 8 √ null
device_profiledata Table device_id int4 10 null
iftable Table contenthash text 2147483647 null
config Table id serial 10 √ nextval('zone.config_id_seq'::regclass)
interface Table vlan int4 10 √ null
target_hist Table cidr_id int4 10 √ null
interface_route Table route_id int4 10 null
profiledata Table data text 2147483647 null
device_values Table device_id int4 10 null
device Table maclastobserved timestamptz 35 √ null
device_snmpalias Table zone_id int4 10 null
device_snmpalias Table snmpalias_id int4 10 null
response_decision Table nlshash text 2147483647 √ null
device_match Table pattern_id int4 10 null
device_attribute Table attribute_cidr_id int4 10 √ null
linkset Table id serial 10 √ nextval('zone.linkset_id_seq'::regclass)
cloudalias Table zone_id int4 10 null
interface_host Table device_id int4 10 null
updatetargetspace_log Table zone_id int4 10 null
updatetargetspace_log Table last_run timestamp 29 √ now()
target_hist Table action text 2147483647 √ null
target Table device_id int4 10 √ null
device Table macvendor_id int4 10 √ null
response_decision Table sysname text 2147483647 √ null
nackcandidate Table zone_id int4 10 null
map Table description text 2147483647 √ null
map Table created_time timestamp 29 √ now()
snmpalias Table collector_id int4 10 null
target_shadow Table id serial 10 √ nextval('zone.target_shadow_id_seq'::regclass)
iftable_vlan Table name text 2147483647 null
attribute Table zone_id int4 10 null
attribute Table attribute text 2147483647 √ null
certificatepath Table zone_id int4 10 null
profiledata Table id serial 10 √ nextval('zone.profiledata_id_seq'::regclass)
target_shadow Table collector_id int4 10 null
route Table internal bool 1 √ null
response_decision Table decision bool 1 √ null
target Table details text 2147483647 √ null
device_profiledata Table port int4 10 null
device_pattern Table macvendor_id int4 10 √ null
certificate Table version int4 10 √ null
device_attribute Table zone_id int4 10 null
link Table device_id2 int4 10 null
target_highpriority Table details text 2147483647 √ null
target_hist Table expandedconfig text 2147483647 √ null
certificate Table expiredate timestamp 29 √ null
response_decision Table iftable_id int4 10 √ null
device_pattern Table attribute_id int4 10 √ null
attribute_cidr Table attributetype_id int4 10 null
target_highpriority Table expandedconfig text 2147483647 √ null
updates Table tbl text 2147483647 √ null
map Table id serial 10 √ nextval('zone.map_id_seq'::regclass)
interface_route Table routetype_id int4 10 √ null
targetm Table zone_id int4 10 √ null
path Table protocols _text 2147483647 √ null
target_highpriority Table cidrval cidr 2147483647 null
device_cloudalias Table cloudalias_id int4 10 null
target Table ordid float4 8 √ random()
target Table expandedconfig text 2147483647 √ null
interface Table iftype int4 10 √ null
acknowledgeddevice Table created_time timestamp 29 √ now()
device Table iftable_id int4 10 √ null
acknowledgeddevice Table user_id int4 10 null
device_wmialias Table last_update timestamp 29 √ now()
interface_route Table nexthop inet 2147483647 √ null
interface_address Table interface_id int4 10 null
cloudalias Table collector_id int4 10 null
acknowledgeddevice Table zone_id int4 10 null
target_shadow Table cidr_id int4 10 √ null
profile_translation Table newattribute_id int4 10 √ null
target_hist Table cidrval cidr 2147483647 null
mapnode Table asset_reference text 2147483647 √ null
target_shadow Table last_target timestamp 29 √ null
targetm Table overwrite bool 1 √ null
response_decision Table reason text 2147483647 √ null
response_decision Table syslocation text 2147483647 √ null
targetm Table device_id int4 10 √ null
device_values Table leakinbound bool 1 √ false
target_shadow Table detailsold text 2147483647 √ null
path Table targetcidrs _cidr 2147483647 √ null
link Table last_update timestamp 29 √ now()
device_values Table zone_id int4 10 null
profiledata_pattern Table pattern_id int4 10 null
snmpalias Table credential text 2147483647 √ null
response_decision Table match_id int4 10 √ null
device Table mac macaddr 2147483647 √ null
device_values Table vendor text 2147483647 √ null
interface Table description text 2147483647 √ null
device_values Table leakoutbound bool 1 √ false
map Table zone_id int4 10 null
map Table title text 2147483647 √ null
device Table active bool 1 √ null
target Table cidr_id int4 10 √ null
interface_route Table zone_id int4 10 null
route Table last_update timestamp 29 √ now()
device_attribute Table id serial 10 √ nextval('zone.device_attribute_id_seq'::regclass)
target_shadow Table device_id int4 10 √ null
device_values Table forwarder bool 1 √ false
response_decision Table created_at timestamp 29 √ now()
interface Table zone_id int4 10 null
certificate Table serial text 2147483647 √ null
device Table lastobserved timestamp 29 √ now()
interface_route Table aspath _int4 10 √ null
interface Table rootport bool 1 √ null
route Table target bool 1 √ null
device_certificate Table last_update timestamp 29 √ now()
map Table preferences text 2147483647 √ null
target Table collector_id int4 10 null
interface_route Table routeprotocol_id int4 10 √ null
path Table hash text 2147483647 √ null
certificate Table extensions text 2147483647 √ null
acknowledgeddevice Table device_id int4 10 null
device_pattern Table certificatepath_id int4 10 √ null
interface Table trunk bool 1 √ null
cloudalias Table alias text 2147483647 null
wmialias Table alias text 2147483647 null
certificatepath Table path text 2147483647 √ null
device_pattern Table profiledata_id int4 10 √ null
device_values Table hastraces bool 1 √ false
response_decision Table cmpinfhash text 2147483647 √ null
snmpalias Table zone_id int4 10 null
edge Table layer int4 10 √ null
device_ports Table open_times hstore 2147483647 √ null
device Table meta bool 1 √ false
target_hist Table ordid float4 8 √ random()
certificatepath Table time timestamp 29 √ transaction_timestamp()
targetm Table collector_id int4 10 √ null
updatetargetspace_log Table parameters _text 2147483647 √ null
device_values Table trusted bool 1 √ false
attribute_cidr Table collector_id int4 10 √ null
mapnode Table acknowledged bool 1 √ false
interface Table iftable_id int4 10 null
device_attribute Table attribute_id int4 10 √ null
device_wmialias Table zone_id int4 10 null
profiledata Table timestamp timestamp 29 √ transaction_timestamp()
device Table ip inet 2147483647 √ null
interface Table port int4 10 √ null
mapnode Table width float4 8 √ null
config Table value text 2147483647 √ null
target Table route_id int4 10 √ null
certificate Table zone_id int4 10 null
device_ports Table zone_id int4 10 null
interface Table vlans _int4 10 √ null
device_response Table device_id int4 10 null
edge Table zone_id int4 10 null
device_values Table perimeter bool 1 √ false
target Table cidrval cidr 2147483647 null
target_highpriority Table zone_id int4 10 null
target_highpriority Table last_target timestamp 29 √ null
updates Table type text 2147483647 √ null
response_decision Table id serial 10 √ nextval('zone.response_decision_id_seq'::regclass)
device_values Table l3hosts int4 10 √ 0
certificate Table chainid int8 19 √ null
profile_translation Table attribute_id int4 10 null
interface Table bridge macaddr 2147483647 √ null
config Table collector_id int4 10 √ null
device_values Table id serial 10 √ nextval('zone.device_values_id_seq'::regclass)
link Table id serial 10 √ nextval('zone.link_id_seq'::regclass)
mapnode Table map_id int4 10 null
device_snmpalias Table last_update timestamp 29 √ now()
path Table results _text 2147483647 √ null
device_match Table type_id int4 10 null
attribute_cidr Table cidrval cidr 2147483647 null
link Table zone_id int4 10 null
device_values Table model text 2147483647 √ null
target_highpriority Table collector_id int4 10 null
attribute_cidr Table id serial 10 √ nextval('zone.attribute_cidr_id_seq'::regclass)
updatetargetspace_log Table id serial 10 √ nextval('zone.updatetargetspace_log_id_seq'::regclass)
device Table id serial 10 √ nextval('zone.device_id_seq'::regclass)
device_response Table protocol_id int4 10 null
device_attribute Table device_id int4 10 null
device_response Table zone_id int4 10 null
certificate Table signaturetype text 2147483647 √ null
iftable Table id serial 10 √ nextval('zone.iftable_id_seq'::regclass)
interface Table id serial 10 √ nextval('zone.interface_id_seq'::regclass)
iftable Table bridgeaddress macaddr 2147483647 √ null
updatetargetspace_log Table message text 2147483647 √ null
target_highpriority Table cidr_id int4 10 √ null
device_cloudalias Table last_update timestamp 29 √ now()
device_values Table os text 2147483647 √ null
device_match Table device_id int4 10 null
interface_host Table zone_id int4 10 √ null
target_shadow Table zone_id int4 10 null
map Table created_by int4 10 √ null
device_values Table devicetype text 2147483647 √ null
profile_translation Table zone_id int4 10 null