Database Tables

From Dreamwidth Notes
Revision as of 22:30, 18 July 2016 by AzureLunaticDW (Talk | contribs)

Jump to: navigation, search

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.

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

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

posts_raw
Table for sphinx to use.

---