Table d47civi_0z3xa.civicrm_tell_friend 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  √  Friend ID
entity_table varchar 64 Name of table where item being referenced is stored.
entity_id int unsigned 10 Foreign key to the referenced item.
title varchar 255  √  null
intro text 65535  √  null Introductory message to contributor or participant displayed on the Tell a Friend form.
suggested_message text 65535  √  null Suggested message to friends, provided as default on the Tell A Friend form.
general_link varchar 255  √  null URL for general info about the organization - included in the email sent to friends.
thankyou_title varchar 255  √  null Text for Tell a Friend thank you page header and HTML title.
thankyou_text text 65535  √  null Thank you message displayed on success page.
is_active tinyint 3  √  null

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

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