Sparx Systems Forum
Enterprise Architect => General Board => Topic started by: rudina 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:
(https://dataedo.com/asset/img/kb/db-tools/oracle_sql_developer/oracle_sql_dev_dm_diagram_descriptions.png)
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.
-
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.