Primary table for our data structure, it contains all the assets and their location.
|Auto incrementing id of the asset||0|
|Physical location of the asset||DCCAachen|
|Customer name, in most cases “factoryinsight”||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) );