[wdmmg-dev] Proposed model overhaul

Martin Keegan martin.keegan at okfn.org
Wed Oct 5 09:38:41 UTC 2011


On Wed, Oct 5, 2011 at 10:11 AM, Friedrich Lindenberg
<friedrich.lindenberg at okfn.org> wrote:
> Thanks for clarification on IRC. Here is an example model file:
>
> https://github.com/pudo/spendb/blob/master/contrib/bund.js
>
> and the actual schema generated from it:
>
> https://gist.github.com/1263987

Ok, thanks very much.

The generated SQL schema has five tables. Where does each of them come
from, for a given dataset?

I'm guessing 1 table, "X_entry", for the entries, and one per
taxonomy, which accounts for

CREATE TABLE bund_entry
CREATE TABLE "bund_funktionenplan-bund"
CREATE TABLE "bund_gruppierungsplan-bund"

Do the other two:

CREATE TABLE bund_bund
CREATE TABLE bund_entity

come from taxonomies too? Is "X_entity" compulsory?

Mk




More information about the openspending-dev mailing list