Re: [Dhis2-devs] Data Element Category Combinations

2013-08-18 Thread Lars Helge Ă˜verland
Hi Farai, the categoryoptioncombo table is in fact very much part of the schema and has foreign keys from the categoryoptioncombos_categoryoptions and categorycombos_optioncombos join tables. The point with category option combos is that we need a single foreign key in the datavalue table which l

[Dhis2-devs] Data Element Category Combinations

2013-08-18 Thread Farai Mutero
Hi All I've been taking a closer look at the object model for Categories and Category Combinations in Postgresql. While putting together the object model I noticed that the *categoryoptioncombo* table* *is not dependent on any other table in the database, yet contains critical values that are also