api.monitoring_humidity

Description

Monitoring environment.%.humidity web view

Table Definition

CREATE VIEW monitoring_humidity AS (
 SELECT m."time",
    jsonb_each_text.key,
    jsonb_each_text.value
   FROM api.metrics m,
    LATERAL jsonb_each_text(m.metrics) jsonb_each_text(key, value)
  WHERE ((jsonb_each_text.key ~~* 'environment.%.humidity'::text) OR (jsonb_each_text.key ~~* 'environment.%.relativeHumidity'::text))
  ORDER BY m."time" DESC
)

Columns

Name	Type	Default	Nullable
key	text		true
time	timestamp with time zone		true
value	text		true

Referenced Tables

Name	Columns	Comment	Type
api.metrics	11	Stores metrics from vessel	BASE TABLE

Relations

erDiagram


"api.monitoring_humidity" {
  text key ""
  timestamp_with_time_zone time ""
  text value ""
}

Generated by tbls