Table d45civi_b72v5.civicrm_payment_processor_type 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_payment_processor.payment_processor_type_id FK_civicrm_payment_processor_payment_processor_type_id R
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 Billing Mode
is_recur tinyint 3  √  null Can process recurring contributions
payment_type int unsigned 10  √  1 Payment Type: Credit or Debit

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
name Must be unique Asc UI_name This unique column is also nullable

Close relationships  within of separation: