schema.sql

/* (Beta) Export of data model ExcIEEEAC8B of the subject dataModel.EnergyCIM for a PostgreSQL database. Pending translation of enumerations and multityped attributes */
CREATE TYPE ExcIEEEAC8B_type AS ENUM ('ExcIEEEAC8B');
CREATE TABLE ExcIEEEAC8B (address JSON, alternateName TEXT, areaServed TEXT, dataProvider TEXT, dateCreated TIMESTAMP, dateModified TIMESTAMP, description TEXT, id TEXT PRIMARY KEY, ka NUMERIC, kc NUMERIC, kd NUMERIC, kdr NUMERIC, ke NUMERIC, kir NUMERIC, kpr NUMERIC, location JSON, name TEXT, owner JSON, seeAlso JSON, seve1 NUMERIC, seve2 NUMERIC, source TEXT, ta NUMERIC, tdr NUMERIC, te NUMERIC, type ExcIEEEAC8B_type, ve1 NUMERIC, ve2 NUMERIC, vemin NUMERIC, vfemax NUMERIC, vrmax NUMERIC, vrmin NUMERIC);