civicrm_payment_processor

2 rows


Columns

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_idN
civicrm_financial_trxn.payment_processor_id FK_civicrm_financial_trxn_payment_processor_idN
civicrm_payment_token.payment_processor_id FK_civicrm_payment_token_payment_processor_idR

Payment Processor ID
domain_id INT UNSIGNED 10 null
civicrm_domain.id FK_civicrm_payment_processor_domain_idR

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
civicrm_payment_processor_type.id FK_civicrm_payment_processor_payment_processor_type_idR
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
title_en_US TEXT 65535 √ null

Payment Processor Descriptive Name.
title_fr_CA TEXT 65535 √ null

Payment Processor Descriptive Name.

Indexes

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

Relationships

Close relationships within degrees of separation