Table eZ Publish.ezurlalias_ml Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
action longtext 2147483647
action_type varchar 32
alias_redirects int 10 1
id int 10 0
is_alias int 10 0
is_original int 10 0
lang_mask int 10 0
link int 10 0
parent int 10 0
text longtext 2147483647
text_md5 varchar 32

Analyzed at Mon Jan 02 16:38 CET 2012

Indexes:
Column(s) Type Sort Constraint Name
parent + text_md5 Primary key Asc/Asc PRIMARY
action + is_original Performance Asc/Asc ezurlalias_ml_act_org
action + id + link Performance Asc/Asc/Asc ezurlalias_ml_action
action_type Performance Asc ezurlalias_ml_actt
action_type + is_original + is_alias Performance Asc/Asc/Asc ezurlalias_ml_actt_org_al
id Performance Asc ezurlalias_ml_id
parent + action + id + link Performance Asc/Asc/Asc/Asc ezurlalias_ml_par_act_id_lnk
parent + link + text Performance Asc/Asc/Asc ezurlalias_ml_par_lnk_txt
parent + text Performance Asc/Asc ezurlalias_ml_par_txt
text + id + link Performance Asc/Asc/Asc ezurlalias_ml_text
text + lang_mask + parent Performance Asc/Asc/Asc ezurlalias_ml_text_lang