DDL generation primary keys, and indexes.

[TonyN]

HI All,

I am trying to get the DDL generaton tool to create (from a logical model), a multi column primary key and I also need to designate another column as having unique content and nulls not allowed.

Could somebody please advise what needs to be specified in the logical model class to have this occure in the table object that is generated by the DDL transform.

Also is there a way to go from DDL back to logical model (ie. round trip)?

Regards,
Tony

[qwerty]

I can only answer the 2nd question: there is no real round trip for DDL. But you can import a database schema so EA creates a class model. This is not in synch with a generated DDL, though.

q.

[Ondrej Kolenaty]

For multicolum PK you have to put into class transformation template a PrimaryKey {} section with one or more Column {} in it. For example create a new attribute template named Attribute__Primary_Key with such content:

$isPk=%FIND(%attStereotype%, "PK")%  
%if $isPk != "-1"%
Column
{
 %if attAlias != ""%
    name=%qt%%attAlias%%qt%
  %else%
    name=%qt%%EXEC_ADD_IN("CS_AdisAddin", "getClassAlias", attClassifierGUID)%%qt%
  %endIf%
}
%endIf%

and in class templete use it:

PrimaryKey
    {
      name=%qt%pk%classAlias%%qt%
      %list="Attribute__Primary_Key" @separator="\n" @indent="  "%
    }