Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
PerformanceData_Java Table _ts timestamptz 35 √ null
firemon_cve_managed_hosts Table cvssbasescore float8 17 √ null
firemon_asset_managed_hosts Table rootcount int4 10 √ null
PerformanceData_Java Table devicespending int4 10 √ null
DiscoveredEndpointsCountSnapshot Table discoveredcount numeric 131089 √ null
tenable_io_managed_hosts Table id text 2147483647 √ null
firemon_asset_managed_hosts Table netbios text 2147483647 √ null
tenable_managed_hosts Table severitymedium int4 10 √ null
tenable_managed_hosts Table startoffset int4 10 √ null
firemon_asset_managed_hosts Table raprojectid int4 10 √ null
tenable_managed_hosts Table _source text 2147483647 √ null
tenable_managed_hosts Table dnsname text 2147483647 √ null
firemon_asset_managed_hosts Table address text 2147483647 √ null
tenable_io_managed_hosts Table hasagent bool 1 √ null
category Table category int4 10 √ null
firemon_device_complexity Table ntwkobjcount int4 10 √ null
firemon_device_managed_hosts Table licenses jsonb 2147483647 √ null
firemon_cve_managed_hosts Table port int4 10 √ null
firemon_device_managed_hosts Table state text 2147483647 √ null
firemon_device_managed_hosts Table description text 2147483647 √ null
tenable_managed_hosts Table lastauthrun text 2147483647 √ null
PerformanceData_RawOut Table endts timestamptz 35 √ null
category Table shortname text 2147483647 √ null
PerformanceData_Java Table gccollections int4 10 √ null
firemon_device_managed_hosts Table name text 2147483647 √ null
firemon_asset_managed_hosts Table assetriskscore float8 17 √ null
PerformanceData_RawIn Table discoverydatatype text 2147483647 √ null
firemon_device_complexity Table lastscicomputedate text 2147483647 √ null
firemon_cve_managed_hosts Table sdhostname text 2147483647 √ null
firemon_device_managed_hosts Table children jsonb 2147483647 √ null
firemon_device_complexity Table gpcpolicycount int4 10 √ null
tenable_managed_hosts Table repository_name text 2147483647 √ null
firemon_cve_managed_hosts Table locality text 2147483647 √ null
ProfiledEndpointsCountSnapshot Table collector_id int4 10 √ null
tenable_managed_hosts Table score int4 10 √ null
tenable_io_managed_hosts Table securityprotectionlevel text 2147483647 √ null
firemon_asset_managed_hosts Table totalvulnerabilitycount int4 10 √ null
firemon_device_managed_hosts Table gpcdirtydate text 2147483647 √ null
tenable_managed_hosts Table policyname text 2147483647 √ null
firemon_device_complexity Table gpcservicecount int4 10 √ null
PerformanceData_Java Table totalheapspace int8 19 √ null
PerformanceData_Java Table directdevicespending int4 10 √ null
firemon_device_complexity Table managementip text 2147483647 √ null
ProfiledEndpointsCountSnapshot Table profiledcount numeric 131089 √ null
tenable_managed_hosts Table biosguid text 2147483647 √ null
PerformanceData_RawOut Table receivedts timestamptz 35 √ null
firemon_device_complexity Table gpcnetworkcount int4 10 √ null
PerformanceData_RawIn Table collectoruuid text 2147483647 √ null
firemon_cve_managed_hosts Table published text 2147483647 √ null
tenable_managed_hosts Table repository_id int4 10 √ null
tenable_managed_hosts Table total int4 10 √ null
firemon_device_complexity Table gpcsecurityrulecount int4 10 √ null
firemon_device_complexity Table description text 2147483647 √ null
firemon_device_managed_hosts Table domainid int4 10 √ null
firemon_device_managed_hosts Table editable bool 1 √ null
firemon_cve_managed_hosts Table vulndescription text 2147483647 √ null
tenable_managed_hosts Table endoffset int4 10 √ null
PerformanceData_RawOut Table proc_ms int4 10 √ null
tenable_io_managed_hosts Table macaddress jsonb 2147483647 √ null
tenable_managed_hosts Table tpmid text 2147483647 √ null
PerformanceData_RawOut Table discoverydatatype text 2147483647 √ null
PerformanceData_RawOut Table scantype text 2147483647 √ null
tenable_managed_hosts Table severityinfo int4 10 √ null
PerformanceData_Java Table usedheapspace int4 10 √ null
PerformanceData_RawOut Table collectoruuid text 2147483647 √ null
firemon_device_managed_hosts Table extendedsettingsjson jsonb 2147483647 √ null
firemon_asset_managed_hosts Table licensed bool 1 √ null
tenable_managed_hosts Table returnedrecords int4 10 √ null
DiscoveredEndpointsCountSnapshot Table collector_id int4 10 √ null
tenable_io_managed_hosts Table lastscantarget inet 2147483647 √ null
DiscoveredEndpointsCountSnapshot Table collector_name text 2147483647 √ null
firemon_cve_managed_hosts Table sdhostid int4 10 √ null
firemon_device_complexity Table userobjcount int4 10 √ null
PerformanceData_Java Table eventsreceived int4 10 √ null
firemon_asset_managed_hosts Table os text 2147483647 √ null
firemon_device_complexity Table routecount int4 10 √ null
tenable_managed_hosts Table netbiosname text 2147483647 √ null
tenable_managed_hosts Table lastunauthrun text 2147483647 √ null
firemon_asset_managed_hosts Table doscount int4 10 √ null
firemon_device_managed_hosts Table gpcstatus text 2147483647 √ null
PerformanceData_Java Table devicesprocessed int4 10 √ null
ProfiledEndpointsCountSnapshot Table _ts timestamptz 35 √ null
firemon_device_complexity Table complexity float8 17 √ null
firemon_device_managed_hosts Table gpcimplementdate text 2147483647 √ null
firemon_device_complexity Table revid int4 10 √ null
firemon_device_managed_hosts Table collectorgroupid text 2147483647 √ null
ProfiledEndpointsCountSnapshot Table zone_name varchar 40 √ null
tenable_managed_hosts Table pluginset text 2147483647 √ null
tenable_managed_hosts Table repository_description text 2147483647 √ null
PerformanceData_RawOut Table _ts timestamptz 35 √ null
firemon_device_complexity Table id int4 10 √ null
PerformanceData_RawOut Table numberofobjects int4 10 √ null
firemon_device_complexity Table zonecount int4 10 √ null
firemon_asset_managed_hosts Table interfaces jsonb 2147483647 √ null
tenable_managed_hosts Table oscpe text 2147483647 √ null
firemon_cve_managed_hosts Table protocol int4 10 √ null
firemon_device_managed_hosts Table collectorgroupname text 2147483647 √ null
PerformanceData_RawIn Table scantype text 2147483647 √ null
tenable_io_managed_hosts Table ipv6 jsonb 2147483647 √ null
firemon_cve_managed_hosts Table raprojectid int4 10 √ null
firemon_device_complexity Table _source text 2147483647 √ null
tenable_io_managed_hosts Table operatingsystem jsonb 2147483647 √ null
PerformanceData_Java Table devicesdropped int4 10 √ null
firemon_cve_managed_hosts Table sdhostaddress text 2147483647 √ null
firemon_asset_managed_hosts Table _source text 2147483647 √ null
firemon_asset_managed_hosts Table riskvalue int4 10 √ null
firemon_cve_managed_hosts Table effect text 2147483647 √ null
tenable_managed_hosts Table severitylow int4 10 √ null
tenable_managed_hosts Table matchingdataelementcount text 2147483647 √ null
firemon_asset_managed_hosts Table othercount int4 10 √ null
tenable_io_managed_hosts Table exposureconfidencevalue text 2147483647 √ null
tenable_managed_hosts Table macaddress text 2147483647 √ null
ProfiledEndpointsCountSnapshot Table collector_name text 2147483647 √ null
firemon_asset_managed_hosts Table assetvalue int4 10 √ null
firemon_device_complexity Table sci float8 17 √ null
tenable_io_managed_hosts Table _source text 2147483647 √ null
firemon_device_complexity Table gpcservicegroupcount int4 10 √ null
PerformanceData_RawOut Table pojoqintime timestamptz 35 √ null
firemon_device_complexity Table devicetype text 2147483647 √ null
firemon_device_managed_hosts Table securityconcernindex float8 17 √ null
PerformanceData_Java Table eventsprocessed int4 10 √ null
firemon_device_complexity Table product text 2147483647 √ null
firemon_device_complexity Table lastupdated text 2147483647 √ null
firemon_device_complexity Table name text 2147483647 √ null
tenable_io_managed_hosts Table sources jsonb 2147483647 √ null
firemon_asset_managed_hosts Table nodeids jsonb 2147483647 √ null
category Table name text 2147483647 √ null
DiscoveredEndpointsCountSnapshot Table zone_name varchar 40 √ null
PerformanceData_RawOut Table errordetected text 2147483647 √ null
firemon_asset_managed_hosts Table id int4 10 √ null
tenable_io_managed_hosts Table lastseen timestamptz 35 √ null
PerformanceData_RawOut Table postprocessedfile text 2147483647 √ null
firemon_device_managed_hosts Table managedtype text 2147483647 √ null
PerformanceData_RawIn Table _ts timestamptz 35 √ null
firemon_device_complexity Table svcobjcount int4 10 √ null
tenable_managed_hosts Table severityhigh int4 10 √ null
firemon_device_managed_hosts Table managementip text 2147483647 √ null
firemon_device_complexity Table gpcstatus text 2147483647 √ null
tenable_io_managed_hosts Table securityprotections jsonb 2147483647 √ null
ProfiledEndpointsCountSnapshot Table zone_id int4 10 √ null
firemon_device_complexity Table totalsecrules int4 10 √ null
tenable_io_managed_hosts Table agentname jsonb 2147483647 √ null
firemon_asset_managed_hosts Table usercount int4 10 √ null
firemon_device_complexity Table lastrevision text 2147483647 √ null
firemon_device_managed_hosts Table id int4 10 √ null
tenable_io_managed_hosts Table netbiosname jsonb 2147483647 √ null
DiscoveredEndpointsCountSnapshot Table zone_id int4 10 √ null
firemon_device_complexity Table interfacecount int4 10 √ null
tenable_managed_hosts Table ip inet 2147483647 √ null
firemon_device_complexity Table vendor text 2147483647 √ null
tenable_io_managed_hosts Table hostname jsonb 2147483647 √ null
firemon_cve_managed_hosts Table _source text 2147483647 √ null
firemon_device_complexity Table policycount int4 10 √ null
PerformanceData_RawIn Table preprocessedfile text 2147483647 √ null
firemon_device_complexity Table natrulecount int4 10 √ null
firemon_asset_managed_hosts Table name text 2147483647 √ null
firemon_device_complexity Table gpcnetworkgroupcount int4 10 √ null
tenable_managed_hosts Table totalrecords int4 10 √ null
firemon_device_managed_hosts Table gpccomputedate text 2147483647 √ null
PerformanceData_Java Table devicesreceived int4 10 √ null
PerformanceData_RawIn Table numberofobjects text 2147483647 √ null
firemon_device_complexity Table gpcimplementdate text 2147483647 √ null
tenable_managed_hosts Table mcafeeguid text 2147483647 √ null
firemon_device_managed_hosts Table _source text 2147483647 √ null
firemon_device_complexity Table appobjcount int4 10 √ null
firemon_device_managed_hosts Table devicepack jsonb 2147483647 √ null
DiscoveredEndpointsCountSnapshot Table _ts timestamptz 35 √ null
firemon_device_managed_hosts Table parents jsonb 2147483647 √ null
PerformanceData_Java Table eventspending int4 10 √ null
firemon_cve_managed_hosts Table vulnkey text 2147483647 √ null
PerformanceData_Java Table gcduration int4 10 √ null
tenable_managed_hosts Table severitycritical int4 10 √ null
tenable_io_managed_hosts Table awsec2name jsonb 2147483647 √ null
tenable_io_managed_hosts Table ipv4 jsonb 2147483647 √ null
tenable_io_managed_hosts Table fqdn jsonb 2147483647 √ null