Database Tables
From Dreamwidth Notes
An overview of what all the tables mean has been started at Database Table Overview.
List of Database Tables
Needs Update: These need sorting into decent categories. Key relationships need more complete annotation. Individual pages need high-level descriptions.
- Database Table: acctcode
- Database Table: actionhistory
- Database Table: active_user
- Database Table: active_user_summary
- Database Table: authactions
- Database Table: backupdirty
- Database Table: birthdays
- Database Table: blobcache
- Database Table: blockwatch_events
- Database Table: captcha_session
- Database Table: captchas
- Database Table: challenges
- Database Table: clients
- Database Table: clientusage
- Database Table: clustermove
- Database Table: clustermove_inprogress
- Database Table: clustertrack2
- Database Table: cmdbuffer
- Database Table: codes
- Database Table: comm_promo_list
- Database Table: commenturls
- Database Table: comminterests
- Database Table: community
- Database Table: content_flag
- Database Table: counter
- Database Table: cprod
- Database Table: cprodlist
- Database Table: dbinfo
- Database Table: dbweights
- Database Table: debug_notifymethod
- Database Table: dirmogsethandles
- Database Table: dirsearchres2
- Database Table: domains
- Database Table: dudata
- Database Table: duplock
- Database Table: dw_paidstatus
- Database Table: dw_payments
- Database Table: dw_pp_details
- Database Table: dw_pp_log
- Database Table: dw_pp_notify_log
- Database Table: email
- Database Table: embedcontent
- Database Table: eventtypelist
- Database Table: expunged_users
- Database Table: extuser
- Database Table: faq
- Database Table: faqcat
- Database Table: faquses
- Database Table: friendgroup2
- Database Table: friends
- Database Table: has_subs
- Database Table: identitymap
- Database Table: includetext
- Database Table: incoming_email_handle
- Database Table: infohistory
- Database Table: interests
- Database Table: inviterecv
- Database Table: invitesent
- Database Table: jabcluster
- Database Table: jablastseen
- Database Table: jabpresence
- Database Table: jabroster
- Database Table: jobstatus
- Database Table: knob
- Database Table: links
- Database Table: log2
- Database Table: loginlog
- Database Table: loginstall
- Database Table: logkwsum
- Database Table: logprop2
- Database Table: logproplist
- Database Table: logsec2
- Database Table: logtags
- Database Table: logtagsrecent
- Database Table: logtext2
- Database Table: meme
- Database Table: memkeyword2
- Database Table: memorable2
- Database Table: ml_domains
- Database Table: ml_items
- Database Table: ml_langdomains
- Database Table: ml_langs
- Database Table: ml_latest
- Database Table: ml_text
- Database Table: modblob
- Database Table: modlog
- Database Table: moods
- Database Table: moodthemedata
- Database Table: moodthemes
- Database Table: navtag
- Database Table: noderefs
- Database Table: notifyarchive
- Database Table: notifybookmarks
- Database Table: notifyqueue
- Database Table: notifytypelist
- Database Table: openid_endpoint
- Database Table: openid_external
- Database Table: openid_trust
- Database Table: openproxy
- Database Table: partialstats
- Database Table: partialstatsdata
- Database Table: password
- Database Table: pendcomments
- Database Table: persistent_queue
- Database Table: poll2
- Database Table: pollitem2
- Database Table: pollowner
- Database Table: pollquestion2
- Database Table: pollresult2
- Database Table: pollsubmission2
- Database Table: portal_box_prop
- Database Table: portal_config
- Database Table: portal_typemap
- Database Table: priv_list
- Database Table: priv_map
- Database Table: priv_packages
- Database Table: priv_packages_content
- Database Table: procnotify
- Database Table: qotd
- Database Table: random_user_set
- Database Table: rateabuse
- Database Table: ratelist
- Database Table: ratelog
- Database Table: readonly_user
- Database Table: recentactions
- Database Table: reluser
- Database Table: reluser2
- Database Table: s2checker
- Database Table: s2compiled
- Database Table: s2compiled2
- Database Table: s2info
- Database Table: s2layers
- Database Table: s2source_inno
- Database Table: s2stylelayers2
- Database Table: s2styles
- Database Table: sch_error
- Database Table: sch_exitstatus
- Database Table: sch_funcmap
- Database Table: sch_job
- Database Table: sch_note
- Database Table: schemacols
- Database Table: schematables
- Database Table: schools
- Database Table: schools_attended
- Database Table: schools_pending
- Database Table: secrets
- Database Table: sessions
- Database Table: sessions_data
- Database Table: site_messages
- Database Table: spamreports
- Database Table: stats
- Database Table: statushistory
- Database Table: subs
- Database Table: subsprop
- Database Table: subsproplist
- Database Table: support
- Database Table: support_answers
- Database Table: support_youreplied
- Database Table: supportcat
- Database Table: supportlog
- Database Table: supportnotify
- Database Table: supportpoints
- Database Table: supportpointsum
- Database Table: supportprop
- Database Table: syndicated
- Database Table: synitem
- Database Table: sysban
- Database Table: talk2
- Database Table: talkleft
- Database Table: talkprop2
- Database Table: talkproplist
- Database Table: talktext2
- Database Table: tempanonips
- Database Table: txtmsg
- Database Table: underage
- Database Table: uniqmap
- Database Table: user
- Database Table: user_schools
- Database Table: userbio
- Database Table: usercounter
- Database Table: useridmap
- Database Table: userinterests
- Database Table: userkeywords
- Database Table: userlog
- Database Table: usermsg
- Database Table: usermsgprop
- Database Table: usermsgproplist
- Database Table: usermsgtext
- Database Table: userpic2
- Database Table: userpicblob2
- Database Table: userpicmap2
- Database Table: userprop
- Database Table: userpropblob
- Database Table: userproplist
- Database Table: userproplite
- Database Table: userproplite2
- Database Table: usersearch_packdata
- Database Table: usertags
- Database Table: usertrans
- Database Table: userusage
- Database Table: weekuserusage
- Database Table: zip
