Software Design
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me

The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.

Go Back   Dev Shed ForumsProgramming Languages - MoreSoftware Design

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old April 19th, 2012, 05:10 PM
dacow dacow is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Mar 2012
Posts: 2 dacow User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 9 m 55 sec
Reputation Power: 0
Any software for database design able to draw polymorphic associations

polymorphic asociation is an association (like has one and has many) but allows to point many types of models/entities.

Like email, user has many emails, company has many emails, workers has many emails, etc.

So email handles a polymorphic association, something like
email
entity_type : string
entity_id : integer


and type can be "company" "user" "worker" etc., pretty much most ORM implementation of polymorphic association.

this is like emails "belongs to" user or worker or company, etc.

is there any database design software that allow to design/draw this kind of associations ? even if a mod/plugin is needed

ive using powerdesigner for a while, but doesnt allow this type of associations, and they really common these days on frameworks and ORMs.

Reply With Quote
  #2  
Old July 5th, 2012, 12:31 AM
nsillk nsillk is offline
Online Strategist
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Mar 2012
Location: Moratuwa, Sri Lanka
Posts: 109 nsillk User rank is Sergeant Major (2000 - 5000 Reputation Level)nsillk User rank is Sergeant Major (2000 - 5000 Reputation Level)nsillk User rank is Sergeant Major (2000 - 5000 Reputation Level)nsillk User rank is Sergeant Major (2000 - 5000 Reputation Level)nsillk User rank is Sergeant Major (2000 - 5000 Reputation Level)nsillk User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 1 Day 9 m 35 sec
Reputation Power: 23
Facebook
Try Creately

I have used Creately database design tools for these kind of things. I don't know whether it will exactly match your need but once you add two tables and connect them, Creately lets you change the arrow type so you can show different relationships. So might fit your need.

Reply With Quote
  #3  
Old July 19th, 2012, 04:56 AM
kathygreen kathygreen is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jun 2012
Posts: 50 kathygreen Negative: is most likely a SPAMMER and a traitor to the cause. 
Time spent in forums: 16 h 30 m 53 sec
Reputation Power: 0
Hi,

Creately database design tool is great source. But I never use before. So, I am little bit confused about this.

Quote:
Originally Posted by nsillk
I have used Creately database design tools for these kind of things. I don't know whether it will exactly match your need but once you add two tables and connect them, Creately lets you change the arrow type so you can show different relationships. So might fit your need.

Reply With Quote
  #4  
Old September 24th, 2012, 04:25 AM
haowangy haowangy is offline
Permanently Banned
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2012
Posts: 3 haowangy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 32 m 29 sec
Warnings Level: 10
Number of bans: 1
Reputation Power: 0
This is very useful to me and I really like it . thank you!

Reply With Quote
  #5  
Old October 30th, 2012, 12:59 AM
NickJhnsn NickJhnsn is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2012
Posts: 33 NickJhnsn Negative: is most likely a SPAMMER and a traitor to the cause. 
Time spent in forums: 6 h 1 m 48 sec
Reputation Power: 0
"creately database design tools"... How it is different from othe designing tool?????
What is its main feature???????

Reply With Quote
Reply

Viewing: Dev Shed ForumsProgramming Languages - MoreSoftware Design > Any software for database design able to draw polymorphic associations

Developer Shed Advertisers and Affiliates



Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.

© 2003-2013 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap