Table drupal.node Generated by
SchemaSpy
Implied relationships Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
nid int unsigned 10  √ 
node_comment_statistics.nid Implied Constraint
vid int unsigned 10 0
vocabulary.vid Implied Constraint
type varchar 32
node_type.type Implied Constraint
title varchar 128
uid int 11 0
status int 11 1
created int 11 0
changed int 11 0
comment int 11 0
promote int 11 0
moderate int 11 0
sticky int 11 0

Table contained 0 rows at Fri Jan 19 10:16 EST 2007

Indexes:
Column(s) Type Sort Constraint Name
nid + vid Primary key Asc/Asc PRIMARY
nid Performance Asc nid
changed Performance Asc node_changed
created Performance Asc node_created
moderate Performance Asc node_moderate
promote + status Performance Asc/Asc node_promote_status
status + type + nid Performance Asc/Asc/Asc node_status_type
title + type Performance Asc/Asc node_title_type
type Performance Asc node_type
status Performance Asc status
uid Performance Asc uid
vid Must be unique Asc vid

Close relationships: