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