Table d47civi_0z3xa.cividiscount_item Generated by
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  √ 
cividiscount_track.item_id FK_cividiscount_track_item_id N
Discount Item ID
code varchar 255 Discount Code.
description varchar 255 Discount Description.
amount varchar 255 Amount of discount either actual or percentage?
amount_type varchar 4 Type of discount, actual or percentage?
count_max int 10 Max number of times this code can be used.
count_use int 10 0 Number of times this code has been used.
events text 65535  √  null Serialized list of events for which this code can be used
pricesets text 65535  √  null Serialized list of pricesets for which this code can be used
memberships text 65535  √  null Serialized list of memberships for which this code can be used
autodiscount text 65535  √  null Some sort of autodiscounting mechanism?
organization_id int unsigned 10  √  null FK_cividiscount_item_organization_id N
FK to Contact ID for the organization that originated this discount
active_on datetime 19  √  null When is this discount activated?
expire_on datetime 19  √  null When does this discount expire?
is_active tinyint 3  √  null Is this discount active?
discount_msg_enabled tinyint 3  √  0 Is discount message is available for promotion?
discount_msg varchar 255  √  null Discount message
filters varchar 255  √  null Discount Filters.

Table contained 0 rows at mer. avr. 13 16:52 EDT 2016

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

Close relationships  within of separation: