Difference between revisions of "Schema"

From Request Tracker Wiki
Jump to navigation Jump to search
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
==RT 4==
==RT 4==
No documentation is currently available. See http://lists.fsck.com/pipermail/rt-users/2011-May/070484.html
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 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

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).