Hello,
(sorry for my bad english)
I want to development a java based tool to analyze the results of various limesurvey-surveys, export them into various formats and calculate different measures etc.
Therefore I want to readout the corresponding database tables and parse them into my java datastructure...
Unfortunately I experience problems - the structure of surveys lokks a little bit tricky (e.g. what do the type-characters of questions mean?). Why is an answer sometimes a row in a question-table and so on... Where can I find a documentation for the database structure and its behaviour?
Thanks a lot.

If you just need the survey results a simple "SELECT * FROM lime_survey_12345" (12345 = surveyID) should do the trick.

Also have a look at the createfieldmap() function.

this was helpful, however, I have one question to add to this. (Sorry for bringing up an old thread, by the way).

When you "SELECT * FROM lime_survey_12345" the results look like they tie back to the 'Code' field in the answers table. I'm not very good with linking tables, so how would I link the survey responses to the appropriate answers so show the answer that was selected rather than the code of the answer selected.