stablenet_info

server_id TEXT
name TEXT
version TEXT
technical_version TEXT

stablenet_taggable

server_id TEXT
domain TEXT
id TEXT
name TEXT
display_name TEXT
state TEXT
attribute_tags JSONB
custom_tags JSONB
tag_filter TEXT

domain TEXT (إلزامية)
id BIGINT
tag_filter TEXT

stablenet_taggable_device

server_id TEXT
id TEXT
name TEXT
display_name TEXT
state TEXT
attribute_tags JSONB
custom_tags JSONB
tag_filter TEXT

id BIGINT
tag_filter TEXT

stablenet_taggable_interface

server_id TEXT
id TEXT
name TEXT
display_name TEXT
state TEXT
attribute_tags JSONB
custom_tags JSONB
tag_filter TEXT

id BIGINT
tag_filter TEXT

stablenet_taggable_job

server_id TEXT
id TEXT
name TEXT
display_name TEXT
state TEXT
attribute_tags JSONB
custom_tags JSONB
tag_filter TEXT

id BIGINT
tag_filter TEXT

stablenet_taggable_link

server_id TEXT
id TEXT
name TEXT
display_name TEXT
state TEXT
attribute_tags JSONB
custom_tags JSONB
tag_filter TEXT

id BIGINT
tag_filter TEXT

stablenet_taggable_service

server_id TEXT
id TEXT
name TEXT
display_name TEXT
state TEXT
attribute_tags JSONB
custom_tags JSONB
tag_filter TEXT

id BIGINT
tag_filter TEXT

stablenet_taggable_agent

server_id TEXT
id TEXT
name TEXT
display_name TEXT
state TEXT
attribute_tags JSONB
custom_tags JSONB
tag_filter TEXT

id BIGINT
tag_filter TEXT

stablenet_tag_category

server_id TEXT
domain TEXT
id TEXT
name TEXT
description TEXT

domain TEXT (إلزامي)
id BIGINT

stablenet_measurement

server_id TEXT
id TEXT
name TEXT
description TEXT
tags JSONB
dest_device_id TEXT
dest_interface_id TEXT
agent_id TEXT
start_time TIMESTAMPTZ
end_time TIMESTAMPTZ
state TEXT
type TEXT
template_name TEXT
permanent BOOL
payload JSONB
active BOOL
tag_filter TEXT

tag_filter TEXT
dest_device_id BIGINT

stablenet_measurement_metric

server_id TEXT
measurement_id TEXT
data_id BIGINT
description TEXT
expected_interval INT
key TEXT
name TEXT
only_average BOOL
unit TEXT

measurement_id BIGINT

stablenet_measurement_data

server_id TEXTmeasurement_id TEXTmetric_key TEXTmetric_name TEXT"start" TIMESTAMPTZ"end" TIMESTAMPTZbucket_size INT(بالثواني)
"timestamp" TIMESTAMPTZ

min double precision
max double precision
avg double precisiontag_filter TEXT

measurement_id BIGINTmetric_key TEXT"start" TIMESTAMPTZ(إلزامي)
"end" TIMESTAMPTZ(إلزامي)
bucket_size INT(إلزامي)
tag_filter TEXT

stablenet_measurement_data_[minutely | 5_minutely | 15_minutely]

server_id TEXT
measurement_type TEXT
measurement_id TEXT
metric_key TEXT
"timestamp" TIMESTAMPTZ NOT NULL
value_min double precision
value_max double precision
value_avg double precision
stats_agg STATSSUMMARY2D
stats_agg_max STATSSUMMARY2D

stablenet_measurement_data_[hourly | daily | weekly | monthly | quarterly | yearly]

server_id TEXT
measurement_type TEXT
measurement_id
metric_key TEXT
timestamp TIMESTAMPTZ
stats_agg STATSSUMMARY2D
stats_agg_max STATSSUMMARY2D
percentile_agg UDDSKETCH
percentile_agg_max UDDSKETCH