View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0003162CaseTalk ModelerGeneration (SQL, XML, etc)public2021-10-16 19:352021-10-18 11:23
ReporterBCP Software Assigned ToBCP Software  
PrioritynormalSeverityminorReproducibilityhave not tried
Status resolvedResolutionfixed 
Target Version12.1Fixed in Version12.1 
Summary0003162: Foreign Key Names are numbered
DescriptionWhen foreign keys are generated for ER/Studio the names of the FK Objects contain numbers. If the original models is changed, these numbers may change and report many differences when comparing two ER Studio models.
Additional InformationExamples snippet where numbered names occur:

Set FK50_Asset = MyModel.Relationships.Item("FK50_Asset")
if FK50_Asset is nothing then
Set FK50_Asset = MyModel.Relationships.AddWithRoleName( _
      Entity_Workload.EntityName, Entity_Asset.EntityName, 3, _
      "workload id, Workload aggregation/Workload")
    end if
    If FK50_Asset.ID <> 0 Then ' succesful
      FK50_Asset.Name = "FK50_Asset"
      FK50_Asset.BusinessName = "Workload aggregation"
      For Each fkpair In FK50_Asset.FkColumnPairs
        fkpair.ChildAttribute.RoleName = fkpair.ChildAttribute.LogicalRoleName
      Next
    End If
TagsNo tags attached.
CaseTalk Editionunknown

Activities

BCP Software

BCP Software

2021-10-17 13:11

administrator   ~0002084

Foreign key names which are technical in contrast to the Business Name, is now based on the business name to get rid of artificial global numbering.
BCP Software

BCP Software

2021-10-18 11:23

administrator   ~0002086

In case a FK name still clashes, a local number is added to make at least one of them unique. Role verbs may also be used to generate a Business Name, aka FK Name.

Similar issues may arise for PK/AK, but the new CaseTalk 12.1 will provide UC Names to prevent that from happening.

Issue History

Date Modified Username Field Change
2021-10-16 19:35 BCP Software New Issue
2021-10-16 19:35 BCP Software Status new => assigned
2021-10-16 19:35 BCP Software Assigned To => BCP Software
2021-10-17 13:11 BCP Software Status assigned => resolved
2021-10-17 13:11 BCP Software Resolution open => fixed
2021-10-17 13:11 BCP Software Fixed in Version => 12.1
2021-10-17 13:11 BCP Software Note Added: 0002084
2021-10-18 11:23 BCP Software Note Added: 0002086