Tables


SchemaSpy Analysis of observer.zone_0001

Generated on Mon Jul 22 10:04 EDT 2019

XML Representation
Insertion Order Deletion Order
TABLES 44
VIEWS 0
COLUMNS 349
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 33 Table
attribute_cidr 2 3 8 11 Table
certificate 1 2 14 75 Table
certificatepath 3 0 4 13 Table
certificatepath_pattern 0 1 3 9 Table
cloudalias 1 1 6 0 Table
config 0 1 5 50 Table
device 16 3 14 609 Table
device_attribute 0 3 7 45 Table
device_certificate 0 2 4 75 Table
device_cloudalias 0 2 4 0 Table
device_match 0 1 6 905 Table
device_pattern 0 1 8 571 Table
device_ports 0 1 6 46 Table
device_profiledata 0 3 5 116 Table
device_response 0 4 8 515 Table
device_snmpalias 0 2 4 2 Table
device_values 0 1 27 609 Table
edge 0 0 7 0 Table
iftable 3 0 6 6 Table
iftable_vlan 0 1 4 142 Table
interface 3 1 17 9 Table
interface_address 0 1 4 12 Table
interface_host 0 2 4 0 Table
interface_route 0 4 12 15 Table
link 0 3 6 387 Table
linkset 1 0 4 2 Table
map 0 1 9 0 Table
mapnode 0 0 14 0 Table
nackcandidate 0 0 6 70 Table
path 0 1 8 0 Table
profile_translation 0 0 7 2 Table
profiledata 2 1 7 37 Table
profiledata_pattern 0 1 3 50 Table
route 3 0 8 15 Table
snmpalias 1 1 6 2 Table
target 1 5 13 653 Table
target_highpriority 0 6 14 0 Table
target_hist 0 0 14 0 Table
target_shadow 0 0 12 0 Table
targetm 0 0 9 0 Table
updates 0 0 6 5 Table
updatetargetspace_log 0 0 7 42 Table