SchemaSpy Analysis of drupal7 - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Mon Jun 23 20:31 UTC 2008
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
drupal7 contains 310 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
access users int 10 0
access_arguments menu_router text 65535  √  null
access_callback menu_router varchar 255
aid actions varchar 255 0
aid actions_aid int unsigned 10  √ 
authmap.aid Implied Constraint
aid authmap int unsigned 10  √ 
actions_aid.aid Implied Constraint
authname authmap varchar 128
batch batch longtext 2147483647  √  null
bid batch int unsigned 10  √ 
boxes.bid Implied Constraint
bid blocks int 10  √ 
bid boxes int unsigned 10  √ 
batch.bid Implied Constraint
block_callback menu_router varchar 255
body boxes longtext 2147483647  √  null
body node_revisions longtext 2147483647
body_label node_type varchar 255
bootstrap system int 10 0
cache blocks tinyint 3 1
cache filter_formats tinyint 3 0
cache sessions int 10 0
callback actions varchar 255
changed node int 10 0
cid cache varchar 255
cache_menu.cid Implied Constraint
cid cache_block varchar 255
cache_menu.cid Implied Constraint
cid cache_filter varchar 255
cache_menu.cid Implied Constraint
cid cache_form varchar 255
cache_menu.cid Implied Constraint
cid cache_menu varchar 255
cache.cid Implied Constraint
cache_block.cid Implied Constraint
cache_filter.cid Implied Constraint
cache_form.cid Implied Constraint
cache_page.cid Implied Constraint
cache_registry.cid Implied Constraint
cache_update.cid Implied Constraint
cid cache_page varchar 255
cache_menu.cid Implied Constraint
cid cache_registry varchar 255
cache_menu.cid Implied Constraint
cid cache_update varchar 255
cache_menu.cid Implied Constraint
cid comments int 10  √ 
comment comments longtext 2147483647
comment node int 10 0
comment_count node_comment_statistics int unsigned 10 0
created cache int 10 0
created cache_block int 10 0
created cache_filter int 10 0
created cache_form int 10 0
created cache_menu int 10 0
created cache_page int 10 0
created cache_registry int 10 0
created cache_update int 10 0
created node int 10 0
created users int 10 0
custom blocks tinyint 3 0
custom node_type tinyint 3 0
customized menu_links smallint 5 0
data cache longblob 2147483647  √  null
data cache_block longblob 2147483647  √  null
data cache_filter longblob 2147483647  √  null
data cache_form longblob 2147483647  √  null
data cache_menu longblob 2147483647  √  null
data cache_page longblob 2147483647  √  null
data cache_registry longblob 2147483647  √  null
data cache_update longblob 2147483647  √  null
data users longtext 2147483647  √  null
daycount node_counter mediumint unsigned 8 0
delta blocks varchar 32 0
delta blocks_roles varchar 32
delta filters tinyint 3 0
depth menu_links smallint 5 0
description actions varchar 255 0
description menu_custom text 65535  √  null
description menu_router text 65535
description node_type mediumtext 16777215
description term_data longtext 2147483647  √  null
description vocabulary longtext 2147483647  √  null
dst url_alias varchar 128
event flood varchar 64
expanded menu_links smallint 5 0
expire cache int 10 0
expire cache_block int 10 0
expire cache_filter int 10 0
expire cache_form int 10 0
expire cache_menu int 10 0
expire cache_page int 10 0
expire cache_registry int 10 0
expire cache_update int 10 0
external menu_links smallint 5 0
fid files int unsigned 10  √ 
fid filters int 10  √ 
flood.fid Implied Constraint
fid flood int 10  √ 
filters.fid Implied Constraint
filemime files varchar 255
filename files varchar 255
registry_file.filename Implied Constraint
filename registry varchar 255
registry_file.filename Implied Constraint
filename registry_file varchar 255
files.filename Implied Constraint
registry.filename Implied Constraint
system.filename Implied Constraint
filename system varchar 255
registry_file.filename Implied Constraint
filepath files varchar 255
filesize files int unsigned 10 0
fit menu_router int 10 0
format boxes smallint 5 0
format comments smallint 5 0
format filter_formats int 10  √ 
filters.format Implied Constraint
node_revisions.format Implied Constraint
format filters int 10 0
filter_formats.format Implied Constraint
format node_revisions int 10 0
filter_formats.format Implied Constraint
gid node_access int unsigned 10 0
grant_delete node_access tinyint unsigned 3 0
grant_update node_access tinyint unsigned 3 0
grant_view node_access tinyint unsigned 3 0
has_body node_type tinyint unsigned 3
has_children menu_links smallint 5 0
has_title node_type tinyint unsigned 3
headers cache text 65535  √  null
headers cache_block text 65535  √  null
headers cache_filter text 65535  √  null
headers cache_form text 65535  √  null
headers cache_menu text 65535  √  null
headers cache_page text 65535  √  null
headers cache_registry text 65535  √  null
headers cache_update text 65535  √  null
help node_type mediumtext 16777215
help vocabulary varchar 255
hidden menu_links smallint 5 0
hierarchy vocabulary tinyint unsigned 3 0
homepage comments varchar 255  √  null
hostname comments varchar 128
hostname flood varchar 128
hostname sessions varchar 128
hostname watchdog varchar 128
iid blocked_ips int unsigned 10  √ 
info boxes varchar 128
info system text 65535  √  null
init users varchar 64  √ 
ip blocked_ips varchar 32
language node varchar 12
language url_alias varchar 12
language users varchar 12
last_comment_name node_comment_statistics varchar 60  √  null
last_comment_timestamp node_comment_statistics int 10 0
last_comment_uid node_comment_statistics int 10 0
link watchdog varchar 255
link_path menu_links varchar 255
link_title menu_links varchar 255
load_functions menu_router varchar 255
location watchdog text 65535
locked node_type tinyint 3 0
log node_revisions longtext 2147483647
login users int 10 0
mail comments varchar 64  √  null
mail users varchar 64  √ 
md5 registry_file varchar 32
menu_name menu_custom varchar 32
menu_links.menu_name Implied Constraint
menu_name menu_links varchar 32
menu_custom.menu_name Implied Constraint
message watchdog longtext 2147483647
min_word_count node_type smallint unsigned 5
mlid menu_links int unsigned 10  √ 
moderate node int 10 0
modified node_type tinyint 3 0
module authmap varchar 128
module blocks varchar 64
module blocks_roles varchar 64
module filters varchar 64
module menu_links varchar 255 system
module node_type varchar 255
module vocabulary varchar 255
multiple vocabulary tinyint unsigned 3 0
name comments varchar 60  √  null
name filter_formats varchar 255
name node_type varchar 255
name registry varchar 255
name role varchar 64
name system varchar 255
name term_data varchar 255
name term_synonym varchar 255
name users varchar 60
name variable varchar 128
name vocabulary varchar 255
nid comments int 10 0
node_counter.nid Implied Constraint
nid history int 10 0
node_counter.nid Implied Constraint
nid node int unsigned 10  √ 
node_access.nid Implied Constraint
node_comment_statistics.nid Implied Constraint
node_revisions.nid Implied Constraint
term_node.nid Implied Constraint
nid node_access int unsigned 10 0
node.nid Implied Constraint
nid node_comment_statistics int unsigned 10 0
node.nid Implied Constraint
nid node_counter int 10 0
comments.nid Implied Constraint
history.nid Implied Constraint
nid node_revisions int unsigned 10 0
node.nid Implied Constraint
nid term_node int unsigned 10 0
node.nid Implied Constraint
number_parts menu_router smallint 5 0
options menu_links text 65535  √  null
orig_type node_type varchar 255
owner system varchar 255
p1 menu_links int unsigned 10 0
p2 menu_links int unsigned 10 0
p3 menu_links int unsigned 10 0
p4 menu_links int unsigned 10 0
p5 menu_links int unsigned 10 0
p6 menu_links int unsigned 10 0
p7 menu_links int unsigned 10 0
p8 menu_links int unsigned 10 0
p9 menu_links int unsigned 10 0
page_arguments menu_router text 65535  √  null
page_callback menu_router varchar 255
pages blocks text 65535
parameters actions longtext 2147483647
parent term_hierarchy int unsigned 10 0
pass users varchar 128
path menu_router varchar 255
permission role_permission varchar 64
picture users varchar 255
pid comments int 10 0
pid url_alias int unsigned 10  √ 
plid menu_links int unsigned 10 0
position menu_router varchar 255
promote node int 10 0
realm node_access varchar 255
referer watchdog varchar 128
region blocks varchar 64
relations vocabulary tinyint unsigned 3 0
required vocabulary tinyint unsigned 3 0
rid blocks_roles int unsigned 10
role.rid Implied Constraint
rid role int unsigned 10  √ 
blocks_roles.rid Implied Constraint
role_permission.rid Implied Constraint
users_roles.rid Implied Constraint
rid role_permission int unsigned 10
role.rid Implied Constraint
rid users_roles int unsigned 10 0
role.rid Implied Constraint
roles filter_formats varchar 255
router_path menu_links varchar 255
schema_version system smallint 5 -1
serialized cache smallint 5 0
serialized cache_block smallint 5 0
serialized cache_filter smallint 5 0
serialized cache_form smallint 5 0
serialized cache_menu smallint 5 0
serialized cache_page smallint 5 0
serialized cache_registry smallint 5 0
serialized cache_update smallint 5 0
session sessions longtext 2147483647  √  null
severity watchdog tinyint unsigned 3 0
sid sessions varchar 64
signature users varchar 255
src url_alias varchar 128
status blocks tinyint 3 0
status comments tinyint unsigned 3 0
status files int 10 0
status node int 10 1
status system int 10 0
status users tinyint 3 0
sticky node int 10 0
subject comments varchar 64
tab_parent menu_router varchar 255
tab_root menu_router varchar 255
tags vocabulary tinyint unsigned 3 0
teaser node_revisions longtext 2147483647
theme blocks varchar 64
theme users varchar 255
thread comments varchar 255
throttle system tinyint 3 0
tid term_data int unsigned 10  √ 
term_hierarchy.tid Implied Constraint
term_node.tid Implied Constraint
term_synonym.tid Implied Constraint
tid term_hierarchy int unsigned 10 0
term_data.tid Implied Constraint
tid term_node int unsigned 10 0
term_data.tid Implied Constraint
tid term_synonym int unsigned 10 0
term_data.tid Implied Constraint
tid1 term_relation int unsigned 10 0
tid2 term_relation int unsigned 10 0
timestamp batch int 10
timestamp comments int 10 0
timestamp files int unsigned 10 0
timestamp flood int 10 0
timestamp history int 10 0
timestamp node_counter int unsigned 10 0
timestamp node_revisions int 10 0
timestamp sessions int 10 0
timestamp watchdog int 10 0
timezone users varchar 8  √  null
title blocks varchar 64
title menu_custom varchar 255
title menu_router varchar 255
title node varchar 255
title node_revisions varchar 255
title_arguments menu_router varchar 255
title_callback menu_router varchar 255
title_label node_type varchar 255
tnid node int unsigned 10 0
to_arg_functions menu_router varchar 255
token batch varchar 64
totalcount node_counter bigint unsigned 20 0
translate node int 10 0
trid term_relation int 10  √ 
tsid term_synonym int 10