Db fields types in XMI export

Hi,

Can you please clarify how to tell type of database column in XMI exported project?

For some reason the type_name attribute is always set to “integer”, no matter what the actual type is.

It seems that the attribute type contains numeric identifier of actual type, but there is no apparent mapping between these types and types specified in the model itself.

For example:
<packagedElement attributeModel=“CLieWuSGAqAAMiRZ” length=“20” name=“name” nullable=“false” primaryKey=“false” scale=“0” syncType=“1” type=“27” typeName=“integer” unique=“true” xmi:id=“uFol9WSAUPHkmwyM” xmi:type=“dbColumn”>

In the model the column name is declared as varchar(20)

Regards

Hi Denis,

Thanks for your post and I’ve forwarded this issue to our engineers to follow-up. Once there is any feedback, I’ll come back to you.

Best regards,
Lilian Wong

Hi Denis,

Since ERD is not standard of XMI/UML, the segment of DBTable in XMI is not standard too. I recommend you export the ERD to XML, and you can find our XML schema “project.xsd” from VPSuite/bundled directory.

If there i any further inquiry, please feel free to ask.

Best regards,
Lilian Wong