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
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