..\\db\\trunk\\zotero.sqlite.zotero contains 226 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:16:19
collections	collectionID	integer	11,10	√		null
collections	collectionName	varchar	65536,10
collections	dateAdded	timestamp	30,10			2010-10-21 17:16:19
collections	dateModified	timestamp	30,10			2010-10-21 17:16:19
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:16:19
creators	creatorDataID	integer	11,10
creators	creatorID	integer	11,10	√		null
creators	dateAdded	timestamp	30,10			2010-10-21 17:16:19
creators	dateModified	timestamp	30,10			2010-10-21 17:16:19
creators	key	varchar	65536,10
creators	libraryID	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:16:19
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
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
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:16:19
items	dateAdded	timestamp	30,10			2010-10-21 17:16:19
items	dateModified	timestamp	30,10			2010-10-21 17:16:19
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
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:16:19
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:16:19
savedSearches	dateAdded	timestamp	30,10			2010-10-21 17:16:19
savedSearches	dateModified	timestamp	30,10			2010-10-21 17:16:19
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:16:19
tags	dateAdded	timestamp	30,10			2010-10-21 17:16:19
tags	dateModified	timestamp	30,10			2010-10-21 17:16:19
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
users	userID	integer	11,10	√		null
users	username	varchar	65536,10
version	schema	varchar	65536,10	√		null
version	version	integer	11,10
zoteroDummyTable	id	integer	11,10	√		null