assetTable
assetTable is contains all assets and their location.
less than a minute
Usage
Primary table for our data structure, it contains all the assets and their location.
Structure
key | data type | description | example |
---|---|---|---|
id | int | Auto incrementing id of the asset | 0 |
assetID | text | Asset name | Printer-03 |
location | text | Physical location of the asset | DCCAachen |
customer | text | Customer name, in most cases “factoryinsight” | factoryinsight |
Relations
DDL
CREATE TABLE IF NOT EXISTS assetTable
(
id SERIAL PRIMARY KEY,
assetID TEXT NOT NULL,
location TEXT NOT NULL,
customer TEXT NOT NULL,
unique (assetID, location, customer)
);
Last modified April 17, 2023: build: version 0.9.13 (6cb0a01)