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 April 17, 2023: build: version 0.9.13 (6cb0a01)