Table d45civi_b72v5.civicrm_contribution_recur | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Table contained 0 rows at Wed Nov 11 17:12 EST 2015 |
Indexes:
Column(s) | Type | Sort | Constraint Name | Anomalies |
---|---|---|---|---|
id | Primary key | Asc | PRIMARY | |
campaign_id | Performance | Asc | FK_civicrm_contribution_recur_campaign_id | |
contact_id | Performance | Asc | FK_civicrm_contribution_recur_contact_id | |
financial_type_id | Performance | Asc | FK_civicrm_contribution_recur_financial_type_id | |
payment_processor_id | Performance | Asc | FK_civicrm_contribution_recur_payment_processor_id | |
contribution_status_id | Performance | Asc | index_contribution_status | |
invoice_id | Must be unique | Asc | UI_contrib_invoice_id | This unique column is also nullable |
trxn_id | Must be unique | Asc | UI_contrib_trxn_id | This unique column is also nullable |
payment_instrument_id | Performance | Asc | UI_contribution_recur_payment_instrument_id |
|