civicrm_premiums

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_premiums_product.premiums_id FK_civicrm_premiums_product_premiums_idR
entity_table VARCHAR 64 null

Joins these premium settings to another object. Always civicrm_contribution_page for now.
entity_id INT UNSIGNED 10 null
premiums_active TINYINT 3 0

Is the Premiums feature enabled for this page?
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 null

Boolean. Should we automatically display minimum contribution amount text after the premium descriptions.
premiums_nothankyou_position INT UNSIGNED 10 √ 1
premiums_intro_title_en_US VARCHAR 255 √ null
premiums_intro_text_en_US TEXT 65535 √ null
premiums_nothankyou_label_en_US VARCHAR 255 √ null
premiums_intro_title_fr_CA VARCHAR 255 √ null
premiums_intro_text_fr_CA TEXT 65535 √ null
premiums_nothankyou_label_fr_CA VARCHAR 255 √ null

Indexes

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

Relationships

Close relationships within degrees of separation