is database schema info available for TL 1.8?

[monogeo]

I am new to TL and have TL 1.8 RC4 installed. I created one test case in a test suite. Go to testlink database, I can see these tables below, but don't see a table for storing testcases info. Just wonder how testcase gets stored and how the testcase id gets generated automatically? Is the testcase id always in this format: <prefix>-<number> ?

Tables_in_testlink
assignment_status
assignment_types
attachments
builds
cfield_design_values
cfield_execution_values
cfield_node_types
cfield_testplan_design_values
cfield_testprojects
custom_fields
db_version
events
execution_bugs
executions
keywords
milestones
node_types
nodes_hierarchy
object_keywords
req_coverage
req_specs
requirements
rights
risk_assignments
role_rights
roles
tcversions
testcase_keywords
testplan_tcversions
testplans
testprojects
testsuites
text_templates
transactions
user_assignments
user_group
user_group_assign
user_testplan_roles
user_testproject_roles
users

Thanks

[monogeo]

ok, I found it. It is in:

SELECT * FROM tcversions t;

[hboeken]

Still there is the question if there is a specification of the database available.
If I am correct the testlink database doesn't use foreign keys and it's quite difficult to understand the relations between all the tables.

[edias]

it would be nice to have some schema document available... i'm sure someone must that the information!