Author Topic: Add DB column descriptions to diagram table element  (Read 4234 times)

rudina

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Add DB column descriptions to diagram table element
« on: July 02, 2021, 11:41:13 pm »
I am trying to document an existing Oracle data model, and I want the descriptions for each column to appear on the visual of each table on my diagram.  Is there a way to do this? 

The comments for each column stored in the DB go into the NOTES attribute for each column on the table object in the EA project.  I see there are some ways to adjust the visual appearance of the table elements on the diagram, but couldn't find a way to expose the NOTES attribute of each column.

As an example I'm looking for something like this that the Oracle database diagram tool can do: 


I want do this in EA because a lot of the 300+ tables in the DB do not have descriptions populated.  I need to add more comments and be able to display them on diagrams for the various sections of the DB before I start a large migration and modernization project.


qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Add DB column descriptions to diagram table element
« Reply #1 on: July 03, 2021, 07:35:28 am »
I don't think you can do that with EA. EA is basically for UML modeling and can do a bit of DB modeling (since that's similar in many aspects). I'd guess you're better off with a fully fledged DB modeling tool. There are quite some out there (obviously you have an example of one). There are ways to show comments. But not in a class display. There's the possibility to turn on information view or diagrams as list. I never used that, but you might play around with it. Or best you wait a few days until more you get some more professional comment that this one.

q.