Wrong foreign keys and missing schemas in datapackage

OpenEnergyPlatform / oedatamodel

A common open energy data model (oedatamodel) and datapackage format for energy and scenario data

Creative Commons Zero v1.0 Universal

7 stars 3 forks source link

Closed henhuy closed 4 years ago

henhuy commented 4 years ago

I tried to create ORM from metadata file (via https://github.com/OpenEnergyPlatform/oem2orm), but this failed due several minor things:

schema not given in FK
wrong PK/FK name in data table (scenario/data IDs switched)
invalid types (for oem2orm) "hstore", "decimal"
array[float] has to be written as float array in oem2orm (to be discussed!, as this looks not nice)

jh-RLI commented 4 years ago

Thats great :) Good Work, I will include this in the oedatamodel and will create a tutorial on how to use eralchemy.

jh-RLI commented 4 years ago

Fixed in linked PR. Include fixes in the concrete and inheritance data model.