基本資料表清單

1 篇文章 / 0 new
author
基本資料表清單
►The accesslog table stores site access information for statistics.
accesslog (statistics module)
Name Type Null Default Description
aid serial No   Primary key: unique accesslog ID
sid varchar(64) No   Browser session ID of user who visited the page
title varchar(255) Yes   Title of the page visited
path varchar(255) Yes   Internal path to the page visited (relative toDrupal root)
url varchar(255) Yes   Referrer URI
hostname varchar(128) Yes   Hostname of the user who visited the page
uid int,unsigned Yes 0 User {users}.uid who visited the page
timer int,unsigned No 0 Time in milliseconds that the page tookto load
timestamp int,unsigned No 0 Timestamp of when the page was visited
►The actions table stores action information.
actions
Name Type Null Default Description
aid varchar(255) No   Primary key: unique actions ID
type varchar(32) No   The object that the action acts on (node, user, comment, system, or custom types)
callback varchar(255) No   The callback function that executes when the action runs
parameters longblob No   Parameters to be passed to the callback function
description varchar(255) No   Description ofthe action
►The aggregator_category table stores categories for aggregator feeds and feed items.
aggregator_category (aggregator module)
Name Type Null Default Description
cid serial No   Primary key: unique aggregator category ID
title varchar(255) No   Title of the category
description text:big No   Description ofthe category
block int:tiny No 0 The number of recent items to show within the category block
►This bridge table maps feeds to categories.
aggregator_category_feed (aggregator module)
Name Type Null Default Description
fid int No 0 The feed’s {aggregator_feed}.fid
cid int No 0 The {aggregator_category}.cid to which the feed is being assigned
►This aggregagor_category_item table maps feed items to categories.
aggregator_category_item (aggregator module)
Name Type Null Default Description
iid int No 0 The feed item’s {aggregator_item}.iid
cid int No 0 The {aggregator_category}.cid to which the feed item is being assigned
►The aggregator_feed table stores feeds to be parsed by the aggregator.
aggregator_feed (aggregator module)
Name Type Null Default Description
fid serial No   Primary key: unique feed ID
title varchar(255) No   Title of the feed
url varchar(255) No   URL to the feed
refresh int No 0 How often to check for new feed items, in seconds
checked int No 0 Last time feed was checked for new items, as a Unix timestamp
queued int No 0 Time when this feed was queued for refresh; 0 ifnot queued
link varchar(255) No   The parent web site of the feed; comes from the <link> element in the feed
description text:big No   The parent web site’s description; comes from the <description> element in the feed
image text:big No   An image representing the feed
hash varchar(64) No   Calculated hash of the feed data; used for validating cache
etag varchar(255) No '' Entity tag HTTP response header; used for validating the cache
modified int No 0 When the feed was last modified, as a Unix timestamp
block int:tiny No 0 Number of items to display in the feed’s block
►The aggregator_item table stores the individual items imported from feeds.
aggregator_item (aggregator module)
Name Type Null Default Description
iid serial   No   Primary key: unique ID for feed item
fid int   No 0 The {aggregator_feed}.fid to which this item belongs
title varchar(255) No '' Title of the feed item
link varchar(255) No '' Link to the feed item
author varchar(255) No '' Author of the feed item
description text:big No   Bodyof the feed item
timestamp int Yes   Post dateof the feed item, as a Unix timestamp
guid varchar(255) Yes   Unique identifier for the feed item
►The authmap table stores distributed authentication mapping.
authmap (user module)
Name Type Null Default Description
aid serial No   Primary key: unique authmap ID
uid int No 0 User’s {users}.uid
authname varchar(128) No '' Unique authentication name
module varchar(128) No '' Module thatis controlling the authentication
►The batch table stores details about batches (processes that run in multiple HTTP requests).
batch (batch.inc)
Name Type Null Default Description
bid serial No   Primary key: unique batch ID
token varchar(64) No   A string token generated against the current user’ssession ID and the batch ID; used to ensure that only the user who submitted the batch can effectively access it
timestamp int No   A Unix timestamp indicating when this batch was submitted for processing; stale batches are purged atcron time.
batch text:big Yes   A serialized array containingthe processing data for the batch
►The blocks table stores block settings, such as region and visibility settings.
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.
Name Type Null Default Description
field_data_field_tags
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
Free Web Hosting