schema.sql

/* (Beta) Export of data model ExcST4B of the subject dataModel.EnergyCIM for a PostgreSQL database. Pending translation of enumerations and multityped attributes */
CREATE TYPE ExcST4B_type AS ENUM ('ExcST4B');
CREATE TABLE ExcST4B (address JSON, alternateName TEXT, areaServed TEXT, dataProvider TEXT, dateCreated TIMESTAMP, dateModified TIMESTAMP, description TEXT, id TEXT PRIMARY KEY, kc NUMERIC, kg NUMERIC, ki NUMERIC, kim NUMERIC, kir NUMERIC, kp NUMERIC, kpm NUMERIC, kpr NUMERIC, location JSON, lvgate NUMERIC, name TEXT, owner JSON, seeAlso JSON, source TEXT, ta NUMERIC, thetap NUMERIC, type ExcST4B_type, uel NUMERIC, vbmax NUMERIC, vgmax NUMERIC, vmmax NUMERIC, vmmin NUMERIC, vrmax NUMERIC, vrmin NUMERIC, xl NUMERIC);