Database PHPMyAdmin relationships?

[matti_hofmans]

Hello you all,

We are trying to add a functionality in Testlink. But we need to see the relationships between all the schemes in the database. But in phpMyAdmin, there are no relationships at all. Is this normal or not? Are there simply no relationships in the database or I just can't see them?

Thanks in advance

[fman]

1) have you give a look to sql scripts used to create the TL database?
2) have you searched forum for topics about Database schema ?

[matti_hofmans]

Hello again,

I did find the Database schema but I can't seems to understand how does the testcase work inside the DB.
there is the testcase name in the node_hierarchy,
there is the summary of this testcase inside tcversion,
and there is the steps of this testcase inside tcsteps

but i don't see how they are linked to one and the other :/

Can you maybe explain me better this part ?

Thanks a lot

[fman]

Here http://mantis.testlink.org/view.php?id=6357

surely there, there is not all info, but if you do a fresh install and create just ONE test project, ONE test suite, ONE TEST CASE with just ONE VERSION and ONE STEP, and do
some queries you will understand everything
Also reading code of testcase.class.php will help

99% of entities are present on nodes_hierarchy
nodes_hierarchies mantains parent / child relationship

there is no testcase table, only tcversions. Only test case attribute is name present on nodes_hierarchy
tcsteps are child of tcversions.
testcase is child of testsuite

IMHO is enough as starting point, now the ball is on your court.