Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_contribution_recur.payment_processor_id FK_civicrm_contribution_recur_payment_processor_id N
civicrm_financial_trxn.payment_processor_id FK_civicrm_financial_trxn_payment_processor_id N
civicrm_payment_token.payment_processor_id FK_civicrm_payment_token_payment_processor_id R

Payment Processor ID

domain_id INT UNSIGNED 10 null FK_civicrm_payment_processor_domain_id R

Which Domain is this match entry for

name VARCHAR 64 null

Payment Processor Name.

description VARCHAR 255 null

Payment Processor Description.

payment_processor_type_id INT UNSIGNED 10 null FK_civicrm_payment_processor_payment_processor_type_id R
is_active TINYINT 3 null

Is this processor active?

is_default TINYINT 3 null

Is this processor the default?

is_test TINYINT 3 null

Is this processor for a test site?

user_name VARCHAR 255 null
password VARCHAR 255 null
signature TEXT 65535 null
url_site VARCHAR 255 null
url_api VARCHAR 255 null
url_recur VARCHAR 255 null
url_button VARCHAR 255 null
subject VARCHAR 255 null
class_name VARCHAR 255 null
billing_mode INT UNSIGNED 10 null

Billing Mode

is_recur TINYINT 3 null

Can process recurring contributions

payment_type INT UNSIGNED 10 1

Payment Type: Credit or Debit

payment_instrument_id INT UNSIGNED 10 1

Payment Instrument ID

accepted_credit_cards TEXT 65535 null

array of accepted credit card types

Table contained 2 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_payment_processor_domain_id Performance Asc domain_id
FK_civicrm_payment_processor_payment_processor_type_id Performance Asc payment_processor_type_id
UI_name_test_domain_id Must be unique Asc/Asc/Asc name + is_test + domain_id