Tables


SchemaSpy Analysis of observer.zone_0002

Generated on Mon Sep 24 11:11 EDT 2018

XML Representation
Insertion Order Deletion Order
TABLES 43
VIEWS 0
COLUMNS 330
Constraints 61

Database Properties

Database Type: PostgreSQL - 9.6.6

Tables

Table / View Children Parents Columns Rows Type Comments
acknowledgeddevice 0 1 5 0 Table
attribute 2 1 4 180 Table
attribute_cidr 2 3 8 9 Table
certificate 1 2 11 0 Table
certificatepath 3 0 4 0 Table
certificatepath_pattern 0 1 3 0 Table
cloudalias 1 1 6 4 Table
config 0 1 5 16 Table
device 16 3 13 65 Table
device_attribute 0 3 7 0 Table
device_certificate 0 2 3 0 Table
device_cloudalias 0 2 4 0 Table
device_match 0 1 6 61 Table
device_pattern 0 1 8 45 Table
device_ports 0 1 6 0 Table
device_profiledata 0 3 5 12 Table
device_response 0 4 8 49 Table
device_snmpalias 0 2 4 0 Table
device_values 0 1 28 65 Table
edge 0 0 7 0 Table
iftable 3 0 6 27 Table
iftable_vlan 0 1 4 63 Table
interface 3 1 17 65 Table
interface_address 0 1 4 7 Table
interface_host 0 2 4 19 Table
interface_route 0 4 11 12 Table
link 0 3 6 18 Table
linkset 1 0 4 1 Table
map 0 1 9 0 Table
mapnode 0 0 14 0 Table
nackcandidate 0 0 6 6 Table
path 0 1 8 0 Table
profile_translation 0 0 7 2 Table
profiledata 2 1 7 6 Table
profiledata_pattern 0 1 3 8 Table
route 3 0 8 10 Table
snmpalias 1 1 6 1 Table
target 1 5 13 11 Table
target_highpriority 0 6 14 0 Table
target_hist 0 0 14 0 Table
targetm 0 0 9 0 Table
updates 0 0 6 3 Table
updatetargetspace_log 0 0 5 3 Table