View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001557 | CaseTalk Modeler | Constraints | public | 2018-01-16 12:09 | 2023-10-13 19:54 |
Reporter | BCP Software | Assigned To | BCP Software | ||
Priority | normal | Severity | major | Reproducibility | sometimes |
Status | resolved | Resolution | fixed | ||
Target Version | 13.0.1 | Fixed in Version | 13.0.1 | ||
Summary | 0001557: Primary key on grouped level | ||||
Description | Primary key is only available on UC's inside an OTFT. However a binary fact type with two UC's could contain a preferred primary key, and this binary fact type is outside an Object Type. Instead of setting an UC's as a Primary Key preference, the OTFT should allow any UC from a grouped view, to be candidate for primary key. This marked UC should then perhaps be visualized as a thicker arrow. | ||||
Tags | No tags attached. | ||||
CaseTalk Edition | |||||
When GLR is performed and a primary key is automatically selected, perhaps we should prefer the non-null roles, and the smallest amount of roles under a relevant uc. To prefer similar sets, we could choose for the oldest (as in lowest role numbers). | |
Instead of using the term "Primary Key" (which is a database implementation term) the more generic "Preferred Identification" should be used. This would allow the change of current PK when transforming to use the "Preferred" instead. Which, by design, may be outside an OT. | |
Also: When 'generate artificial key' is set, the UC on the roles are no longer really required. The consequences need to be discussed and investigated. | |
The UC Dialog now collects UCs inside the selected OTFT, but also checks for groupable roles and UCs related to those OTFTs. | |
Date Modified | Username | Field | Change |
---|---|---|---|
2018-01-16 12:09 | BCP Software | New Issue | |
2018-01-16 12:09 | BCP Software | Status | new => assigned |
2018-01-16 12:09 | BCP Software | Assigned To | => BCP Software |
2018-01-16 12:10 | BCP Software | Note Added: 0001073 | |
2020-04-19 09:25 | BCP Software | Category | Model Constraints => Constraints |
2021-02-27 09:45 | BCP Software | Note Added: 0001911 | |
2021-02-27 09:45 | BCP Software | Target Version | Future => 13.0.1 |
2022-10-25 18:10 | BCP Software | Note Added: 0004648 | |
2023-10-13 19:53 | BCP Software | Status | assigned => resolved |
2023-10-13 19:53 | BCP Software | Resolution | open => fixed |
2023-10-13 19:53 | BCP Software | Fixed in Version | => 13.0.1 |
2023-10-13 19:54 | BCP Software | Note Added: 0004979 |