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.