The comprehensive way of learning about Zotero's database structures is by digging into the .sql files. Here is, however, some automatically generated database documentation (created by SchemaSpy):

• for the current trunk
• for the multilingual branch