In the last release we introduced a cool tool which allows you to see the structure of your application at a high level. The tool is called "Relationship Diagram". We want to know what you think about this new tool. Please share below!
If this if your first time hearing about this tool, let me tell you how you can play with it. Go to your home page and click on settings in the upper left. Next click on "Application Management" and then under the section titled "Show App Info" click on "Show Relationship Diagram". From here you can rearrange the diagram. Click and drag a table in the diagram to move it to a different place on the page. Once you have rearranged the diagram to your liking, click Save this layout. If you return to the relationship diagram for this app, it will display as you have saved it. If you don't like the layout, click Clear saved layout and refresh the page. Read more here: http://www.quickbase.com/user-assistance/Default.html#relationship_diagram.html
A COMPARISON OF DATA MODELING TECHNIQUES (search for "crow" within document)
I have two conclusions:
1) use crow's foot instead of an arrowhead to connect tables
2) use staircase lines not straight lines to connect tables
BTW, something is wrong with the forum - neither your hyerlink nor mine are clickable.
Entity Relationship Diagrams in Quickbase?https://quickbase-community.intuit.com/questions/58087-entity-relationship-diagrams-in-quickbase
Final ER diagramhttp://i.imgur.com/wXmuR.jpg
This is the script that did the generation of the graphviz file:
Graphviz Generation Scripthttp://pastie.org/2424130
I have not looked at this in over four years but I think that script is general purpose so it could be used on any QuickBase application.
Update: Compare the above ER diagram with what the QuickBzase a=?reldiagram produces
A little trick I do is you can put a web page widget of your relationship diagram page right on your Admin dashboard. When I'm actively working on an app I cheat and do that so I don't have to go back to it. You can also put a button to it on your dashboard as an alternative to save you a few clicks.