PostgreSQL

Previous Next

Database schema for PostgreSQL storage

Primary Key  Foreign Key  Unique

subnetworks

Name Type
id BIGINT
created_at TIMESTAMPTZ
updated_at TIMESTAMPTZ
network_cidr VARCHAR
network_addr VARCHAR
mask_size BIGINT
ip_version BIGINT
gateway VARCHAR
vlan_id BIGINT
tag VARCHAR

machines

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

cpus

Name Type
id BIGINT
created_at TIMESTAMPTZ
updated_at TIMESTAMPTZ
model_name VARCHAR
vendor VARCHAR
cores BIGINT
machine_id BIGINT

gpus

Name Type
id BIGINT
created_at TIMESTAMPTZ
updated_at TIMESTAMPTZ
index BIGINT
product VARCHAR
vendor VARCHAR
driver VARCHAR
machine_id BIGINT

disks

Name Type
id BIGINT
created_at TIMESTAMPTZ
updated_at TIMESTAMPTZ
name VARCHAR
model VARCHAR
size BIGINT
type VARCHAR
controller VARCHAR
partitions JSON
machine_id BIGINT

network_interfaces

Name Type
id BIGINT
created_at TIMESTAMPTZ
updated_at TIMESTAMPTZ
name VARCHAR
mac VARCHAR
mac_vendor VARCHAR
ip VARCHAR[]
gateway VARCHAR
flags JSON
tag VARCHAR
machine_id BIGINT

network_interface_subnets

Name Type
network_interface_id BIGINT
subnetwork_id BIGINT
ip VARCHAR
mac_subnet VARCHAR

packages

Name Type
id BIGINT
created_at TIMESTAMPTZ
updated_at TIMESTAMPTZ
name VARCHAR
version VARCHAR
vendor VARCHAR
manager VARCHAR
install_time_unix BIGINT
files JSONB
machine_id BIGINT

applications

Name Type
id BIGINT
created_at TIMESTAMPTZ
updated_at TIMESTAMPTZ
name VARCHAR
args JSONB
pid BIGINT
version VARCHAR
protocol VARCHAR
config JSON
cpe VARCHAR
machine_id BIGINT
package_id BIGINT

application_endpoints

Name Type
id BIGINT
created_at TIMESTAMPTZ
updated_at TIMESTAMPTZ
port INTEGER
protocol VARCHAR
addr VARCHAR
tls JSON
fingerprints JSON
application_protocols JSONB
saas VARCHAR
application_id BIGINT
network_interface_id BIGINT

users

Name Type
id BIGINT
created_at TIMESTAMPTZ
updated_at TIMESTAMPTZ
uid VARCHAR
gid VARCHAR
name VARCHAR
username VARCHAR
domain VARCHAR
machine_id BIGINT

user_applications

Name Type
id BIGINT
created_at TIMESTAMPTZ
updated_at TIMESTAMPTZ
user_id BIGINT
application_id BIGINT
linux VARCHAR

flows

Name Type
id BIGINT
created_at TIMESTAMPTZ
updated_at TIMESTAMPTZ
src_application_id BIGINT
src_network_interface_id BIGINT
src_addr VARCHAR
dst_endpoint_id BIGINT

endpoint_policies

Name Type
id BIGINT
created_at TIMESTAMPTZ
updated_at TIMESTAMPTZ
endpoint_id BIGINT
action VARCHAR
src_endpoint_id BIGINT
src_addr VARCHAR
priority BIGINT
source VARCHAR
Overview SQLite