Difference between revisions of "Schema"
(→RT 3.x) |
|||
(4 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
==RT 4== | ==RT 4== | ||
On the left is a quick export generated by dbVisualizer. This is just tables and columns; there are no enforced relational integrity constraints at the database levels. | |||
On the right is a diagram of the relationships between tables, generated from the schema.dot file which ships with RT 4 under the docs/ directory. | |||
<gallery captionalign="left"> | |||
rt_schema.svg|RT4 Schema | |||
Rt4-schema-relationships.svg|RT 4 schema relationships | |||
</gallery> | |||
==RT 3.x== | ==RT 3.x== | ||
Look at the file 'docs/rt-schema-relationships.dot', included in the RT 3.x distribution (download page: http://www.bestpractical.com/rt/download.html ). | Look at the file 'docs/rt-schema-relationships.dot', included in the RT 3.x distribution (download page: http://www.bestpractical.com/rt/download.html ). | ||
Or, browse http://svn.bestpractical.com/cgi-bin/index.cgi/bps/browse/rt/branches/ , choose the link to the relevant RT version, then click on the 'docs' link, then on 'rt3-schema-relationships.dot'. | Or, browse http://svn.bestpractical.com/cgi-bin/index.cgi/bps/browse/rt/branches/ , choose the link to the relevant RT version, then click on the 'docs' link, then on 'rt3-schema-relationships.dot'.py9;[9p-'u0['/uy9p | ||
== How to visualize 'dot' format == | == How to visualize 'dot' format == |
Revision as of 08:26, 20 August 2012
RT 4
On the left is a quick export generated by dbVisualizer. This is just tables and columns; there are no enforced relational integrity constraints at the database levels.
On the right is a diagram of the relationships between tables, generated from the schema.dot file which ships with RT 4 under the docs/ directory.
- Rt schema.svg
RT4 Schema
- Rt4-schema-relationships.svg
RT 4 schema relationships
RT 3.x
Look at the file 'docs/rt-schema-relationships.dot', included in the RT 3.x distribution (download page: http://www.bestpractical.com/rt/download.html ).
Or, browse http://svn.bestpractical.com/cgi-bin/index.cgi/bps/browse/rt/branches/ , choose the link to the relevant RT version, then click on the 'docs' link, then on 'rt3-schema-relationships.dot'.py9;[9p-'u0['/uy9p
How to visualize 'dot' format
- dbdesigner4, see http://www.fabforce.net/dbdesigner4/ (sooner or later will be MySQL Workbench. See: The FabForce Forum)
- graphviz, see http://www.research.att.com/sw/tools/graphviz/
Existing visualizations
(Warning: these may be out of date. You can always download dotty or other visualizer and apply it to your .dot file to see the latest).