SchemaSpy Analysis of drupal - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Fri Jan 19 10:16 EST 2007
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
drupal contains 226 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
aid access int 11  √ 
mask access varchar 255
status access tinyint 4 0
type access varchar 255
aid authmap int unsigned 10  √ 
authname authmap varchar 128
module authmap varchar 128
uid authmap int 11 0
custom blocks tinyint 4 0
delta blocks varchar 32 0
module blocks varchar 64
pages blocks text 65535
region blocks varchar 64 left
status blocks tinyint 4 0
theme blocks varchar 255
throttle blocks tinyint 4 0
title blocks varchar 64
visibility blocks tinyint 4 0
weight blocks tinyint 4 0
delta blocks_roles varchar 32
module blocks_roles varchar 64
rid blocks_roles int unsigned 10
role.rid Implied Constraint
bid boxes int 11  √ 
body boxes longtext 2147483647  √  null
format boxes int 11 0
filter_formats.format Implied Constraint
info boxes varchar 128
cid cache varchar 255
cache_page.cid Implied Constraint
created cache int 11 0
data cache longblob 2147483647  √  null
expire cache int 11 0
headers cache text 65535  √  null
cid cache_filter varchar 255
cache_page.cid Implied Constraint
created cache_filter int 11 0
data cache_filter longblob 2147483647  √  null
expire cache_filter int 11 0
headers cache_filter text 65535  √  null
cid cache_menu varchar 255
cache_page.cid Implied Constraint
created cache_menu int 11 0
data cache_menu longblob 2147483647  √  null
expire cache_menu int 11 0
headers cache_menu text 65535  √  null
cid cache_page varchar 255
cache.cid Implied Constraint
cache_filter.cid Implied Constraint
cache_menu.cid Implied Constraint
created cache_page int 11 0
data cache_page longblob 2147483647  √  null
expire cache_page int 11 0
headers cache_page text 65535  √  null
cid comments int 11  √ 
comment comments longtext 2147483647
format comments int 11 0
filter_formats.format Implied Constraint
homepage comments varchar 255  √  null
hostname comments varchar 128
mail comments varchar 64  √  null
name comments varchar 60  √  null
nid comments int 11 0
node_counter.nid Implied Constraint
pid comments int 11 0
score comments mediumint 9 0
status comments tinyint unsigned 3 0
subject comments varchar 64
thread comments varchar 255
timestamp comments int 11 0
uid comments int 11 0
users comments longtext 2147483647  √  null
description file_revisions varchar 255
fid file_revisions int unsigned 10 0
files.fid Implied Constraint
list file_revisions tinyint unsigned 3 0
vid file_revisions int unsigned 10 0
vocabulary.vid Implied Constraint
fid files int unsigned 10 0
file_revisions.fid Implied Constraint
filemime files varchar 255
filename files varchar 255
system.filename Implied Constraint
filepath files varchar 255
filesize files int unsigned 10 0
nid files int unsigned 10 0
node_comment_statistics.nid Implied Constraint
cache filter_formats tinyint 4 0
format filter_formats int 11  √ 
boxes.format Implied Constraint
comments.format Implied Constraint
filters.format Implied Constraint
node_revisions.format Implied Constraint
name filter_formats varchar 255
sequences.name Implied Constraint
roles filter_formats varchar 255
delta filters tinyint 4 0
format filters int 11 0
filter_formats.format Implied Constraint
module filters varchar 64
weight filters tinyint 4 0
event flood varchar 64
hostname flood varchar 128
timestamp flood int 11 0
nid history int 11 0
node_counter.nid Implied Constraint
timestamp history int 11 0
uid history int 11 0
description menu varchar 255
mid menu int unsigned 10 0
path menu varchar 255
pid menu int unsigned 10 0
url_alias.pid Implied Constraint
title menu varchar 255
type menu int unsigned 10 0
weight menu tinyint 4 0
changed node int 11 0
comment node int 11 0
created node int 11 0
moderate node int 11 0
nid node int unsigned 10  √ 
node_comment_statistics.nid Implied Constraint
promote node int 11 0
status node int 11 1
sticky node int 11 0
title node varchar 128
type node varchar 32
node_type.type Implied Constraint
uid node int 11 0
vid node int unsigned 10 0
vocabulary.vid 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
nid node_access int unsigned 10 0
node_comment_statistics.nid Implied Constraint
realm node_access varchar 255
comment_count node_comment_statistics int unsigned 10 0
last_comment_name node_comment_statistics varchar 60  √  null
last_comment_timestamp node_comment_statistics int 11 0
last_comment_uid node_comment_statistics int 11 0
nid node_comment_statistics int unsigned 10  √ 
files.nid Implied Constraint
node.nid Implied Constraint
node_access.nid Implied Constraint
node_revisions.nid Implied Constraint
term_node.nid Implied Constraint
daycount node_counter mediumint unsigned 8 0
nid node_counter int 11 0
comments.nid Implied Constraint
history.nid Implied Constraint
timestamp node_counter int unsigned 10 0
totalcount node_counter bigint unsigned 20 0
body node_revisions longtext 2147483647
format node_revisions int 11 0
filter_formats.format Implied Constraint
log node_revisions longtext 2147483647
nid node_revisions int unsigned 10
node_comment_statistics.nid Implied Constraint
teaser node_revisions longtext 2147483647
timestamp node_revisions int 11 0
title node_revisions varchar 128
uid node_revisions int 11 0
vid node_revisions int unsigned 10
vocabulary.vid Implied Constraint
body_label node_type varchar 255
custom node_type tinyint 4 0
description node_type mediumtext 16277215
has_body node_type tinyint unsigned 3
has_title node_type tinyint unsigned 3
help node_type mediumtext 16277215
locked node_type tinyint 4 0
min_word_count node_type smallint unsigned 5
modified node_type tinyint 4 0
module node_type varchar 255
name node_type varchar 255
sequences.name Implied Constraint
orig_type node_type varchar 255
title_label node_type varchar 255
type node_type varchar 32
node.type Implied Constraint
vocabulary_node_types.type Implied Constraint
perm permission longtext 2147483647  √  null
rid permission int unsigned 10 0
role.rid Implied Constraint
tid permission int unsigned 10 0
term_data.tid Implied Constraint
name role varchar 64
rid role int unsigned 10  √ 
blocks_roles.rid Implied Constraint
permission.rid Implied Constraint
users_roles.rid Implied Constraint
id sequences int unsigned 10 0
name sequences varchar 255
filter_formats.name Implied Constraint
node_type.name Implied Constraint
system.name Implied Constraint
term_data.name Implied Constraint
term_synonym.name Implied Constraint
vocabulary.name Implied Constraint
cache sessions int 11 0
hostname sessions varchar 128
session sessions longtext 2147483647  √  null
sid sessions varchar 64
timestamp sessions int 11 0
uid sessions int unsigned 10
users.uid Implied Constraint
bootstrap system int 11 0
description system varchar 255
filename system varchar 255
files.filename Implied Constraint
name system varchar 255
sequences.name Implied Constraint
schema_version system smallint 6 -1
status system int 11 0
throttle system tinyint 4 0
type system varchar 255
weight system int 11 0
description term_data longtext 2147483647  √  null
name term_data varchar 255
sequences.name Implied Constraint
tid term_data int unsigned 10  √ 
permission.tid Implied Constraint
term_hierarchy.tid Implied Constraint
term_node.tid Implied Constraint
term_synonym.tid Implied Constraint
vid term_data int unsigned 10 0
vocabulary.vid Implied Constraint
weight term_data tinyint 4 0
parent term_hierarchy int unsigned 10 0
tid term_hierarchy int unsigned 10 0
term_data.tid Implied Constraint
nid term_node int unsigned 10 0
node_comment_statistics.nid Implied Constraint
tid term_node int unsigned 10 0
term_data.tid Implied Constraint
tid1 term_relation int unsigned 10 0
tid2 term_relation int unsigned 10 0
name term_synonym varchar 255
sequences.name Implied Constraint
tid term_synonym int unsigned 10 0
term_data.tid Implied Constraint
dst url_alias varchar 128
pid url_alias int unsigned 10  √ 
menu.pid Implied Constraint
src url_alias varchar 128
access users int 11 0
created users int 11 0
data users longtext 2147483647  √  null
init users varchar 64  √ 
language users varchar 12
login users int 11 0
mail users varchar 64  √ 
mode users tinyint 4 0
name users varchar 60
pass users varchar 32
picture users varchar 255
signature users varchar 255
sort users tinyint 4  √  0
status users tinyint 4 0
theme users varchar 255
threshold users tinyint 4  √  0
timezone users varchar 8  √  null
uid users int unsigned 10 0
sessions.uid Implied Constraint
users_roles.uid Implied Constraint
rid users_roles int unsigned 10 0
role.rid Implied Constraint
uid users_roles int unsigned 10 0
users.uid Implied Constraint
name variable varchar 48
value variable longtext 2147483647
description vocabulary longtext 2147483647  √  null
help vocabulary varchar 255
hierarchy vocabulary tinyint unsigned 3 0
module vocabulary varchar 255
multiple vocabulary tinyint unsigned 3 0
name vocabulary varchar 255
sequences.name Implied Constraint
relations vocabulary tinyint unsigned 3 0
required vocabulary tinyint unsigned 3 0
tags vocabulary tinyint unsigned 3 0
vid vocabulary int unsigned 10  √ 
file_revisions.vid Implied Constraint
node.vid Implied Constraint
node_revisions.vid Implied Constraint
term_data.vid Implied Constraint
vocabulary_node_types.vid Implied Constraint
weight vocabulary tinyint 4 0
type vocabulary_node_types varchar 32
node_type.type Implied Constraint
vid vocabulary_node_types int unsigned 10 0
vocabulary.vid Implied Constraint
hostname watchdog varchar 128
link watchdog varchar 255
location watchdog text 65535
message watchdog longtext 2147483647
referer watchdog varchar 128
severity watchdog tinyint unsigned 3 0
timestamp watchdog int 11 0
type watchdog varchar 16
uid watchdog int 11 0
wid watchdog int 11  √