CREATE TYPE deviceClass_type AS ENUM ('C0','C1','C2');CREATE TYPE energyLimitationClass_type AS ENUM ('E0','E1','E2','E9');CREATE TYPE DeviceModel_type AS ENUM ('DeviceModel');

CREATE TABLE DeviceModel (alternateName TEXT, annotations JSON, brandName TEXT, category JSON, color TEXT, controlledProperty JSON, dataProvider TEXT, dateCreated TIMESTAMP, dateModified TIMESTAMP, description TEXT, deviceCategory JSON, deviceClass deviceClass_type, documentation TEXT, energyLimitationClass energyLimitationClass_type, function JSON, id TEXT PRIMARY KEY, image TEXT, macAddress TEXT, manufacturerName TEXT, modelName TEXT, name TEXT, owner JSON, seeAlso JSON, source TEXT, supportedProtocol JSON, supportedUnits JSON, type DeviceModel_type);