Entity 'access'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK aid Integer YES NO
mask Varchar (255) YES NO
type Varchar (255) YES NO
status Tinyint YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
authmap Non-identifying access authmap 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'accesslog'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK aid Integer YES NO
FK sid Varchar (64) YES NO
title Varchar (255) NO NO
path Varchar (255) NO NO
url Varchar (255) NO NO
hostname Varchar (128) NO NO
FK uid Integer YES NO
timer Integer YES NO
timestamp Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
accesslog Non-identifying sessions accesslog 1:N
accesslog Non-identifying users accesslog 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'aggregator_category'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK cid Integer YES NO
title Varchar (255) YES NO
description Longtext YES NO
block Tinyint YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
aggregator_category_feed Non-identifying aggregator_category aggregator_category_feed 1:N
aggregator_category_item Non-identifying aggregator_category aggregator_category_item 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'aggregator_category_feed'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PFK fid Integer YES NO
PFK cid Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
aggregator_category_feed Non-identifying aggregator_category aggregator_category_feed 1:N
aggregator_feed Non-identifying aggregator_feed aggregator_category_feed 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'aggregator_category_item'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PFK iid Integer YES NO
PFK cid Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
aggregator_category_item Non-identifying aggregator_category aggregator_category_item 1:N
aggregator_category_item Non-identifying aggregator_item aggregator_category_item 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'aggregator_feed'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK fid Integer YES NO
title Varchar (255) YES NO
url Varchar (255) YES NO
refresh Integer YES NO
checked Integer YES NO
link Varchar (255) YES NO
description Longtext YES NO
image Longtext YES NO
etag Varchar (255) YES NO
modified Integer YES NO
block Tinyint YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
aggregator_feed Non-identifying aggregator_feed aggregator_category_feed 1:N
aggregator_item Non-identifying aggregator_feed aggregator_item 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'aggregator_item'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK iid Integer YES NO
FK fid Integer YES NO
title Varchar (255) YES NO
link Varchar (255) YES NO
author Varchar (255) YES NO
description Longtext YES NO
timestamp Integer NO NO
guid Varchar (255) NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
aggregator_item Non-identifying aggregator_feed aggregator_item 1:N
aggregator_category_item Non-identifying aggregator_item aggregator_category_item 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'authmap'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PFK aid Integer YES NO
FK uid Integer YES NO
authname Varchar (128) YES NO
module Varchar (128) YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
authmap Non-identifying access authmap 1:N
authmap Non-identifying users authmap 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'blocks'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
module Varchar (64) YES NO
delta Varchar (32) YES NO
theme Varchar (255) YES NO
status Tinyint YES NO
weight Tinyint YES NO
region Varchar (64) YES NO
custom Tinyint YES NO
throttle Tinyint YES NO
visibility Tinyint YES NO
pages Text YES NO
title Varchar (64) YES NO
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'blocks_roles'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK module Varchar (64) YES NO
PK delta Varchar (32) YES NO
PFK rid Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
blocks_roles Non-identifying role blocks_roles 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'book'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PFK vid Integer YES NO
FK nid Integer YES NO
weight Tinyint YES NO
FK vid/parent Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
book Non-identifying node book 1:N
book Non-identifying node_revisions book 1:N
book Non-identifying book book 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'boxes'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK bid Integer YES NO
body Longtext NO NO
info Varchar (128) YES NO
FK format Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
boxes Non-identifying filter_formats boxes 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'cache'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK cid Varchar (255) YES NO
data Longblob NO NO
expire Integer YES NO
created Integer YES NO
headers Text NO NO
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'cache_filter'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK cid Varchar (255) YES NO
data Longblob NO NO
expire Integer YES NO
created Integer YES NO
headers Text NO NO
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'cache_menu'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK cid Varchar (255) YES NO
data Longblob NO NO
expire Integer YES NO
created Integer YES NO
headers Text NO NO
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'cache_page'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK cid Varchar (255) YES NO
data Longblob NO NO
expire Integer YES NO
created Integer YES NO
headers Text NO NO
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'client'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK cid Integer YES NO
link Varchar (255) YES NO
name Varchar (128) YES NO
mail Varchar (128) YES NO
slogan Longtext YES NO
mission Longtext YES NO
users Integer YES NO
nodes Integer YES NO
version Varchar (35) YES NO
created Integer YES NO
changed Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
client_system Non-identifying client client_system 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'client_system'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PFK cid Integer YES NO
PK name Varchar (255) YES NO
type Varchar (255) YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
client_system Non-identifying client client_system 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'comments'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK cid Integer YES NO
FK cid/pid Integer YES NO
FK nid Integer YES NO
FK uid Integer YES NO
subject Varchar (64) YES NO
comment Longtext YES NO
hostname Varchar (128) YES NO
timestamp Integer YES NO
score Mediumint YES NO
status Tinyint YES NO
FK format Integer YES NO
thread Varchar (255) YES NO
users Longtext NO NO
name Varchar (60) NO NO
mail Varchar (64) NO NO
homepage Varchar (255) NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
comment(parent) Non-identifying comments comments 1:N
comments Non-identifying users comments 1:N
comments Non-identifying node comments 1:N
comments Non-identifying filter_formats comments 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'contact'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK cid Integer YES NO
category Varchar (255) YES NO
recipients Longtext YES NO
reply Longtext YES NO
weight Tinyint YES NO
selected Tinyint YES NO
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'file_revisions'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PFK fid Integer YES NO
FK vid Integer YES NO
description Varchar (255) YES NO
list Tinyint YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
file_revisions Non-identifying files file_revisions 1:N
file_revisions Non-identifying node_revisions file_revisions 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'files'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK fid Integer YES NO
FK nid Integer YES NO
filename Varchar (255) YES NO
filepath Varchar (255) YES NO
filemime Varchar (255) YES NO
filesize Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
file_revisions Non-identifying files file_revisions 1:N
files Non-identifying node files 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'filter_formats'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique Notes
PK format Integer YES NO
name Varchar (255) YES NO
roles Varchar (255) YES NO comma-separated list of "rid"s from "role" table
cache Tinyint YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
boxes Non-identifying filter_formats boxes 1:N
filters Non-identifying filter_formats filters 1:N
comments Non-identifying filter_formats comments 1:N
node_revisions Non-identifying filter_formats node_revisions 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'filters'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
FK format Integer YES NO
module Varchar (64) YES NO
delta Tinyint YES NO
weight Tinyint YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
filters Non-identifying filter_formats filters 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'flood'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
event Varchar (64) YES NO
hostname Varchar (128) YES NO
timestamp Integer YES NO
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'forum'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PFK vid Integer YES NO
FK nid Integer YES NO
FK tid Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
forum Non-identifying node_revisions forum 1:N
forum Non-identifying node forum 1:N
forum Non-identifying term_data forum 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'history'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PFK uid Integer YES NO
PFK nid Integer YES NO
timestamp Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
history Non-identifying users history 1:N
history Non-identifying node history 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'locales_meta'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK locale Varchar (12) YES NO
name Varchar (64) YES NO
enabled Integer YES NO
isdefault Integer YES NO
plurals Integer YES NO
formula Varchar (128) YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
locales_target Non-identifying locales_meta locales_target 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'locales_source'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK lid Integer YES NO
location Varchar (255) YES NO
source Blob YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
locales_target Non-identifying locales_source locales_target 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'locales_target'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
FK lid Integer YES NO
translation Blob YES NO
FK locale Varchar (12) YES NO
plid Integer YES NO
plural Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
locales_target Non-identifying locales_source locales_target 1:N
locales_target Non-identifying locales_meta locales_target 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'menu'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK mid Integer YES NO
FK mid/pid Integer YES NO
path Varchar (255) YES NO
title Varchar (255) YES NO
description Varchar (255) YES NO
weight Tinyint YES NO
type Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
menu Non-identifying menu menu 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'node'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK nid Integer YES NO
FK vid Integer YES NO
type Varchar (32) YES NO
title Varchar (128) YES NO
FK uid Integer YES NO
status Integer YES NO
created Integer YES NO
changed Integer YES NO
comment Integer YES NO
promote Integer YES NO
moderate Integer YES NO
sticky Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
book Non-identifying node book 1:N
node Non-identifying node_revisions node 1:N
node Non-identifying users node 1:N
node_revision Non-identifying node node_revisions 1:N
comments Non-identifying node comments 1:N
node_comment_statistics Non-identifying node node_comment_statistics 1:N
history Non-identifying node history 1:N
files Non-identifying node files 1:N
forum Non-identifying node forum 1:N
term_node Non-identifying node term_node 1:N
node_access Non-identifying node node_access 1:N
poll Non-identifying node poll 1:N
node_counter Non-identifying node node_counter 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'node_access'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PFK nid Integer YES NO
PK gid Integer YES NO
PK realm Varchar (255) YES NO
grant_view Tinyint YES NO
grant_update Tinyint YES NO
grant_delete Tinyint YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
node_access Non-identifying node node_access 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'node_comment_statistics'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PFK nid Integer YES NO
last_comment_timestamp Integer YES NO
last_comment_name Varchar (60) NO NO
FK uid/last_comment_uid Integer YES NO
comment_count Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
node_comment_statistics Non-identifying node node_comment_statistics 1:N
node_comment_statistics Non-identifying users node_comment_statistics 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'node_counter'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PFK nid Integer YES NO
totalcount Bigint YES NO
daycount Mediumint YES NO
timestamp Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
node_counter Non-identifying node node_counter 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'node_revisions'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK vid Integer YES NO
FK nid Integer YES NO
FK uid Integer YES NO
title Varchar (128) YES NO
body Longtext YES NO
teaser Longtext YES NO
log Longtext YES NO
timestamp Integer YES NO
FK format Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
node Non-identifying node_revisions node 1:N
node_revision Non-identifying node node_revisions 1:N
file_revisions Non-identifying node_revisions file_revisions 1:N
node_revisions Non-identifying filter_formats node_revisions 1:N
forum Non-identifying node_revisions forum 1:N
book Non-identifying node_revisions book 1:N
node_revisions Non-identifying users node_revisions 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'node_type'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK type Varchar (32) YES NO
name Varchar (255) YES NO
module Varchar (255) YES NO
description Mediumtext YES NO
help Mediumtext YES NO
has_title Tinyint YES NO
title_label Varchar (255) YES NO
has_body Tinyint YES NO
body_label Varchar (255) YES NO
min_word_count Smallint YES NO
custom Tinyint YES NO
modified Tinyint YES NO
locked Tinyint YES NO
orig_type Varchar (255) YES NO
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'permission'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
FK rid Integer YES NO
perm Longtext NO NO
FK tid Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
permission Non-identifying role permission 1:N
permission Non-identifying term_data permission 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'poll'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PFK nid Integer YES NO
runtime Integer YES NO
active Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
poll Non-identifying node poll 1:N
poll_votes Non-identifying poll poll_votes 1:N
poll_choices Non-identifying poll poll_choices 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'poll_choices'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK chid Integer YES NO
FK nid Integer YES NO
chtext Varchar (128) YES NO
chvotes Integer YES NO
chorder Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
poll_choices Non-identifying poll poll_choices 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'poll_votes'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
FK nid Integer YES NO
FK uid Integer YES NO
chorder Integer YES NO
hostname Varchar (128) YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
poll_votes Non-identifying poll poll_votes 1:N
poll_votes Non-identifying users poll_votes 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'profile_fields'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK fid Integer YES NO
title Varchar (255) NO NO
name Varchar (128) NO NO
explanation Text NO NO
category Varchar (255) NO NO
page Varchar (255) NO NO
type Varchar (128) NO NO
weight Tinyint YES NO
required Tinyint YES NO
register Tinyint YES NO
visibility Tinyint YES NO
autocomplete Tinyint YES NO
options Text NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
profile_values Non-identifying profile_fields profile_values 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'profile_values'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
FK fid Integer YES NO
FK uid Integer YES NO
value Text NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
profile_values Non-identifying profile_fields profile_values 1:N
profile_values Non-identifying users profile_values 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'role'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK rid Integer YES NO
name Varchar (64) YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
users_roles Non-identifying role users_roles 1:N
permission Non-identifying role permission 1:N
blocks_roles Non-identifying role blocks_roles 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'search_dataset'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
sid Integer YES NO
type Varchar (16) NO NO
data Longtext YES NO
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'search_index'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
FK word Varchar (50) YES NO
sid Integer YES NO
type Varchar (16) NO NO
fromsid Integer YES NO
fromtype Varchar (16) NO NO
score Float NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
search_index Non-identifying search_total search_index 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'search_total'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK word Varchar (50) YES NO
count Float NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
search_index Non-identifying search_total search_index 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'sequences'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK name Varchar (255) YES NO
id Integer YES NO
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'sessions'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK sid Varchar (64) YES NO
FK uid Integer YES NO
hostname Varchar (128) YES NO
timestamp Integer YES NO
cache Integer YES NO
session Longtext NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
accesslog Non-identifying sessions accesslog 1:N
session Non-identifying users sessions 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'system'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK filename Varchar (255) YES NO
name Varchar (255) YES NO
type Varchar (255) YES NO
description Varchar (255) YES NO
status Integer YES NO
throttle Tinyint YES NO
bootstrap Integer YES NO
schema_version Smallint YES NO
weight Integer YES NO
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'term_data'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK tid Integer YES NO
FK vid Integer YES NO
name Varchar (255) YES NO
description Longtext NO NO
weight Tinyint YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
term_heirarchy Non-identifying term_data term_hierarchy 1:N
term_node Non-identifying term_data term_node 1:N
term_relation1 Non-identifying term_data term_relation 1:N
term_relation2 Non-identifying term_data term_relation 1:N
term_synonym Non-identifying term_data term_synonym 1:N
forum Non-identifying term_data forum 1:N
permission Non-identifying term_data permission 1:N
term_data Non-identifying vocabulary term_data 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'term_hierarchy'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PFK tid Integer YES NO
PK parent Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
term_heirarchy Non-identifying term_data term_hierarchy 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'term_node'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PFK tid Integer YES NO
PFK nid Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
term_node Non-identifying term_data term_node 1:N
term_node Non-identifying node term_node 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'term_relation'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
FK tid/tid1 Integer YES NO
FK tid/tid2 Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
term_relation1 Non-identifying term_data term_relation 1:N
term_relation2 Non-identifying term_data term_relation 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'term_synonym'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
FK tid Integer YES NO
name Varchar (255) YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
term_synonym Non-identifying term_data term_synonym 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'url_alias'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK pid Integer YES NO
src Varchar (128) YES NO
dst Varchar (128) YES NO
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'users'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK uid Integer YES NO
name Varchar (60) YES NO
pass Varchar (32) YES NO
mail Varchar (64) NO NO
mode Tinyint YES NO
sort Tinyint NO NO
threshold Tinyint NO NO
theme Varchar (255) YES NO
signature Varchar (255) YES NO
created Integer YES NO
access Integer YES NO
login Integer YES NO
status Tinyint YES NO
timezone Varchar (8) NO NO
language Varchar (12) YES NO
picture Varchar (255) YES NO
init Varchar (64) NO NO
data Longtext NO NO
Relationships
Relationship name Type Parent entity Child entity Card.
accesslog Non-identifying users accesslog 1:N
authmap Non-identifying users authmap 1:N
node Non-identifying users node 1:N
session Non-identifying users sessions 1:N
comments Non-identifying users comments 1:N
history Non-identifying users history 1:N
node_comment_statistics Non-identifying users node_comment_statistics 1:N
users_roles Non-identifying users users_roles 1:N
profile_values Non-identifying users profile_values 1:N
poll_votes Non-identifying users poll_votes 1:N
watchdog Non-identifying users watchdog 1:N
node_revisions Non-identifying users node_revisions 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'users_roles'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PFK uid Integer YES NO
PFK rid Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
users_roles Non-identifying role users_roles 1:N
users_roles Non-identifying users users_roles 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'variable'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK name Varchar (48) YES NO
value Longtext YES NO
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'vocabulary'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK vid Integer YES NO
name Varchar (255) YES NO
description Longtext NO NO
help Varchar (255) YES NO
relations Tinyint YES NO
hierarchy Tinyint YES NO
multiple Tinyint YES NO
required Tinyint YES NO
tags Tinyint YES NO
module Varchar (255) YES NO
weight Tinyint YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
vocabulary_node_types Non-identifying vocabulary vocabulary_node_types 1:N
term_data Non-identifying vocabulary term_data 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'vocabulary_node_types'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PFK vid Integer YES NO
PK type Varchar (32) YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
vocabulary_node_types Non-identifying vocabulary vocabulary_node_types 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT


Entity 'watchdog'
General info
Entity type: independent
Attributes
Key Attribute/role name Data type Not null Unique
PK wid Integer YES NO
FK uid Integer YES NO
type Varchar (16) YES NO
message Longtext YES NO
severity Tinyint YES NO
link Varchar (255) YES NO
location Text YES NO
referer Varchar (128) YES NO
hostname Varchar (128) YES NO
timestamp Integer YES NO
Relationships
Relationship name Type Parent entity Child entity Card.
watchdog Non-identifying users watchdog 1:N
User-defined variables
Name Value
Temporary table No
If not exists No
Table type InnoDB
Character Set
Row Format Compact
Collation
Database Name
Initial AUTO_INCREMENT