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
ReporterMarco Wobben Assigned ToMarco Wobben  
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

Marco Wobben

Marco Wobben

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.
Marco Wobben

Marco Wobben

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 Marco Wobben New Issue
2021-10-16 19:35 Marco Wobben Status new => assigned
2021-10-16 19:35 Marco Wobben Assigned To => Marco Wobben
2021-10-17 13:11 Marco Wobben Status assigned => resolved
2021-10-17 13:11 Marco Wobben Resolution open => fixed
2021-10-17 13:11 Marco Wobben Fixed in Version => 12.1
2021-10-17 13:11 Marco Wobben Note Added: 0002084
2021-10-18 11:23 Marco Wobben Note Added: 0002086