Columns
Table | Type | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|---|
ot_vendor | Table | notes | text | 2147483647 | √ | null | ||
interface | Table | system_id | int4 | 10 | null | |||
feed | Table | password | text | 2147483647 | √ | null | ||
interface | Table | name | text | 2147483647 | null | |||
session | Table | clientaddress | text | 2147483647 | √ | null | ||
admap | Table | ad | _text | 2147483647 | √ | null | ||
feed | Table | pollinterval | int4 | 10 | √ | null | ||
dataview | Table | user_id | int4 | 10 | √ | null | ||
role | Table | id | serial | 10 | √ | nextval('system.role_id_seq'::regclass) | ||
feed | Table | username | text | 2147483647 | √ | null | ||
macvendor | Table | vendor | text | 2147483647 | null | |||
iftype | Table | description | text | 2147483647 | √ | null | ||
displayinfo | Table | label | text | 2147483647 | √ | null | ||
zone | Table | description | text | 2147483647 | √ | null | ||
dashboard | Table | gridcontent | jsonb | 2147483647 | √ | null | ||
collector | Table | name | text | 2147483647 | null | |||
ot_vendor | Table | coo | text | 2147483647 | √ | null | ||
enterprise | Table | id | int4 | 10 | null | Private Enterprise Number |
||
loglevel | Table | target | text | 2147483647 | null | |||
notificationpolicy | Table | name | text | 2147483647 | √ | null | ||
admap | Table | role_id | int4 | 10 | √ | null | ||
notificationpolicy | Table | message | text | 2147483647 | √ | null | ||
meta | Table | key | text | 2147483647 | null | |||
attributetype | Table | system | bool | 1 | √ | false | Boolean flag indicating if an attributetype is system defined type. System defined attribute types are present out of the box. Example: target, trusted, avoid, dnsname, ASname |
|
user | Table | name | text | 2147483647 | √ | null | ||
feed | Table | laststarttime | timestamp | 29 | √ | null | ||
attributetype | Table | devicetag | bool | 1 | √ | false | Boolean flag indicating if an attributetype is used for adding custom attributes to device. This flag supports device specific custom attributes and is set to true for device level custom attribute name(labels) |
|
ot_vendor | Table | class | text | 2147483647 | √ | null | ||
attribute_cidr | Table | attributetype_id | int4 | 10 | null | |||
config | Table | value | text | 2147483647 | √ | null | ||
notificationpolicy | Table | event | text | 2147483647 | √ | null | ||
notificationsubscription | Table | name | text | 2147483647 | √ | null | ||
scan_in_progress | Table | uuid | text | 2147483647 | √ | null | ||
feed_config | Table | id | serial | 10 | √ | nextval('system.feed_config_id_seq'::regclass) | ||
collector | Table | zone_id | int4 | 10 | null | |||
notificationsubscription | Table | subscribed | bool | 1 | true | |||
notificationpolicy | Table | category | text | 2147483647 | √ | null | ||
ifstatus | Table | id | int4 | 10 | √ | null | ||
macvendor | Table | id | serial | 10 | √ | nextval('system.macvendor_id_seq'::regclass) | ||
attribute | Table | attributetype_id | int4 | 10 | √ | null | ||
integration_risk_ranges | Table | id | serial | 10 | √ | nextval('system.integration_risk_ranges_id_seq'::regclass) | ||
admap | Table | superuser | bool | 1 | false | |||
interface | Table | config | text | 2147483647 | √ | null | ||
user | Table | hidden | bool | 1 | false | |||
user_apikey | Table | user_id | int4 | 10 | null | |||
permission | Table | permission | text | 2147483647 | √ | null | ||
organization | Table | id | serial | 10 | √ | nextval('system.organization_id_seq'::regclass) | ||
user | Table | fullname | text | 2147483647 | √ | null | ||
notificationpolicy | Table | isdefault | bool | 1 | √ | false | ||
feed_config | Table | key | text | 2147483647 | null | |||
zone | Table | id | serial | 10 | √ | nextval('system.zone_id_seq'::regclass) | ||
interface | Table | id | serial | 10 | √ | nextval('system.interface_id_seq'::regclass) | ||
notificationsubscription | Table | text | 2147483647 | √ | null | |||
interface | Table | ospf_authtype | int4 | 10 | √ | null | ||
attributetype | Table | type | text | 2147483647 | √ | null | Value of attributetype. Example: target, dnsname, any label for custom attribute or device centric attribute/tag. Custom defined (zone level as well as device level) label gets normalized into this column. |
|
notificationsubscription | Table | priority | text | 2147483647 | √ | null | ||
user_role | Table | role_id | int4 | 10 | null | |||
displayinfo | Table | system_id | int4 | 10 | null | |||
interface | Table | ospf_area | int4 | 10 | √ | null | ||
system | Table | version | text | 2147483647 | √ | null | Current version of Spectre software that the system is running. |
|
attribute | Table | attribute | text | 2147483647 | √ | null | ||
loglevel | Table | level | text | 2147483647 | null | |||
collector | Table | leakinterface_id | int4 | 10 | √ | null | ||
dashboard | Table | user_id | int4 | 10 | √ | null | ||
user | Table | updatenotes | hstore | 2147483647 | √ | null | ||
loglevel | Table | description | text | 2147483647 | √ | null | ||
interface | Table | type | text | 2147483647 | √ | null | ||
permission | Table | id | serial | 10 | √ | nextval('system.permission_id_seq'::regclass) | ||
session | Table | session_activity | timestamp | 29 | √ | null | ||
macvendor | Table | hi | int4 | 10 | null | |||
feed | Table | shortname | text | 2147483647 | √ | null | ||
interface | Table | ospf_router_id | inet | 2147483647 | √ | null | ||
integration_risk_ranges | Table | feed_id | int4 | 10 | null | |||
scan_in_progress | Table | id | serial | 10 | √ | nextval('system.scan_in_progress_id_seq'::regclass) | ||
feed | Table | key | text | 2147483647 | √ | null | ||
dataview | Table | content | text | 2147483647 | √ | null | ||
user_certificate | Table | dn | text | 2147483647 | null | |||
feed | Table | name | text | 2147483647 | null | |||
feed | Table | url | text | 2147483647 | √ | null | ||
notificationpolicy | Table | regexpolicy | text | 2147483647 | √ | null | ||
notificationsubscription | Table | zone_id | int4 | 10 | √ | null | ||
feed | Table | enabled | bool | 1 | √ | null | ||
attribute | Table | time | timestamp | 29 | √ | transaction_timestamp() | ||
enterprise | Table | vendor | text | 2147483647 | null | IANA tracked Organization |
||
user_apikey | Table | key | text | 2147483647 | null | |||
interface | Table | active | bool | 1 | √ | null | ||
normalized_vendor | Table | normalized | text | 2147483647 | √ | null | ||
notificationsubscription | Table | notificationpolicy_id | int4 | 10 | null | |||
dashboard | Table | id | serial | 10 | √ | nextval('system.dashboard_id_seq'::regclass) | ||
user_certificate | Table | certificate | text | 2147483647 | null | |||
dataview | Table | name | text | 2147483647 | √ | null | ||
dashboard | Table | name | text | 2147483647 | null | |||
feed | Table | tablename | text | 2147483647 | √ | null | ||
attribute_cidr | Table | time | timestamp | 29 | √ | transaction_timestamp() | ||
user_apikey | Table | enabled | bool | 1 | true | |||
organization | Table | name | varchar | 40 | null | |||
iftype | Table | name | text | 2147483647 | √ | null | ||
system | Table | name | text | 2147483647 | null | System name that is specified by the user upon initilization of the box. |
||
notificationpolicy | Table | id | serial | 10 | √ | nextval('system.notificationpolicy_id_seq'::regclass) | ||
system | Table | type | text | 2147483647 | √ | null | System type of the remote system. |
|
attribute | Table | id | serial | 10 | √ | nextval('system.attribute_id_seq'::regclass) | ||
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. |
||
macvendor | Table | lo | int4 | 10 | null | |||
feed | Table | pipelinename | text | 2147483647 | √ | null | ||
collector | Table | ipv4 | inet | 2147483647 | √ | null | ||
loglevel | Table | id | serial | 10 | √ | nextval('system.loglevel_id_seq'::regclass) | ||
notificationsubscription | Table | user_id | int4 | 10 | √ | null | ||
zone | Table | name | varchar | 40 | null | |||
notificationpolicy | Table | priority | text | 2147483647 | √ | null | ||
feed_config | Table | feed_id | int4 | 10 | null | |||
attributetype | Table | userdefined | bool | 1 | √ | false | Boolean flag indicating if an attributetype is added by user. This flag supports zone specific custom attributes and is set to true for zone level as well as device level custom attribute (labels) |
|
feed | Table | isvalidconfig | bool | 1 | √ | false | ||
user | Table | superuser | bool | 1 | false | |||
notificationsubscription | Table | subscriptiontype | text | 2147483647 | √ | null | ||
role_permission | Table | permission_id | int4 | 10 | null | |||
session | Table | user_id | int4 | 10 | √ | null | ||
attribute_cidr | Table | attribute_id | int4 | 10 | √ | null | ||
meta | Table | value | text | 2147483647 | √ | null | ||
session | Table | session_end | timestamp | 29 | √ | null | ||
feed | Table | id | serial | 10 | √ | nextval('system.feed_id_seq'::regclass) | ||
notificationsubscription | Table | id | serial | 10 | √ | nextval('system.notificationsubscription_id_seq'::regclass) | ||
dataview | Table | description | text | 2147483647 | √ | null | ||
zone | Table | organization_id | int4 | 10 | null | |||
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. |
|
iftype | Table | refs | text | 2147483647 | √ | null | ||
collector | Table | interface_id | int4 | 10 | √ | null | ||
role_permission | Table | role_id | int4 | 10 | null | |||
scan_in_progress | Table | details | text | 2147483647 | √ | null | ||
ot_vendor | Table | macvendor | text | 2147483647 | √ | null | ||
session | Table | id | text | 2147483647 | null | |||
role | Table | organization_id | int4 | 10 | √ | null | ||
dashboard | Table | description | text | 2147483647 | √ | null | ||
interface | Table | ipv6 | inet | 2147483647 | √ | null | ||
config | Table | key | text | 2147483647 | null | |||
scan_in_progress | Table | cidrval | cidr | 2147483647 | √ | null | ||
collector | Table | externaldnsinterface_id | int4 | 10 | √ | null | ||
user | Table | id | serial | 10 | √ | nextval('system.user_id_seq'::regclass) | ||
session | Table | session_start | timestamp | 29 | √ | null | ||
feed | Table | servername | text | 2147483647 | √ | null | ||
attribute_cidr | Table | cidrval | cidr | 2147483647 | null | |||
displayinfo | Table | iconfilename | text | 2147483647 | √ | 'lumeta-bug.png'::text | ||
iftype | Table | id | int4 | 10 | √ | null | ||
collector | Table | ipv6 | inet | 2147483647 | √ | null | ||
displayinfo | Table | ycoord | float8 | 17 | √ | null | ||
macvendor | Table | prefix | text | 2147483647 | null | |||
feed | Table | isrunning | bool | 1 | √ | false | ||
interface | Table | address | macaddr | 2147483647 | √ | null | ||
collector | Table | updatenotes | hstore | 2147483647 | √ | null | ||
collector | Table | id | serial | 10 | √ | nextval('system.collector_id_seq'::regclass) | ||
user_certificate | Table | user_id | int4 | 10 | null | |||
interface | Table | ospf_auth | text | 2147483647 | √ | null | ||
collector | Table | uuid | uuid | 2147483647 | √ | uuid_generate_v1() | ||
user_role | Table | user_id | int4 | 10 | null | |||
scan_in_progress | Table | created | timestamptz | 35 | √ | now() | ||
integration_risk_ranges | Table | medium_risk_maximum | int4 | 10 | √ | null | ||
notificationpolicy | Table | querypolicy | text | 2147483647 | √ | null | ||
displayinfo | Table | longitude | float8 | 17 | √ | null | ||
dataview_link | Table | link_id | int4 | 10 | null | |||
feed | Table | autosubscribe | bool | 1 | √ | false | ||
loglevel | Table | service | text | 2147483647 | null | |||
role | Table | name | text | 2147483647 | null | |||
interface | Table | packetrate | int4 | 10 | 1000 | |||
feed_config | Table | value | text | 2147483647 | null | |||
session | Table | systemaddress | text | 2147483647 | √ | null | ||
organization | Table | description | text | 2147483647 | √ | 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. |
|
dataview | Table | id | serial | 10 | √ | nextval('system.dataview_id_seq'::regclass) | ||
interface | Table | ospf_enabled | bool | 1 | √ | null | ||
ot_vendor | Table | url | text | 2147483647 | √ | null | ||
zone | Table | updatenotes | hstore | 2147483647 | √ | null | ||
scan_in_progress | Table | fetch_count | int4 | 10 | √ | 0 | ||
ifstatus | Table | status | text | 2147483647 | √ | null | ||
feed | Table | overwrite | bool | 1 | √ | null | ||
system | Table | lastconnection | timestamp | 29 | √ | null | Current time on local server whenever the WebSocket connection is established |
|
user | Table | aduser | bool | 1 | √ | false | ||
notificationpolicy | Table | notification_type | text | 2147483647 | √ | null | ||
attribute_cidr | Table | id | serial | 10 | √ | nextval('system.attribute_cidr_id_seq'::regclass) | ||
spectre_timezone | View | getcurrentimezone | text | 2147483647 | √ | null | ||
dataview | Table | type | text | 2147483647 | √ | null | ||
dataview_link | Table | dataview_id | int4 | 10 | null | |||
session | Table | source | text | 2147483647 | √ | null | ||
ot_vendor | Table | category | text | 2147483647 | √ | null | ||
feed | Table | lastendtime | timestamp | 29 | √ | null | ||
feed | Table | assetcount | int8 | 19 | √ | 0 | ||
normalized_vendor | Table | raw | text | 2147483647 | √ | null | ||
attributetype | Table | id | serial | 10 | √ | nextval('system.attributetype_id_seq'::regclass) | Unique identifier for attributetype record |
|
scan_in_progress | Table | scantype | text | 2147483647 | √ | null | ||
displayinfo | Table | latitude | float8 | 17 | √ | null | ||
integration_risk_ranges | Table | medium_risk_minimum | int4 | 10 | √ | null | ||
displayinfo | Table | xcoord | float8 | 17 | √ | null | ||
interface | Table | ipv4 | inet | 2147483647 | √ | null | ||
feed | Table | mapping | bool | 1 | √ | false | ||
feed | Table | filename | text | 2147483647 | √ | null |