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 |
| Status | closed | Resolution | fixed | ||
| 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. | ||||
| 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 |
