The content of this article is deprecated, and will be removed in the future
assetTable is contains all assets and their location.
Primary table for our data structure, it contains all the assets and their location.
|Auto incrementing id of the asset
|Physical location of the asset
|Customer name, in most cases “factoryinsight”
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 February 28, 2024: Merge pull request #254 from united-manufacturing-hub/feat/xxx/release-0.2.12 (6c4232b)