Re: Parse-Dia-SQL foreign key

2015-05-31 Thread paul . hermeneutic
Alex, many thanks for your message. My experience has been with Parse::Dia::SQL from CPAN. I have not been using dia2code. However I did download it and read about it some. I am not sure about the FK naming convention. My fact table might have 20 surrogate keys pointing to a dimension. They canno

Re: Parse-Dia-SQL foreign key

2015-05-31 Thread paul . hermeneutic
>> I created two UML classes (tables) and gave each several attributes >> (columns). >> >> I created an association between them, but the foreign key is never >> created in the SQL unless I make it the primary key of the one-side >> table. >> >> Is there a better place to ask Parse-Dia-SQL question

Re: Parse-Dia-SQL foreign key

2015-05-30 Thread Alejandro Imass
On Sat, May 30, 2015 at 10:24 AM, Alejandro Imass wrote: > On Thu, May 28, 2015 at 10:40 PM, wrote: >> I created two UML classes (tables) and gave each several attributes >> (columns). >> >> I created an association between them, but the foreign key is never >> created in the SQL unless I make

Re: Parse-Dia-SQL foreign key

2015-05-30 Thread Alejandro Imass
On Thu, May 28, 2015 at 10:40 PM, wrote: > I created two UML classes (tables) and gave each several attributes (columns). > > I created an association between them, but the foreign key is never > created in the SQL unless I make it the primary key of the one-side > table. > > Is there a better pl

Re: Parse-Dia-SQL foreign key

2015-05-30 Thread Slavko
Hi, Dňa Thu, 28 May 2015 20:40:01 -0600 paul.hermeneu...@gmail.com napísal: > I created two UML classes (tables) and gave each several attributes > (columns). > > I created an association between them, but the foreign key is never > created in the SQL unless I make it the primary key of the one-

Parse-Dia-SQL foreign key

2015-05-28 Thread paul . hermeneutic
I created two UML classes (tables) and gave each several attributes (columns). I created an association between them, but the foreign key is never created in the SQL unless I make it the primary key of the one-side table. Is there a better place to ask Parse-Dia-SQL questions? ___