SQLite

Previous Next

Database schema for SQLite storage

Primary Key  Foreign Key  Unique

subnetworks

Name Type
id INTEGER
created_at TIMESTAMP
updated_at TIMESTAMP
network_cidr VARCHAR
network_addr VARCHAR
mask_size INTEGER
ip_version INTEGER
gateway VARCHAR
vlan_id INTEGER
tag VARCHAR

machines

Name Type
id INTEGER
created_at TIMESTAMP
updated_at TIMESTAMP
hostname VARCHAR
host_id VARCHAR
arch VARCHAR
platform VARCHAR
distribution VARCHAR
distribution_version VARCHAR
distribution_family VARCHAR
uptime INTEGER
agent VARCHAR
cpe VARCHAR
chassis VARCHAR
parent_machine_id INTEGER

cpus

Name Type
id INTEGER
created_at TIMESTAMP
updated_at TIMESTAMP
model_name VARCHAR
vendor VARCHAR
cores INTEGER
machine_id INTEGER

gpus

Name Type
id INTEGER
created_at TIMESTAMP
updated_at TIMESTAMP
index INTEGER
product VARCHAR
vendor VARCHAR
driver VARCHAR
machine_id INTEGER

disks

Name Type
id INTEGER
created_at TIMESTAMP
updated_at TIMESTAMP
name VARCHAR
model VARCHAR
size INTEGER
type VARCHAR
controller VARCHAR
partitions VARCHAR
machine_id INTEGER

network_interfaces

Name Type
id INTEGER
created_at TIMESTAMP
updated_at TIMESTAMP
name VARCHAR
mac VARCHAR
mac_vendor VARCHAR
ip VARCHAR
gateway VARCHAR
flags VARCHAR
tag VARCHAR
machine_id INTEGER

network_interface_subnets

Name Type
network_interface_id INTEGER
subnetwork_id INTEGER
ip VARCHAR
mac_subnet VARCHAR

packages

Name Type
id INTEGER
created_at TIMESTAMP
updated_at TIMESTAMP
name VARCHAR
version VARCHAR
vendor VARCHAR
manager VARCHAR
install_time_unix INTEGER
files VARCHAR
machine_id INTEGER

applications

Name Type
id INTEGER
created_at TIMESTAMP
updated_at TIMESTAMP
name VARCHAR
args VARCHAR
pid INTEGER
version VARCHAR
protocol VARCHAR
config VARCHAR
cpe VARCHAR
machine_id INTEGER
package_id INTEGER

application_endpoints

Name Type
id INTEGER
created_at TIMESTAMP
updated_at TIMESTAMP
port INTEGER
protocol VARCHAR
addr VARCHAR
tls VARCHAR
fingerprints VARCHAR
application_protocols VARCHAR
saas VARCHAR
application_id INTEGER
network_interface_id INTEGER

users

Name Type
id INTEGER
created_at TIMESTAMP
updated_at TIMESTAMP
uid VARCHAR
gid VARCHAR
name VARCHAR
username VARCHAR
domain VARCHAR
machine_id INTEGER

user_applications

Name Type
id INTEGER
created_at TIMESTAMP
updated_at TIMESTAMP
user_id INTEGER
application_id INTEGER
linux VARCHAR

flows

Name Type
id INTEGER
created_at TIMESTAMP
updated_at TIMESTAMP
src_application_id INTEGER
src_network_interface_id INTEGER
src_addr VARCHAR
dst_endpoint_id INTEGER

endpoint_policies

Name Type
id INTEGER
created_at TIMESTAMP
updated_at TIMESTAMP
endpoint_id INTEGER
action VARCHAR
src_endpoint_id INTEGER
src_addr VARCHAR
priority INTEGER
source VARCHAR
PostgreSQL Ansible