| rowid |
int(11)
|
|
|
|
| type |
varchar(32)
|
utf8_unicode_ci
|
|
|
| label |
varchar(200)
|
utf8_unicode_ci
|
|
|
| fk_soc |
int(11)
|
|
|
|
| datec |
datetime
|
|
|
|
| tms |
timestamp
|
|
|
|
| bank |
varchar(255)
|
utf8_unicode_ci
|
|
|
| code_banque |
varchar(128)
|
utf8_unicode_ci
|
|
|
| code_guichet |
varchar(6)
|
utf8_unicode_ci
|
|
|
| number |
varchar(255)
|
utf8_unicode_ci
|
|
|
| cle_rib |
varchar(5)
|
utf8_unicode_ci
|
|
|
| bic |
varchar(20)
|
utf8_unicode_ci
|
|
|
| iban_prefix |
varchar(34)
|
utf8_unicode_ci
|
|
|
| domiciliation |
varchar(255)
|
utf8_unicode_ci
|
|
|
| proprio |
varchar(60)
|
utf8_unicode_ci
|
|
|
| owner_address |
varchar(255)
|
utf8_unicode_ci
|
|
|
| default_rib |
smallint(6)
|
|
|
|
| rum |
varchar(32)
|
utf8_unicode_ci
|
|
|
| date_rum |
date
|
|
|
|
| frstrecur |
varchar(16)
|
utf8_unicode_ci
|
|
|
| last_four |
varchar(4)
|
utf8_unicode_ci
|
|
|
| card_type |
varchar(255)
|
utf8_unicode_ci
|
|
|
| cvn |
varchar(255)
|
utf8_unicode_ci
|
|
|
| exp_date_month |
int(11)
|
|
|
|
| exp_date_year |
int(11)
|
|
|
|
| country_code |
varchar(10)
|
utf8_unicode_ci
|
|
|
| approved |
int(11)
|
|
|
|
| email |
varchar(255)
|
utf8_unicode_ci
|
|
|
| ending_date |
date
|
|
|
|
| max_total_amount_of_all_payments |
double(24,8)
|
|
|
|
| preapproval_key |
varchar(255)
|
utf8_unicode_ci
|
|
|
| starting_date |
date
|
|
|
|
| total_amount_of_all_payments |
double(24,8)
|
|
|
|
| stripe_card_ref |
varchar(128)
|
utf8_unicode_ci
|
|
|
| stripe_account |
varchar(128)
|
utf8_unicode_ci
|
|
|
| comment |
varchar(255)
|
utf8_unicode_ci
|
|
|
| ipaddress |
varchar(68)
|
utf8_unicode_ci
|
|
|
| status |
int(11)
|
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|