Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
dashboard Table description text 2147483647 √ null
notificationsubscription Table email text 2147483647 √ null
feed_config Table value text 2147483647 null
attributetype Table id serial 10 √ nextval('system.attributetype_id_seq'::regclass)
notificationsubscription Table name text 2147483647 √ null
feed_config Table key text 2147483647 null
collector Table uuid uuid 2147483647 √ uuid_generate_v1()
user_certificate Table user_id int4 10 null
session Table clientaddress text 2147483647 √ null
attribute Table attribute text 2147483647 √ null
notificationpolicy Table category text 2147483647 √ null
organization Table id serial 10 √ nextval('system.organization_id_seq'::regclass)
user_apikey Table user_id int4 10 null
config Table key text 2147483647 null
notificationpolicy Table message text 2147483647 √ null
feed Table enabled bool 1 √ null
notificationpolicy Table querypolicy text 2147483647 √ null
macvendor Table lo int4 10 null
feed Table laststarttime timestamp 29 √ null
interface Table address macaddr 2147483647 √ null
feed Table url text 2147483647 √ null
interface Table ospf_authtype int4 10 √ null
notificationsubscription Table zone_id int4 10 √ null
admap Table ad _text 2147483647 √ null
displayinfo Table label text 2147483647 √ null
attribute Table time timestamp 29 √ transaction_timestamp()
notificationpolicy Table isdefault bool 1 √ false
notificationpolicy Table event text 2147483647 √ null
user_role Table role_id int4 10 null
role Table organization_id int4 10 √ null
role Table id serial 10 √ nextval('system.role_id_seq'::regclass)
dataview Table description text 2147483647 √ null
notificationpolicy Table id serial 10 √ nextval('system.notificationpolicy_id_seq'::regclass)
displayinfo Table xcoord float8 17 √ null
displayinfo Table longitude float8 17 √ null
interface Table ospf_area int4 10 √ null
meta Table key text 2147483647 null
notificationpolicy Table priority text 2147483647 √ null
zone Table id serial 10 √ nextval('system.zone_id_seq'::regclass)
collector Table ipv6 inet 2147483647 √ null
notificationsubscription Table subscriptiontype text 2147483647 √ null
macvendor Table vendor text 2147483647 null
session Table session_activity timestamp 29 √ null
attributetype Table system bool 1 √ false
user Table name text 2147483647 √ null
attribute_cidr Table attributetype_id int4 10 null
feed Table lastendtime timestamp 29 √ null
interface Table id serial 10 √ nextval('system.interface_id_seq'::regclass)
user Table fullname text 2147483647 √ null
feed Table mapping bool 1 √ false
interface Table name text 2147483647 null
interface Table ipv6 inet 2147483647 √ null
macvendor Table id serial 10 √ nextval('system.macvendor_id_seq'::regclass)
dataview Table id serial 10 √ nextval('system.dataview_id_seq'::regclass)
displayinfo Table system_id int4 10 null
feed Table overwrite bool 1 √ null
user Table aduser bool 1 √ false
loglevel Table description text 2147483647 √ null
dataview_link Table dataview_id int4 10 null
role_permission Table permission_id int4 10 null
zone Table description text 2147483647 √ null
admap Table role_id int4 10 √ null
loglevel Table target text 2147483647 null
attribute_cidr Table id serial 10 √ nextval('system.attribute_cidr_id_seq'::regclass)
user_apikey Table enabled bool 1 true
feed Table isrunning bool 1 √ false
interface Table ospf_enabled bool 1 √ null
system Table uuid text 2147483647 null

System UUID as reported by 'dmidecode -s system-uuid' on systems that support it, otherwise a random uuid from /proc/sys/kernel/random/uuid (written once), and is RFC4122 compliant.
zone Table updatenotes hstore 2147483647 √ null
user_apikey Table key text 2147483647 null
feed Table shortname text 2147483647 √ null
user Table id serial 10 √ nextval('system.user_id_seq'::regclass)
dataview Table type text 2147483647 √ null
organization Table name varchar 40 null
zone Table organization_id int4 10 null
interface Table config text 2147483647 √ null
feed Table pipelinename text 2147483647 √ null
system Table type text 2147483647 √ null

System type of the remote system.
dataview Table user_id int4 10 √ null
feed Table pollinterval int4 10 √ null
collector Table interface_id int4 10 √ null
interface Table ipv4 inet 2147483647 √ null
feed_config Table feed_id int4 10 null
interface Table ospf_router_id inet 2147483647 √ null
loglevel Table service text 2147483647 null
interface Table type text 2147483647 √ null
notificationsubscription Table id serial 10 √ nextval('system.notificationsubscription_id_seq'::regclass)
displayinfo Table ycoord float8 17 √ null
loglevel Table id serial 10 √ nextval('system.loglevel_id_seq'::regclass)
attribute Table attributetype_id int4 10 √ null
feed Table password text 2147483647 √ null
spectre_timezone View getcurrentimezone text 2147483647 √ null
loglevel Table level text 2147483647 null
system Table lastconnection timestamp 29 √ null

Current time on local server whenever the WebSocket connection is established
collector Table leakinterface_id int4 10 √ null
role_permission Table role_id int4 10 null
notificationsubscription Table subscribed bool 1 true
notificationsubscription Table priority text 2147483647 √ null
attribute Table id serial 10 √ nextval('system.attribute_id_seq'::regclass)
interface Table ospf_auth text 2147483647 √ null
user Table hidden bool 1 false
feed Table filename text 2147483647 √ null
notificationsubscription Table user_id int4 10 √ null
feed Table autosubscribe bool 1 √ false
macvendor Table hi int4 10 null
config Table value text 2147483647 √ null
role Table name text 2147483647 null
notificationsubscription Table notificationpolicy_id int4 10 null
interface Table active bool 1 √ null
collector Table id serial 10 √ nextval('system.collector_id_seq'::regclass)
feed Table tablename text 2147483647 √ null
feed Table username text 2147483647 √ null
collector Table name text 2147483647 null
collector Table zone_id int4 10 null
session Table session_end timestamp 29 √ null
feed Table name text 2147483647 null
interface Table packetrate int4 10 1000
session Table id text 2147483647 null
dashboard Table user_id int4 10 √ null
notificationpolicy Table name text 2147483647 √ null
dashboard Table id serial 10 √ nextval('system.dashboard_id_seq'::regclass)
feed Table key text 2147483647 √ null
permission Table id serial 10 √ nextval('system.permission_id_seq'::regclass)
session Table session_start timestamp 29 √ null
zone Table name varchar 40 null
macvendor Table prefix text 2147483647 null
meta Table value text 2147483647 √ null
system Table name text 2147483647 null

System name that is specified by the user upon initilization of the box.
attribute_cidr Table cidrval cidr 2147483647 null
displayinfo Table latitude float8 17 √ null
user_certificate Table certificate text 2147483647 null
feed Table servername text 2147483647 √ null
collector Table updatenotes hstore 2147483647 √ null
notificationpolicy Table notification_type text 2147483647 √ null
session Table source text 2147483647 √ null
permission Table permission text 2147483647 √ null
feed_config Table id serial 10 √ nextval('system.feed_config_id_seq'::regclass)
user_role Table user_id int4 10 null
system Table connection text 2147483647 √ null

Tracks how this system connects to the remote system. If an IP address or hostname is present, this system is the connection initiator. If there is no data in this column, the remote system will connect to this system. The field is populated with the value that is entered when connecting a system, whether that be an IP or hostname.
collector Table ipv4 inet 2147483647 √ null
attribute_cidr Table time timestamp 29 √ transaction_timestamp()
dashboard Table name text 2147483647 null
dataview Table name text 2147483647 √ null
dataview_link Table link_id int4 10 null
feed Table id serial 10 √ nextval('system.feed_id_seq'::regclass)
attribute_cidr Table attribute_id int4 10 √ null
attributetype Table userdefined bool 1 √ false
dashboard Table gridcontent jsonb 2147483647 √ null
collector Table externaldnsinterface_id int4 10 √ null
user Table superuser bool 1 false
system Table id serial 10 √ nextval('system.system_id_seq'::regclass)

The local system will always have an id of 1, and thus the entry can be determined if it the local system by checking to make sure its id is 1. All other systems will have an id greater than 1.
displayinfo Table iconfilename text 2147483647 √ 'lumeta-bug.png'::text
admap Table superuser bool 1 false
session Table user_id int4 10 √ null
attributetype Table type text 2147483647 √ null
user Table updatenotes hstore 2147483647 √ null
user_certificate Table dn text 2147483647 null
interface Table system_id int4 10 null
system Table version text 2147483647 √ null

Current version of Spectre software that the system is running.
dataview Table content text 2147483647 √ null
session Table systemaddress text 2147483647 √ null
organization Table description text 2147483647 √ null
notificationpolicy Table regexpolicy text 2147483647 √ null