schema.sql

/* (Beta) Export of data model ManufacturingMachine of the subject dataModel.ManufacturingMachine for a PostgreSQL database. Pending translation of enumerations and multityped attributes */
CREATE TYPE ManufacturingMachine_type AS ENUM ('ManufacturingMachine');
CREATE TABLE ManufacturingMachine (address JSON, alternateName TEXT, areaServed TEXT, assetIdentifier TEXT, batteryLevel NUMERIC, countryOfManufacture TEXT, current NUMERIC, dataProvider TEXT, dateCreated TIMESTAMP, dateModified TIMESTAMP, description TEXT, factory TEXT, firmwareVersion TEXT, firstUsedAt TIMESTAMP, hardwareVersion TEXT, id TEXT PRIMARY KEY, installationNotes JSON, installedAt TIMESTAMP, location JSON, machineOwner JSON, manufacturedAt TIMESTAMP, name TEXT, online BOOLEAN, osVersion TEXT, owner JSON, power NUMERIC, rotationalSpeed NUMERIC, seeAlso JSON, serialNumber TEXT, softwareVersion TEXT, source TEXT, status TEXT, subscriptionService JSON, supplierName TEXT, supportedProtocol JSON, type ManufacturingMachine_type, voltage NUMERIC);