Can I generate mapping tables for many-to-many's?

[Drane]

Is it possible to define a data model with aggregation relationships so that when generating DDL, a mapping table will automatically be placed between the many-to-many related tables?

Seems a quite basic task tough couldn't find any info on this yet.

Thanks heaps!

Jochen  

[azemerov]

I don't know if it is possible using build-in EA tools, but you can use 3rd party tools. I can recommend DbUML 2.0 - https://sites.google.com/site/dbumlmap2/ - it allows you to create any kind of templates and generate everything you want - DDL, UML report or source code - any language, any structure. What is important - it has build-in mapping tool and is free.

[Eve]

The built-in DDL transformation in EA does that.