civicrm_premiums_product

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null

Contribution ID
premiums_id INT UNSIGNED 10 null
civicrm_premiums.id FK_civicrm_premiums_product_premiums_idR

Foreign key to premiums settings record.
product_id INT UNSIGNED 10 null
civicrm_product.id FK_civicrm_premiums_product_product_idR

Foreign key to each product object.
weight INT UNSIGNED 10 null
financial_type_id INT UNSIGNED 10 √ null
civicrm_financial_type.id FK_civicrm_premiums_product_financial_type_idN

FK to Financial Type.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_premiums_product_financial_type_id Performance Asc financial_type_id
FK_civicrm_premiums_product_premiums_id Performance Asc premiums_id
FK_civicrm_premiums_product_product_id Performance Asc product_id

Relationships

Close relationships within degrees of separation