DBColumn properties for report composer template

I am using the report composer and building my own templates.
Where can I find documentation for the properties available for various elements.
In particular, what are the properties of DBColumn and what children does it have?

Hello Ion,

Thank you for your message and you can find out details about the report template at http://www.visual-paradigm.com/support/documents/vpumluserguide/304_reportgenera.html

Best regards,
Rain Wong

I looked at the report template documentation. There is information about generic properties but nothing specific to DBColumn (like primary key, foreign key, etc.).
Maybe I’m missing something. Could you point me to the appropriate section that documents DBColumn?

Hi Ion ,

You can check if the column is a primary key with:

To show the column type:

To show the length with scale:

Hope this helps. Feel free to post again if you need any more help.

Best regards,
Jick Yeung

Thanks, it works.
Can you please tell me how I can determine if there is a foreign key on a column and which table and field is it referencing?

Hi Ion,

You may use <ForEach property=“foreignKeyConstraints” …> to get the foreign key constraints (s) from a column.
Foreign key constraint has 2 properties:
refColumn (the opposite side’s Entity’s PK Column)
foreignKey (the relationship)

For your case, you refColumn.
So, use <MetaModelElement property=“refColumn” …> to get the column from the foreign key constraint.
Then use <ParentModel …> to get the table of the column

Best regards,
Jick Yeung