SchemaSpy Analysis of dmoz - Columns Generated by
SchemaSpy
Generated by SchemaSpy on lun feb 04 12:06 CET 2008
Legend: SourceForge.net
Primary key columns
Columns with indexes

Related columns Constraint names Comments Legend
dmoz contains 56 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
Alias dmoz_aliases varchar 128
Target dmoz_aliases varchar 255
Title dmoz_aliases varchar 255
Title dmoz_categories varchar 255
Title dmoz_externalpages varchar 255
Topic dmoz_categories varchar 255
ages dmoz_externalpages varchar 128
aolsearch dmoz_categories varchar 255
charset dmoz_categories varchar 255
dispname dmoz_categories varchar 255
editor dmoz_editors varchar 255
language dmoz_altlangs varchar 255
lastUpdate dmoz_categories varchar 255
letterbar dmoz_letterbars varchar 255
mediadate dmoz_externalpages varchar 255
narrow dmoz_narrows varchar 255
newsGroup dmoz_newsgroups varchar 255
related dmoz_related varchar 254
resource dmoz_altlangs varchar 255
resource dmoz_symbolics varchar 255
symbolic dmoz_symbolics varchar 255
type dmoz_externalpages varchar 128
type dmoz_newsgroups varchar 128
catid dmoz_aliases int 11 0
catid dmoz_altlangs int 11 0
catid dmoz_categories int 11 0
catid dmoz_editors int 255 0
catid dmoz_externalpages int 11 0
catid dmoz_letterbars int 11 0
catid dmoz_narrows int 11 0
catid dmoz_newsgroups int 11 0
catid dmoz_related int 11 0
catid dmoz_symbolics int 11 0
fatherid dmoz_categories int 11 0
lcatid dmoz_letterbars int 11 0
ncatid dmoz_narrows int 11 0
priority dmoz_externalpages int 11 0
priority dmoz_narrows int 11 0
priority dmoz_symbolics int 11 0
rcatid dmoz_altlangs int 11 0
rcatid dmoz_related int 11 0
scatid dmoz_symbolics int 11 0
tcatid dmoz_aliases int 11 0
Description dmoz_categories text 65535
Description dmoz_externalpages text 65535
id dmoz_aliases int 11  √ 
id dmoz_altlangs int 11  √ 
id dmoz_categories int 11  √ 
id dmoz_editors int 11  √ 
id dmoz_externalpages int 11  √ 
id dmoz_letterbars int 11  √ 
id dmoz_narrows int 11  √ 
id dmoz_newsgroups int 11  √ 
id dmoz_related int 11  √ 
id dmoz_symbolics int 11  √ 
link dmoz_externalpages varchar 512