SchemaSpy Analysis of dmoz - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on lun feb 04 12:06 CET 2008 |
| ||||||
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 |