Table d44civi_9xzwf.civicrm_contribution | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Table contained 93 rows at Wed Nov 11 17:14 EST 2015 |
Indexes:
Column(s) | Type | Sort | Constraint Name | Anomalies |
---|---|---|---|---|
id | Primary key | Asc | PRIMARY | |
check_number | Performance | Asc | check_number | |
address_id | Performance | Asc | FK_civicrm_contribution_address_id | |
campaign_id | Performance | Asc | FK_civicrm_contribution_campaign_id | |
contact_id | Performance | Asc | FK_civicrm_contribution_contact_id | |
contribution_page_id | Performance | Asc | FK_civicrm_contribution_contribution_page_id | |
contribution_recur_id | Performance | Asc | FK_civicrm_contribution_contribution_recur_id | |
financial_type_id | Performance | Asc | FK_civicrm_contribution_financial_type_id | |
honor_contact_id | Performance | Asc | FK_civicrm_contribution_honor_contact_id | |
contribution_status_id | Performance | Asc | index_contribution_status | |
receive_date | Performance | Asc | received_date | |
invoice_id | Must be unique | Asc | UI_contrib_invoice_id | This unique column is also nullable |
payment_instrument_id | Performance | Asc | UI_contrib_payment_instrument_id | |
trxn_id | Must be unique | Asc | UI_contrib_trxn_id | This unique column is also nullable |
|