civicrm_premiums_en_US - civicrm Database

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

INT UNSIGNED

entity_table

VARCHAR

null

Joins these premium settings to another object. Always civicrm_contribution_page for now.

entity_id

INT UNSIGNED

null

premiums_active

TINYINT

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

√

null

This phone number is included in receipts if it is populated and a premium has been selected.

premiums_display_min_contribution

TINYINT

null

Boolean. Should we automatically display minimum contribution amount text after the premium descriptions.

premiums_nothankyou_position

INT UNSIGNED

√

premiums_intro_title

VARCHAR

255

√

null

premiums_intro_text

TEXT

65535

√

null

premiums_nothankyou_label

VARCHAR

255

√

null

Showing 1 to 11 of 11 entries

View Definition

 
select `civicrm`.`civicrm_premiums`.`id` AS `id`,`civicrm`.`civicrm_premiums`.`entity_table` AS `entity_table`,`civicrm`.`civicrm_premiums`.`entity_id` AS `entity_id`,`civicrm`.`civicrm_premiums`.`premiums_active` AS `premiums_active`,`civicrm`.`civicrm_premiums`.`premiums_contact_email` AS `premiums_contact_email`,`civicrm`.`civicrm_premiums`.`premiums_contact_phone` AS `premiums_contact_phone`,`civicrm`.`civicrm_premiums`.`premiums_display_min_contribution` AS `premiums_display_min_contribution`,`civicrm`.`civicrm_premiums`.`premiums_nothankyou_position` AS `premiums_nothankyou_position`,`civicrm`.`civicrm_premiums`.`premiums_intro_title_en_US` AS `premiums_intro_title`,`civicrm`.`civicrm_premiums`.`premiums_intro_text_en_US` AS `premiums_intro_text`,`civicrm`.`civicrm_premiums`.`premiums_nothankyou_label_en_US` AS `premiums_nothankyou_label` from `civicrm`.`civicrm_premiums`

Possibly Referenced Tables/Views

civicrm_premiums