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