need Zotero database schema

sirin

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

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

In userdata.sql:
-- These shouldn't be used yet
CREATE TABLE customItemTypes ...
So tempting...

sirin

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

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

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