Drupal 7

Drupal 7 ERD

Tables (73)

actions

  • aid — varchar(255) — Primary key — NOT NULL — Primary Key: Unique actions ID.
  • type — varchar(32) — NOT NULL — The object that that action acts on (node, user, comment, system or custom types.)
  • callback — varchar(255) — NOT NULL — The callback function that executes when the action runs.
  • parameters — longblob — NOT NULL — Parameters to be passed to the callback function.
  • label — varchar(255) — NOT NULL — Label of the action.

authmap

  • aid — int(10) — Primary key — NOT NULL — Primary Key: Unique authmap ID.
  • uid — int(11) — Foreign key → users.uid — NOT NULL — User’s users.uid.
  • authname — varchar(128) — NOT NULL — Unique authentication name.
  • module — varchar(128) — NOT NULL — Module which is controlling the authentication.

batch

  • bid — int(10) — Primary key — NOT NULL — Primary Key: Unique batch ID.
  • token — varchar(64) — NOT NULL — A string token generated against the current user’s session id and the batch id, used to ensure that only the user who…
  • timestamp — int(11) — NOT NULL — A Unix timestamp indicating when this batch was submitted for processing. Stale batches are purged at cron time.
  • batch — longblob — A serialized array containing the processing data for the batch.

block

  • bid — int(11) — Primary key — NOT NULL — Primary Key: Unique block ID.
  • module — varchar(64) — NOT NULL — The module from which the block originates; for example, ’user’ for the Who’s Online block, and ’block’ for any custom…
  • delta — varchar(32) — NOT NULL — Unique ID for block within a module.
  • theme — varchar(64) — NOT NULL — The theme under which the block settings apply.
  • status — tinyint(4) — NOT NULL — Block enabled status. (1 = enabled, 0 = disabled)
  • weight — int(11) — NOT NULL — Block weight within region.
  • region — varchar(64) — NOT NULL — Theme region within which the block is set.
  • custom — tinyint(4) — NOT NULL — Flag to indicate how users may control visibility of the block. (0 = Users cannot control, 1 = On by default, but can b…
  • visibility — tinyint(4) — NOT NULL — Flag to indicate how to show blocks on pages. (0 = Show on all pages except listed pages, 1 = Show only on listed pages…
  • pages — text — NOT NULL — Contents of the "Pages" block; contains either a list of paths on which to include/exclude the block or PHP code, depen…
  • title — varchar(255) — NOT NULL — Custom title for the block. (Empty string will use block default title, <none> will remove the title, text will cause b…
  • cache — tinyint(4) — NOT NULL — Binary flag to indicate block cache mode. (-2: Custom cache, -1: Do not cache, 1: Cache per role, 2: Cache per user, 4:…

block_custom

  • bid — int(10) — Foreign key → block.bid — NOT NULL — The block’s block.bid.
  • body — longtext — Block contents.
  • info — varchar(128) — NOT NULL — Block description.
  • format — varchar(255) — The filter_format.format of the block body.

block_node_type

  • module — varchar(64) — Primary key — NOT NULL — The block’s origin module, from block.module.
  • delta — varchar(32) — Primary key — NOT NULL — The block’s unique delta within module, from block.delta.
  • type — varchar(32) — Primary key — NOT NULL — The machine-readable name of this type from node_type.type.

block_role

  • module — varchar(64) — Primary key — NOT NULL — The block’s origin module, from block.module.
  • delta — varchar(32) — Primary key — NOT NULL — The block’s unique delta within module, from block.delta.
  • rid — int(10) — Foreign key → role.rid — NOT NULL — The user’s role ID from users_roles.rid.

blocked_ips

  • iid — int(10) — Primary key — NOT NULL — Primary Key: unique ID for IP addresses.
  • ip — varchar(40) — NOT NULL — IP address

cache

  • cid — varchar(255) — Primary key — NOT NULL — Primary Key: Unique cache ID.
  • data — longblob — A collection of data to cache.
  • expire — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry should expire, or 0 for never.
  • created — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry was created.
  • serialized — smallint(6) — NOT NULL — A flag to indicate whether content is serialized (1) or not (0).

cache_block

  • cid — varchar(255) — Primary key — NOT NULL — Primary Key: Unique cache ID.
  • data — longblob — A collection of data to cache.
  • expire — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry should expire, or 0 for never.
  • created — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry was created.
  • serialized — smallint(6) — NOT NULL — A flag to indicate whether content is serialized (1) or not (0).

cache_bootstrap

  • cid — varchar(255) — Primary key — NOT NULL — Primary Key: Unique cache ID.
  • data — longblob — A collection of data to cache.
  • expire — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry should expire, or 0 for never.
  • created — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry was created.
  • serialized — smallint(6) — NOT NULL — A flag to indicate whether content is serialized (1) or not (0).

cache_field

  • cid — varchar(255) — Primary key — NOT NULL — Primary Key: Unique cache ID.
  • data — longblob — A collection of data to cache.
  • expire — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry should expire, or 0 for never.
  • created — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry was created.
  • serialized — smallint(6) — NOT NULL — A flag to indicate whether content is serialized (1) or not (0).

cache_filter

  • cid — varchar(255) — Primary key — NOT NULL — Primary Key: Unique cache ID.
  • data — longblob — A collection of data to cache.
  • expire — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry should expire, or 0 for never.
  • created — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry was created.
  • serialized — smallint(6) — NOT NULL — A flag to indicate whether content is serialized (1) or not (0).

cache_form

  • cid — varchar(255) — Primary key — NOT NULL — Primary Key: Unique cache ID.
  • data — longblob — A collection of data to cache.
  • expire — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry should expire, or 0 for never.
  • created — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry was created.
  • serialized — smallint(6) — NOT NULL — A flag to indicate whether content is serialized (1) or not (0).

cache_image

  • cid — varchar(255) — Primary key — NOT NULL — Primary Key: Unique cache ID.
  • data — longblob — A collection of data to cache.
  • expire — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry should expire, or 0 for never.
  • created — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry was created.
  • serialized — smallint(6) — NOT NULL — A flag to indicate whether content is serialized (1) or not (0).

cache_menu

  • cid — varchar(255) — Primary key — NOT NULL — Primary Key: Unique cache ID.
  • data — longblob — A collection of data to cache.
  • expire — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry should expire, or 0 for never.
  • created — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry was created.
  • serialized — smallint(6) — NOT NULL — A flag to indicate whether content is serialized (1) or not (0).

cache_page

  • cid — varchar(255) — Primary key — NOT NULL — Primary Key: Unique cache ID.
  • data — longblob — A collection of data to cache.
  • expire — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry should expire, or 0 for never.
  • created — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry was created.
  • serialized — smallint(6) — NOT NULL — A flag to indicate whether content is serialized (1) or not (0).

cache_path

  • cid — varchar(255) — Primary key — NOT NULL — Primary Key: Unique cache ID.
  • data — longblob — A collection of data to cache.
  • expire — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry should expire, or 0 for never.
  • created — int(11) — NOT NULL — A Unix timestamp indicating when the cache entry was created.
  • serialized — smallint(6) — NOT NULL — A flag to indicate whether content is serialized (1) or not (0).

comment

  • cid — int(11) — Primary key — NOT NULL — Primary Key: Unique comment ID.
  • pid — int(11) — Foreign key → comment.cid — NOT NULL — The comment.cid to which this comment is a reply. If set to 0, this comment is not a reply to an existing comment.
  • nid — int(11) — Foreign key → node.nid — NOT NULL — The node.nid to which this comment is a reply.
  • uid — int(11) — Foreign key → users.uid — NOT NULL — The users.uid who authored the comment. If set to 0, this comment was created by an anonymous user.
  • subject — varchar(64) — NOT NULL — The comment title.
  • hostname — varchar(128) — NOT NULL — The author’s host name.
  • created — int(11) — NOT NULL — The time that the comment was created, as a Unix timestamp.
  • changed — int(11) — NOT NULL — The time that the comment was last edited, as a Unix timestamp.
  • status — tinyint(3) — NOT NULL — The published status of a comment. (0 = Not Published, 1 = Published)
  • thread — varchar(255) — NOT NULL — The vancode representation of the comment’s place in a thread.
  • name — varchar(60) — The comment author’s name. Uses users.name if the user is logged in, otherwise uses the value typed into the comment fo…
  • mail — varchar(64) — The comment author’s e-mail address from the comment form, if user is anonymous, and the ’Anonymous users may/must leav…
  • homepage — varchar(255) — The comment author’s home page address from the comment form, if user is anonymous, and the ’Anonymous users may/must l…
  • language — varchar(12) — NOT NULL — The languages.language of this comment.

date_format_locale

  • language — varchar(12) — Primary key — NOT NULL — A languages.language for this format to be used with.
  • type — varchar(64) — Foreign key → date_format_type.type — NOT NULL — The date format type, e.g. medium.
  • format — varchar(100) — NOT NULL — The date format string.

date_format_type

  • type — varchar(64) — Primary key — NOT NULL — The date format type, e.g. medium.
  • title — varchar(255) — NOT NULL — The human readable name of the format type.
  • locked — tinyint(4) — NOT NULL — Whether or not this is a system provided format.

date_formats

  • dfid — int(10) — Primary key — NOT NULL — The date format identifier.
  • format — varchar(100) — NOT NULL — The date format string.
  • type — varchar(64) — Foreign key → date_format_type.type — NOT NULL — The date format type, e.g. medium.
  • locked — tinyint(4) — NOT NULL — Whether or not this format can be modified.

field_config

  • id — int(11) — Primary key — NOT NULL — The primary identifier for a field
  • field_name — varchar(32) — NOT NULL — The name of this field. Non-deleted field names are unique, but multiple deleted fields can have the same name.
  • type — varchar(128) — NOT NULL — The type of this field.
  • module — varchar(128) — NOT NULL — The module that implements the field type.
  • active — tinyint(4) — NOT NULL — Boolean indicating whether the module that implements the field type is enabled.
  • storage_type — varchar(128) — NOT NULL — The storage backend for the field.
  • storage_module — varchar(128) — NOT NULL — The module that implements the storage backend.
  • storage_active — tinyint(4) — NOT NULL — Boolean indicating whether the module that implements the storage backend is enabled.
  • locked — tinyint(4) — NOT NULL — @TODO
  • data — longblob — NOT NULL — Serialized data containing the field properties that do not warrant a dedicated column.
  • cardinality — tinyint(4) — NOT NULL
  • translatable — tinyint(4) — NOT NULL
  • deleted — tinyint(4) — NOT NULL

field_config_instance

  • id — int(11) — Primary key — NOT NULL — The primary identifier for a field instance
  • field_id — int(11) — Foreign key → field_config.id — NOT NULL — The identifier of the field attached by this instance
  • field_name — varchar(32) — NOT NULL
  • entity_type — varchar(32) — NOT NULL
  • bundle — varchar(128) — NOT NULL
  • data — longblob — NOT NULL
  • deleted — tinyint(4) — NOT NULL

field_data_body

  • entity_type — varchar(128) — Primary key — NOT NULL — The entity type this data is attached to
  • entity_id — int(10) — Primary key — NOT NULL — The entity id this data is attached to
  • deleted — tinyint(4) — Primary key — NOT NULL — A boolean indicating whether this data item has been deleted
  • delta — int(10) — Primary key — NOT NULL — The sequence number for this data item, used for multi-value fields
  • language — varchar(32) — Primary key — NOT NULL — The language for this data item.
  • bundle — varchar(128) — NOT NULL — The field instance bundle to which this row belongs, used when deleting a field instance
  • revision_id — int(10) — The entity revision id this data is attached to, or NULL if the entity type is not versioned
  • body_value — longtext
  • body_summary — longtext
  • body_format — varchar(255)

field_data_comment_body

  • entity_type — varchar(128) — Primary key — NOT NULL — The entity type this data is attached to
  • entity_id — int(10) — Primary key — NOT NULL — The entity id this data is attached to
  • deleted — tinyint(4) — Primary key — NOT NULL — A boolean indicating whether this data item has been deleted
  • delta — int(10) — Primary key — NOT NULL — The sequence number for this data item, used for multi-value fields
  • language — varchar(32) — Primary key — NOT NULL — The language for this data item.
  • bundle — varchar(128) — NOT NULL — The field instance bundle to which this row belongs, used when deleting a field instance
  • revision_id — int(10) — The entity revision id this data is attached to, or NULL if the entity type is not versioned
  • comment_body_value — longtext
  • comment_body_format — varchar(255)

field_data_field_image

  • entity_type — varchar(128) — Primary key — NOT NULL — The entity type this data is attached to
  • entity_id — int(10) — Primary key — NOT NULL — The entity id this data is attached to
  • deleted — tinyint(4) — Primary key — NOT NULL — A boolean indicating whether this data item has been deleted
  • delta — int(10) — Primary key — NOT NULL — The sequence number for this data item, used for multi-value fields
  • language — varchar(32) — Primary key — NOT NULL — The language for this data item.
  • bundle — varchar(128) — NOT NULL — The field instance bundle to which this row belongs, used when deleting a field instance
  • revision_id — int(10) — The entity revision id this data is attached to, or NULL if the entity type is not versioned
  • field_image_fid — int(10) — The file_managed.fid being referenced in this field.
  • field_image_alt — varchar(512) — Alternative image text, for the image’s ’alt’ attribute.
  • field_image_title — varchar(1024) — Image title text, for the image’s ’title’ attribute.
  • field_image_width — int(10) — The width of the image in pixels.
  • field_image_height — int(10) — The height of the image in pixels.

field_data_field_tags

  • entity_type — varchar(128) — Primary key — NOT NULL — The entity type this data is attached to
  • entity_id — int(10) — Primary key — NOT NULL — The entity id this data is attached to
  • deleted — tinyint(4) — Primary key — NOT NULL — A boolean indicating whether this data item has been deleted
  • delta — int(10) — Primary key — NOT NULL — The sequence number for this data item, used for multi-value fields
  • language — varchar(32) — Primary key — NOT NULL — The language for this data item.
  • bundle — varchar(128) — NOT NULL — The field instance bundle to which this row belongs, used when deleting a field instance
  • revision_id — int(10) — The entity revision id this data is attached to, or NULL if the entity type is not versioned
  • field_tags_tid — int(10)

field_revision_body

  • entity_type — varchar(128) — Primary key — NOT NULL — The entity type this data is attached to
  • entity_id — int(10) — Primary key — NOT NULL — The entity id this data is attached to
  • revision_id — int(10) — Primary key — NOT NULL — The entity revision id this data is attached to
  • deleted — tinyint(4) — Primary key — NOT NULL — A boolean indicating whether this data item has been deleted
  • delta — int(10) — Primary key — NOT NULL — The sequence number for this data item, used for multi-value fields
  • language — varchar(32) — Primary key — NOT NULL — The language for this data item.
  • bundle — varchar(128) — NOT NULL — The field instance bundle to which this row belongs, used when deleting a field instance
  • body_value — longtext
  • body_summary — longtext
  • body_format — varchar(255)

field_revision_comment_body

  • entity_type — varchar(128) — Primary key — NOT NULL — The entity type this data is attached to
  • entity_id — int(10) — Primary key — NOT NULL — The entity id this data is attached to
  • revision_id — int(10) — Primary key — NOT NULL — The entity revision id this data is attached to
  • deleted — tinyint(4) — Primary key — NOT NULL — A boolean indicating whether this data item has been deleted
  • delta — int(10) — Primary key — NOT NULL — The sequence number for this data item, used for multi-value fields
  • language — varchar(32) — Primary key — NOT NULL — The language for this data item.
  • bundle — varchar(128) — NOT NULL — The field instance bundle to which this row belongs, used when deleting a field instance
  • comment_body_value — longtext
  • comment_body_format — varchar(255)

field_revision_field_image

  • entity_type — varchar(128) — Primary key — NOT NULL — The entity type this data is attached to
  • entity_id — int(10) — Primary key — NOT NULL — The entity id this data is attached to
  • revision_id — int(10) — Primary key — NOT NULL — The entity revision id this data is attached to
  • deleted — tinyint(4) — Primary key — NOT NULL — A boolean indicating whether this data item has been deleted
  • delta — int(10) — Primary key — NOT NULL — The sequence number for this data item, used for multi-value fields
  • language — varchar(32) — Primary key — NOT NULL — The language for this data item.
  • bundle — varchar(128) — NOT NULL — The field instance bundle to which this row belongs, used when deleting a field instance
  • field_image_fid — int(10) — The file_managed.fid being referenced in this field.
  • field_image_alt — varchar(512) — Alternative image text, for the image’s ’alt’ attribute.
  • field_image_title — varchar(1024) — Image title text, for the image’s ’title’ attribute.
  • field_image_width — int(10) — The width of the image in pixels.
  • field_image_height — int(10) — The height of the image in pixels.

field_revision_field_tags

  • entity_type — varchar(128) — Primary key — NOT NULL — The entity type this data is attached to
  • entity_id — int(10) — Primary key — NOT NULL — The entity id this data is attached to
  • revision_id — int(10) — Primary key — NOT NULL — The entity revision id this data is attached to
  • deleted — tinyint(4) — Primary key — NOT NULL — A boolean indicating whether this data item has been deleted
  • delta — int(10) — Primary key — NOT NULL — The sequence number for this data item, used for multi-value fields
  • language — varchar(32) — Primary key — NOT NULL — The language for this data item.
  • bundle — varchar(128) — NOT NULL — The field instance bundle to which this row belongs, used when deleting a field instance
  • field_tags_tid — int(10)

file_managed

  • fid — int(10) — Primary key — NOT NULL — File ID.
  • uid — int(10) — Foreign key → users.uid — NOT NULL — The users.uid of the user who is associated with the file.
  • filename — varchar(255) — NOT NULL — Name of the file with no path components. This may differ from the basename of the URI if the file is renamed to avoid…
  • uri — varchar(255) — NOT NULL — The URI to access the file (either local or remote).
  • filemime — varchar(255) — NOT NULL — The file’s MIME type.
  • filesize — bigint(20) — NOT NULL — The size of the file in bytes.
  • status — tinyint(4) — NOT NULL — A field indicating the status of the file. Two status are defined in core: temporary (0) and permanent (1). Temporary f…
  • timestamp — int(10) — NOT NULL — UNIX timestamp for when the file was added.

file_usage

  • type — varchar(64) — Primary key — NOT NULL — The name of the object type in which the file is used.
  • id — int(10) — Primary key — NOT NULL — The primary key of the object using the file.
  • module — varchar(255) — Primary key — NOT NULL — The name of the module that is using the file.
  • fid — int(10) — Foreign key → file_managed.fid — NOT NULL — File ID.
  • count — int(10) — NOT NULL — The number of times this file is used by this object.

filter

  • name — varchar(32) — Primary key — NOT NULL — Name of the filter being referenced.
  • format — varchar(255) — Foreign key → filter_format.format — NOT NULL — Foreign key: The filter_format.format to which this filter is assigned.
  • module — varchar(64) — NOT NULL — The origin module of the filter.
  • weight — int(11) — NOT NULL — Weight of filter within format.
  • status — int(11) — NOT NULL — Filter enabled status. (1 = enabled, 0 = disabled)
  • settings — longblob — A serialized array of name value pairs that store the filter settings for the specific format.

filter_format

  • format — varchar(255) — Primary key — NOT NULL — Primary Key: Unique machine name of the format.
  • name — varchar(255) — NOT NULL — Name of the text format (Filtered HTML).
  • cache — tinyint(4) — NOT NULL — Flag to indicate whether format is cacheable. (1 = cacheable, 0 = not cacheable)
  • status — tinyint(3) — NOT NULL — The status of the text format. (1 = enabled, 0 = disabled)
  • weight — int(11) — NOT NULL — Weight of text format to use when listing.

flood

  • fid — int(11) — Primary key — NOT NULL — Unique flood event ID.
  • event — varchar(64) — NOT NULL — Name of event (e.g. contact).
  • identifier — varchar(128) — NOT NULL — Identifier of the visitor, such as an IP address or hostname.
  • timestamp — int(11) — NOT NULL — Timestamp of the event.
  • expiration — int(11) — NOT NULL — Expiration timestamp. Expired events are purged on cron run.

history

  • uid — int(11) — Foreign key → users.uid — NOT NULL — The users.uid that read the node nid.
  • nid — int(10) — Foreign key → node.nid — NOT NULL — The node.nid that was read.
  • timestamp — int(11) — NOT NULL — The Unix timestamp at which the read occurred.

image_effects

  • ieid — int(10) — Primary key — NOT NULL — The primary identifier for an image effect.
  • isid — int(10) — Foreign key → image_styles.isid — NOT NULL — The image_styles.isid for an image style.
  • weight — int(11) — NOT NULL — The weight of the effect in the style.
  • name — varchar(255) — NOT NULL — The unique name of the effect to be executed.
  • data — longblob — NOT NULL — The configuration data for the effect.

image_styles

  • isid — int(10) — Primary key — NOT NULL — The primary identifier for an image style.
  • name — varchar(255) — NOT NULL — The style machine name.
  • label — varchar(255) — NOT NULL — The style administrative name.

menu_custom

  • menu_name — varchar(32) — Primary key — NOT NULL — Primary Key: Unique key for menu. This is used as a block delta so length is 32.
  • title — varchar(255) — NOT NULL — Menu title; displayed at top of block.
  • description — text — Menu description.

menu_links

  • mlid — int(10) — Primary key — NOT NULL — The menu link ID (mlid) is the integer primary key.
  • menu_name — varchar(32) — Foreign key → menu_custom.menu_name — NOT NULL — The menu name. All links with the same menu name (such as ’navigation’) are part of the same menu.
  • plid — int(10) — Foreign key → menu_links.mlid — NOT NULL — The parent link ID (plid) is the mlid of the link above in the hierarchy, or zero if the link is at the top level in it…
  • link_path — varchar(255) — NOT NULL — The Drupal path or external path this link points to.
  • router_path — varchar(255) — NOT NULL — For links corresponding to a Drupal path (external = 0), this connects the link to a menu_router.path for joins.
  • link_title — varchar(255) — NOT NULL — The text displayed for the link, which may be modified by a title callback stored in menu_router.
  • options — blob — A serialized array of options to be passed to the url() or l() function, such as a query string or HTML attributes.
  • module — varchar(255) — NOT NULL — The name of the module that generated this link.
  • hidden — smallint(6) — NOT NULL — A flag for whether the link should be rendered in menus. (1 = a disabled menu item that may be shown on admin screens,…
  • external — smallint(6) — NOT NULL — A flag to indicate if the link points to a full URL starting with a protocol, like http:// (1 = external, 0 = internal).
  • has_children — smallint(6) — NOT NULL — Flag indicating whether any links have this link as a parent (1 = children exist, 0 = no children).
  • expanded — smallint(6) — NOT NULL — Flag for whether this link should be rendered as expanded in menus - expanded links always have their child links displ…
  • weight — int(11) — NOT NULL — Link weight among links in the same menu at the same depth.
  • depth — smallint(6) — NOT NULL — The depth relative to the top level. A link with plid == 0 will have depth == 1.
  • customized — smallint(6) — NOT NULL — A flag to indicate that the user has manually created or edited the link (1 = customized, 0 = not customized).
  • p1 — int(10) — NOT NULL — The first mlid in the materialized path. If N = depth, then pN must equal the mlid. If depth > 1 then p(N-1) must equal…
  • p2 — int(10) — NOT NULL — The second mlid in the materialized path. See p1.
  • p3 — int(10) — NOT NULL — The third mlid in the materialized path. See p1.
  • p4 — int(10) — NOT NULL — The fourth mlid in the materialized path. See p1.
  • p5 — int(10) — NOT NULL — The fifth mlid in the materialized path. See p1.
  • p6 — int(10) — NOT NULL — The sixth mlid in the materialized path. See p1.
  • p7 — int(10) — NOT NULL — The seventh mlid in the materialized path. See p1.
  • p8 — int(10) — NOT NULL — The eighth mlid in the materialized path. See p1.
  • p9 — int(10) — NOT NULL — The ninth mlid in the materialized path. See p1.
  • updated — smallint(6) — NOT NULL — Flag that indicates that this link was generated during the update from Drupal 5.

menu_router

  • path — varchar(255) — Primary key — NOT NULL — Primary Key: the Drupal path this entry describes
  • load_functions — blob — NOT NULL — A serialized array of function names (like node_load) to be called to load an object corresponding to a part of the cur…
  • to_arg_functions — blob — NOT NULL — A serialized array of function names (like user_uid_optional_to_arg) to be called to replace a part of the router path…
  • access_callback — varchar(255) — NOT NULL — The callback which determines the access to this router path. Defaults to user_access.
  • access_arguments — blob — A serialized array of arguments for the access callback.
  • page_callback — varchar(255) — NOT NULL — The name of the function that renders the page.
  • page_arguments — blob — A serialized array of arguments for the page callback.
  • delivery_callback — varchar(255) — NOT NULL — The name of the function that sends the result of the page_callback function to the browser.
  • fit — int(11) — NOT NULL — A numeric representation of how specific the path is.
  • number_parts — smallint(6) — NOT NULL — Number of parts in this router path.
  • context — int(11) — NOT NULL — Only for local tasks (tabs) - the context of a local task to control its placement.
  • tab_parent — varchar(255) — NOT NULL — Only for local tasks (tabs) - the router path of the parent page (which may also be a local task).
  • tab_root — varchar(255) — NOT NULL — Router path of the closest non-tab parent page. For pages that are not local tasks, this will be the same as the path.
  • title — varchar(255) — NOT NULL — The title for the current page, or the title for the tab if this is a local task.
  • title_callback — varchar(255) — NOT NULL — A function which will alter the title. Defaults to t()
  • title_arguments — varchar(255) — NOT NULL — A serialized array of arguments for the title callback. If empty, the title will be used as the sole argument for the t…
  • theme_callback — varchar(255) — NOT NULL — A function which returns the name of the theme that will be used to render this page. If left empty, the default theme…
  • theme_arguments — varchar(255) — NOT NULL — A serialized array of arguments for the theme callback.
  • type — int(11) — NOT NULL — Numeric representation of the type of the menu item, like MENU_LOCAL_TASK.
  • description — text — NOT NULL — A description of this item.
  • position — varchar(255) — NOT NULL — The position of the block (left or right) on the system administration page for this item.
  • weight — int(11) — NOT NULL — Weight of the element. Lighter weights are higher up, heavier weights go down.
  • include_file — mediumtext — The file to include for this element, usually the page callback function lives in this file.

node

  • nid — int(10) — Primary key — NOT NULL — The primary identifier for a node.
  • vid — int(10) — Foreign key → node_revision.vid — The current node_revision.vid version identifier.
  • type — varchar(32) — Foreign key → node_type.type — NOT NULL — The node_type.type of this node.
  • language — varchar(12) — NOT NULL — The languages.language of this node.
  • title — varchar(255) — NOT NULL — The title of this node, always treated as non-markup plain text.
  • uid — int(11) — Foreign key → users.uid — NOT NULL — The users.uid that owns this node; initially, this is the user that created it.
  • status — int(11) — NOT NULL — Boolean indicating whether the node is published (visible to non-administrators).
  • created — int(11) — NOT NULL — The Unix timestamp when the node was created.
  • changed — int(11) — NOT NULL — The Unix timestamp when the node was most recently saved.
  • comment — int(11) — NOT NULL — Whether comments are allowed on this node: 0 = no, 1 = closed (read only), 2 = open (read/write).
  • promote — int(11) — NOT NULL — Boolean indicating whether the node should be displayed on the front page.
  • sticky — int(11) — NOT NULL — Boolean indicating whether the node should be displayed at the top of lists in which it appears.
  • tnid — int(10) — NOT NULL — The translation set id for this node, which equals the node id of the source post in each set.
  • translate — int(11) — NOT NULL — A boolean indicating whether this translation page needs to be updated.

node_access

  • gid — int(10) — Primary key — NOT NULL — The grant ID a user must possess in the specified realm to gain this row’s privileges on the node.
  • realm — varchar(255) — Primary key — NOT NULL — The realm in which the user must possess the grant ID. Each node access node can define one or more realms.
  • nid — int(10) — Foreign key → node.nid — NOT NULL — The node.nid this record affects.
  • grant_view — tinyint(3) — NOT NULL — Boolean indicating whether a user with the realm/grant pair can view this node.
  • grant_update — tinyint(3) — NOT NULL — Boolean indicating whether a user with the realm/grant pair can edit this node.
  • grant_delete — tinyint(3) — NOT NULL — Boolean indicating whether a user with the realm/grant pair can delete this node.

node_comment_statistics

  • nid — int(10) — Foreign key → node.nid — NOT NULL — The node.nid for which the statistics are compiled.
  • cid — int(11) — Foreign key → comment.cid — NOT NULL — The comment.cid of the last comment.
  • last_comment_timestamp — int(11) — NOT NULL — The Unix timestamp of the last comment that was posted within this node, from comment.changed.
  • last_comment_name — varchar(60) — The name of the latest author to post a comment on this node, from comment.name.
  • last_comment_uid — int(11) — NOT NULL — The user ID of the latest author to post a comment on this node, from comment.uid.
  • comment_count — int(10) — NOT NULL — The total number of comments on this node.

node_revision

  • vid — int(10) — Primary key — NOT NULL — The primary identifier for this version.
  • nid — int(10) — Foreign key → node.nid — NOT NULL — The node this version belongs to.
  • uid — int(11) — Foreign key → users.uid — NOT NULL — The users.uid that created this version.
  • title — varchar(255) — NOT NULL — The title of this version.
  • log — longtext — NOT NULL — The log entry explaining the changes in this version.
  • timestamp — int(11) — NOT NULL — A Unix timestamp indicating when this version was created.
  • status — int(11) — NOT NULL — Boolean indicating whether the node (at the time of this revision) is published (visible to non-administrators).
  • comment — int(11) — NOT NULL — Whether comments are allowed on this node (at the time of this revision): 0 = no, 1 = closed (read only), 2 = open (rea…
  • promote — int(11) — NOT NULL — Boolean indicating whether the node (at the time of this revision) should be displayed on the front page.
  • sticky — int(11) — NOT NULL — Boolean indicating whether the node (at the time of this revision) should be displayed at the top of lists in which it…

node_type

  • type — varchar(32) — Primary key — NOT NULL — The machine-readable name of this type.
  • name — varchar(255) — NOT NULL — The human-readable name of this type.
  • base — varchar(255) — NOT NULL — The base string used to construct callbacks corresponding to this node type.
  • module — varchar(255) — NOT NULL — The module defining this node type.
  • description — mediumtext — NOT NULL — A brief description of this type.
  • help — mediumtext — NOT NULL — Help information shown to the user when creating a node of this type.
  • has_title — tinyint(3) — NOT NULL — Boolean indicating whether this type uses the node.title field.
  • title_label — varchar(255) — NOT NULL — The label displayed for the title field on the edit form.
  • custom — tinyint(4) — NOT NULL — A boolean indicating whether this type is defined by a module (FALSE) or by a user via Add content type (TRUE).
  • modified — tinyint(4) — NOT NULL — A boolean indicating whether this type has been modified by an administrator; currently not used in any way.
  • locked — tinyint(4) — NOT NULL — A boolean indicating whether the administrator can change the machine name of this type.
  • disabled — tinyint(4) — NOT NULL — A boolean indicating whether the node type is disabled.
  • orig_type — varchar(255) — NOT NULL — The original machine-readable name of this node type. This may be different from the current type name if the locked fi…

queue

  • item_id — int(10) — Primary key — NOT NULL — Primary Key: Unique item ID.
  • name — varchar(255) — NOT NULL — The queue name.
  • data — longblob — The arbitrary data for the item.
  • expire — int(11) — NOT NULL — Timestamp when the claim lease expires on the item.
  • created — int(11) — NOT NULL — Timestamp when the item was created.

rdf_mapping

  • type — varchar(128) — Primary key — NOT NULL — The name of the entity type a mapping applies to (node, user, comment, etc.).
  • bundle — varchar(128) — Primary key — NOT NULL — The name of the bundle a mapping applies to.
  • mapping — longblob — The serialized mapping of the bundle type and fields to RDF terms.

registry

  • name — varchar(255) — Primary key — NOT NULL — The name of the function, class, or interface.
  • type — varchar(9) — Primary key — NOT NULL — Either function or class or interface.
  • filename — varchar(255) — Foreign key → registry_file.filename — NOT NULL — Name of the file.
  • module — varchar(255) — NOT NULL — Name of the module the file belongs to.
  • weight — int(11) — NOT NULL — The order in which this module’s hooks should be invoked relative to other modules. Equal-weighted modules are ordered…

registry_file

  • filename — varchar(255) — Primary key — NOT NULL — Path to the file.
  • hash — varchar(64) — NOT NULL — sha-256 hash of the file’s contents when last parsed.

role

  • rid — int(10) — Primary key — NOT NULL — Primary Key: Unique role ID.
  • name — varchar(64) — NOT NULL — Unique role name.
  • weight — int(11) — NOT NULL — The weight of this role in listings and the user interface.

role_permission

  • permission — varchar(128) — Primary key — NOT NULL — A single permission granted to the role identified by rid.
  • rid — int(10) — Foreign key → role.rid — NOT NULL — Foreign Key: role.rid.
  • module — varchar(255) — NOT NULL — The module declaring the permission.

search_dataset

  • sid — int(10) — Primary key — NOT NULL — Search item ID, e.g. node ID for nodes.
  • type — varchar(16) — Primary key — NOT NULL — Type of item, e.g. node.
  • data — longtext — NOT NULL — List of space-separated words from the item.
  • reindex — int(10) — NOT NULL — Set to force node reindexing.

search_index

  • word — varchar(50) — Foreign key → search_total.word — NOT NULL — The search_total.word that is associated with the search item.
  • sid — int(10) — Foreign key → search_dataset.sid — NOT NULL — The search_dataset.sid of the searchable item to which the word belongs.
  • type — varchar(16) — Foreign key → search_dataset.type — NOT NULL — The search_total.word that is associated with the search item.
  • score — float — The numeric score of the word, higher being more important.

search_node_links

  • sid — int(10) — Foreign key → search_dataset.sid — NOT NULL — The search_dataset.sid of the searchable item containing the link to the node.
  • type — varchar(16) — Foreign key → search_dataset.type — NOT NULL — The search_dataset.type of the searchable item containing the link to the node.
  • nid — int(10) — Foreign key → node.nid — NOT NULL — The node.nid that this item links to.
  • caption — longtext — The text used to link to the node.nid.

search_total

  • word — varchar(50) — Primary key — NOT NULL — Primary Key: Unique word in the search index.
  • count — float — The count of the word in the index using Zipf’s law to equalize the probability distribution.

semaphore

  • name — varchar(255) — Primary key — NOT NULL — Primary Key: Unique name.
  • value — varchar(255) — NOT NULL — A value for the semaphore.
  • expire — double — NOT NULL — A Unix timestamp with microseconds indicating when the semaphore should expire.

sequences

  • value — int(10) — Primary key — NOT NULL — The value of the sequence.

sessions

  • sid — varchar(128) — Primary key — NOT NULL — A session ID. The value is generated by Drupal’s session handlers.
  • ssid — varchar(128) — Primary key — NOT NULL — Secure session ID. The value is generated by Drupal’s session handlers.
  • uid — int(10) — Foreign key → users.uid — NOT NULL — The users.uid corresponding to a session, or 0 for anonymous user.
  • hostname — varchar(128) — NOT NULL — The IP address that last used this session ID (sid).
  • timestamp — int(11) — NOT NULL — The Unix timestamp when this session last requested a page. Old records are purged by PHP automatically.
  • cache — int(11) — NOT NULL — The time of this user’s last post. This is used when the site has specified a minimum_cache_lifetime. See cache_get().
  • session — longblob — The serialized contents of $_SESSION, an array of name/value pairs that persists across page requests by this session I…

shortcut_set

  • set_name — varchar(32) — Primary key — NOT NULL — Primary Key: The menu_links.menu_name under which the set’s links are stored.
  • title — varchar(255) — NOT NULL — The title of the set.

shortcut_set_users

  • uid — int(10) — Foreign key → users.uid — NOT NULL — The users.uid for this set.
  • set_name — varchar(32) — Foreign key → shortcut_set.set_name — NOT NULL — The shortcut_set.set_name that will be displayed for this user.

system

  • filename — varchar(255) — Primary key — NOT NULL — The path of the primary file for this item, relative to the Drupal root; e.g. modules/node/node.module.
  • name — varchar(255) — NOT NULL — The name of the item; e.g. node.
  • type — varchar(12) — NOT NULL — The type of the item, either module, theme, or theme_engine.
  • owner — varchar(255) — NOT NULL — A theme’s ’parent’ . Can be either a theme or an engine.
  • status — int(11) — NOT NULL — Boolean indicating whether or not this item is enabled.
  • bootstrap — int(11) — NOT NULL — Boolean indicating whether this module is loaded during Drupal’s early bootstrapping phase (e.g. even before the page c…
  • schema_version — smallint(6) — NOT NULL — The module’s database schema version number. -1 if the module is not installed (its tables do not exist); 0 or the larg…
  • weight — int(11) — NOT NULL — The order in which this module’s hooks should be invoked relative to other modules. Equal-weighted modules are ordered…
  • info — blob — A serialized array containing information from the module’s .info file; keys can include name, description, package, ve…

taxonomy_index

  • nid — int(10) — Foreign key → node.nid — NOT NULL — The node.nid this record tracks.
  • tid — int(10) — Foreign key → taxonomy_term_data.tid — NOT NULL — The term ID.
  • sticky — tinyint(4) — Boolean indicating whether the node is sticky.
  • created — int(11) — NOT NULL — The Unix timestamp when the node was created.

taxonomy_term_data

  • tid — int(10) — Primary key — NOT NULL — Primary Key: Unique term ID.
  • vid — int(10) — Foreign key → taxonomy_vocabulary.vid — NOT NULL — The taxonomy_vocabulary.vid of the vocabulary to which the term is assigned.
  • name — varchar(255) — NOT NULL — The term name.
  • description — longtext — A description of the term.
  • format — varchar(255) — The filter_format.format of the description.
  • weight — int(11) — NOT NULL — The weight of this term in relation to other terms.

taxonomy_term_hierarchy

  • tid — int(10) — Foreign key → taxonomy_term_data.tid — NOT NULL — Primary Key: The taxonomy_term_data.tid of the term.
  • parent — int(10) — Foreign key → taxonomy_term_data.tid — NOT NULL — Primary Key: The taxonomy_term_data.tid of the term’s parent. 0 indicates no parent.

taxonomy_vocabulary

  • vid — int(10) — Primary key — NOT NULL — Primary Key: Unique vocabulary ID.
  • name — varchar(255) — NOT NULL — Name of the vocabulary.
  • machine_name — varchar(255) — NOT NULL — The vocabulary machine name.
  • description — longtext — Description of the vocabulary.
  • hierarchy — tinyint(3) — NOT NULL — The type of hierarchy allowed within the vocabulary. (0 = disabled, 1 = single, 2 = multiple)
  • module — varchar(255) — NOT NULL — The module which created the vocabulary.
  • weight — int(11) — NOT NULL — The weight of this vocabulary in relation to other vocabularies.

url_alias

  • pid — int(10) — Primary key — NOT NULL — A unique path alias identifier.
  • source — varchar(255) — NOT NULL — The Drupal path this alias is for; e.g. node/12.
  • alias — varchar(255) — NOT NULL — The alias for this path; e.g. title-of-the-story.
  • language — varchar(12) — NOT NULL — The language this alias is for; if ’und’, the alias will be used for unknown languages. Each Drupal path can have an al…

users

  • uid — int(10) — Primary key — NOT NULL — Primary Key: Unique user ID.
  • name — varchar(60) — NOT NULL — Unique user name.
  • pass — varchar(128) — NOT NULL — User’s password (hashed).
  • mail — varchar(254) — User’s e-mail address.
  • theme — varchar(255) — NOT NULL — User’s default theme.
  • signature — varchar(255) — NOT NULL — User’s signature.
  • signature_format — varchar(255) — The filter_format.format of the signature.
  • created — int(11) — NOT NULL — Timestamp for when user was created.
  • access — int(11) — NOT NULL — Timestamp for previous time user accessed the site.
  • login — int(11) — NOT NULL — Timestamp for user’s last login.
  • status — tinyint(4) — NOT NULL — Whether the user is active(1) or blocked(0).
  • timezone — varchar(32) — User’s time zone.
  • language — varchar(12) — NOT NULL — User’s default language.
  • picture — int(11) — NOT NULL — Foreign key: file_managed.fid of user’s picture.
  • init — varchar(254) — E-mail address used for initial account creation.
  • data — longblob — A serialized array of name value pairs that are related to the user. Any form values posted during user edit are stored…

users_roles

  • uid — int(10) — Foreign key → users.uid — NOT NULL — Primary Key: users.uid for user.
  • rid — int(10) — Foreign key → role.rid — NOT NULL — Primary Key: role.rid for role.

variable

  • name — varchar(128) — Primary key — NOT NULL — The name of the variable.
  • value — longblob — NOT NULL — The value of the variable.

watchdog

  • wid — int(11) — Primary key — NOT NULL — Primary Key: Unique watchdog event ID.
  • uid — int(11) — Foreign key → users.uid — NOT NULL — The users.uid of the user who triggered the event.
  • type — varchar(64) — NOT NULL — Type of log message, for example "user" or "page not found."
  • message — longtext — NOT NULL — Text of log message to be passed into the t() function.
  • variables — longblob — NOT NULL — Serialized array of variables that match the message string and that is passed into the t() function.
  • severity — tinyint(3) — NOT NULL — The severity level of the event; ranges from 0 (Emergency) to 7 (Debug)
  • link — varchar(255) — Link to view the result of the event.
  • location — text — NOT NULL — URL of the origin of the event.
  • referer — text — URL of referring page.
  • hostname — varchar(128) — NOT NULL — Hostname of the user who triggered the event.
  • timestamp — int(11) — NOT NULL — Unix timestamp of when event occurred.