..\\db\\trunk\\zotero.sqlite.zotero contains 226 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
transactions	action	varchar	65536,10	√		null
annotations	annotationID	integer	11,10	√		null
proxies	autoAssociate	integer	11,10	√		null
baseFieldMappings	baseFieldID	integer	11,10	√		null
baseFieldMappingsCombined	baseFieldID	integer	11,10	√		null
customBaseFieldMappings	baseFieldID	integer	11,10	√		null
creatorData	birthYear	integer	11,10	√		null
charsets	charset	varchar	65536,10	√		null
charsets	charsetID	integer	11,10	√		null
itemAttachments	charsetID	integer	11,10	√		null
translatorCache	code	varchar	65536,10	√		null
annotations	collapsed	varchar	65536,10	√		null
collectionItems	collectionID	integer	11,10	√		null
collections	collectionID	integer	11,10	√		null
annotations	cols	integer	11,10	√		null
savedSearchConditions	condition	varchar	65536,10	√		null
transactions	context	varchar	65536,10	√		null
creatorData	creatorDataID	integer	11,10	√		null
creators	creatorID	integer	11,10	√		null
itemCreators	creatorID	integer	11,10	√		null
creatorTypes	creatorType	varchar	65536,10	√		null
creatorTypes	creatorTypeID	integer	11,10	√		null
itemCreators	creatorTypeID	integer	11,10	√		1
itemTypeCreatorTypes	creatorTypeID	integer	11,10	√		null
customBaseFieldMappings	customFieldID	integer	11,10	√		null
customFields	customFieldID	integer	11,10	√		null
customItemTypeFields	customFieldID	integer	11,10	√		null
customBaseFieldMappings	customItemTypeID	integer	11,10	√		null
customItemTypes	customItemTypeID	integer	11,10	√		null
annotations	dateModified	date	10,10	√		null
highlights	dateModified	date	10,10	√		null
customItemTypes	display	integer	11,10	√		1
itemTypes	display	integer	11,10	√		1
highlights	endOffset	integer	11,10	√		null
highlights	endParent	varchar	65536,10	√		null
highlights	endTextNode	integer	11,10	√		null
transactionSets	event	varchar	65536,10	√		null
transactionLog	field	varchar	65536,10	√		null
fieldFormats	fieldFormatID	integer	11,10	√		null
fields	fieldFormatID	integer	11,10	√		null
fieldsCombined	fieldFormatID	integer	11,10	√		null
baseFieldMappings	fieldID	integer	11,10	√		null
baseFieldMappingsCombined	fieldID	integer	11,10	√		null
customItemTypeFields	fieldID	integer	11,10	√		null
fields	fieldID	integer	11,10	√		null
itemData	fieldID	integer	11,10	√		null
itemTypeFields	fieldID	integer	11,10	√		null
creatorData	fieldMode	integer	11,10	√		null
customFields	fieldName	varchar	65536,10	√		null
fields	fieldName	varchar	65536,10	√		null
fileTypes	fileType	varchar	65536,10	√		null
fileTypeMimeTypes	fileTypeID	integer	11,10	√		null
fileTypes	fileTypeID	integer	11,10	√		null
creatorData	firstName	varchar	65536,10	√		null
groups	groupID	integer	11,10	√		null
itemTypeFields	hide	integer	11,10	√		null
itemTypeFieldsCombined	hide	integer	11,10	√		null
highlights	highlightID	integer	11,10	√		null
proxyHosts	hostID	integer	11,10	√		null
proxyHosts	hostname	varchar	65536,10	√		null
customItemTypes	icon	varchar	65536,10	√		null
transactionSets	id	integer	11,10	√		null
zoteroDummyTable	id	integer	11,10	√		null
fulltextItems	indexedChars	integer	11,10	√		null
fulltextItems	indexedPages	integer	11,10	√		null
fieldFormats	isInteger	integer	11,10	√		null
annotations	itemID	integer	11,10	√		null
collectionItems	itemID	integer	11,10	√		null
deletedItems	itemID	integer	11,10	√		null
fulltextItems	itemID	integer	11,10	√		null
fulltextItemWords	itemID	integer	11,10	√		null
groupItems	itemID	integer	11,10	√		null
highlights	itemID	integer	11,10	√		null
itemAttachments	itemID	integer	11,10	√		null
itemCreators	itemID	integer	11,10	√		null
itemData	itemID	integer	11,10	√		null
itemNotes	itemID	integer	11,10	√		null
items	itemID	integer	11,10	√		null
itemSeeAlso	itemID	integer	11,10	√		null
itemTags	itemID	integer	11,10	√		null
baseFieldMappings	itemTypeID	integer	11,10	√		null
baseFieldMappingsCombined	itemTypeID	integer	11,10	√		null
itemTypeCreatorTypes	itemTypeID	integer	11,10	√		null
itemTypeFields	itemTypeID	integer	11,10	√		null
itemTypes	itemTypeID	integer	11,10	√		null
settings	key	varchar	65536,10	√		null
customFields	label	varchar	65536,10	√		null
customItemTypes	label	varchar	65536,10	√		null
fieldsCombined	label	varchar	65536,10	√		null
translatorCache	lastModifiedTime	integer	11,10	√		null
creatorData	lastName	varchar	65536,10	√		null
translatorCache	leafName	varchar	65536,10	√		null
collections	libraryID	integer	11,10	√		null
creators	libraryID	integer	11,10	√		null
items	libraryID	integer	11,10	√		null
libraries	libraryID	integer	11,10	√		null
savedSearches	libraryID	integer	11,10	√		null
storageDeleteLog	libraryID	integer	11,10	√		null
tags	libraryID	integer	11,10	√		null
itemSeeAlso	linkedItemID	integer	11,10	√		null
itemAttachments	linkMode	integer	11,10	√		null
fileTypeMimeTypes	mimeType	varchar	65536,10	√		null
itemAttachments	mimeType	varchar	65536,10	√		null
proxies	multiHost	integer	11,10	√		null
syncObjectTypes	name	varchar	65536,10	√		null
itemNotes	note	varchar	65536,10	√		null
annotations	offset	integer	11,10	√		null
savedSearchConditions	operator	varchar	65536,10	√		null
collectionItems	orderIndex	integer	11,10	√		0
itemCreators	orderIndex	integer	11,10	√		0
itemTypeFields	orderIndex	integer	11,10	√		null
itemAttachments	originalPath	varchar	65536,10	√		null
annotations	parent	varchar	65536,10	√		null
collections	parentCollectionID	integer	11,10	√		null
itemAttachments	path	varchar	65536,10	√		null
itemTypeCreatorTypes	primaryField	integer	11,10	√		null
proxies	proxyID	integer	11,10	√		null
proxyHosts	proxyID	integer	11,10	√		null
fieldFormats	regex	varchar	65536,10	√		null
savedSearchConditions	required	varchar	65536,10	√		null
annotations	rows	integer	11,10	√		null
savedSearchConditions	savedSearchID	integer	11,10	√		null
savedSearches	savedSearchID	integer	11,10	√		null
version	schema	varchar	65536,10	√		null
proxies	scheme	varchar	65536,10	√		null
savedSearchConditions	searchConditionID	integer	11,10	√		null
settings	setting	varchar	65536,10	√		null
creatorData	shortName	varchar	65536,10	√		null
itemAttachments	sourceItemID	integer	11,10	√		null
itemNotes	sourceItemID	integer	11,10	√		null
highlights	startOffset	integer	11,10	√		null
highlights	startParent	varchar	65536,10	√		null
highlights	startTextNode	integer	11,10	√		null
itemAttachments	storageHash	varchar	65536,10	√		null
itemAttachments	storageModTime	integer	11,10	√		null
syncObjectTypes	syncObjectTypeID	integer	11,10	√		null
itemAttachments	syncState	integer	11,10	√		0
itemTags	tagID	integer	11,10	√		null
tags	tagID	integer	11,10	√		null
itemTypes	templateItemTypeID	integer	11,10	√		null
annotations	text	varchar	65536,10	√		null
annotations	textNode	integer	11,10	√		null
itemNotes	title	varchar	65536,10	√		null
fulltextItems	totalChars	integer	11,10	√		null
fulltextItems	totalPages	integer	11,10	√		null
transactionLog	transactionID	integer	11,10	√		null
transactions	transactionID	integer	11,10	√		null
transactions	transactionSetID	integer	11,10	√		null
transactionSets	transactionSetID	integer	11,10	√		null
translatorCache	translatorJSON	varchar	65536,10	√		null
customItemTypes	typeName	varchar	65536,10	√		null
itemTypes	typeName	varchar	65536,10	√		null
users	userID	integer	11,10	√		null
itemDataValues	value	varchar	65536,10	√		null
savedSearchConditions	value	varchar	65536,10	√		null
settings	value	varchar	65536,10	√		null
transactionLog	value	varchar	65536,10	√		null
itemData	valueID	varchar	65536,10	√		null
itemDataValues	valueID	integer	11,10	√		null
fulltextItems	version	integer	11,10	√		null
fulltextWords	word	varchar	65536,10	√		null
fulltextItemWords	wordID	integer	11,10	√		null
fulltextWords	wordID	integer	11,10	√		null
annotations	x	integer	11,10	√		null
annotations	y	integer	11,10	√		null
collections	clientDateModified	timestamp	30,10			2010-10-21 17:16:19
creators	clientDateModified	timestamp	30,10			2010-10-21 17:16:19
items	clientDateModified	timestamp	30,10			2010-10-21 17:16:19
relations	clientDateModified	timestamp	30,10			2010-10-21 17:16:19
savedSearches	clientDateModified	timestamp	30,10			2010-10-21 17:16:19
tags	clientDateModified	timestamp	30,10			2010-10-21 17:16:19
collections	collectionName	varchar	65536,10
groupItems	createdByUserID	integer	11,10
creators	creatorDataID	integer	11,10
fieldsCombined	custom	integer	11,10
itemTypesCombined	custom	integer	11,10
customItemTypeFields	customItemTypeID	integer	11,10
collections	dateAdded	timestamp	30,10			2010-10-21 17:16:19
creators	dateAdded	timestamp	30,10			2010-10-21 17:16:19
items	dateAdded	timestamp	30,10			2010-10-21 17:16:19
savedSearches	dateAdded	timestamp	30,10			2010-10-21 17:16:19
tags	dateAdded	timestamp	30,10			2010-10-21 17:16:19
deletedItems	dateDeleted	varchar	65536,10			2010-10-21 17:16:19
collections	dateModified	timestamp	30,10			2010-10-21 17:16:19
creators	dateModified	timestamp	30,10			2010-10-21 17:16:19
items	dateModified	timestamp	30,10			2010-10-21 17:16:19
savedSearches	dateModified	timestamp	30,10			2010-10-21 17:16:19
tags	dateModified	timestamp	30,10			2010-10-21 17:16:19
groups	description	varchar	65536,10
itemTypesCombined	display	integer	11,10			1
groups	editable	integer	11,10
fieldsCombined	fieldID	integer	11,10
itemTypeFieldsCombined	fieldID	integer	11,10
fieldsCombined	fieldName	varchar	65536,10
groups	filesEditable	integer	11,10
customItemTypeFields	hide	integer	11,10
items	itemTypeID	integer	11,10
itemTypeFieldsCombined	itemTypeID	integer	11,10
itemTypesCombined	itemTypeID	integer	11,10
collections	key	varchar	65536,10
creators	key	varchar	65536,10
items	key	varchar	65536,10
savedSearches	key	varchar	65536,10
storageDeleteLog	key	varchar	65536,10
syncDeleteLog	key	varchar	65536,10
tags	key	varchar	65536,10
groupItems	lastModifiedByUserID	integer	11,10
groups	libraryID	integer	11,10
relations	libraryID	integer	11,10
syncDeleteLog	libraryID	integer	11,10
libraries	libraryType	varchar	65536,10
groups	name	varchar	65536,10
tags	name	varchar	65536,10
relations	object	varchar	65536,10
customItemTypeFields	orderIndex	integer	11,10
itemTypeFieldsCombined	orderIndex	integer	11,10
relations	predicate	varchar	65536,10
savedSearches	savedSearchName	varchar	65536,10
relations	subject	varchar	65536,10
syncDeleteLog	syncObjectTypeID	integer	11,10
storageDeleteLog	timestamp	integer	11,10
syncDeleteLog	timestamp	integer	11,10
tags	type	integer	11,10
itemTypesCombined	typeName	varchar	65536,10
users	username	varchar	65536,10
version	version	integer	11,10