civicrm_payment_processor_type

13 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_payment_processor.payment_processor_type_id FK_civicrm_payment_processor_payment_processor_type_idR

Payment Processor Type ID
name VARCHAR 64 √ null

Payment Processor Name.
title VARCHAR 127 √ null

Payment Processor Name.
description VARCHAR 255 √ null

Payment Processor Description.
is_active TINYINT 3 √ null

Is this processor active?
is_default TINYINT 3 √ null

Is this processor the default?
user_name_label VARCHAR 255 √ null
password_label VARCHAR 255 √ null
signature_label VARCHAR 255 √ null
subject_label VARCHAR 255 √ null
class_name VARCHAR 255 √ null
url_site_default VARCHAR 255 √ null
url_api_default VARCHAR 255 √ null
url_recur_default VARCHAR 255 √ null
url_button_default VARCHAR 255 √ null
url_site_test_default VARCHAR 255 √ null
url_api_test_default VARCHAR 255 √ null
url_recur_test_default VARCHAR 255 √ null
url_button_test_default 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

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
UI_name Must be unique Asc name

Relationships

Close relationships within degrees of separation