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