schema.sql

/* (Beta) Export of data model StreetlightFeeder of the subject dataModel.Streetlighting for a PostgreSQL database. Pending translation of enumerations and multityped attributes */
CREATE TYPE StreetlightFeeder_type AS ENUM ('StreetlightFeeder');
CREATE TABLE StreetlightFeeder (activePower JSON, address JSON, alternateName TEXT, areaServed TEXT, dataProvider TEXT, dateCreated TIMESTAMP, dateModified TIMESTAMP, description TEXT, deviceInfo JSON, id TEXT PRIMARY KEY, location JSON, name TEXT, numStreetlight NUMERIC, observationDateTime TIMESTAMP, owner JSON, phaseCurrent JSON, phaseVoltage JSON, powerState TEXT, reactivePower JSON, seeAlso JSON, source TEXT, totalActivePower NUMERIC, totalReactivePower NUMERIC, type StreetlightFeeder_type);