View Issue Details

IDProjectCategoryView StatusLast Update
0001124Database Workbench v5Diagrammingpublic2015-01-22 13:24
ReporterMartijn Tonies Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Fixed in Version5.0.8 
Summary0001124: Issue with CDM to PDM and relationships
DescriptionI am using the diagram editor of Database Workbench. I define entities, and the relationship between them. This happens in the CDM. Then, I export this CDM to a Firebird PDM. Then, when I inspect what was generated, I realize that the relationships I defined in the CDM were not correctly generated in the PDM.

For example, I defined the CLIENT and ORDER entities.

CLIENT has 2 attributes : ID (Integer, PK) and NAME (Varchar).
ORDER has 2 attributes : ID (Integer, PK) and DATE (Date).

Then I put in the relationship between those two entities : an identifying relationship, with parameters like : CLIENT has 0..n orders, order has 1..1 client. Both attributes are set to [default]. The roles are not specified.

What I aim at to be generated (in the PDM) would be the two tables corresponding to CLIENT and ORDER, as well as an added column in the ORDER table "CLIENT_ID" with a foreign key to CLIENT.ID.

Though, what gets generated is only the two tables and a foreign key linking CLIENT.ID to ORDER.ID, which is incorrect in this case. No CLIENT_ID column was added.

If I want to get a correct generated PDM, I have to manually add the CLIENT_ID column to the ORDER entity, and have the relationship point to that specific column.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2014-12-24 10:30 Martijn Tonies New Issue
2014-12-24 10:32 Martijn Tonies Status new => confirmed
2015-01-20 12:27 Martijn Tonies Assigned To => Martijn Tonies
2015-01-20 12:27 Martijn Tonies Status confirmed => assigned
2015-01-20 14:40 Martijn Tonies Status assigned => resolved
2015-01-20 14:40 Martijn Tonies Fixed in Version => 5.0.8
2015-01-20 14:40 Martijn Tonies Resolution open => fixed
2015-01-22 13:24 Martijn Tonies Status resolved => closed