Table Description for the DB under Testlink 1.8

[vinzsanity]

Hi Folks,

just wanna start some special queries on the mysql database under Testlink 1.8!
So i have already found the DB schema.. but im really missing some informations.
Could someone tell me where i can found the description of the tables?
I mean if i just take a table like "Executions" and the column exections.STATUS:

you find there values like: p, f, r-... and so on
What the hell is p, f or r?
So im in need of the description of every field from the tables...

thanks

vinzy

[fman]

IMHO you are choosing a not so good solution direct access to DB, instead of trying to use XMLRPC API.
In this way you will be ready to change your work, when changes to DB will be done (thing that will be happen on 1.9)
Anyway if you want to use this approache, you will need to dig on existent code.
For definition of constans see const.inc.php