Need information about RT tables

Hi everybody!

I DO need description and information about tables in RT. For example, what
does “pbcattbl” table do, for what the field “pbt_owner” in that is used,
which modules are using which tables, what is connected to what and…

I have the model of RT tables right now. I just need documentation of
tables, please let me know if you know any place I can go and find them

Thanks.
Alex

Alex Decalli wrote:

Hi everybody!

I DO need description and information about tables in RT. For example,
what does “pbcattbl” table do, for what the field “pbt_owner” in that
is used, which modules are using which tables, what is connected to
what and…

That doesn’t look like that is an RT table. Have a look at the source of
RT, in the etc folder you’ll find the create table statements for the
different databases supported and their table names.

Joop

Thanks Joop… I actually need to know about table description, for
example, it is clear that the table “tickets” handles the tickets… but
some are not clear… So there is no documentation about it?? Is there any
way I can track these tables in the programs?On Wed, Aug 28, 2013 at 4:47 PM, Joop jvdwege@xs4all.nl wrote:

Alex Decalli wrote:

Hi everybody!

I DO need description and information about tables in RT. For example,
what does “pbcattbl” table do, for what the field “pbt_owner” in that is
used, which modules are using which tables, what is connected to what
and…

That doesn’t look like that is an RT table. Have a look at the source of
RT, in the etc folder you’ll find the create table statements for the
different databases supported and their table names.

Joop

Thanks Joop… I actually need to know about table description, for example, it is clear that the table “tickets” handles the tickets… but some are not clear… So there is no documentation about it?? Is there any way I can track these tables in the programs?

Like this you mean?
http://requesttracker.wikia.com/wiki/Schema

Depending on what you are trying to accomplish, I would also recommend you look at using the API to interface with RT, as the underlying schema may change between versions…