[openspending-dev] adding foreign keys for imported datasets

Tue Jan 31 14:36:22 UTC 2012

Hi there,

I've added some changes to a github openspending fork [1]. These
changes basically add foreign keys for the imported star schema, i.e.,
from "<dataset>_entry" to each CompoundDimension. The changes do not
add any noticeable functionality, they only make the model more
understandable when you reverse engineer it (and, yes, add referential
integrity)

Changes are in [2]. I've tested on a simple model with some
CompoundDimensions and it worked fine. Since I'm new in the list, I
dont know if I should open an issue on github or make a pull request
(for a new branch?)...

Telmo

--
[1] https://github.com/tbrugz/openspending
[2] https://github.com/tbrugz/openspending/tree/feature/model+fk