基本資料表清單

blocks(blockmodule)

Name	Type	Null	Default	Description
bid	serial	No		Primary key: unique block ID
module	varchar(64)	No	''	The module from which the block originates; for example,  user for the Who’s Online block and block for any custom blocks
delta	varchar(32)	No	'0'	Unique ID for block within a module
theme	varchar(64)	No	''	The theme under which the block settings apply
status	int:tiny	No	0	Block enabled status (1 means enabled and 0, disabled)
weight	int:tiny	No	0	Block weight within region
region	varchar(64)	No		Theme region within which the block is set
custom	int:tiny	No	0	Flag to indicate how users may control visibility of the block; 0 indicates that users cannot control it; 1 means that the block is on by default but can be hidden; 2 means that the block is hidden by default but can be shown.
visibility	int:tiny	No	0	Flag to indicate how to show blocks on pages; 0 means to show on all pages except listed pages; 1 •means to show only on listed pages; 2 means to use custom PHP code to determine visibility.
pages	text	No		Contents of the Pages block; contains either a list of paths on which to include or exclude the block or PHP code, depending on the visibility setting
title	varchar(64)	No	''	Custom title for the block; an empty string will use block default title; <none> will remove the title; text will cause block to use specified title.
cache	int:tiny	No	1	Binary flag to indicate block cache mode; -1 means do not cache; 1 means cache per role; 2 means cache per user; 4 means cache per page; 8 means block cache is global. See Chapter 9 for an explanation of block cache modes.

►The blocked_ips table stores a list of blocked IP addresses.

blocked_ips

Name	Type	Null	Default	Description
iid	serial	No		Primary Key: unique ID for IP addresses
ip	varchar(40)	No		IP address

►The block_custom table stores the contentsof custom-made blocks.

block_custom (block module)

Name	Type	Null	Default	Description
bid	serial, unsigned	No		The block’s {block}.bid
body	text:gig	Yes		NULLBlock contents
info	varchar(128)	No		Block description
format	int:small	No		0The {filter_format}.format of the block body

►The blocks_node_type table stores information that sets up display criteria for blocks based on content type.

blocks_node_type (block module)

Name	Type	Null	Default	Description
module	varchar(64)	No		The block’sorigin module, from{block}.module
delta	varchar(32)	No		The block’s unique delta within module, from {block}.delta
type	varchar(32)	No		The machine-readable name of this type from {node_type}.type

►The blocks_role table stores access permissions for blocksbased on user roles.

blocks_role (block module)

Name	Type	Null	Default	Description
module	varchar(64)	No		The block’sorigin module, from{blocks}.module
delta	varchar(32)	No		The block’s unique delta within module, from {blocks}.delta
rid	int,unsigned	No		The user’s role ID from {users_roles}.rid

►The book table stores book outline information and connects each node in the outline to a unique link in themenu_links table.

book (bookmodule)

Name	Type		Null	Default	Description
mlid	int,unsigned		No	0	The book page’s {menu_links}.mlid
nid	int,unsigned		No	0	The book page’s {node}.nid
bid	int,unsigned		No	0	The book ID is the {book}.nid of the top-level page

►The cache table is used to cache things not separated out into their own cache tables. Contributed modules may also use this to store cached items.

cache

Name	Type		Null	Default	Description
cid	varchar(255)		No	''	Primary key: unique cache ID
data	blob:big		Yes		A collection ofdata to cache
expire	int		No	0	A Unix timestamp indicating when the cache entry should expireor0 for never
created	int		No	0	A Unix timestamp indicating when the cache entry was created
serialized	int:small		No	0	A flag toindicate whether content is serialized (1) or not (0)

►The cache_block table for the block module to store already built blocks, identified by module, delta, and various contextsthat may change the block, such as the theme, locale, and caching mode defined for the block.

cache_block (block module)

Name	Type		Null	Default	Description
cid	varchar(255)		No	''	Primary key: unique cache ID
data	blob:big		Yes		A collection ofdata to cache
expire	int		No	0	A Unix timestamp indicating when the cache entry should expire or0 for never
created	int		No	0	A Unix timestamp indicating when the cache entry was created
serialized	int:small		No	0	A flag to indicate whether content is serialized(1) or not (0)

 

cache_bootstrap

Name	Type		Null	Default	Description
cid	varchar(255)		No	''	Primary key: unique cache ID
data	blob:big		Yes		A collection ofdata to cache
expire	int		No	0	A Unix timestamp indicating when the cache entry should expire or0 for never
created	int		No	0	A Unix timestamp indicating when the cache entry was created
serialized	int:small		No	0	A flag to indicate whether content is serialized(1) or not (0)

►The cache_field table stores cached field values.

cache_field

Name	Type		Null	Default	Description
cid	varchar(255)		No	''	Primary key: unique cache ID
data	blob:big		Yes		A collection ofdata to cache
expire	int		No	0	A Unix timestamp indicating when the cache entry should expire or0 for never
created	int		No	0	A Unix timestamp indicating when the cache entry was created
serialized	int:small		No	0	A flag to indicate whether content is serialized(1) or not (0)

►The cache_filter stores already filtered pieces of text, identified by inputformat and the sha_256 hash of the text.

cache_filter (filter module)

Name	Type		Null	Default	Description
cid	varchar(255)		No	''	Primary key: unique cache ID
data	blob:big		Yes		A collection ofdata to cache
expire	int		No	0	A Unix timestamp indicating when the cache entry should expireor0 for never
created	int		No	0	A Unix timestamp indicating when the cache entry was created
serialized	int:small		No	0	A flag to indicate whether content is serialized (1) ornot (0)

►The cache_form table stores recently built forms and their storage data for use in subsequent page requests.

cache_form

Name	Type		Null	Default	Description
cid	varchar(255)		No		Primary key: unique cache ID
data	blob:big		Yes		A collection ofdata to cache
expire	int		No	0	A Unix timestamp indicating when the cache entry should expire or0 for never
created	int		No	0	A Unix timestamp indicating when the cache entry was created
serialized	int:small		No	0	A flag to indicate whether content is serialized (1) or not (0)

►The cache_image table is used to store information about image manipulations that are in progress.

cache_image

Name	Type		Null	Default	Description
cid	varchar(255)		No	''	Primary key: unique cache ID
data	blob:big		Yes		A collection ofdata to cache
expire	int		No	0	A Unix timestamp indicating when the cache entry should expire or0 for never
created	int		No	0	A Unix timestamp indicating when the cache entry was created
serialized	int:small		No	0	A flag to indicate whether content is serialized(1) or not (0)

►The cache_menu table stores router information as well as generated link trees for various menu/page/user combinations.

cache_menu

Name	Type		Null	Default	Description
cid	varchar(255)		No	''	Primary key: unique cache ID
data	blob:big		Yes		A collection ofdata to cache
expire	int		No	0	A Unix timestamp indicating when the cache entry should expire or0 for never
created	int		No	0	A Unix timestamp indicating when the cache entry was created
serialized	int:small		No	0	A flag to indicate whether content is serialized (1) or not (0)

►The cache_page table is used to store compressed pages for anonymous users, if page caching is enabled.

cache_page

Name	Type		Null	Default	Description
cid	varchar(255)		No		Primary key: unique cache ID
data	blob:big		Yes		A collection ofdata to cache
expire	int		No	0	A Unix timestamp indicating when the cache entry should expireor0 for never
created	int		No	0	A Unix timestamp indicating when the cache entry was created
serialized	int:small		No	0	A flag to indicate whether content is serialized (1) ornot (0)

►The cache_path table stores path aliases.

cache_path

Name	Type		Null	Default	Description
cid	varchar(255)		No		Primary key: unique cache ID
data	blob:big		Yes		A collection ofdata to cache
expire	int		No	0	A Unix timestamp indicating when the cache entry should expire or0 for never
created	int		No	0	A Unix timestamp indicating when the cache entry was created
serialized	int:small		No	0	A flag to indicate whether content is serialized(1) or not (0)

►The cache_update table stores information, fetched fromdrupal.org, about available releases for Drupal core, modules, and themes loaded on your site.

cache_update

Name	Type		Null	Default	Description
cid	varchar(255)		No		Primary key: unique cache ID
data	blob:big		Yes		A collection ofdata to cache
expire	int		No	0	A Unix timestamp indicating when the cache entry should expireor0 • for never
created	int		No	0	A Unix timestamp indicating when the cache entry was created
serialized	int:small		No	0	A flag to indicate whether content is serialized (1) ornot (0)

►The comment table stores comments and associated data.

comment (comment module)

Name	Type	Null	Default	Description
cid	serial	No		Primary key: unique comment ID
pid	int	No	0	The {comments}.cid to which this comment is a reply; if set to 0, this comment is not a reply to an existing comment.
nid	int	No	0	The {node}.nid to which this comment is a reply
uid	int	No	0	The {users}.uid who authored the comment; if set to0, this comment was created by an anonymous user.
subject	varchar(64)	No	''	The comment title
hostname	varchar(128)	No	''	The author’s hostname
created	int	No	0	The time, as a Unixtimestamp, that the comment was created
changed	int	No	0	The time, as a Unixtimestamp, when the comment was updated
status	int:tiny,unsigned		1	The published status of a comment (0 means published, and 1, not published)
thread	varchar(255)	No		The vancode representation of the comment’s place in a thread
name	varchar(60)	Yes		The comment author’s name; uses {users}.name if the user is logged in; otherwise, uses the value typed into thecomment form
mail	varchar(64)	Yes		The comment author’s e-mail address fromthe comment form if user is anonymous and the “Anonymous users may/must leave their contact information” setting is turnedon
homepage	varchar(255)	Yes		The comment author’s home page address from the comment form if user is anonymous and the “Anonymous users may/must leave their contactinformation” setting isturned on
language	varchar(12)	No		Language that the comment was authored in

►The contact table stores the contact form category settings.

contact (contact module)

Name	Type	Null	Default	Description
cid	serial,unsigned	No		Primary key: unique category ID
category	varchar(255)	No		Category name
recipients	text:big	No		Comma-separated listof recipient e-mail addresses
reply	text:big	No		Text ofthe automatic reply message
weight	int	No		0The category’s weight
selected	int:tiny	No		0Flag to indicate whether the category is selected by default (1 for yes and 0 for no)

►The date_formats module stores configured date formats.

date_formats

Name	Type	Null	Default	Description
dfid	serial,unsigned	No		The date format identifier
format	varchar(100)	No		The date format string
type	varchar(64)	No		The date format type, e.g., medium
locked	int:tiny	No		0Whether this format can be modified

►The date_format_locale table stores configured date formats for each locale.

date_format_locale

Name	Type		Null	Default	Description
format	varchar(100)		No		The date format string
type	varchar(64)		No		The date format type, e.g., medium
language	varchar(12)		No		A {languages}.language for this format to be used with

►The date_format_type table stores configured date format types.

date_format_type

Name	Type	Null	Default	Description
type	varchar(64)	No		The date format type, e.g., medium
title	varchar(255)	No		The human readable name of the format type
locked	int:tiny	No	0	Whether this is a system-provided format

►The field_config table stores field configuration information.

field_config

Name	Type	Null	Default	Description
id	serial No			The primary identifier for a field
field_name	varchar(32)	No		The name of this field; non-deleted field names are unique, but multiple deleted fields can have the same name.
type	varchar(128)	No		The type of this field
module	varchar(128)	No		The module that implements the field type
active	int:tiny	No	0	Boolean indicating whether the module that implements the field type is enabled
storage_type	varchar(128)	No		The storage back end for the field
storage_module	varchar(128)	No		The module that implements the storage back end
storage_active	int:tiny	No	0	Boolean indicating whether the module that implements the storage back end is enabled
locked	int:tiny	No	0	A Boolean that determines whether the field can be modified
data	longblob	No		Serialized data containing the field properties that do not warrant a dedicated column
cardinality	int:tiny	No	0
translatable	int:tiny	No	0	Defines whether the field is translatable
deleted	int:tiny	No	0	A Boolean that determines whether the field was deleted

►The field_config_entity_type table stores entity information that is used by the field API.

field_config_entity_type

Name	Type	Null	Default	Description
etid	serial, unsigned	No		The unique id for this entity type
type	varchar(128)	No		An entity type

►The field_config_instance table stores field configuration information.

field_config_instance

Name	Type	Null	Default	Description
id	serial	No		The primary identifier for a field instance
field_id	int	No		The identifier of the field attached by this instance
field_name	varchar(32)	No		Name of the field
entity_type	varchar(32)	No		The type of entity associated with this configuration
bundle	varchar(128)	No		The bundle that this configuration is associated with
data	blog:big	No		Stores the contents of the field
deleted	int:tiny	No	0	A Boolean value that identifies whether this field configuration has been deleted

►The field_data_body table stores details about the body field of an entity.

field_data_body

Name	Type	Null	Default	Description
etid	serial,unsigned	No		Entity ID
bundle	varchar(128)	No		Bundle associated with this entity
deleted	int:tiny	No		0A Boolean that signifies whether the record was deleted
entity_id	int, unsigned	No		The associated entity ID
revision_id	int, unsigned	Yes		NULLThe revision ID
language	varchar(32) No			Language associated with this entity
delta	int, unsigned	No		The sequence number for this data item, used for multi-value fields
body_value	text:big Yes		NULL	The content stored in the body
body_summary	text:big Yes		NULL	The summary of the content stored in the body
body_format	int, unsigned	Yes	NULL	The format of the content stored in the body

►The field_data_comment_body stores information aboutcomments associated with an entity.

field_data_comment_body

Name	Type	Null	Default	Description
etid	serial, unsigned	No		Entity ID
bundle	varchar(128)	No		Bundle associated with this entity
deleted	int:tiny	No	0	A Boolean that signifies whether the record was deleted
entity_id	int	No		The associated entity ID
revision_id	int	Yes	NULL	The revision ID
language	varchar(32)	No		Language associated with this entity
delta	int	No		The sequence number for this data item, used for multi-value fields
comment_body_value	text:big	Yes	NULL	The contents of the comment body
comment_body_format	int	Yes	NULL	The format of the comment body

►The field_data_field_image table stores information about images associated with an entity.

field_data_field_image

Name	Type	Null	Default	Description
etid	serial	No		Entity ID
bundle	varchar(128)	No		Bundle associated with this entity
deleted	int:tiny	No	0	A Boolean that signifies whether the record was deleted
entity_id	int	No		The associated entity ID
revision_id	int	Yes	NULL	The revision ID
language	varchar(32)	No		Language associated with this entity
delta	int	No		The sequence number for this data item, used for multi-value fields
field_image_fid	int	Yes	NULL	The File ID of the image
field_image_alt	varchar(128)	Yes	NULL	The ALT tag associated withthe image
field_image_title	varchar(128)	Yes	NULL	The title associated with the image

►This is the table that stores information about tags associated with an entity.

field_data_field_tags

Name	Type	Null	Default	Description
etid	serial	No		Entity ID
bundle	varchar(128) No	No		Bundle associated with this entity
deleted	int:tiny No	No	0	A Boolean that signifies whether the record was deleted
entity_id	int No	No		The associated entity ID
revision_id	int Yes		NULL	The revision ID
language	varchar(32)	No		Language associated with this entity
delta	int	No		The sequence number for this data item, used for multi-value fields
field_tags_tid	int	Yes	NULL	The taxonomy term ID associated with the entity’s tags

►The field_data_taxonomy_foirums table stores information about taxonomy terms associated with forums.

field_data_taxonomy_forums

Name	Type	Null	Default	Description
etid	serial	No		Entity ID
bundle	varchar(128)	No		Bundle associated with this entity
deleted	int:tiny	No	0	A Boolean that signifies whether the record was deleted
entity_id	int	No		The associated entity ID
revision_id	int	Yes	NULL	The revision ID
language	varchar(32)	No		The language associated with the entity
delta	int	No		The sequence number for this data item, used for multi-value fields
taxonomy_forums_tid	int	Yes	NULL	The term ID associated with the forum

►The field_revision_body table stores information about revisions to body fields.

field_revision_body

Name	Type	Null	Default	Description
etid	serial, unsigned	No		Entity ID
bundle	varchar(128)	No		Bundle associated with this entity
deleted	int:tiny	No	0	A Boolean that specifies whether this record has been deleted
entity_id	int	No		Associated entity ID
revision_id	int	Yes	NULL	Revision ID
language	varchar(32)	No		Language associated with this entity
delta	int No	No		The sequence number for this data item, used for multi-value fields
body_value	text:big	Yes	NULL	Value stored in the body of the entity
body_summary	text:big	Yes	NULL	Summary of the body text
body_format	int	Yes	NULL	Format of the body text

►The field_revision_comment_body table stores information about revisions to comments.

field_revision_comment_body

Name	Type	Null	Default	Description
etid	serial, unsigned	No		The entity type id of the entity the field isattached to
bundle	varchar(128)	No		Bundle associated with this entity
deleted	int:tiny	No	0	A Boolean that specifies whether this record has been deleted
entity_id	int	No		Associated entity ID
revision_id	int	Yes	NULL	The entity revision id thisdata is attached to
language	varchar(32)	No		Language associated with this entity
delta	int, unsigned	No		The sequence number for this data item, used for multi-value fields
comment_body_value	text:big	Yes	NULL	Value associated with the body of the comment
comment_body_format	int, unsigned	Yes	NULL	Format associated withthe comment body

► The field_revision_field_image table stores information about revisions to images.

field_revision_field_image

Name	Type	Null	Default	Description
etid	serial No	No		Entity ID
bundle	varchar(128)	No		Bundle associated with this entity
deleted	int:tiny	No	0	A Boolean that specifies whether this record has been deleted
entity_id	int	No		Associated entity ID
revision_id	int	Yes	NULL	Revision ID
language	varchar(32)	No		Language associated with this entity
delta	int, unsigned	No		The sequence number for this data item, used for multi-value fields
field_image_fid	int, unsigned	Yes	NULL	File ID of the image
field_image_alt	varchar(128)	Yes	NULL	ALT tag associated with this image
field_image_title	varchar(128)	Yes	NULL	Title associated with this image

►The field_revision_field_tagstable stores information about revisions to taxonomy terms/tagsassociated with an entity.

field_revision_field_tags

Name	Type	Null	Default	Description
etid	serial, unsigned	No		Entity ID
bundle	varchar(128)	No		Bundle associated with this entity
deleted	int:tiny	No	0	A Boolean that signifies whether this record was deleted
entity_id	int, unsigned	No		Associated entity ID
revision_id	int, unsigned	Yes	NULL	Revision ID
language	varchar(32)	No		Language associated with this entity
delta	int, unsigned	No		The sequence number for this data item, used for multi-value fields
field_tags_tid	int	Yes	NULL	Term ID of the associated tags

►The field_revision_taxonomy_forums table stores information about revisions to taxonomy termsassociated with forums.

field_revision_taxonomy_forums

Name	Type	Null	Default	Description
etid	serial, unsigned	No		Entity ID
bundle	varchar(128)	No		Associated bundle
deleted	int:tiny	No	0	A Boolean that signifies whether the record was deleted
entity_id	int, unsigned	No		Associated entity ID
revision_id	int, unsigned	Yes	NULL	Revision ID
language	varchar(32)	No		Language associated withthis instance
delta	int, unsigned	No		The sequence number for this data item, used for multi-value fields
taxonomy_forums_tid	int, unsigned	Yes	NULL	Term ID of the forum associated with this entity

►The files_managed table stores information about uploaded files.

files_managed

Name	Type	Null	Default	Description
fid	serial, unsigned autoincrement	No		Primary key: unique files ID
uid	int,unsigned	No	0	The {users}.uid of the user who is associated with the file
filename	varchar(255)	No		Name of the file
uri	varchar(255)	No		Path of the file relative to Drupal root
filemime	varchar(255)	No		The file MIME type
filesize	int,unsigned	No	0	The size of the file in bytes
status	int	No	0	A flag indicating whether file is temporary (0) orpermanent (1)
timestamp	int,unsigned	No	0	Unix timestamp for when the file was added

►The file_usage table stores information for tracking where a file is used.

file_usage(systemmodule)

Name	Type	Null	Default	Description
fid	int.unsigned	No		File ID of the field being tracked
module	varchar(255)	No	NULL	The name of the module that is using the file
type	varchar(64)	No	NULL	The name of the object type in which the file is used
id	int,unsigned	No	0	The primary key of the object using the file
count	int,unsigned	No	0	The number of times this file is used by this object

►The filter table maps filters (HTML corrector) to text formats (Filtered HTML)

filter(filtermodule)

Name	Type	Null	Default	Description
format	int	No	0	The {filter_format}.format to which this filter is assigned
module	varchar(64)	No		The origin module of the filter
name	varchar(32)	No		Name of the filter being referenced
weight	int	No	0	Weight of filter within format
status	int	No	0	Filter enabled status (1= enabled, 0= disabled)
settings	longblob	Yes	NULL	A serialized array of name/value pairs that store the filter settings for the specific format

►The filter_format table stores input formats, which are custom groupings of filters such as Filtered HTML.

filter_format (filter module)

Name	Type	Null	Default	Description
format	serial, autoincrement	No		Primary key: unique ID for format
name	varchar(255)	No		Name of the input format (e.g., Filtered HTML)
cache	int:tiny	No	0	Flag to indicate whether format is cacheable (1= cacheable, 0= not cacheable)
weight	int:tiny	No	0	Weight of filter within format

►The flood table controls the threshold of events, such as the number of contact attempts.

flood

Name	Type	Null	Default	Description
fid	serial,autoincrement	No		Primary key: unique flood event ID
event	varchar(64)	No		Name of event (e.g., contact)
identifier	varchar(128)	No		Identifier of the visitor, such as an IP address orhostname
timestamp	int	No	0	Timestamp of the event
expiration	int	No	0	Expiration timestamp; expired events are purged on cron run.

►The forum table stores the relationship of nodes to forumterms.

forum (forum module)

Name	Type		Null	Default	Description
nid	int,unsigned		No	0	The {node}.nid of the node
vid	int,unsigned		No	0	Primary key: the {node}.vid of the node
tid	int,unsigned		No	0	The {taxonomy_term_data}.tid of the forum termassigned to the node

►The forum_index table maintains de-normalized information about node/term relationships.

forum_index (forum module)

Name	Type	Null	Default	Description
nid int,	unsigned	No	0	The {node}.nid this record tracks
title	varchar(255)	No		The title of this node, always treated as non-markup plain text
tid int,	unsigned	No	0	The term ID
sticky	int:tiny	Yes	0	Boolean indicating whether the node is sticky
created	int,unsigned	No	0	The Unix timestamp when the node was created
last_comment_timestamp	int	No	0	The Unixtimestamp of the last commentthat was posted within this node, from {comment}.timestamp
comment_count	int,unsigned	No	0	The total number of comments on this node

►The history table stores a record of which users have read which nodes.

history (node module)

Name	Type	Null	Default	Description
uid	int	No	0	The {users}.uid that read the {node}.nid
nid	int	No	0	The {node}.nid that was read
timestamp	int	No	0	The Unixtimestamp at which the read occurred

►The image_effects table stores configuration options for image effects.

image_effects

Name	Type	Null	Default	Description
ieid	serial, unsigned autoincrement	No		The primary identifier for an image effect
isid	int, unsigned	No	0	The {image_styles}.isid for an image style
weight	int	No	0	The weight of the effect in the style
name	varchar(255)	No		The unique name of the effect to be executed
data	longblob	No		The configuration data for the effect

►The image_styles table stores configurationoptions for image styles.

image_styles

Name	Type	Null	Default	Description
isid	serial, unsigned auto increment	No		The primary identifier for an image style
name	varchar(255)	No		The style name

►The languages table stores a list of all available languages in the system.

languages (locale module)

Name	Type	Null	Default	Description
language	varchar(12)	No		Language code, for example, de oren-US
name	varchar(64)	No		Language name in English
native	varchar(64)	No		Native language name
direction	int	No	0	Direction of language (0for left-to-right,1 for right-to-left)
enabled	int	No	0	Enabled flag (1 for enabled,0 for disabled)
plurals	int	No	0	Number of plural indexes in this language
formula	varchar(128)	No		Plural formula in PHP code to evaluate to get plural indexes
domain	varchar(128)	No		Domain to use for this language
prefix	varchar(128)	No		Path prefix touse for this language
weight	int	No	0	Weight, used in lists of languages
javascript	varchar(32)	No		Location of the JavaScript translation file

►The locales_source table stores a list ofthe English source strings.

locales_source (locale module)

Name	Type	Null	Default	Description
lid	serial,autoincrement	No		Unique identifier of this string
location	varchar(255)	No		Drupal path in case of online discovered translations or file path in case of importedstrings
textgroup	varchar(255)	No	'default'	A module-defined group of translations; see hook_locale().
source	blob	No		The original string in English
context	varchar(255)	No		The context this string applies to
version	varchar(20)	No	'none'	Version of Drupal where the string was last used (for locales optimization)

►The locales_target table stores translated versions of strings.

locales_target (locale module)

Name	Type	Null	Default	Description
lid	int	No	''	Source string ID, references {locales_source}.lid
translation	blob	No		Translation string value in this language
language	varchar(12)	No		Language code, references {languages}.language
plid	int	No	0	Parent lid (lid of the previous string in theplural chain) in case of plural strings, references {locales_source}.lid
plural	int	No	0	Plural index number in case of plural strings

►The menu_custom table holds definitions for top-level custom menus (for example, primary links).

menu_custom (menu module)

Name	Type	Null	Default	Description
menu_name	varchar(32)	No		Primary key: unique key for menu; this is used as a block delta so the length is32 to match{blocks}.delta.
title	varchar(255)	No		Menu title, displayed at top of block
description	text	Yes		Menu description

►The menu_links table contains the individual links within a menu. The menu_router table maps paths to various callbacks (e.g., access, page, and title callbacks). The node table is the base table for nodes.

menu_links (menu module)

Name	Type	Null	Default	Description
menu_name	varchar(32)	No		The menu name; all links with the same menu name (such asnavigation) are part of the same menu.
mlid	serial,unsigned auto increment	No		The menu link ID is the integer primary key.
plid	int,unsigned	No		0The parent link ID is the mlid of the link above in the hierarchy, or 0if the link is atthe top level in itsmenu.
link_path	varchar(255)	No		The Drupal path or external path this link points to
router_path	varchar(255)	No		For links corresponding to a Drupal path (0 means external), this connects the link to a {menu_router}.path for joins.
link_title	varchar(255)	No		The text displayed for the link, which may be modified by a title callback stored in{menu_router}
options	blob	Yes		A serialized array of options to be passed tothe url() or l() function, such as a query string orHTML attributes
module	varchar(255)	No	'system'	The name of the module that generated this link
hidden	int:small	No	0	A flag for whether the link should be rendered in menus (1 indicates a disabled menu item that may be shown on admin screens; -1, a menu callback;and 0, a normal, visible link)
external	int:small	No	0	A flag to indicate if the link points to a full URL starting with aprotocol, likehttp://(1 for external and 0 for internal)
has_children	int:small	No	0	Flag indicating whether any links have this link as a parent; 1 means children exist; 0 means there are nochildren.
expanded	int:small	No	0	Flag for whether this link should be rendered as expanded in menus; expanded links have their child links displayed always, instead of only when the linkis in the active trail (1 means expanded, and 0 means not expanded).
weight	int	No	0	Link weight among links in the same menu at the same depth
depth	int:small	No	0	The depth relative to the top level; a link withplid == 0 will have depth ==1.
customized	int:small	No	0	A flag to indicate thatthe user has manually created or edited the link (1 means customized, and 0 means not customized)
p1	int,unsigned	No	0	The first mlid in the materialized path; if N = depth, then pN must equal the mlid. Ifdepth >1, thenp(N-1) must equal the plid. All pX where X > depthmustequal 0. The columns p1 . . . p9 are also called the parents.
p2	int,unsigned	No	0	The second mlid in the materialized path; see p1.
p3	int,unsigned	No	0	The third mlid in the materialized path; see p1.
p4	int,unsigned	No	0	The fourth mlid in the materialized path; see p1.
p5	int,unsigned	No	0	The fifth mlid in the materialized path; see p1.
p6	int,unsigned	No	0	The sixth mlid in the materialized path; see p1.
p7	int,unsigned	No	0	The seventh mlid in the materialized path; see p1.
p8	int,unsigned	No	0	The eighth mlid in the materialized path; see p1.
p9	int,unsigned	No	0	The ninth mlid in the materialized path; see p1.
updated	int:small		0	Flag that indicates that this link was generated during the update from Drupal 5

►The menu_router table maps paths to various callbacks (e.g., access, page, and title callbacks).

menu_router

Name	Type	Null	Default	Description
path	varchar(255)	No		Primary key: the Drupal path this entry describes
load_functions	blob	No		A serialized array of functionnames (like node_load) to be called to load an object corresponding to a part of the current path
to_arg_functions	blob	No		A serialized array of functionnames (like user_uid_optional_to_arg) to be called to replace a part of the router path with another string
access_callback	varchar(255)	No		The callback that determines the access to this router path; defaults touser_access
access_arguments	blob	Yes		A serialized array of arguments for the access callback
page_callback	varchar(255)	No		The name of the function that renders the page
page_arguments	blob	Yes		A serialized array of arguments for the page callback
delivery_callback	varchar(255)	No	NULL	The name of the function that sends the result of the page_callback function to the browser
fit	int	No	0	A numeric representation of how specific the path is
number_parts	int:small	No	0	Number of parts in this router path
context	int	No	0	Only for local tasks (tabs); the context of a local task to control its placement
tab_parent	varchar(255)	No		Only for local tasks (tabs); the router path of the parent page (which may also be a local task)
tab_root	varchar(255)	No		Router path of the closest nontab parent page; for pages that are not local tasks, this will be the same as the path.
title	varchar(255)	No		The title for the current page or the title for the tab if this is a local task
title_callback	varchar(255)	No		A function that will alter the title; defaultsto t()
title_arguments	varchar(255)	No		A serialized array of arguments for the title callback; if empty, the title will be used as the sole argument for the title callback.
type	int	No	0	Numeric representation of the type of the menu item, like MENU_LOCAL_TASK
theme_callback	varchar(255)	No	NULL	A function that returns the name of the theme that will be used to render this page; if left empty, the default theme will be used.
theme_arguments	varchar(255)	No	NULL	A serialized array of arguments for the theme callback
block_callback	varchar(255)	No		Name of a function used to render the blockon the system administration page for this menu item
description	text	No		A description of this menu item
position	varchar(255)	No		The position of the block (left or right) onthe system administration page for this menu item
weight	int	No	0	Weight of the element; lighter weights are higher up; heavier weights move down.
include_file	text:medium	Yes		The file to include for this element; usually the page callback function lives in this file.

►The node table is the base table for nodes.

node(nodemodule)

Name	Type	Null	Default	Description
nid	serial, unsigned auto increment	No		The primary identifier for a node
vid	int,unsigned	No	0	The current {node_revisions}.vid version identifier
type	varchar(32)	No		The {node_type}.type of this node
language	varchar(12)	No		The {languages}.language of this node
title	varchar(255)			The title of this node, always treated as non-markup, plain text
uid	int	No	0	The {users}.uid that owns this node; initially, the user who created it
status	int	No	1	Boolean value indicating whether the node is published (visible to non-administrators)
created	int	No	0	The Unix timestamp when the node was created
changed	int	No	0	The Unix timestamp when the node was most recently saved
comment	int	No	0	Whether comments are allowed on this node: 0 means no; 1 means comments are read-only; and 2 means comments can be read or written.
promote	int	No	0	Boolean value indicating whether the node should be displayed on the front page
sticky	int	No	0	Boolean value indicating whether the node should be displayed at the top of lists in which it appears
tnid	int,unsigned	No	0	The translation set ID for this node, which equals the node ID of the source post in each set
translate	int	No	0	A Boolean value indicating whether this translation page needs to be updated

► The node_access table identifies which realm/grant pairs a user must possess in order to view, update, or delete specific nodes

node_access (node module)

Name	Type	Null	Default	Description
nid	int,unsigned	No	0	The {node}.nid this record affects
gid	int,unsigned	No	0	The grant ID a user must possess in the specified realm to gain this row’s privileges on the node
realm	varchar(255)	No		The realm in which the user must possess the grant ID; each node-access node can define one or more realms.
grant_view	int:tiny,unsigned	No	0	Boolean value indicating whether a user with the realm/grant pair can view this node
grant_update	int:tiny,unsigned	No	0	Boolean value indicating whether a user with the realm/grant pair can edit this node
grant_delete	int:tiny,unsigned	No	0	Boolean value indicating whether a user with the realm/grant pair can delete this node

►The node_comment_statistics table maintains statistics ofnodes and comments posts to show “new” and “updated” flags.

node_comment_statistics (comment module)

Name	Type	Null	Default	Description
nid	int,unsigned	No	0	The {node}.nidfor which thestatistics are compiled
cid	int	No	0	The {comment}.cid for which the statistics are compiled
last_comment_timestamp	int	No	0	The Unixtimestamp of the lastcomment that was posted within this node, from {comments}.timestamp
last_comment_name	varchar(60)	Yes		The name of the latest author to posta comment on this node, from {comments}.name
last_comment_uid	int	No	0	The user ID of the latest author to post a comment on this node, from {comments}.uid
comment_count	int,unsigned	No	0	The total number of comments on this node

►The node_counter table stores access statistics for nodes.

node_counter (statistics module)

Name	Type	Null	Default	Description
nid	int	No	0	The {node}.nid for these statistics
totalcount	int:big,unsigned	No	0	The total number of times the {node}has been viewed
daycount	int:medium,unsigned	No	0	The total number of times the {node}has been viewed today
timestamp	int,unsigned	No	0	The most recent time the {node}has been viewed

►The node_revisions table stores information about each saved version ofa node.

node_revision (node module)

Name	Type	Null	Default	Description
nid	int,unsigned	No	0	The {node} this version belongs to
vid	serial, unsigned auto increment	No		The primary identifier for this version
uid	int	No	0	The {users}.uid that created this version
title	varchar(255)	No		The title of thisversion
log	text:long	No		The log entry explaining the changes in thisversion
timestamp	int	No	0	A Unix timestamp indicating when this version was created
status	int	No	1	Boolean indicating whether the node (at the time ofthis revision)is published (visible to non-administrators)
comment	int	No	0	Whether comments are allowed on this node (at the time of this revision): 0= no, 1= closed (readonly), 2= open (read/write).
promote	int	No	0	Boolean indicating whether the node (at the time ofthis revision) should be displayed on the front page
sticky	int	No	0	Boolean indicating whether the node (at the time ofthis revision) should be displayed at the top of lists in which it appears

►The node_type table stores information about all defined {node} types.

node_type (node module)

Name	Type	Null	Default	Description
type	varchar(32)	No		The machine-readable name of this type
name	varchar(255)	No		The human-readable name of this type
base	varchar(255)	No		The base string used to constructcallbacks corresponding to this node type
description	text:medium	No		A brief description of this type
help	text:medium	No		Help information shown to the user when creating a node of this type
has_title	int:tiny,unsigned	No		Boolean value indicating whether this type uses the {node}.title field
title_label	varchar(255)	No		The label displayed for the title field on the edit form
custom	int:tiny	No	0	A Boolean value indicating whether this type is defined by a module (0) or by a user via a module like the Content Construction Kit (1)
modified	int:tiny	No	0	A Boolean value indicating whether this type has been modified by an administrator; currently not used in any way
locked	int:tiny	No	0	A Boolean value indicating whether the administrator can change the machine name of this type
orig_type	varchar(255)	No		The original machine-readable name ofthis node type; this may be different from the current type name if the lockedfield is 0.

►The opened_association table stores temporary shared key association information for OpenID authentication.

openid_association (openid module)

Name	Type	Null	Default	Description
idp_endpoint_uri	varchar(255)	Yes		URI of the OpenID provider endpoint
assoc_handle	varchar(255)	No		Primary key: used to refer to this association in subsequentmessages
assoc_type	varchar(32)	Yes		The signature algorithm used: HMAC-SHA1 orHMAC-SHA256
session_type	varchar(32)	Yes		Valid association session types: no-encryption, DH-SHA1, and DH-SHA256
mac_key	varchar(255)	Yes		The MAC key (shared secret)for thisassociation
created	int	No	0	Unixtimestamp for when the association was created
expires_in	int	No	0	The lifetime, in seconds, ofthis association

►The opened_nonce table stores received opened.response_nonce per OpenID endpoint URL toprevent relay attacks.

openid_nonce (openid module)

Name	Type	Null	Default	Description
description	varchar(255)	Yes		URI of the OpenID Provider endpoint
nonce	varchar(255)	Yes		The value of opened.response_nonce
expires	int	No	0	A Unix timestamp indicating when the entryshould expire

►The poll table stores poll-specific information for poll nodes.

poll (poll module)

Name	Type	Null	Default	Description
nid	int,unsigned	No	0	The poll’s {node}.nid
runtime	int	No	0	The number of seconds past{node}.createdduring which the poll is open
active	int,unsigned	No	0	Boolean value indicating whether the poll is open

►The poll_choice table stores information about all choices for all polls.

poll_choice (poll module)

Name	Type	Null	Default	Description
chid	serial, unsigned auto increment	No		Primary key: unique identifier for a poll choice
nid	int,unsigned	No	0	The {node}.nid this choice belongs to
chtext	varchar(128)	No		The text for this choice
chvotes	int	No	0	The total number of votes this choice has received by all users
weight	int	No	0	The sort order of this choice among all choices for the same node

►The poll_vote table stores per-user votes for each poll.

poll_vote (poll module)

Name	Type	Null	Default	Description
chid	int,unsigned	No	0	Unique identifier for a poll choice
nid	int,unsigned	No		The {poll} node this vote is for
uid	int,unsigned	No	0	The {users}.uid this vote is from, unless the voter was anonymous
hostname	varchar(128)	No		The IP address this vote is from, unless the voter was logged in
timestamp	int	No		The timestamp of the vote creation

►The profile_field table stores profile field information. The profile_value table stores values for profile fields.

profile_field (profile module)

Name	Type	Null	Default	Description
fid	serial, auto increment	No		Primary key: unique profile field ID
title	varchar(255)	Yes		Title of the field shown to the end user
name	varchar(128)	No	''	Internal name of the field used in the form HTML and URLs
explanation	text	Yes		Explanation of the field to end users
category	varchar(255)	Yes		Profile category that the fieldwill be grouped under
page	varchar(255)	Yes		Title of page used for browsing by the field’svalue
type	varchar(128)	Yes		Type of form field
weight	int	No	0	Weight of field in relation to other profile fields
required	int:tiny	No	0	Whether the user is required to enter a value (0 for no and1 for yes)
register	int:tiny	No	0	Whether the field is visible in the user registration form (1for yes and 0 for no)
visibility	int:tiny	No	0	The level of visibility for the field (0for hidden, 1for private, 2 for public on profile pages but noton member list pages, and 3 for public on profile and list pages)
autocomplete	int:tiny	No	0	Whether form automatic completion isenabled (0 for disabled and 1 for enabled)
options	text	Yes		List ofoptions to be used in a list selection field

►The profile_value table stores values for profile fields.

profile_value (profile module)

Name	Type	Null	Default	Description
fid	int,unsigned	No	0	The {profile_field}.fid of the field
uid	int,unsigned	No	0	The {users}.uid of the profile user
value	text	Yes		The value for the field

►The queue table stores items in queues.

queue

Name	Type	Null	Default	Description
item_id	serial, unsigned auto increment	No		Unique item ID
name	varchar(255)	No		The queue name
data	longblob	Yes	NULL	The arbitrary data for the item
expire	int	No	0	Timestamp when the claim lease expires on the item
created	int	No	0	Timestamp when the item was created

►The rdf_mapping table stores custom RDF mappings for user-defined content types or overridden module-defined mappings.

rdf_mapping

Name	Type	Null	Default	Description
type	varchar(128)	No		The name of the entity type a mapping applies to (node, user, comment, etc.)
bundle	varchar(128)	No		The name of the bundle a mapping applies to
mapping	longblob	Yes	NULL	The serialized mapping of the bundle type and fields to RDF terms

►The registry table stores a function, class, or interface name and the file itis in.

registry

Name	Type	Null	Default	Description
name	varchar(255)	No		The name of the function, class, or interface
type	varchar(9)	No		Either function or class or interface
filename	varchar(255)	No		Name of the file
module	varchar(255)	No		Name of the module the file belongs to
weight	int	No	0	The order in which this module’s hooks should be invoked relative to other modules; equal-weighted modules are ordered by name.

►The registry_file stores information about files that were parsed to build the registry.

registry_file

Name	Type	Null	Default	Description
filename	varchar(255)	No		Path to the file
hash	varchar(64)	No		sha-256 hash of the file’s contents when last parsed

►The role table stores user roles.

role (user module)

Name	Type	Null	Default	Description
rid	serial, unsigned auto increment	No		Primary key: unique role ID
name	varchar(64)	No		Unique role name
weight	int	No	0	The weight of this role in listings and the user interface

►The role_permission table stores permissions for users.

role_permission (usermodule)

Name	Type	Null	Default	Description
rid	int,unsigned	No	0	The {role}.rid to which the permissions are assigned
permission	varchar(64)	No		A single permission granted to the role identified by rid
module	varchar(255)	No		The module declaring the permission

►The search_dataset table stores items that will be searched..

search_dataset (searchmodule)

Name	Type	Null	Default	Description
sid	int,unsigned	No	0	Search item ID, for example, the node ID for nodes
type	varchar(16)	Yes		Type of item, for example, node
data	text:big	No		List of space-separated words from the item
reindex	int, unsigned	No	0	Set to force node reindexing

►The search_index table stores the search index and associates words, items, and scores

search_index (searchmodule)

Name	Type	Null	Default	Description
word	varchar(50)	No		The {search_total}.word that is associated with the search item
sid	int,unsigned	No	0	The {search_dataset}.sid of the searchable item to which the word belongs
type	varchar(16)	Yes		The {search_dataset}.type of the searchable item to which the word belongs
score	float	Yes		The numeric score of the word, higher being more important

►The search_node table stores items (like nodes) that link to other nodes; itis used to improve search scores for nodes that are frequently linked to.

search_node_links (search module)

Name	Type	Null	Default	Description
sid	int,unsigned	No	0	The {search_dataset}.sid of the searchable item containing the link to the node
type	varchar(16)	No		The {search_dataset}.type of the searchable item containing the link to the node
nid	int,unsigned	No	0	The {node}.nid that this item linksto
caption	text:big	Yes		The text used to link to the {node}.nid

►The search_total table stores search totals for words.

search_total (search module)

Name	Type	Null	Default	Description
word	varchar(50)	No		Primary key: unique word in the search index
count	float	Yes		The count of the word in the index using Zipf’s law to equalize the probability distribution

►The semaphore table stores semaphores, locks, and flags.

semaphore

Name	Type	Null	Default	Description
name	varchar(255)	No		Unique name
value	varchar(255)	No		A value for the semaphore
expire	double	No		A Unixtimestamp with microseconds indicating when the semaphore should expire

► The sequences table stores IDs.

sequences

Name	Type	Null	Default	Description
value	int	No		he value of the sequence

►The sessions table stores information abouta user session, either anonymous or authenticated.

sessions

Name	Type	Null	Default	Description
uid	int,unsigned	No		The {users}.uid corresponding to a session or0 for anonymous user
sid	varchar(64)	No		Primary key: a session ID. The value is generated by PHP’s Session API.
ssid	varchar(128)	No		Secure session ID; the value is generated by PHP’s Session API.
hostname	varchar(128)	No		The IP address that last used this session ID (sid)
timestamp	int	No	0	The Unix timestamp when this session lastrequested a page; old records are purged by PHP automatically. See sess_gc().
cache	int	No	0	The time of this user’s last post; this is used when the site has specified a minimum_cache_lifetime. See cache_get().
session	blob:big	Yes		The serialized contents of $_SESSION, an array of name/value pairs that persists across page requests by this session ID; Drupal loads $_SESSION from here at the start of each request and saves it atthe end.

►The shortcut_set table stores information about sets of shortcuts links.

shortcut_set

Name	Type	Null	Default	Description
set_name	varchar(32)	No		The {menu_links}.menu_name under which the set’s links are stored
title	varchar(255)	No		The title of the set

►The shortcut_set_users table stores information that maps users to shortcut sets.

shortcut_set_users

Name	Type	Null	Default	Description
uid	int	No	0	The {users}.uid for this set
set_name	varchar(32)	No		The {shortcut_set}.set_name that will be displayed for this user

►The simpletest table stores simple test messages.

simpletest

Name	Type	Null	Default	Description
message_id	serial, auto increment	No		Unique simpletest message ID
test_id	int	No	0	Test ID; messages belonging to the same ID are reported together.
test_class	varchar(255)	No		The name of the class that created this message
status	varchar(9)	No		Message status; core understands pass, fail, exception.
message	text	No		The message itself
message_group	varchar(255)	No		The message group this message belongs to, for example: warning, browser, user
function	varchar(255)	No		Name of the assertion function or method thatcreated this message
line	int	No	0	Line number on which the function is called
file	varchar(255)	No		Name of the file where the function is called

►The simpletest_test_id table stores simpletest test IDs, used to auto-increment the test ID so that afresh test ID is used.

simpletest_test_id

Name	Type	Null	Default	Description
test_id	serial, auto increment	No		Unique simpletest ID used togroup test results together; each time a set of tests are run, a new testID is used.
last_prefix	varchar(60)	Yes		The last database prefix used during testing

►The system table contains a list of all modules, themes, and theme engines that are or have been installed in Drupal’s file system.

system

Name	Type	Null	Default	Description
filename	varchar(255)	No		The path of the primary file for this item, relative to the Drupal root; e.g., modules/node/node.module
name	varchar(255)	No		The name of the item; for example, node
type	varchar(12)	No		The type of the item: module, theme, or theme_engine
owner	varchar(255)	No		A theme’s “parent”; can be either a theme or an engine
status	int	No	0	Boolean value indicating whether this item is enabled
bootstrap	int	No	0	Boolean value indicating whether this module is loaded during Drupal’s early bootstrapping phase (e.g., even before the page cache is consulted)
schema_version	int:small	No	-1	The module’s database schema version number; -1 if the module is not installed (itstables do not exist); if the module is installed, 0 or the largest N of the module’s hook_update_N() function that has either been run or existed when the module was first installed
weight	int	No	0	The order in which this module’s hooks should be invoked relative to other modules;equally weighted modules are ordered by name.
info	blob	Yes		A serialized array containing information from the module’s .info file; keys can include name, description, package, version, core, dependencies, dependents, and php.

►The taxonomy_index table maintains de-normalized information aboutnode/term relationships.

taxonomy_index

Name	Type	Null	Default	Description
nid	int,unsigned	No	0	The {node}.nid this record tracks
tid	int,unsigned	No	0	The term ID
sticky	int:tiny	Yes	0	Boolean indicating whether the node is sticky
created	int	No	0	The Unix timestamp when the node was created

►The taxonomy_term_data table stores term information.

taxonomy_term_data (taxonomy module)

Name	Type	Null	Default	Description
tid	serial,unsigned auto increment	No		Primary key: unique term ID
vid	int,unsigned	No	0	The {taxonomy_vocabulary}.vid of the vocabulary to which the term is assigned
name	varchar(255)	No		The term name
description	text:big	Yes		A description of the term
format	int:small	No	0	The {filter_format}.format of the description
weight	int	No	0	The weight of this term in relation to other terms

►The taxonomy_term_hierarchy table stores the hierarchical relationship between terms.

taxonomy_term_hierarchy (taxonomy module)

Name	Type	Null	Default	Description
tid	int,unsigned	No	0	Primary key: the {taxonomy_term_data}.tid of the term
parent	int, unsigned	No	0	Primary key: the {taxonomy_term_data}.tid of the term’s parent; 0 indicates no parent.

►The taxonomy_vocabulary_module stores vocabulary information.

taxonomy_vocabulary

Name	Type	Null	Default	Description
vid	serial,unsigned auto increment	No		Unique vocabulary ID
name	varchar(255)	No		Name of the vocabulary
machine_name	varchar(255)	No		The vocabulary machine name
description	text:big	Yes	NUll	Description ofthe vocabulary
hierarchy	int:tiny	No	0	The type of hierarchy allowed within the vocabulary. (0= disabled, 1= single, 2= multiple)
module	varchar(255)	No		The module that created the vocabulary
weight	int	No	0	The weight of this vocabulary in relation to other vocabularies

►The tracker_node table stores information about when nodes were last changed or commented on.

tracker_node

Name	Type		Null	Default	Description
nid	int		No 0		The {node}.nid this record tracks
published	int:tiny		Yes	0	Boolean indicating whether the node is published
changed	int		No	0	The Unix timestamp when the node was most recently saved or commented on

The tracker_user table stores information about when nodes were last changed or commented on, for each user that authored the node or one of its comments.

tracker_user

Name	Type		Null	Default	Description
nid	int,unsigned		No	0	The {node}.nid this record tracks
uid	int		No	0	The {users}.uid of the node author or commenter
published	int:tiny		Yes	0	Boolean indicating whether the node is published
changed	int		No	0	The Unix timestamp when the node was most recently saved or commented on

►The trigger_assignments table maps triggers to hook and operation assignments from the trigger module.

trigger_assignments (trigger module)

Name	Type	Null	Default	Description
hook	varchar(32)	No		Primary key: the name of the internal Drupal hookonwhich an action is firing; for example, user
aid	varchar(255)	No		Primary key: the action’s{actions}.aid
weight	int	No	0	The weight of the trigger assignment in relation toother triggers

►The url_alias table contains a list of URL aliases for Drupal paths; a user may visit either the sourceor destination path.

url_alias (path module)

Name	Type	Null	Default	Description
pid	serial, unsigned auto increment	No		A unique path alias identifier
source	varchar(255)	No		The Drupal path this alias is for, for example, node/12
alias	varchar(255)	No		The alias for this path, for example, title-of-the-story
language	varchar(12)	No		The language this alias is for; if blank, the alias will be used for unknown languages. Each Drupal path can have an alias for each supported language.

►The users table stores user data.

users (user module)

Name	Type	Null	Default	Description
uid	serial,unsigned	No		Primary key: unique user ID
name	varchar(60)	No		Unique username
pass	varchar(128)	No		User’s password (hashed)
mail	varchar(255)	Yes		User’s e-mail address
theme	varchar(255)	No		User’s default theme
signature	varchar(255)	No		User’s signature
signature_format	int:small	No	0	The {filter_format}.format of the signature
created	int	No	0	Timestamp for when user was created
access	int	No	0	Timestamp for previous time user accessed the site
login	int	No	0	Timestamp for user’s last login
status	int:tiny	No	0	Whether the user is active (1) or blocked (0)
timezone	varchar(8)	Yes		User’s time zone
language	varchar(12)	No		User’s default language
picture	int	Yes		Foreign key: {file_managed}. fid of user’spicture
init	varchar(254)	Yes		E-mail address used for initial account creation
data	longblob	Yes		A serialized array of name/value pairs that are related to the user; any form values posted during user edit are stored and loaded into the $user object during user_load(). Use of this field is discouraged, and it will likely disappear in a future version of Drupal.

►The users_roles table maps users to roles.

users_roles (users)

Name	Type	Null	Default	Description
uid	int,unsigned	No	0	Primarykey:{users}.uid foruser
rid	int,unsigned	No	0	Primarykey:{role}.rid forrole

►The variable table stores variable/value pairs created by Drupal core or any other module or theme. All variables are cached in memory at the start of every Drupal request, so developers should not be careless about what is stored here.

variable

Name	Type		Null	Default	Description
name	varchar(128)		No		Primary key: the name of the variable
value	longblob		No		The value of the variable

►The watchdog table contains logs of all system events

watchdog (dblogmodule)

Name	Type	Null	Default	Description
wid	serial, auto increment	No		Primary key: unique watchdog event ID
uid	int	No	0	The {users}.uid of the user who triggered the event
type	archar(64)	No	''	Type of log message, for example user or page not found
message	text:big	No		Text of log message to be passed into the t() function
variables	blob	No		Serialized array of variables that match the message string and that is passed into the t() function
severity	int:t iny, unsigned	No	0	The severity level of the event; ranges from 0 (Emergency) to 7 (Debug)
link	varchar(255)	No	''	Link to view the result of the event
location	text	No		URL of the origin of the event
referer	varchar(128)	No	''	URL of referring page
hostname	varchar(128)	No	''	Hostname of the user who triggered the event
timestamp	int	No	0	Unix timestamp of when event occurred