Wiki

Table	Description & Columns
active_bibtex_users	This table is for active bibtex user ...
	user_name, max(date), min(date), posting_time_in_days, num_res, num_tags
active_user_names	TODO
	user_name, max(date), min(date), posting_time_in_days, num_res, num_tags
author	Authors of publications in Bibsonomy. Not to be confused with users.
	author_id, first_name, middle, last_name, ctr
author_bibtex_content	TODO
	author_id, content_id, author_bibtex_content
author_bibtex_name	TODO
	author_id, bibtex_author_name
bibhash	counts for each of the four supported hash types, how often each hash appears
	hash, ctr, type
bibtex	resources from publication posts
	content_id, journal, volume, chapter, edition, month, day, booktitle, howPublished, institution, organization, publisher, address, school, series, bibtexKey, group, date, user_name, url, type, description, annote, note, pages, bKey, number, crossref, misc, bibtexAbstract, simhash0, simhash1, simhash2, simhash3, entrytype, title, author, editor, year, privnote, scraperid, change_date, rating
bibtexurls	TODO
	content_id, url, text, group, date
bookmark	resources from bookmark posts
	content_id, book_url_hash, book_description, book_extended, group, date, user_name to_bib, change_date, rating
classifier_settings	configuration of the user classification framework
	ID, key, value
classifier_whitelist	whitelist for the user classification framework
	white_regex
clicklog	logged clicks
	id, logdate, dompath, dompathwclasses, type, pageurl, ahref, acontent, useragent, host, completeheader, xforwardedfor, username, sessionid, listpos, mouseclientpos, mousedocumentpos, clientwindowsize, anumofposts, abmown, referer
collector	the publication basket
	user_name, content_id, date
DBLP	date of last successful DBLP update
	lastupdate
discussion	discussion items for posts
	discussion_id, interHash, hash, type, text, user_name, parent_hash, rating, anonymous, group, date, change_date, content_type
document	metadata about uploaded documents for publication posts and uploaded JabRef layouts
	hash, content_id, name, user_name, date, md5hash
extended_fields_data	TODO
	key, value, content_id, date_of_create, date_of_last_mod
followers	Users who follow f_user_name
	followers_id, user_name, f_user_name, fellowship_date
friends	Users who are friends of f_user_name
	friends_id, user_name, f_user_name, friendship_date, f_network_user_id, tag_name
gold_standard	community posts
	content_id, journal, volume, chapter, edition, month, day, booktitle, howPublished, institution, organization, publisher, address, school, series, bibtexKey, group, date, user_name, url, type, description, annote, note, pages, bKey, number, crossref, misc, bibtexAbstract, simhash0, simhash1, simhash2, simhash3, entrytype, title, author, editor, year, privnote, scraperid, change_date, rating, content_type
gold_standard_ publication_references	TODO
	publication, reference, user_name, date
group_tagsets	each group can define a set of tags which are shown when the relevantfor:GROUP system tag for that group is chosen (currently, no user interface to define group tag sets exists, though)
	tag_name, set_name, group
groupids	information about groups
	group_name, group, privlevel, sharedDocuments, publ_reporting_external_url, publ_reporting_mail, publ_reporting_mail_template
groups	group membership of users
	user_name, group, defaultgroup, start_date, user_status, userSharedDocuments
grouptas	for posts that are only visible to group members of several groups (not active, yet)
	tas_id, tag_name, content_id, content_type, user_name, date, group, tag_lower, change_date
highwirelist	unused (!?)
	list, lastupdate
ids	counters for all system-generated IDs (e.g., the content_id, etc.)
	name, value, description
inbox_tas	TODO
	message_id, tag_name
inboxMail	Messages from sender_user to receiver_user
	message_id, content_id, intraHash, sender_user, receiver_user, date, content_type
inetAddressStates	TODO
	address, status, updated_at
ip_to_country	Mapping ip to country (unused)
	start_ip, end_ip, country2, country3, countrylong
ldapUser	information for LDAP authentication
	user_name, ldapUserId, lastAccess
log_bibtex	history of publication posts
	content_id, journal, volume, chapter, edition, month, day, bookTitle, howPublished, institution, organization, publisher, address, school, series, bibtexKey, group, date, user_name, url, type, description, annote, note, pages, bKey, number, crossref, misc, bibtexAbstract, entrytype, title, author, editor, year, simhash0, simhash1, simhash2, simhash3, new_content_id, scraperid, change_date, rating, privnote, log_date, current_content_id
log_bibtexurls	Logging data of bibtex URLS
	content_id, url, text, group, date, log_date
log_bookmark	history of bookmark posts
	content_id, book_url_hash, book_description, book_extended, group, date, user_name, new_content_id, change_date, rating, log_date
log_collector	basket history
	user_name, content_id, add_date, del_date
log_discussion	discussion history
	discussion_id, interHash, hash, text, user_name, type, parent_hash, rating, anonymous, group, date, change_date, log_date, content_type
log_document	uploaded documents history
	hash, content_id, name, user_name, date, md5hash, log_date, log_id
log_followers	Logging data of user's following behaviour
	followers_id, user_name, f_user_name, fellowship_date, fellowship_end_date
log_friends	Logging data of user's friendships
	friends_id, user_name, f_user_name, friendship_date, friendship_end_date, f_network_user_id, tag_name
log_gold_standard	community post history
	content_id, journal, volume, chapter, edition, month, day, booktitle, howPublished, institution, organization, publisher, address, school, series, bibtexKey, group, date, user_name, url, type, description, annote, note, pages, bKey, number, crossref, misc, bibtexAbstract, entrytype, title, author, editor, year, simhash0, simhash1, simhash2, simhash3, new_content_id, scraperid, change_date, rating, privnote, new_simhash1, log_date, content_type
log_gold_standard_ publication_references	TODO
	publication, reference, user_name, log_date
log_groups	TODO
	user_name, group, defaultgroup, start_date, end_date, user_status
log_inboxMail	TODO
	message_id, content_id, intraHash, sender_user, receiver_user, date, content_type, log_date
log_prediction	TODO
	ID, user_name, prediction, timestamp, updated_at, algorithm, mode, confidence
log_tagtagrelations	TODO
	relationID, lower, upper, date_of_create, date_of_last_mod, user_name, picked
log_tas	Logging data of TAS relationships
	tas_id, tag_name, content_id, content_type, date, change_date, log_date
log_user	Logging data of users
	nr, user_name, user_email, user_password, user_password_salt, user_homepage, user_realname, spammer, openurl, reg_date, ip_address, id, tmp_password, tmp_request_date, tagbox_style, tagbox_sort, tagbox_minfreq, tagbox_tooltip, list_itemcount, spammer_suggest, birthday, gender, profession, interests, hobbies, place, profilegroup, api_key, updated_by, updated_at, lang, role, timestamp, prediction, algorithm, count, log_level, to_classify, confirmDelete, is_max_count, tagbox_max_count, simple_interface, show_bookmark, show_bibtex, institution, gravatarAddress, useExternalPicture
log_wiki	TODO
	user_name, user_wiki, date
openIDUser	information for OpenID authentification
	user_name, openID
pendingUser	registered, but not yet active users
	user_name, user_email, user_password, user_password_salt, user_homepage, user_realname, spammer, openurl, reg_date, ip_address, id, tmp_password, tmp_request_date, tagbox_style, tagbox_sort, tagbox_minfreq, tagbox_max_count, is_max_count, tagbox_tooltip, list_itemcount, spammer_suggest, birthday, gender, profession, interests, hobbies, place, profilegroup, api_key, updated_by, updated_at, role, lang, to_classify, log_level, confirmDelete, simple_interface, show_bookmark, show_bibtex, institution, gravatarAddress, useExternalPicture
popular_tags	popular tags (computed by a batch script
	tag_lower, tag_ctr, content_type, popular_days
post_metadata	TODO
	user_name, intra_hash, inter_hash, key, value, date, content_id, ref_content_id
prediction	user classification framework
	user_name, prediction, timestamp, updated_at, algorithm, mode, evaluator, confidence
ranking_queue	FolkRank
	id, dim, item, date, status
rankings	FolkRank
	id, dim, item, date, status, id, time, alpha, beta, gamma, basepref, dim, item, itemtype, itempref, delta, iter
relevant_tas	TODO
	tag_name, user_name, res_hash, date
repository	TODO
	inter_hash, intra_hash, repository_date, user_name, repository_name, repository
review_ratings_cache	cache for discussions
	interHash, number_of_ratings, rating_arithmetic_mean
samlUser	information for SAML authentification
	user_name, samlUserId, identity_provider, lastAccess
scheduled_tags	TODO
	tas_id, date, done, type
scraperMetaData	additional metadata for scraper (only used by IEScraper)
	id, metaResult, scraper, url, scrape_date
spammer_tags	tag blacklist
	tag_name, spammer
sync	user information about synchronization
	user_name, service_id, credentials, content_type, direction, strategy, autosync
sync_data	user information about synchronization status
	service_id, user_name, content_type, last_sync_date, status, info, device_id, device_info
sync_services	available services for synchronization
	uri, secure_api, service_id, server, ssl_dn, name
tags	tag counts (on how many posts does each tag occur?)
	tag_id, tag_name, tag_stem, tag_ctr, waiting_content_sim, tag_ctr_public, show_tag
tagtag	tag-tag counts (how often do two tags appear together? used to show related tags on /tag/TAG)
	t1, t2, ctr, ctr_public
tagtag_batch	unused
	content_id, tags, toinc, isactive, id
tagtag_similarity	TODO
	t1, t2, sim
tagtag_similarity2	TODO
	t1, t2, sim
tagtag_temp	TODO
	t1, t2, incdec, id
tagtagrelations	TODO
	relationID, date_of_create, date_of_last_mod, user_name, lower, upper, picked lower_lcase, upper_lcase
tas	tag assignments - which tags belong to a post?
	tas_id, tag_name, content_id, content_type, user_name, date, group, tag_lower, change_date
temp_bibtex	TODO
	content_id, journal, volume, chapter, edition, month, day, bookTitle, howPublished, institution, organization, publisher, address, school, series, bibtexKey, date, user_name, url, type, description, annote, note, pages, bKey, number, crossref, misc, bibtexAbstract, simhash0, ctr, rank, simhash1, simhash2, simhash3, entrytype, title, author, editor, year, rating, popular_days
temp_bookmark	TODO
	content_id, book_description, book_extended, book_url_hash, date, user_name, book_url_ctr, rank, rating, popular_days
urls	URL counts - on how many bookmark posts does each URL appear?
	book_url_hash, book_url, book_url_ctr
user	user information
	user_name, user_email, user_password, user_password_salt, user_homepage, user_realname, spammer, openurl, reg_date, ip_address, id, tmp_password, tmp_request_date, tagbox_style, tagbox_sort, tagbox_minfreq, tagbox_tooltip, list_itemcount, spammer_suggest, birthday, gender, profession, interests, hobbies, place, profilegroup, api_key, updated_by, updated_at, role, lang, to_classify, log_level, confirmDelete, is_max_count, tagbox_max_count, simple_interface, show_bookmark, show_bibtex, institution, gravatarAddress, useExternalPicture
user_wiki	content of user's wiki page
	user_name, user_wiki, date
useruser_similarity	TODO
	u1, u2, sim, measure_id
useruser_similarity2	TODO
	u1, u2, sim, `measure_id
weights	FolkRank
	id, weight, dim, item, itemtype