Table d47civi_0z3xa.civicrm_mailing_abtest 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
id int unsigned 10  √ 
name varchar 128  √  null Name of the A/B test
status varchar 32  √  null Status
mailing_id_a int unsigned 10  √  null The first experimental mailing ("A" condition)
mailing_id_b int unsigned 10  √  null The second experimental mailing ("B" condition)
mailing_id_c int unsigned 10  √  null The final, general mailing (derived from A or B)
domain_id int unsigned 10  √  null Which site is this mailing for
testing_criteria varchar 32  √  null
winner_criteria varchar 32  √  null
specific_url varchar 255  √  null What specific url to track
declare_winning_time datetime 19  √  null In how much time to declare winner
group_percentage int unsigned 10  √  null
created_id int unsigned 10  √  null
civicrm_contact.id FK_civicrm_mailing_abtest_created_id N
FK to Contact ID
created_date datetime 19  √  null When was this item created

Table contained 0 rows at mer. avr. 13 16:52 EDT 2016

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

Close relationships  within of separation: