Table d45civi_b72v5.civicrm_premiums 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  √ 
civicrm_premiums_product.premiums_id FK_civicrm_premiums_product_premiums_id R
entity_table varchar 64 Joins these premium settings to another object. Always civicrm_contribution_page for now.
entity_id int unsigned 10
premiums_active tinyint 3 0 Is the Premiums feature enabled for this page?
premiums_intro_title varchar 255  √  null Title for Premiums section.
premiums_intro_text text 65535  √  null Displayed in <div> at top of Premiums section of page. Text and HTML allowed.
premiums_contact_email varchar 100  √  null This email address is included in receipts if it is populated and a premium has been selected.
premiums_contact_phone varchar 50  √  null This phone number is included in receipts if it is populated and a premium has been selected.
premiums_display_min_contribution tinyint 3 Boolean. Should we automatically display minimum contribution amount text after the premium descriptions.
premiums_nothankyou_label varchar 255  √  null Label displayed for No Thank-you option in premiums block (e.g. No thank you)
premiums_nothankyou_position int unsigned 10  √  1

Table contained 0 rows at Wed Nov 11 17:12 EST 2015

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

Close relationships  within of separation: