I like understanding the underline database first for any application. I don’t have full grasp yet. But here is brief summary of database. Help me complete this summary. You can give your suggestions by posting comments on this post.
1. access - aid, mask, type, status - not sure what this table does.
2. authmap - aid, uid, authname, module - name suggests it is type of mapping.
3. blocks - this table is used to store blocks.
module - name of the module e.g. views, og, menu, comment, node etc.
delta - not sure
theme - name of the theme for the block.
status - 0,1 not sure but I guess it is used to tell if the block is active or not.
weight - denote the order of display.
region - left, right, center etc. used to tell the position where it will render.
custom - not sure
throttle - throttle it under high load
visibility - name suggests it is visible or not
pages - pages setting to tell on which page it will appear
title - title of the module
4. blocks_roles - used to map block with roles settings.
module - name of the module
delta - ?
rid - role id - some access permissions will be saved here
5. boxes - obsolete now.
bid -
body -
info -
format -
6. cache - used to store some cached data.
cid - id e.g. variables
data - blob
expire - when it will expire
created - timestamp
headers - ?
7. cache_content - caches the content data
cid
data
expire
created
headers
8. cache_filters - ?
cid
data
expire
created
headers
9. cache_menu - holds menu settings
cid
data
expire
created
headers
10. cache_page - caches the pages
cid
data
expire
created
headers
11. cache_views - may be used for caching the views. Used for views.
cid
data
expire
created
headers
12. comments - used to store comments.
cid = unique comment id
pid = parent id
nid = node id on which the comment is made
uid = user who has put the comment
subject = title or subject
comment = body of comment
hostname
timestamp
score = ?
status = may be something like published
format = ?
thread = used to manage thread need to find out
users = ?
name = name of the user who posted the comment
mail = ?
homepage =?
13. history - keeps track of user’s activities. Used for online users I guess.
uid
nid
timestamp
14. node - to store piece of content
nid = incremental node id
vid = version control id
type = type of the content e.g. blog, article
title
uid = author id
status = published etc
created
changed
comment = comment’s settings
promote = to show on homepage or not
moderate = ?
sticky = used to order by field
15. node_access = access permissions associated with the node.
nid
gid = ?
realm = ?
grant_view = view permissions
grant_update
grant_delete
16. node_revisions = used to store version of the node.
nid
vid
uid
title
body
teaser
log
timestamp
format
17. node_type = I guess this table is used for CCK.
type
name
module
description
help
has_title
title_label
has_body
body_label
min_word_count
custom
modified
locked
orig_type
18. filters - not sure what this table does?
19. OG - comes with organic group module. Interesting module.
nid = id of the group
selective = type of group
description
theme
register = I think it is a flag to show it on register page
directory = show it in listing or not. Guess.
notification = send email alerts or not.
language = en, fr I dont know.
private = checks if it will come in listings
20. og_ancestory = not sure what this table does.
nid = ?
group_nid = id of the group
is_public = I think it is to denote the public status of the group
21. og_uid - maps user to group
nid = ?
og_role = role of the user
is_active
is_admin
uid
mail_type = email alerts settings
created
changed
22. og_uid_global - have global settings. It only has two fields - uid and og_email. I am not getting any idea what it will contain.