Table ezp54_community.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 bigint 19 0
link int 10 0
parent int 10 0
text longtext 2147483647
text_md5 varchar 32

Analyzed at ? 7 07 11:43 CEST 2015

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_type + is_original + is_alias Performance Asc/Asc/Asc ezurlalias_ml_actt_org_al
id Performance Asc ezurlalias_ml_id
action + id + link + parent Performance Asc/Asc/Asc/Asc ezurlalias_ml_par_act_id_lnk
parent + text + link Performance Asc/Asc/Asc ezurlalias_ml_par_lnk_txt
text + id + link Performance Asc/Asc/Asc ezurlalias_ml_text
text + lang_mask + parent Performance Asc/Asc/Asc ezurlalias_ml_text_lang