Table d47civi_0z3xa.civicrm_contribution_widget 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  √  Contribution Id
contribution_page_id int unsigned 10  √  null
civicrm_contribution_page.id FK_civicrm_contribution_widget_contribution_page_id C
The Contribution Page which triggered this contribution
is_active tinyint 3  √  null Is this property active?
title varchar 255  √  null Widget title.
url_logo varchar 255  √  null URL to Widget logo
button_title varchar 255  √  null Button title.
about text 65535  √  null About description.
url_homepage varchar 255  √  null URL to Homepage.
color_title varchar 10  √  null
color_button varchar 10  √  null
color_bar varchar 10  √  null
color_main_text varchar 10  √  null
color_main varchar 10  √  null
color_main_bg varchar 10  √  null
color_bg varchar 10  √  null
color_about_link varchar 10  √  null
color_homepage_link varchar 10  √  null

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

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

Close relationships  within of separation: