Zotero's database schema (multilingual)
373 views
Skip to first unread message
ziche
Oct 21, 2010, 10:10:57 AM10/21/10
to zotero-dev
I have been trying to familiarize myself with Zotero's sqlite schema.
Hacking the SchemaSpy package (http://schemaspy.sourceforge.net/) to
get around some of the Sqlite oddities, I got some more or less usable
output:
http://github.com/zomark/zotero-marc/raw/master/schema/zotero-dbschema-trunk.zip
for the current trunk's schema,
http://github.com/zomark/zotero-marc/raw/master/schema/zotero-dbschema-multilingual.zip
for the multilingual branch.
This is a cross-reffed HTML documentation of Zotero's tables, columns
and relations. Still, I am not quite sure that I do not prefer looking
at system.sql...
Best, Florian
Hacking the SchemaSpy package (http://schemaspy.sourceforge.net/) to
get around some of the Sqlite oddities, I got some more or less usable
output:
http://github.com/zomark/zotero-marc/raw/master/schema/zotero-dbschema-trunk.zip
for the current trunk's schema,
http://github.com/zomark/zotero-marc/raw/master/schema/zotero-dbschema-multilingual.zip
for the multilingual branch.
This is a cross-reffed HTML documentation of Zotero's tables, columns
and relations. Still, I am not quite sure that I do not prefer looking
at system.sql...
Best, Florian
Bruce D'Arcus
Oct 21, 2010, 10:18:07 AM10/21/10
to zoter...@googlegroups.com
On Thu, Oct 21, 2010 at 10:10 AM, ziche <zi...@noos.fr> wrote:
> I have been trying to familiarize myself with Zotero's sqlite schema.
> Hacking the SchemaSpy package (http://schemaspy.sourceforge.net/) to
> get around some of the Sqlite oddities, I got some more or less usable
> output:
> http://github.com/zomark/zotero-marc/raw/master/schema/zotero-dbschema-trunk.zip
> for the current trunk's schema,
> http://github.com/zomark/zotero-marc/raw/master/schema/zotero-dbschema-multilingual.zip
> for the multilingual branch.
> I have been trying to familiarize myself with Zotero's sqlite schema.
> Hacking the SchemaSpy package (http://schemaspy.sourceforge.net/) to
> get around some of the Sqlite oddities, I got some more or less usable
> output:
> http://github.com/zomark/zotero-marc/raw/master/schema/zotero-dbschema-trunk.zip
> for the current trunk's schema,
> http://github.com/zomark/zotero-marc/raw/master/schema/zotero-dbschema-multilingual.zip
> for the multilingual branch.
Why zip archives, and not straight HTML?
Bruce
ziche
Oct 21, 2010, 11:49:22 AM10/21/10
to zotero-dev
SchemaSpy documentation gets kind of heavy because of the diagrams,
and I did not think github is the place for storing these data. If
people find this useful, we might just integrate it into the wiki.
On Oct 21, 4:18 pm, "Bruce D'Arcus" <bdar...@gmail.com> wrote:
> On Thu, Oct 21, 2010 at 10:10 AM, ziche <zi...@noos.fr> wrote:
> > I have been trying to familiarize myself with Zotero's sqlite schema.
> > Hacking the SchemaSpy package (http://schemaspy.sourceforge.net/) to
> > get around some of the Sqlite oddities, I got some more or less usable
> > output:
> >http://github.com/zomark/zotero-marc/raw/master/schema/zotero-dbschem...
and I did not think github is the place for storing these data. If
people find this useful, we might just integrate it into the wiki.
On Oct 21, 4:18 pm, "Bruce D'Arcus" <bdar...@gmail.com> wrote:
> On Thu, Oct 21, 2010 at 10:10 AM, ziche <zi...@noos.fr> wrote:
> > I have been trying to familiarize myself with Zotero's sqlite schema.
> > Hacking the SchemaSpy package (http://schemaspy.sourceforge.net/) to
> > get around some of the Sqlite oddities, I got some more or less usable
> > output:
> > for the current trunk's schema,
> >http://github.com/zomark/zotero-marc/raw/master/schema/zotero-dbschem...
ziche
Oct 22, 2010, 4:29:10 AM10/22/10
to zotero-dev
Reply all
Reply to author
Forward
0 new messages