Difference between revisions of "Database Tables"

From Dreamwidth Notes
Jump to: navigation, search
m (Kind works better then Category)
m
Line 4: Line 4:
 
[[:Category:Database Table Needing Relationship Data]]
 
[[:Category:Database Table Needing Relationship Data]]
  
[[:Category:Database_Tables_Needing_Description]]
+
[[:Category:Database Tables Needing Description]]
  
 
== List of Database Tables ==
 
== List of Database Tables ==

Revision as of 11:51, 27 January 2010

An overview of what all the tables mean has been started at Database Table Overview.

Needs Update: These two categories need work.
Category:Database Table Needing Relationship Data

Category:Database Tables Needing Description

List of Database Tables

55 database tables.

Global

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.

---

Database_Table:_userblob Database_Table:_userblobcache