Understanding schema of RT

Good morning,

As a consequence of my current work, I have to learn the schema of the RT
database. My current version is 3.8.1, but on my explanation I am going to
use the version 3.4 (http://bestpractical.com/rt/3.4-schema.png).

I want to understand a relation using the “Any RT::Record” virtual table
perfectly. For example: using the “Transactions” table. I’m going to do my
explanation, and please you correct me if I do wrong.

My explanation:

  • ONE ObjectID of “Transactions” has MANY id in “Any RT::Record” virtual
  • ONE Creator of “Any RT::Record” has MANY id in “Principals” table.
  • Therefore, ONE Creator of “Transactions” has MANY id in “Principals” table.

Before I show several queries I have test, I would like to know if my
explanation is correct.

Thanks a lot!
Best regards,


ALTRAN: talento generando innovaci�n

ParqueEmpresarial Las Mercedes, Edificio 1
C/ Campezo, 1. 28022 Madrid
Tel : + 34 91 744 46 00
Fax: + 34 91 415 24 57