Book a Demo

Author Topic: v15.2β - QuickLinker: Associations in DB model diagrams  (Read 11019 times)

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8626
  • Karma: +259/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
v15.2β - QuickLinker: Associations in DB model diagrams
« on: June 15, 2020, 03:47:48 pm »
I think I may be falling foul of the perspectives issue again.

I can reverse engineer a DB with Database builder and I can create tables with the Data Modelling profile.

When I use the QuickLinker, should I be able to create an Association between the two tables?

TIA,
Paolo
« Last Edit: June 15, 2020, 04:29:03 pm by Paolo F Cantoni »
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8626
  • Karma: +259/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: v15.2β - QuickLinker: Associations in DB model diagrams
« Reply #1 on: June 18, 2020, 09:11:20 am »
[SNIP]

When I use the QuickLinker, should I be able to create an Association between the two tables?

TIA,
Paolo
[BUMP]

We see NO Association on the list of QuickLinker relationships.  Since we need to create an Association BEFORE we can assign Foreign Key Constraints...  We "can't get there from here"!

Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: v15.2β - QuickLinker: Associations in DB model diagrams
« Reply #2 on: June 18, 2020, 09:53:55 am »
We see NO Association on the list of QuickLinker relationships.  Since we need to create an Association BEFORE we can assign Foreign Key Constraints...  We "can't get there from here"!
When I drag the quicklinker between two instances of EAUML::table I see Association (with the only other options being Dependency, Trace and Information Flow)

Yes, this will be dependent on perspective and the filter to toolbox.

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8626
  • Karma: +259/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: v15.2β - QuickLinker: Associations in DB model diagrams
« Reply #3 on: June 18, 2020, 03:35:20 pm »
We see NO Association on the list of QuickLinker relationships.  Since we need to create an Association BEFORE we can assign Foreign Key Constraints...  We "can't get there from here"!
When I drag the QuickLinker between two instances of EAUML::table I see Association (with the only other options being Dependency, Trace and Information Flow)

Yes, this will be dependent on perspective and the "filter to toolbox".
YMMVDWFM

I have a new diagram, type Extended: Data Modelling, Perspective: Data Modelling (via selective Toolbox Perspective = ALL Database Engineering).
"Filter to Toolbox" is OFF!

No other relationships than the "Three Amigos" above!

Where's my Association gone?

Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!