View Issue Details

IDProjectCategoryView StatusLast Update
0001557CaseTalk ModelerConstraintspublic2021-02-27 09:45
ReporterBCP Software Assigned ToBCP Software  
PrioritynormalSeveritymajorReproducibilitysometimes
Status assignedResolutionopen 
Target Version12.0 
Summary0001557: Primary key on grouped level
DescriptionPrimary 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.
TagsNo tags attached.
CaseTalk Edition

Activities

BCP Software

BCP Software

2018-01-16 12:10

administrator   ~0001073

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).
BCP Software

BCP Software

2021-02-27 09:45

administrator   ~0001911

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.

Issue History

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 => 12.0