/* (Beta) Export of data model PhreaticObserved of the subject dataModel.Environment for a PostgreSQL database. Pending translation of enumerations and multityped attributes */

CREATE TYPE PhreaticObserved_type AS ENUM ('PhreaticObserved');

CREATE TABLE PhreaticObserved (address JSON, alternateName TEXT, areaServed TEXT, dataProvider TEXT, dateCreated TIMESTAMP, dateModified TIMESTAMP, dateObserved TIMESTAMP, dateObservedFrom TIMESTAMP, dateObservedTo TIMESTAMP, depth NUMERIC, description TEXT, id TEXT PRIMARY KEY, investigationDepth NUMERIC, isMobile BOOLEAN, location JSON, measurementType JSON, name TEXT, owner JSON, pollutionRate NUMERIC, pressure NUMERIC, refDevice JSON, residueLevel NUMERIC, seeAlso JSON, source TEXT, type PhreaticObserved_type, waterTable NUMERIC);