View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0001124||Database Workbench v5||Diagramming||public||2014-12-24 10:30||2015-01-22 13:24|
|Reporter||Martijn Tonies||Assigned To||Martijn Tonies|
|Priority||normal||Severity||minor||Reproducibility||have not tried|
|Fixed in Version||5.0.8|
|Summary||0001124: Issue with CDM to PDM and relationships|
|Description||I 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.
|Tags||No tags attached.|
|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|