Table d45civi_b72v5.civicrm_payment_processor Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
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
Payment Processor ID
domain_id int unsigned 10
civicrm_domain.id 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
civicrm_payment_processor_type.id 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 Billing Mode
is_recur tinyint 3  √  null Can process recurring contributions
payment_type int unsigned 10  √  1 Payment Type: Credit or Debit

Table contained 2 rows at Wed Nov 11 17:12 EST 2015

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

Close relationships  within of separation: