Where are Zotero SQLite DB parent-child relationships stored?

mtillman
I am trying to write a Python package that reads Zotero's database on my local computer. I was looking through the tables in ~/Zotero/zotero.sqlite and am unable to figure out how the parent-child relationships of research items & their attachments are stored.

Any insight as to which tables I should be looking at would be much appreciated. Thank you!
  • dstillman
    (Better to post questions like to zotero-dev. We try to keep technical discussions there.)

    parentItemID in itemAttachments, itemNotes, and itemAnnotations
  • tim820
    You ideally want a (free) sqlite-compatible tool that shows a visible map of the parent-child links. I recall looking at several a few years back to get some of that information, but I only needed them briefly and no longer use them. I recall one was Model Xtractor. I use DB Browser for SQLite for just looking at various tables. The Zotero database is complex. Only work on a copy of your database.

  • adamsmith
    The Zotero database is complex. Only work on a copy of your database.
    People should really not do anything other than repair/vacuum the sqlite (errors might not be immediately obvious), but
    this sounds like it's going to be a read tool, which shouldn't pose any risks
Sign In or Register to comment.