schema.sql

/* (Beta) Export of data model ManufacturingMachineOperation of the subject dataModel.ManufacturingMachine for a PostgreSQL database. Pending translation of enumerations and multityped attributes */
CREATE TYPE result_type AS ENUM ('aborted','failed','ok','success','suspended');CREATE TYPE status_type AS ENUM ('cancelled','finished','ongoing','planned','scheduled');CREATE TYPE ManufacturingMachineOperation_type AS ENUM ('ManufacturingMachineOperation');
CREATE TABLE ManufacturingMachineOperation (address JSON, alternateName TEXT, areaServed TEXT, commandSequence JSON, dataProvider TEXT, dateCreated TIMESTAMP, dateModified TIMESTAMP, description TEXT, endedAt TIMESTAMP, id TEXT PRIMARY KEY, location JSON, name TEXT, operationOutput JSON, operationType JSON, owner JSON, plannedEndAt TIMESTAMP, plannedStartAt TIMESTAMP, result result_type, seeAlso JSON, source TEXT, startedAt TIMESTAMP, status status_type, type ManufacturingMachineOperation_type);