SchemaSpy Analysis of ..\\db\\multilingual\\zotero.sqlite.zotero - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on jeu. oct. 21 19:15 CEST 2010 |
| ||||||
|
..\\db\\multilingual\\zotero.sqlite.zotero contains 261 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
annotations | annotationID | integer | 11,10 | √ | null | ||
annotations | collapsed | varchar | 65536,10 | √ | null | ||
annotations | cols | integer | 11,10 | √ | null | ||
annotations | dateModified | date | 10,10 | √ | null | ||
annotations | itemID | integer | 11,10 | √ | null | ||
annotations | offset | integer | 11,10 | √ | null | ||
annotations | parent | varchar | 65536,10 | √ | null | ||
annotations | rows | integer | 11,10 | √ | null | ||
annotations | text | varchar | 65536,10 | √ | null | ||
annotations | textNode | integer | 11,10 | √ | null | ||
annotations | x | integer | 11,10 | √ | null | ||
annotations | y | integer | 11,10 | √ | null | ||
baseFieldMappings | baseFieldID | integer | 11,10 | √ | null | ||
baseFieldMappings | fieldID | integer | 11,10 | √ | null | ||
baseFieldMappings | itemTypeID | integer | 11,10 | √ | null | ||
baseFieldMappingsCombined | baseFieldID | integer | 11,10 | √ | null | ||
baseFieldMappingsCombined | fieldID | integer | 11,10 | √ | null | ||
baseFieldMappingsCombined | itemTypeID | integer | 11,10 | √ | null | ||
charsets | charset | varchar | 65536,10 | √ | null | ||
charsets | charsetID | integer | 11,10 | √ | null | ||
collectionItems | collectionID | integer | 11,10 | √ | null | ||
collectionItems | itemID | integer | 11,10 | √ | null | ||
collectionItems | orderIndex | integer | 11,10 | √ | 0 | ||
collections | clientDateModified | timestamp | 30,10 | 2010-10-21 17:15:58 | |||
collections | collectionID | integer | 11,10 | √ | null | ||
collections | collectionName | varchar | 65536,10 | ||||
collections | dateAdded | timestamp | 30,10 | 2010-10-21 17:15:58 | |||
collections | dateModified | timestamp | 30,10 | 2010-10-21 17:15:58 | |||
collections | key | varchar | 65536,10 | ||||
collections | libraryID | integer | 11,10 | √ | null | ||
collections | parentCollectionID | integer | 11,10 | √ | null | ||
creatorData | birthYear | integer | 11,10 | √ | null | ||
creatorData | creatorDataID | integer | 11,10 | √ | null | ||
creatorData | fieldMode | integer | 11,10 | √ | null | ||
creatorData | firstName | varchar | 65536,10 | √ | null | ||
creatorData | lastName | varchar | 65536,10 | √ | null | ||
creatorData | shortName | varchar | 65536,10 | √ | null | ||
creators | clientDateModified | timestamp | 30,10 | 2010-10-21 17:15:58 | |||
creators | creatorDataID | integer | 11,10 | ||||
creators | creatorID | integer | 11,10 | √ | null | ||
creators | dateAdded | timestamp | 30,10 | 2010-10-21 17:15:58 | |||
creators | dateModified | timestamp | 30,10 | 2010-10-21 17:15:58 | |||
creators | key | varchar | 65536,10 | ||||
creators | libraryID | integer | 11,10 | √ | null | ||
creatorsMulti | creatorDataID | integer | 11,10 | √ | null | ||
creatorsMulti | creatorID | integer | 11,10 | √ | null | ||
creatorsMulti | languageTagID | integer | 11,10 | √ | null | ||
creatorTypes | creatorType | varchar | 65536,10 | √ | null | ||
creatorTypes | creatorTypeID | integer | 11,10 | √ | null | ||
customBaseFieldMappings | baseFieldID | integer | 11,10 | √ | null | ||
customBaseFieldMappings | customFieldID | integer | 11,10 | √ | null | ||
customBaseFieldMappings | customItemTypeID | integer | 11,10 | √ | null | ||
customFields | customFieldID | integer | 11,10 | √ | null | ||
customFields | fieldName | varchar | 65536,10 | √ | null | ||
customFields | label | varchar | 65536,10 | √ | null | ||
customItemTypeFields | customFieldID | integer | 11,10 | √ | null | ||
customItemTypeFields | customItemTypeID | integer | 11,10 | ||||
customItemTypeFields | fieldID | integer | 11,10 | √ | null | ||
customItemTypeFields | hide | integer | 11,10 | ||||
customItemTypeFields | orderIndex | integer | 11,10 | ||||
customItemTypes | customItemTypeID | integer | 11,10 | √ | null | ||
customItemTypes | display | integer | 11,10 | √ | 1 | ||
customItemTypes | icon | varchar | 65536,10 | √ | null | ||
customItemTypes | label | varchar | 65536,10 | √ | null | ||
customItemTypes | typeName | varchar | 65536,10 | √ | null | ||
deletedItems | dateDeleted | varchar | 65536,10 | 2010-10-21 17:15:58 | |||
deletedItems | itemID | integer | 11,10 | √ | null | ||
fieldFormats | fieldFormatID | integer | 11,10 | √ | null | ||
fieldFormats | isInteger | integer | 11,10 | √ | null | ||
fieldFormats | regex | varchar | 65536,10 | √ | null | ||
fields | fieldFormatID | integer | 11,10 | √ | null | ||
fields | fieldID | integer | 11,10 | √ | null | ||
fields | fieldName | varchar | 65536,10 | √ | null | ||
fieldsCombined | custom | integer | 11,10 | ||||
fieldsCombined | fieldFormatID | integer | 11,10 | √ | null | ||
fieldsCombined | fieldID | integer | 11,10 | ||||
fieldsCombined | fieldName | varchar | 65536,10 | ||||
fieldsCombined | label | varchar | 65536,10 | √ | null | ||
fieldsMulti | fieldID | integer | 11,10 | √ | null | ||
fieldsMulti | itemID | integer | 11,10 | √ | null | ||
fieldsMulti | languageTagID | integer | 11,10 | √ | null | ||
fieldsMulti | valueID | integer | 11,10 | √ | null | ||
fileTypeMimeTypes | fileTypeID | integer | 11,10 | √ | null | ||
fileTypeMimeTypes | mimeType | varchar | 65536,10 | √ | null | ||
fileTypes | fileType | varchar | 65536,10 | √ | null | ||
fileTypes | fileTypeID | integer | 11,10 | √ | null | ||
fulltextItems | indexedChars | integer | 11,10 | √ | null | ||
fulltextItems | indexedPages | integer | 11,10 | √ | null | ||
fulltextItems | itemID | integer | 11,10 | √ | null | ||
fulltextItems | totalChars | integer | 11,10 | √ | null | ||
fulltextItems | totalPages | integer | 11,10 | √ | null | ||
fulltextItems | version | integer | 11,10 | √ | null | ||
fulltextItemWords | itemID | integer | 11,10 | √ | null | ||
fulltextItemWords | wordID | integer | 11,10 | √ | null | ||
fulltextWords | word | varchar | 65536,10 | √ | null | ||
fulltextWords | wordID | integer | 11,10 | √ | null | ||
groupItems | createdByUserID | integer | 11,10 | ||||
groupItems | itemID | integer | 11,10 | √ | null | ||
groupItems | lastModifiedByUserID | integer | 11,10 | ||||
groups | description | varchar | 65536,10 | ||||
groups | editable | integer | 11,10 | ||||
groups | filesEditable | integer | 11,10 | ||||
groups | groupID | integer | 11,10 | √ | null | ||
groups | libraryID | integer | 11,10 | ||||
groups | name | varchar | 65536,10 | ||||
highlights | dateModified | date | 10,10 | √ | null | ||
highlights | endOffset | integer | 11,10 | √ | null | ||
highlights | endParent | varchar | 65536,10 | √ | null | ||
highlights | endTextNode | integer | 11,10 | √ | null | ||
highlights | highlightID | integer | 11,10 | √ | null | ||
highlights | itemID | integer | 11,10 | √ | null | ||
highlights | startOffset | integer | 11,10 | √ | null | ||
highlights | startParent | varchar | 65536,10 | √ | null | ||
highlights | startTextNode | integer | 11,10 | √ | null | ||
isoTagMap | iana | varchar | 65536,10 | √ | null | ||
isoTagMap | iso | varchar | 65536,10 | √ | null | ||
itemAttachments | charsetID | integer | 11,10 | √ | null | ||
itemAttachments | itemID | integer | 11,10 | √ | null | ||
itemAttachments | linkMode | integer | 11,10 | √ | null | ||
itemAttachments | mimeType | varchar | 65536,10 | √ | null | ||
itemAttachments | originalPath | varchar | 65536,10 | √ | null | ||
itemAttachments | path | varchar | 65536,10 | √ | null | ||
itemAttachments | sourceItemID | integer | 11,10 | √ | null | ||
itemAttachments | storageHash | varchar | 65536,10 | √ | null | ||
itemAttachments | storageModTime | integer | 11,10 | √ | null | ||
itemAttachments | syncState | integer | 11,10 | √ | 0 | ||
itemCreators | creatorID | integer | 11,10 | √ | null | ||
itemCreators | creatorTypeID | integer | 11,10 | √ | 1 | ||
itemCreators | itemID | integer | 11,10 | √ | null | ||
itemCreators | orderIndex | integer | 11,10 | √ | 0 | ||
itemData | fieldID | integer | 11,10 | √ | null | ||
itemData | itemID | integer | 11,10 | √ | null | ||
itemData | valueID | varchar | 65536,10 | √ | null | ||
itemDataValues | value | varchar | 65536,10 | √ | null | ||
itemDataValues | valueID | integer | 11,10 | √ | null | ||
itemNotes | itemID | integer | 11,10 | √ | null | ||
itemNotes | note | varchar | 65536,10 | √ | null | ||
itemNotes | sourceItemID | integer | 11,10 | √ | null | ||
itemNotes | title | varchar | 65536,10 | √ | null | ||
items | clientDateModified | timestamp | 30,10 | 2010-10-21 17:15:58 | |||
items | dateAdded | timestamp | 30,10 | 2010-10-21 17:15:58 | |||
items | dateModified | timestamp | 30,10 | 2010-10-21 17:15:58 | |||
items | itemID | integer | 11,10 | √ | null | ||
items | itemTypeID | integer | 11,10 | ||||
items | key | varchar | 65536,10 | ||||
items | libraryID | integer | 11,10 | √ | null | ||
itemSeeAlso | itemID | integer | 11,10 | √ | null | ||
itemSeeAlso | linkedItemID | integer | 11,10 | √ | null | ||
itemTags | itemID | integer | 11,10 | √ | null | ||
itemTags | tagID | integer | 11,10 | √ | null | ||
itemTypeCreatorTypes | creatorTypeID | integer | 11,10 | √ | null | ||
itemTypeCreatorTypes | itemTypeID | integer | 11,10 | √ | null | ||
itemTypeCreatorTypes | primaryField | integer | 11,10 | √ | null | ||
itemTypeFields | fieldID | integer | 11,10 | √ | null | ||
itemTypeFields | hide | integer | 11,10 | √ | null | ||
itemTypeFields | itemTypeID | integer | 11,10 | √ | null | ||
itemTypeFields | orderIndex | integer | 11,10 | √ | null | ||
itemTypeFieldsCombined | fieldID | integer | 11,10 | ||||
itemTypeFieldsCombined | hide | integer | 11,10 | √ | null | ||
itemTypeFieldsCombined | itemTypeID | integer | 11,10 | ||||
itemTypeFieldsCombined | orderIndex | integer | 11,10 | ||||
itemTypes | display | integer | 11,10 | √ | 1 | ||
itemTypes | itemTypeID | integer | 11,10 | √ | null | ||
itemTypes | templateItemTypeID | integer | 11,10 | √ | null | ||
itemTypes | typeName | varchar | 65536,10 | √ | null | ||
itemTypesCombined | custom | integer | 11,10 | ||||
itemTypesCombined | display | integer | 11,10 | 1 | |||
itemTypesCombined | itemTypeID | integer | 11,10 | ||||
itemTypesCombined | typeName | varchar | 65536,10 | ||||
languageTagData | languageTag | varchar | 65536,10 | ||||
languageTagData | languageTagID | integer | 11,10 | √ | null | ||
libraries | libraryID | integer | 11,10 | √ | null | ||
libraries | libraryType | varchar | 65536,10 | ||||
proxies | autoAssociate | integer | 11,10 | √ | null | ||
proxies | multiHost | integer | 11,10 | √ | null | ||
proxies | proxyID | integer | 11,10 | √ | null | ||
proxies | scheme | varchar | 65536,10 | √ | null | ||
proxyHosts | hostID | integer | 11,10 | √ | null | ||
proxyHosts | hostname | varchar | 65536,10 | √ | null | ||
proxyHosts | proxyID | integer | 11,10 | √ | null | ||
relations | clientDateModified | timestamp | 30,10 | 2010-10-21 17:15:58 | |||
relations | libraryID | integer | 11,10 | ||||
relations | object | varchar | 65536,10 | ||||
relations | predicate | varchar | 65536,10 | ||||
relations | subject | varchar | 65536,10 | ||||
savedSearchConditions | condition | varchar | 65536,10 | √ | null | ||
savedSearchConditions | operator | varchar | 65536,10 | √ | null | ||
savedSearchConditions | required | varchar | 65536,10 | √ | null | ||
savedSearchConditions | savedSearchID | integer | 11,10 | √ | null | ||
savedSearchConditions | searchConditionID | integer | 11,10 | √ | null | ||
savedSearchConditions | value | varchar | 65536,10 | √ | null | ||
savedSearches | clientDateModified | timestamp | 30,10 | 2010-10-21 17:15:58 | |||
savedSearches | dateAdded | timestamp | 30,10 | 2010-10-21 17:15:58 | |||
savedSearches | dateModified | timestamp | 30,10 | 2010-10-21 17:15:58 | |||
savedSearches | key | varchar | 65536,10 | ||||
savedSearches | libraryID | integer | 11,10 | √ | null | ||
savedSearches | savedSearchID | integer | 11,10 | √ | null | ||
savedSearches | savedSearchName | varchar | 65536,10 | ||||
settings | key | varchar | 65536,10 | √ | null | ||
settings | setting | varchar | 65536,10 | √ | null | ||
settings | value | varchar | 65536,10 | √ | null | ||
storageDeleteLog | key | varchar | 65536,10 | ||||
storageDeleteLog | libraryID | integer | 11,10 | √ | null | ||
storageDeleteLog | timestamp | integer | 11,10 | ||||
syncDeleteLog | key | varchar | 65536,10 | ||||
syncDeleteLog | libraryID | integer | 11,10 | ||||
syncDeleteLog | syncObjectTypeID | integer | 11,10 | ||||
syncDeleteLog | timestamp | integer | 11,10 | ||||
syncObjectTypes | name | varchar | 65536,10 | √ | null | ||
syncObjectTypes | syncObjectTypeID | integer | 11,10 | √ | null | ||
tags | clientDateModified | timestamp | 30,10 | 2010-10-21 17:15:58 | |||
tags | dateAdded | timestamp | 30,10 | 2010-10-21 17:15:58 | |||
tags | dateModified | timestamp | 30,10 | 2010-10-21 17:15:58 | |||
tags | key | varchar | 65536,10 | ||||
tags | libraryID | integer | 11,10 | √ | null | ||
tags | name | varchar | 65536,10 | ||||
tags | tagID | integer | 11,10 | √ | null | ||
tags | type | integer | 11,10 | ||||
transactionLog | field | varchar | 65536,10 | √ | null | ||
transactionLog | transactionID | integer | 11,10 | √ | null | ||
transactionLog | value | varchar | 65536,10 | √ | null | ||
transactions | action | varchar | 65536,10 | √ | null | ||
transactions | context | varchar | 65536,10 | √ | null | ||
transactions | transactionID | integer | 11,10 | √ | null | ||
transactions | transactionSetID | integer | 11,10 | √ | null | ||
transactionSets | event | varchar | 65536,10 | √ | null | ||
transactionSets | id | integer | 11,10 | √ | null | ||
transactionSets | transactionSetID | integer | 11,10 | √ | null | ||
translatorCache | code | varchar | 65536,10 | √ | null | ||
translatorCache | lastModifiedTime | integer | 11,10 | √ | null | ||
translatorCache | leafName | varchar | 65536,10 | √ | null | ||
translatorCache | translatorJSON | varchar | 65536,10 | √ | null | ||
unicodeScriptMap | fromCode | integer | 11,10 | √ | null | ||
unicodeScriptMap | script | varchar | 65536,10 | √ | null | ||
unicodeScriptMap | toCode | integer | 11,10 | √ | null | ||
users | userID | integer | 11,10 | √ | null | ||
users | username | varchar | 65536,10 | ||||
version | schema | varchar | 65536,10 | √ | null | ||
version | version | integer | 11,10 | ||||
zlsPreferences | param | varchar | 65536,10 | ||||
zlsPreferences | profile | varchar | 65536,10 | ||||
zlsPreferences | tag | varchar | 65536,10 | ||||
zlsSubtagData | id | integer | 11,10 | √ | null | ||
zlsSubtagData | value | varchar | 65536,10 | √ | null | ||
zlsSubtags | added | integer | 11,10 | √ | null | ||
zlsSubtags | comment | integer | 11,10 | √ | null | ||
zlsSubtags | deprecated | integer | 11,10 | √ | null | ||
zlsSubtags | description | integer | 11,10 | √ | null | ||
zlsSubtags | macrolanguage | integer | 11,10 | √ | null | ||
zlsSubtags | preferredvalue | integer | 11,10 | √ | null | ||
zlsSubtags | prefix | integer | 11,10 | √ | null | ||
zlsSubtags | scope | integer | 11,10 | √ | null | ||
zlsSubtags | seq | integer | 11,10 | √ | null | ||
zlsSubtags | subtag | integer | 11,10 | √ | null | ||
zlsSubtags | suppressscript | integer | 11,10 | √ | null | ||
zlsSubtags | tag | integer | 11,10 | √ | null | ||
zlsSubtags | type | integer | 11,10 | √ | null | ||
zlsTags | nickname | varchar | 65536,10 | √ | null | ||
zlsTags | parent | varchar | 65536,10 | √ | null | ||
zlsTags | tag | varchar | 65536,10 | √ | null | ||
zoteroDummyTable | id | integer | 11,10 | √ | null |