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
The canonical current version of the database tables can be viewd at /bin/upgrading/update-db-general.pl. Search this file for the section you're interested in.
Contents
List of Database Tables
55 database tables.
Global
Individually Listed
Search Results
- acctcode_promo
- acctcode_request
- captcha_cache
- cc_log
- cc_trans
- email_aliases
- external_site_moods
- externaluserinfo
- gco_log
- gco_map
- import_data
- import_items
- import_usermap
- media_prop_list
- openid_claims
- pollproplist2
- This table stores metadata of poll properties used.
- pp_log
- pp_tokens
- pp_trans
- renames
- s2categories
- shop_carts
- shop_cmo
- shop_codes
- site_stats
- sitekeywords
- statkeylist
- syndicated_hubbub2
- tor_proxy_exits
- users_for_paid_accounts
- vgift_counts
- vgift_ids
- vgift_tagpriv
- vgift_tags
- wt_edges
Clustered
Individually Listed
Search Results
- bannotes
- birthdays
- This is a table on the clustered database that stores information about upcoming birthdays.
- collection_items
- collections
- content_filter_data
- content_filters
- dbnotes
- embedcontent_preview
- externalaccount
- import_status
- logprop_history
- logslugs
- media
- media_props
- media_versions
- pollprop2
- trust_groups
- userblob
- Ancient system for storing userpics. Used if MogileFS or BlobCache is not being run.
- userpicmap3
- Stores userpic keyword mappings.
Other
Individually Listed
Search Results
- posts_raw
- Table for sphinx to use.
---