PowerDesigner can use variables in the generation and reverse-engineering of reference columns.
|
Variable |
Comment |
|---|---|
|
%CKEYCOLUMN% |
Generated code of Parent table column (primary key) |
|
%FKEYCOLUMN% |
Generated code of Child table column (foreign key) |
|
%PK% |
Generated code of Primary key column |
|
%PKNAME% |
Primary key column name |
|
%FK% |
Generated code of Foreign key column |
|
%FKNAME% |
Foreign key column name |
|
%AK% |
Alternate key column code (same as PK) |
|
%AKNAME% |
Alternate key column name (same as PKNAME) |
|
%COLTYPE% |
Primary key column data type |
|
%DEFAULT% |
Foreign key column default value |
|
%HOSTCOLTYPE% |
Primary key column data type used in procedure declaration. For example: without length |