Table d47civi_0z3xa.cividiscount_track Generated by
SchemaSpy
Legend: SourceForge.net
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  √  Discount Item ID
item_id int unsigned 10  √  null
cividiscount_item.id FK_cividiscount_track_item_id N
FK to Item ID of the discount code
contact_id int unsigned 10  √  null
civicrm_contact.id FK_cividiscount_track_contact_id N
FK to Contact ID for the contact that used this discount
used_date datetime 19  √  null Date of use
contribution_id int unsigned 10  √  null
civicrm_contribution.id FK_cividiscount_track_contribution_id C
FK to contribution table.
entity_table varchar 64 Name of table where item being referenced is stored
entity_id int unsigned 10 Foreign key to the referenced item
description text 65535  √  null Discount use description

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
contact_id Performance Asc FK_cividiscount_track_contact_id
contribution_id Performance Asc FK_cividiscount_track_contribution_id
item_id Performance Asc FK_cividiscount_track_item_id

Close relationships  within of separation: