Table ezp54_community.eztrigger 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
connect_type char 1
function_name varchar 200
id int 10  √ 
module_name varchar 200
name varchar 255  √  null
workflow_id int 10  √  null
ezworkflow.id eztrigger_ibfk_1 R

Analyzed at ? 7 07 11:43 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
module_name + function_name + connect_type Must be unique Asc/Asc/Asc eztrigger_def_id
name + module_name + function_name Performance Asc/Asc/Asc eztrigger_fetch
workflow_id Performance Asc workflow_id

Close relationships  within of separation: