schema.sql

/* (Beta) Export of data model RegulationStructureSimulation of the subject dataModel.OpenChannelManagement for a PostgreSQL database. Pending translation of enumerations and multityped attributes */
CREATE TYPE RegulationStructureSimulation_type AS ENUM ('RegulationStructureSimulation');
CREATE TABLE RegulationStructureSimulation (address JSON, alternateName TEXT, areaServed TEXT, dataProvider TEXT, dateCreated TIMESTAMP, dateModified TIMESTAMP, description TEXT, endSimulationTime TIMESTAMP, equivalentSluiceOpening NUMERIC, estimatedGateDischargeCoefficient NUMERIC, id TEXT PRIMARY KEY, initialConditions JSON, inputParameters JSON, location JSON, modelError NUMERIC, modelledDischarge NUMERIC, name TEXT, owner JSON, seeAlso JSON, simulationOutput JSON, source TEXT, spillwayFlow NUMERIC, startSimulationTime TIMESTAMP, targetDischarge NUMERIC, type RegulationStructureSimulation_type);