http://syndie-project.i2p/db.html
The database schema itself is kept as part of the Syndie source code as src/syndie/db/ddl.txt , and is documented therein. Basically, it has
tables to contain individual channels, messages within those channels, the content
stored in those messages (including attachments and references), individual local
nyms, their keys, and their preferences.