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
catid dmoz_aliases int 11 0
id dmoz_aliases int 11  √ 
tcatid dmoz_aliases int 11 0
catid dmoz_altlangs int 11 0
id dmoz_altlangs int 11  √ 
language dmoz_altlangs varchar 255
rcatid dmoz_altlangs int 11 0
resource dmoz_altlangs varchar 255
Description dmoz_categories text 65535
Title dmoz_categories varchar 255
Topic dmoz_categories varchar 255
aolsearch dmoz_categories varchar 255
catid dmoz_categories int 11 0
charset dmoz_categories varchar 255
dispname dmoz_categories varchar 255
fatherid dmoz_categories int 11 0
id dmoz_categories int 11  √ 
lastUpdate dmoz_categories varchar 255
catid dmoz_editors int 255 0
editor dmoz_editors varchar 255
id dmoz_editors int 11  √ 
Description dmoz_externalpages text 65535
Title dmoz_externalpages varchar 255
ages dmoz_externalpages varchar 128
catid dmoz_externalpages int 11 0
id dmoz_externalpages int 11  √ 
link dmoz_externalpages varchar 512
mediadate dmoz_externalpages varchar 255
priority dmoz_externalpages int 11 0
type dmoz_externalpages varchar 128
catid dmoz_letterbars int 11 0
id dmoz_letterbars int 11  √ 
lcatid dmoz_letterbars int 11 0
letterbar dmoz_letterbars varchar 255
catid dmoz_narrows int 11 0
id dmoz_narrows int 11  √ 
narrow dmoz_narrows varchar 255
ncatid dmoz_narrows int 11 0
priority dmoz_narrows int 11 0
catid dmoz_newsgroups int 11 0
id dmoz_newsgroups int 11  √ 
newsGroup dmoz_newsgroups varchar 255
type dmoz_newsgroups varchar 128
catid dmoz_related int 11 0
id dmoz_related int 11  √ 
rcatid dmoz_related int 11 0
related dmoz_related varchar 254
catid dmoz_symbolics int 11 0
id dmoz_symbolics int 11  √ 
priority dmoz_symbolics int 11 0
resource dmoz_symbolics varchar 255
scatid dmoz_symbolics int 11 0
symbolic dmoz_symbolics varchar 255