DDL Transformation - retaining keys

[Tim Hosking]

Hi Everyone,

First post for me - if you know about DDL transformation from data model to data model, you may be able to help. I am writing my own DDL transformation to transform a data model so that it conforms with our corporate standards, and going from logical to physical. I have included primary and foreign keys in my model (I know - not strictly logical model stuff) for various reasons rather than let EA generate them for me in the DDL transformation. So I have tried writing my own transformation and getting rid of the generation of the columns for the keys. (EA generates keys with classNameID by default.) I also get rid of spaces in the column names doing the ..."Spaced", "Ht()Ht"... thing in CONVERT_NAME. So, specifically what do I put in the following where the appears:

ForeignKey
{
    blah
    Source
    {
     blah
          Column
          {
                name=%qt%%CONVERT_NAME(, "Spaced", "Ht()Ht")%%qt%
                type=blah
           }
     }
}

Basically, how do I refer to the attribute or column name that is the primary key?

OR am I doing it wrong? Shouldn't EA just move the PK and FK stuff for me?