Database Tables
From Dreamwidth Notes
An overview of what all the tables mean has been started at Database Table Overview.
Needs Update: These three categories need work.
Category:Database Table Needing Relationship Data
Category:Database Tables Needing Description
Category:Database Tables To Check
Contents |
List of Database Tables
228 database tables.
Global
- acctcode
- This table stores data on valid invite codes and who has used them.
- acctcode_promo
- acctcode_request
- actionhistory
- active_user_summary
- authactions
- backupdirty
- blobcache
- blockwatch_events
- captcha_cache
- cc_log
- cc_trans
- challenges
- clients
- clientusage
- This table is populated at login.
- clustermove
- This table tracks history when users are moved between clusters.
- clustermove_inprogress
- this table is used to track the transitions of users between clusters.
- codes
- This table stores coded values for a number of lists, including countries, states/provinces, and certain sets of colors. See upgrading/base-data.sql for initial content.
- comm_promo_list
- comminterests
- This table links community-type users to interests.
- community
- This stores information about communities. UserID points to the user record for the community itself, and ownerid points the user who owns the community.
- counter
- Stores user counters.
- cprodlist
- This table supports the prodding feature not currently supported in Dreamwidth.
- dbinfo
- dbweights
- debug_notifymethod
- dirmogsethandles
- dirsearchres2
- domains
- duplock
- Stores a record that an action has been done, so it doesn't get done a second time later by a user accidentally double-clicking a single-click button in their browser.
- dw_paidstatus
- email_aliases
- eventtypelist
- expunged_users
- external_site_moods
- externaluserinfo
- extuser
- faq
- faqcat
- faquses
- gco_log
- gco_map
- identitymap
- import_data
- import_items
- import_usermap
- includetext
- incoming_email_handle
- infohistory
- interests
- This table stores information about interests.
- jabcluster
- jabpresence
- jobstatus
- logproplist
- ml_domains
- ml_items
- ml_langdomains
- ml_langs
- ml_latest
- ml_text
- moods
- moodthemedata
- moodthemes
- navtag
- noderefs
- notifytypelist
- openid_claims
- openid_endpoint
- openid_external
- openid_trust
- openproxy
- partialstats
- partialstatsdata
- password
- persistent_queue
- pollowner
- pollproplist2
- This table stores metadata of poll properties used.
- pp_log
- pp_tokens
- pp_trans
- priv_list
- priv_map
- priv_packages
- priv_packages_content
- procnotify
- qotd
- rateabuse
- ratelist
- readonly_user
- reluser
- Stores information about permissions for users to post to journals other than their own, such as community memberships, mod privileges and bans. Most of the edges are stored here, since edges can cross clusters.
- renames
- s2categories
- s2checker
- s2compiled
- s2info
- s2layers
- s2source_inno
- s2styles
- schemacols
- schematables
- secrets
- shop_carts
- shop_cmo
- shop_codes
- site_messages
- site_stats
- sitekeywords
- spamreports
- statkeylist
- stats
- statushistory
- subsproplist
- support
- support_answers
- This table stores stock answers for the Support system.
- support_youreplied
- supportcat
- supportlog
- supportnotify
- supportpoints
- supportpointsum
- supportprop
- syndicated
- syndicated_hubbub2
- synitem
- sysban
- talkleft_xfp
- Stores comments when the database cluster of the user making the comment is unavailable. A maintenance task (clean_caches) moves data from here to talkleft on clusters.
- talkproplist
- tor_proxy_exits
- txtmsg
- This table stores numbers and message data for text messaging. NOT specific to the TextLJ feature, which is not supported in DreamWidth.
- underage
- uniqmap
- user
- This table stores some of the permanent, account-specific data for personal accounts, communities and feeds.
- usercounter
- useridmap
- userinterests
- This table associated userIDs to interests.
- usermsgproplist
- userprop
- userproplist
- userproplite
- Associates users to properties at the global level.
- users_for_paid_accounts
- usersearch_packdata
- usertrans
- userusage
- vgift_counts
- vgift_ids
- vgift_tagpriv
- vgift_tags
- wt_edges
Clustered
- active_user
- bannotes
- birthdays
- This is a table on the clustered database that stores information about upcoming birthdays.
- clustertrack2
- This table on each clustered database tracks users on that cluster.
- cmdbuffer
- collection_items
- collections
- content_filter_data
- content_filters
- cprod
- This table supports the prodding feature not currently supported in Dreamwidth.
- dbnotes
- dudata
- embedcontent
- embedcontent_preview
- externalaccount
- has_subs
- import_status
- inviterecv
- invitesent
- jablastseen
- jabroster
- links
- log2
- loginlog
- loginstall
- logkwsum
- logprop2
- logprop_history
- logsec2
- logslugs
- logtags
- logtagsrecent
- This table stores data for mapping tags.
- logtext2
- media
- memkeyword2
- memorable2
- modblob
- modlog
- notifyarchive
- notifybookmarks
- notifyqueue
- pendcomments
- poll2
- pollitem2
- pollprop2
- pollquestion2
- pollresult2
- pollsubmission2
- random_user_set
- ratelog
- recentactions
- reluser2
- User-space (clustered) relationships table. Only used for 'hide this comm from my profile page'.
- s2compiled2
- s2stylelayers2
- sessions
- sessions_data
- subs
- subsprop
- talk2
- talkleft
- talkprop2
- talktext2
- tempanonips
- trust_groups
- userbio
- userblob
- Ancient system for storing userpics. Used if MogileFS is not being run.
- userkeywords
- userlog
- usermsg
- usermsgprop
- usermsgtext
- userpic2
- userpicblob2
- Stores the actual userpic blobs. Optionally a blob server can be used instead of storing them here in the database.
- userpicmap2
- userpicmap3
- Stores userpic keyword mappings.
- userpropblob
- userproplite2
- This table is used to store multihomed userprops on the clustered database.
- usertags
Other
- posts_raw
- Table for sphinx to use.
---
