May 5th, 2009, 05:21 PM
|
|
Contributing User
|
|
Join Date: Mar 2009
Posts: 80
Time spent in forums: 19 h 45 m 3 sec
Reputation Power: 1
|
|
|
Visually represent database
Hi,
I am trying to build a cross-reference editor/viewer. Currently, I have two tables in my database:
Code:
sku_list(sku_id, sku)*
relationships(rel_id, sku1, sku2)**
*sku_id is incremental, although it may not appear like so in my example below.
**This is not the concept of parent-child relationship, just plain old one-to-one between two SKUs.
Example:
sku_list
Code:
sku_id sku
123 ABC
456 DEF
789 GHI
101 JKL
112 MNO
relationships
Code:
rel_id sku1 sku2
1 123 456
2 123 789
3 789 101
4 789 112
5 101 123
I would like to represent it visually, like this:
I would want the lines to be editable/draggable, not unlike the Relationships Designer in MSACCESS or phpMyAdmin. Could anyone suggest the language or program for this?
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
