Wiki

Clone wiki

BibSonomy / development / Database description

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

Updated