TestLink

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

ok, I found it. It is in:

SELECT * FROM tcversions t;

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.

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