SchemaSpy - ..\\db\\multilingual\\zotero.sqlite.zotero

Generated by
SchemaSpy

Generated by SchemaSpy on jeu. oct. 21 19:15 CEST 2010
Database Type: SQLite - 2.8.17
XML Representation Insertion Order Deletion Order (for database loading/purging scripts)

Comments

Table	Parents	Columns	Rows
annotations	1	12	0
baseFieldMappings	3	3	54
baseFieldMappingsCombined		3	54
charsets		2	168
collectionItems	2	3	148
collections	1	8	1
creatorData		6	161
creators	1	7	161
creatorsMulti	2	3	0
creatorTypes		2	29
customBaseFieldMappings	2	3	0
customFields		3	0
customItemTypeFields	3	5	0
customItemTypes		5	0
deletedItems		2	0
fieldFormats		3	3
fields	1	3	104
fieldsCombined		5	104
fieldsMulti		4	0
fileTypeMimeTypes	1	2	30
fileTypes		2	7
fulltextItems	1	6	0
fulltextItemWords	2	2	0
fulltextWords		2	0
groupItems	2	3	0
groups	1	6	0
highlights	1	9	0
isoTagMap		2	204
itemAttachments	2	10	0
itemCreators	3	4	186
itemData	3	3	1 325
itemDataValues		2	838
itemNotes	2	4	222
items	1	7	380
itemSeeAlso	2	2	0
itemTags	2	2	196
itemTypeCreatorTypes	2	3	123
itemTypeFields	2	4	582
itemTypeFieldsCombined		4	582
itemTypes		4	36
itemTypesCombined		4	36
languageTagData		2	0
libraries		2	0
proxies		4	0
proxyHosts	1	3	0
relations		5	0
savedSearchConditions	1	6	0
savedSearches		7	0
settings		3	1
storageDeleteLog		3	0
syncDeleteLog	1	4	955
syncObjectTypes		2	6
tags		8	164
transactionLog	1	3	0
transactions		4	0
transactionSets		3	0
translatorCache		4	307
unicodeScriptMap		3	197
users		2	0
version		2	9
zlsPreferences		3	0
zlsSubtagData		2	16 919
zlsSubtags		13	8 673
zlsTags		3	17
zoteroDummyTable		1	1

65 Tables		261	32 983
0 Views		0