search

DDieterich / DTGen

DTGEN Code Generation Tool for Relational Designers (See Wiki Branch)
http://dtgen.org
3 stars 0 forks source link

Foreign Key Prefixes in _ACT view join needs to be Unique #32

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?

 1. Create an agencies table
 2. Create a contract_ids table with a foreign key to agencies included in the natural key
 3. Create a purchasers table with a foreign key to agencies included in the natural key
 4. Create a contracts table with foreign keys to contract_ids and purchasers
 5. The foreign keys to agencies from contracts don't differentiate between purchasers and contract_ids.

What is the expected output? What do you see instead?

 -) The foreign keys to agencies from contracts must be differentiated between purchasers and contract_ids.

Please use labels and text to provide additional information.

 -) If the _ACT views join to other _ACT views instead of the base tables, the foreign natural keys will be unique and the fk_prefixes will not be necessary.

Original issue reported on code.google.com by Duane.Di...@gmail.com on 9 Jun 2012 at 8:29

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago

Original comment by Duane.Di...@gmail.com on 3 Aug 2012 at 8:13