need Zotero database schema

sirin · May 2, 2010

Hi all,
i am a college student and i study on Zotero as my graduation project. It will be an open source project but i have trouble understand database relational. i need immediately Zotero' database schema. Could you please help me?

dstillman · May 3, 2010

https://www.zotero.org/svn/extension/trunk/system.sql
https://www.zotero.org/svn/extension/trunk/userdata.sql
https://www.zotero.org/svn/extension/trunk/triggers.sql

ajlyon · May 3, 2010

In userdata.sql:

-- These shouldn't be used yet
CREATE TABLE customItemTypes ...

So tempting...

sirin · May 3, 2010

so thanks but i am sorry. i didn't write, i am working with sqlite. i need see the entry-relation diagram as an image.

ajlyon · May 3, 2010

Well, you should look around for Sqlite browsers that can create such a diagram, and use them to look at your Zotero database; you might try the advice at http://stackoverflow.com/questions/989112/ .

I highly doubt that the Zotero team has made such a diagram for internal use-- the data model isn't terribly complex and it's pretty self-evident from the SQL that Dan provided.

sirin · May 3, 2010

the link provided a helpful tool. thanks for your attention.