Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
dev:client_coding:direct_sqlite_database_access [2012/10/09 17:27] – dstillman | dev:client_coding:direct_sqlite_database_access [2017/12/18 09:02] – Move data model information into this page bwiernik | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | < | ||
+ | in the process of updating the documentation for | ||
+ | <a href=" | ||
+ | may be outdated in the meantime. Thanks for your understanding.</ | ||
+ | |||
+ | |||
====== Direct Access to the Zotero SQLite Database ====== | ====== Direct Access to the Zotero SQLite Database ====== | ||
Line 8: | Line 14: | ||
Also be aware that the SQLite database structure can change between Zotero releases. | Also be aware that the SQLite database structure can change between Zotero releases. | ||
+ | |||
+ | ====== Zotero Client Data Model ====== | ||
+ | |||
+ | Each bibliographic record in Zotero has an "item type" (book, journal article, thesis...), a set of fields (author, title, date...), and field values. The selection of fields depends on the item; for instance, a thesis has a " | ||
+ | |||
+ | Item types and fields are defined in [[https:// | ||
+ | |||
+ | In addition to the basic item types and fields, each item can have associated user data as defined in [[https:// | ||
+ | * a set of notes | ||
+ | * a set of attachments | ||
+ | * a set of tags | ||
+ | * a set of links to related items | ||
+ | |||
+ | Attachments (PDFs, snapshots, etc.) are stored inside the [[: | ||
+ | |||
+ | For a comprehensive list of the internal names of fields, their English equivalents, | ||
+ | |||
+ | ===== Schema Spy ===== | ||
+ | |||
+ | The comprehensive way of learning about Zotero' | ||
+ | |||
+ | * for the [[http:// | ||
+ | * for the [[http:// |