Hi,
i was exporting an ER-Diagram into XML and took a look at the structure. Tables and their columns are exported and also the foreign-key information of a column. But the way foreign-key information is exported differs between tables.
For some columns the referenced column is not defined, as shown here:
<ModelRefProperty displayName="Fremdschlüssel" name="foreignKey">
<ModelRef id="GK0EalSD.AACAUbf"/>
</ModelRefProperty>
<ModelRefProperty displayName="Ref Column" name="refColumn"/>
for other columns the referenced column is defined:
<ModelRefProperty displayName="Fremdschlüssel" name="foreignKey">
<ModelRef id="jZrw6lSD.AACARkj"/>
</ModelRefProperty>
<ModelRefProperty displayName="Ref Column" name="refColumn">
<ModelRef id="vPBHalSD.AACAQCr"/>
</ModelRefProperty>
Why isn’t the output always like the second sample? What is the reason?
I think that it depends on the sequence of the export of the table/column definitions in the xml-file.
If a column which is referenced by another column already exported in the xml file, then the refColumn value
is set, otherwise not.
But this is horrible (if it is like i suggested). Or is it a bug?
Does anybody know something about that?
Thanks,
Heiko