SchemaSpy - dmoz

Generated by SchemaSpy on lun feb 04 12:06 CET 2008

Legend:

Primary key columns

Columns with indexes

dmoz contains 56 columns:

Column	Table	Type	Size	Auto	Default
catid	dmoz_aliases	int	11		0
catid	dmoz_altlangs	int	11		0
catid	dmoz_categories	int	11		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
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	√
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
Alias	dmoz_aliases	varchar	128
ages	dmoz_externalpages	varchar	128
type	dmoz_externalpages	varchar	128
type	dmoz_newsgroups	varchar	128
related	dmoz_related	varchar	254
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
aolsearch	dmoz_categories	varchar	255
catid	dmoz_editors	int	255		0
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
resource	dmoz_altlangs	varchar	255
resource	dmoz_symbolics	varchar	255
symbolic	dmoz_symbolics	varchar	255
link	dmoz_externalpages	varchar	512
Description	dmoz_categories	text	65535
Description	dmoz_externalpages	text	65535