SchemaSpy Analysis of ..\\db\\trunk\\zotero.sqlite.zotero Generated by
SchemaSpy
Generated by SchemaSpy on jeu. oct. 21 19:16 CEST 2010
Database Type: SQLite - 2.8.17 SourceForge.net


XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table Children Parents Columns Rows Comments
annotations 1 12 0
baseFieldMappings 3 3 54
baseFieldMappingsCombined 3 54
charsets 2 168
collectionItems 2 3 0
collections 1 8 0
creatorData 6 18
creators 1 7 18
creatorTypes 2 29
customBaseFieldMappings 2 3 0
customFields 3 0
customItemTypeFields 3 5 0
customItemTypes 5 0
deletedItems 2 16
fieldFormats 3 3
fields 1 3 104
fieldsCombined 5 104
fileTypeMimeTypes 1 2 30
fileTypes 2 7
fulltextItems 1 6 1
fulltextItemWords 2 2 180
fulltextWords 2 180
groupItems 2 3 0
groups 1 6 0
highlights 1 9 0
itemAttachments 2 10 1
itemCreators 3 4 18
itemData 3 3 156
itemDataValues 2 73
itemNotes 2 4 29
items 1 7 46
itemSeeAlso 2 2 0
itemTags 2 2 4
itemTypeCreatorTypes 2 3 123
itemTypeFields 2 4 582
itemTypeFieldsCombined 4 582
itemTypes 4 36
itemTypesCombined 4 36
libraries 2 0
proxies 4 0
proxyHosts 1 3 0
relations 5 0
savedSearchConditions 1 6 0
savedSearches 7 0
settings 3 0
storageDeleteLog 3 0
syncDeleteLog 1 4 0
syncObjectTypes 2 6
tags 8 3
transactionLog 1 3 0
transactions 4 0
transactionSets 3 0
translatorCache 4 306
users 2 0
version 2 8
zoteroDummyTable 1 1
           
56 Tables     226 2 976  
0 Views     0