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