processValueStringTable

processValueStringTable contains process values.

less than a minute

Usage

This table stores process values, for example toner level of a printer, flow rate of a pump, etc. This table, has a closely related table for storing number values, processValueTable .

Structure

key	data type	description	example
`timestamp`	`timestamptz`	Entry timestamp	0
`asset_id`	`serial`	Asset id (see assetTable )	1
`valueName`	`text`	Name of the process value	toner-level
`value`	`string`	Value of the process value	100

Relations

DDL

CREATE TABLE IF NOT EXISTS processValueStringTable
(
    timestamp               TIMESTAMPTZ                         NOT NULL,
    asset_id                SERIAL                              REFERENCES assetTable (id),
    valueName               TEXT                                NOT NULL,
    value                   TEST                                NULL,
    UNIQUE(timestamp, asset_id, valueName)
);
-- creating hypertable
SELECT create_hypertable('processValueStringTable', 'timestamp');

-- creating an index to increase performance
CREATE INDEX ON processValueStringTable (asset_id, timestamp DESC);

-- creating an index to increase performance
CREATE INDEX ON processValueStringTable (valuename);

Last modified May 5, 2023: feat: finishing touches (1147002)