civicrm_discount

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_participant.discount_id FK_civicrm_participant_discount_idN

primary key

entity_table VARCHAR 64 null

physical tablename for entity being joined to discount, e.g. civicrm_event

entity_id INT UNSIGNED 10 null

FK to entity table specified in entity_table column.

price_set_id INT UNSIGNED 10 null
civicrm_price_set.id FK_civicrm_discount_price_set_idC

FK to civicrm_price_set

start_date DATE 10 null

Date when discount starts.

end_date DATE 10 null

Date when discount ends.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_discount_price_set_id Performance Asc price_set_id
index_entity Performance Asc/Asc entity_table + entity_id
index_entity_option_id Performance Asc/Asc/Asc entity_table + entity_id + price_set_id

Relationships