Table ezp54_community.eznotificationcollection_item 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
address varchar 255
collection_id int 10 0
eznotificationcollection.id eznotificationcollection_item_ibfk_1 R
event_id int 10 0
eznotificationevent.id eznotificationcollection_item_ibfk_2 R
id int 10  √ 
send_date int 10 0

Analyzed at ? 7 07 11:43 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
collection_id Performance Asc collection_id
event_id Performance Asc event_id

Close relationships: