Child pages
  • Zotero data model

This space has moved to IU's Confluence.
It is located at https://uisapp2.iu.edu/confluence-prd/display/iulDLFAquifer/

Skip to end of metadata
Go to start of metadata

Zotero data model

Overview

* Each item in Zotero has an itemType (e.g., document, letter, manuscript, artwork).
* Each itemType has certain fields (e.g., title, abstractNote, language).
** Some fields (e.g., title, abstractNote) appear in most itemTypes.
** Other fields appear in only a few itemTypes: for example "interviewMedium" only appears in an interview.
* Item types and fields are defined in [system.sql|https://www.zotero.org/trac/browser/extension/trunk/system.sql]
* The U.S. English labels of itemTypes and fields are in [zotero.properties|https://www.zotero.org/trac/browser/extension/trunk/chrome/locale/en-US/zotero/zotero.properties]
* In the Zotero UI, most fields are in the "Info" tab. 
** Each of the fields in the "Info" tab can only have one value with the exception of creator, which is repeatable.
*** *creator* is also customizable in ways that other fields in the"Info" tab are not:
**** can choose a different field label (a.k.a creatorType) (e.g., artist, composer, author)
**** can display name as two fields or one
** The following fields are system-generated (not editable): *dateAdded, *dateModified*
*** *source* is atypical but I'm not sure exactly how
* The other tabs (i.e., not "Info") contain repeatable fields:
** *notes*
** *attachments*
** *tags*
** *related*
** These (as well as creator) are defined in [userdata.sql|https://www.zotero.org/trac/browser/extension/trunk/userdata.sql], not in system.sql

itemTypes Table

|| itemTypeID || typeName ||
| 12 | artwork |
| 14 | attachment |
| 26 | audioRecording |
| 16 | bill |
| 23 | blogPost |
| 2 | book |
| 3 | bookSection |
| 17 | case |
| 32 | computerProgram |
| 33 | conferencePaper |
| 36 | dictionaryEntry |
| 34 | document |
| 21 | email |
| 35 | encyclopediaArticle |
| 11 | film |
| 24 | forumPost |
| 18 | hearing |
| 25 | instantMessage |
| 10 | interview |
| 4 | journalArticle |
| 8 | letter |
| 5 | magazineArticle |
| 9 | manuscript |
| 22 | map |
| 6 | newspaperArticle |
| 1 | note |
| 19 | patent |
| 31 | podcast |
| 27 | presentation |
| 30 | radioBroadcast |
| 15 | report |
| 20 | statute |
| 7 | thesis |
| 29 | tvBroadcast |
| 28 | videoRecording |
| 13 | webpage |

fields Table

* For fields in the "Info" tab
* These can only hold one value.

|| fieldID || fieldName || Comments ||
| 90 | abstractNote | |
| 27 | accessDate | |
| 103 | applicationNumber | |
| 19 | archiveLocation | |
| 59 | artworkMedium | |
| 61 | artworkSize | |
| 48 | assignee | |
| 80 | audioFileType | |
| 71 | audioRecordingType | |
| 93 | billNumber | |
| 107 | blogTitle | |
| 115 | bookTitle | |
| 18 | callNumber | |
| 111 | caseName | |
| 36 | code | |
| 55 | codeNumber | |
| 95 | codePages | |
| 94 | codeVolume | |
| 46 | committee | |
| 83 | company | |
| 84 | conferenceName | |
| 102 | country | |
| 44 | court | |
| 14 | date | |
| | dateAdded | system-generated |
| 96 | dateDecided | |
| 100 | dateEnacted | |
| | dateModified | system-generated |
| 86 | dictionaryTitle | |
| 21 | distributor | |
| 99 | documentNumber | |
| 26 | DOI | |
| 6 | edition | |
| 85 | encyclopediaTitle | |
| 105 | episodeNumber | |
| 22 | extra | |
| 98 | firstPage | |
| 104 | forumTitle | |
| 42 | history | |
| 31 | institution | |
| 64 | interviewMedium | |
| 11 | ISBN | |
| 13 | ISSN | |
| 5 | issue | |
| 52 | issueDate | |
| | itemType | constrained values in a pull-down menu; governs which fields display |
| 25 | journalAbbreviation | |
| 72 | label | |
| 87 | language | |
| 54 | legalStatus | |
| 41 | legislativeBody | |
| 65 | letterType | |
| 66 | manuscriptType | |
| 67 | mapType | |
| 75 | meetingName | |
| 112 | nameOfAct | |
| 78 | network | |
| 60 | number | |
| 45 | numberOfVolumes | |
| 10 | pages | |
| 50 | patentNumber | |
| 7 | place | |
| 79 | postType | |
| 74 | presentationType | |
| 51 | priorityNumbers | |
| 114 | proceedingsTitle | |
| 88 | programmingLanguage | |
| 12 | publicationTitle | |
| 101 | publicLawNumber | |
| 8 | publisher | |
| 53 | references | |
| 43 | reporter | |
| 97 | reporterVolume | |
| 92 | reportNumber | |
| 32 | reportType | |
| 62 | repository | |
| 2 | rights | |
| 77 | runningTime | |
| 68 | scale | |
| 15 | section | |
| 3 | series | |
| 30 | seriesNumber | |
| 29 | seriesText | |
| 28 | seriesTitle | |
| 40 | session | |
| 116 | shortTitle | |
| | source | lookup from translator (and labeled as "Repository")? or comes from /mods/recordInfo/recordContentSource? |
| 76 | studio | |
| 113 | subject | |
| 82 | system | |
| 69 | thesisType | |
| 110 | title | |
| 89 | university | |
| 1 | url | |
| 81 | version | |
| 63 | videoRecordingType | |
| 4 | volume | |
| 91 | websiteTitle | |
| 70 | websiteType | |

creatorTypes Table

|| creatorTypeID || creatorType ||
| 22 | artist |
| 15 | attorneyAgent |
| 1 | author |
| 20 | cartographer |
| 11 | castMember |
| 23 | commenter |
| 18 | composer |
| 2 | contributor |
| 13 | counsel |
| 8 | director |
| 3 | editor |
| 25 | guest |
| 6 | interviewee |
| 7 | interviewer |
| 14 | inventor |
| 17 | performer |
| 26 | podcaster |
| 24 | presenter |
| 10 | producer |
| 21 | programmer |
| 16 | recipient |
| 27 | reviewedAuthor |
| 9 | scriptwriter |
| 5 | seriesEditor |
| 12 | sponsor |
| 4 | translator |
| 19 | wordsBy |

  • No labels