Bug 54928 - include entity relationship diagrams (database schema support)
Summary: include entity relationship diagrams (database schema support)
Status: RESOLVED FIXED
Alias: None
Product: umbrello
Classification: Applications
Component: general (show other bugs)
Version: unspecified
Platform: Compiled Sources Linux
: NOR wishlist
Target Milestone: ---
Assignee: Umbrello Development Group
URL:
Keywords:
: 55247 88453 (view as bug list)
Depends on:
Blocks:
 
Reported: 2003-02-20 18:14 UTC by Jonathan Riddell
Modified: 2005-11-19 15:20 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jonathan Riddell 2003-02-20 18:14:16 UTC
Version:            (using KDE Devel)
Installed from:    Compiled sources

I have just one question: would you consider adding a basic database                       
diagram, such as ERD, to the model?  We use PostgreSQL to store data                       
for our application and so far have had to resort to Visio for our                         
ERDs.  I would much rather use a tool like Umbrello for the entire                         
model, here on my comfortable and functional FreeBSD workstation. 

From: Wes Peters <wes-AT-softweyr.com>
Comment 1 Jonathan Riddell 2003-02-26 23:13:36 UTC
*** Bug 55247 has been marked as a duplicate of this bug. ***
Comment 2 Mathieu Jobin 2004-08-24 23:51:06 UTC
you can consider DataArchitect, DBDesigner and Kexi for your ERD.
but I guess ERD in umbrello is a nice idea. or at least some sort of collaboration between kexi and umbrello.
so they become more integrated



Comment 3 Jonathan Riddell 2004-08-31 14:16:52 UTC
*** Bug 88453 has been marked as a duplicate of this bug. ***
Comment 4 Scott Wheeler 2004-08-31 17:44:38 UTC
Just changing the title so that it's more easily found when searching for duplicates.
Comment 5 Oliver Kellogg 2004-09-14 10:57:24 UTC
For more info on ER in UML, see e.g.

http://www3.software.ibm.com/ibmdl/pub/software/rational/web/whitepapers/2003/ermodeling.pdf
Comment 6 Jonathan Riddell 2004-12-17 09:42:40 UTC
CVS commit by jriddell: 

FEATURE:54928
entity relationship diagrams (database schema support)


  A            entity.cpp   1.1 [GPL (v2+)]
  A            entity.h   1.1 [GPL (v2+)]
  A            entityattribute.cpp   1.1 [GPL (v2+)]
  A            entityattribute.h   1.1 [GPL (v2+)]
  A            entitywidget.cpp   1.1 [GPL (v2+)]
  A            entitywidget.h   1.1 [GPL (v2+)]
  A            umlentityattributelist.cpp   1.1 [GPL (v2+)]
  A            umlentityattributelist.h   1.1 [GPL (v2+)]
  A            dialogs/umlentityattributedialog.cpp   1.1 [GPL (v2+)]
  A            dialogs/umlentityattributedialog.h   1.1 [GPL (v2+)]
  A            pics/cr22-action-umbrello_diagram_entityrelationship.png   1.1
  A            pics/cursor-entity.png   1.1
  A            pics/cursor-relationship.png   1.1
  A            pics/entity.png   1.1
  A            pics/relationship.png   1.1
  A            pics/sources/diag_entityrelationship.svg   1.1
  A            pics/sources/entity.svg   1.1
  A            pics/sources/relationship.svg   1.1
  M +4 -0      Makefile.am   1.53
  M +2 -0      association.cpp   1.60
  M +7 -3      assocrules.cpp   1.34
  M +1 -0      classifier.cpp   1.61
  M +16 -0     linepath.cpp   1.38
  M +91 -0     listpopupmenu.cpp   1.58
  M +11 -0     listpopupmenu.h   1.35
  M +2 -1      model_utils.cpp   1.12
  M +0 -2      operation.cpp   1.37
  M +2 -1      optionstate.h   1.6
  M +1 -1      tips   1.16
  M +1 -0      toolbarstatefactory.cpp   1.4
  M +1 -0      toolbarstateother.cpp   1.9
  M +1 -0      umbrelloui.rc   1.17
  M +13 -1     uml.cpp   1.125
  M +5 -0      uml.h   1.44
  M +6 -0      umlcanvasobject.cpp   1.32
  M +7 -0      umlcanvasobject.h   1.21
  M +88 -8     umldoc.cpp   1.216
  M +10 -0     umldoc.h   1.90
  M +137 -5    umllistview.cpp   1.132
  M +9 -0      umllistview.h   1.51
  M +9 -0      umllistviewitem.cpp   1.65
  M +19 -1     umlnamespace.h   1.40
  M +2 -1      umlobject.cpp   1.61
  M +13 -1     umlrole.cpp   1.34
  M +33 -5     umlview.cpp   1.197
  M +2 -1      umlwidget.cpp   1.112
  M +13 -3     worktoolbar.cpp   1.39
  M +4 -0      worktoolbar.h   1.25
  M +1 -0      dialogs/Makefile.am   1.27
  M +4 -1      dialogs/classgenpage.cpp   1.28
  M +38 -0     dialogs/classifierlistpage.cpp   1.23
  M +13 -0     dialogs/classpropdlg.cpp   1.22
  M +1 -0      dialogs/classpropdlg.h   1.11
  M +6 -3      pics/Makefile.am   1.27



Comment 7 Scott Wheeler 2004-12-17 15:19:31 UTC
Hmm, I'm trying out the new mode now, but as far as I can tell there's no way to show a relationship between a property in one "entity" and a property in another.  The terminology has changed a bit but I still don't see how this can really be used for showing relationships between columns in various database tables.

The canonical example would be showing a how an index field in one table was used in another.  i.e. if I have a table with "Trees" and another with "Branches" and there's an "ID" column in "Trees" and a "TreeID" column in "Branches" there needs to be a way to show that those two columns in the different tables are linked.
Comment 8 Jonathan Riddell 2004-12-17 19:14:20 UTC
Yep, still quite a bit of work to do to make it feature filled.
95352 opened.
Comment 9 greatbunzinni 2005-11-19 15:20:53 UTC
It seems that the ER diagrams that Umbrello generates don't follow any of the established ER diagram formats.

Is it possible to support any established ER diagram format like Chen diagrams?