f880640595af6ee821a4e6a737deb14deb8a2ef9
[civicrm-core.git] / xml / schema / Financial / PaymentProcessor.xml
1 <?xml version="1.0" encoding="iso-8859-1" ?>
2
3 <table>
4 <base>CRM/Financial</base>
5 <class>PaymentProcessor</class>
6 <name>civicrm_payment_processor</name>
7 <add>1.8</add>
8 <field>
9 <name>id</name>
10 <title>Payment Processor ID</title>
11 <type>int unsigned</type>
12 <required>true</required>
13 <comment>Payment Processor ID</comment>
14 <add>1.8</add>
15 </field>
16 <primaryKey>
17 <name>id</name>
18 <autoincrement>true</autoincrement>
19 </primaryKey>
20 <field>
21 <name>domain_id</name>
22 <title>Payment Processor Domain</title>
23 <type>int unsigned</type>
24 <required>true</required>
25 <pseudoconstant>
26 <table>civicrm_domain</table>
27 <keyColumn>id</keyColumn>
28 <labelColumn>name</labelColumn>
29 </pseudoconstant>
30 <comment>Which Domain is this match entry for</comment>
31 <add>3.0</add>
32 </field>
33 <foreignKey>
34 <name>domain_id</name>
35 <table>civicrm_domain</table>
36 <key>id</key>
37 <add>3.0</add>
38 </foreignKey>
39 <field>
40 <name>name</name>
41 <title>Payment Processor</title>
42 <type>varchar</type>
43 <length>64</length>
44 <comment>Payment Processor Name.</comment>
45 <add>1.8</add>
46 </field>
47 <field>
48 <name>description</name>
49 <title>Processor Description</title>
50 <type>varchar</type>
51 <length>255</length>
52 <comment>Payment Processor Description.</comment>
53 <add>1.8</add>
54 </field>
55 <field>
56 <name>payment_processor_type</name>
57 <type>varchar</type>
58 <length>255</length>
59 <comment>Payment Processor Type.</comment>
60 <add>1.8</add>
61 <drop>4.3</drop>
62 </field>
63 <field>
64 <name>payment_processor_type_id</name>
65 <title>Payment Processor Type ID</title>
66 <type>int unsigned</type>
67 <pseudoconstant>
68 <table>civicrm_payment_processor_type</table>
69 <keyColumn>id</keyColumn>
70 <labelColumn>title</labelColumn>
71 </pseudoconstant>
72 <length>10</length>
73 <add>4.3</add>
74 </field>
75 <foreignKey>
76 <name>payment_processor_type_id</name>
77 <table>civicrm_payment_processor_type</table>
78 <key>id</key>
79 <add>4.3</add>
80 </foreignKey>
81 <field>
82 <name>is_active</name>
83 <title>Processor is Active?</title>
84 <type>boolean</type>
85 <comment>Is this processor active?</comment>
86 <add>1.8</add>
87 </field>
88 <field>
89 <name>is_default</name>
90 <title>Processor Is Default?</title>
91 <type>boolean</type>
92 <comment>Is this processor the default?</comment>
93 <add>1.8</add>
94 </field>
95 <field>
96 <name>is_test</name>
97 <title>Is Test Processor?</title>
98 <type>boolean</type>
99 <comment>Is this processor for a test site?</comment>
100 <add>1.8</add>
101 </field>
102 <index>
103 <name>UI_name_test_domain_id</name>
104 <fieldName>name</fieldName>
105 <fieldName>is_test</fieldName>
106 <fieldName>domain_id</fieldName>
107 <unique>true</unique>
108 <add>1.8</add>
109 </index>
110 <field>
111 <name>user_name</name>
112 <title>User Name</title>
113 <type>varchar</type>
114 <length>255</length>
115 <add>1.8</add>
116 </field>
117 <field>
118 <name>password</name>
119 <title>Password</title>
120 <type>varchar</type>
121 <length>255</length>
122 <add>1.8</add>
123 </field>
124 <field>
125 <name>signature</name>
126 <title>Signature</title>
127 <type>text</type>
128 <add>1.8</add>
129 </field>
130 <field>
131 <name>url_site</name>
132 <title>Site URL</title>
133 <type>varchar</type>
134 <length>255</length>
135 <add>1.8</add>
136 </field>
137 <field>
138 <name>url_api</name>
139 <title>API URL</title>
140 <type>varchar</type>
141 <length>255</length>
142 <add>1.8</add>
143 </field>
144 <field>
145 <name>url_recur</name>
146 <title>Recurring Payments URL</title>
147 <type>varchar</type>
148 <length>255</length>
149 <add>1.8</add>
150 </field>
151 <field>
152 <name>url_button</name>
153 <title>Button URL</title>
154 <type>varchar</type>
155 <length>255</length>
156 <add>1.8</add>
157 </field>
158 <field>
159 <name>subject</name>
160 <title>Subject</title>
161 <type>varchar</type>
162 <length>255</length>
163 <add>1.8</add>
164 </field>
165 <field>
166 <name>class_name</name>
167 <title>Suffix for PHP class name implementation</title>
168 <type>varchar</type>
169 <length>255</length>
170 <add>1.8</add>
171 </field>
172 <field>
173 <name>billing_mode</name>
174 <title>Processor Billing Mode</title>
175 <type>int unsigned</type>
176 <required>true</required>
177 <comment>Billing Mode (deprecated)</comment>
178 <add>1.8</add>
179 </field>
180 <field>
181 <name>is_recur</name>
182 <title>Processor Supports Recurring?</title>
183 <type>boolean</type>
184 <comment>Can process recurring contributions</comment>
185 <add>1.8</add>
186 </field>
187 <field>
188 <name>payment_type</name>
189 <title>Payment Type</title>
190 <type>int unsigned</type>
191 <default>1</default>
192 <comment>Payment Type: Credit or Debit (deprecated)</comment>
193 <add>3.0</add>
194 </field>
195 <field>
196 <name>payment_instrument_id</name>
197 <title>Payment Method</title>
198 <type>int unsigned</type>
199 <default>1</default>
200 <comment>Payment Instrument ID</comment>
201 <pseudoconstant>
202 <optionGroupName>payment_instrument</optionGroupName>
203 </pseudoconstant>
204 <add>4.7</add>
205 </field>
206 </table>