Schema
RT 4
No documentation is currently available. See http://lists.fsck.com/pipermail/rt-users/2011-May/070484.html
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'.
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).