Table comparison: sma_virtual_payments
|
LO PEDIS |
ELIZ |
| Table-name |
Type |
Nullable |
Type |
Nullable |
|
payment_id |
int(10) unsigned |
NO |
int(10) unsigned |
NO |
|
invoice_id |
int(10) unsigned |
NO |
int(10) unsigned |
NO |
|
method_id |
tinyint(3) unsigned |
NO |
tinyint(3) unsigned |
NO |
|
id |
varchar(100) |
YES |
varchar(100) |
YES |
|
external_reference |
varchar(250) |
NO |
varchar(250) |
NO |
|
form_url |
varchar(2000) |
NO |
varchar(2000) |
NO |
|
status_payment |
varchar(100) |
NO |
varchar(100) |
NO |
|
request_date |
varchar(100) |
YES |
varchar(100) |
YES |
|
due_date |
varchar(100) |
YES |
varchar(100) |
YES |
|
last_due_date |
varchar(100) |
YES |
varchar(100) |
YES |
|
last_update_date |
varchar(100) |
YES |
varchar(100) |
YES |
|
process_date |
varchar(100) |
YES |
varchar(100) |
YES |
|
paid_date |
varchar(100) |
YES |
varchar(100) |
YES |
|
accreditation_date |
varchar(100) |
YES |
varchar(100) |
YES |
|
due1 |
date |
YES |
date |
YES |
|
due2 |
date |
YES |
date |
YES |
|
final_amount |
double |
NO |
double |
NO |
|
payer_name |
varchar(140) |
NO |
varchar(140) |
NO |
|
payer_email |
varchar(250) |
NO |
varchar(250) |
NO |
|
payer_type_id |
varchar(20) |
NO |
varchar(20) |
NO |
|
payer_number |
varchar(20) |
NO |
varchar(20) |
NO |
|
register_date |
datetime |
NO |
datetime |
NO |
|
payer_country |
varchar(20) |
NO |
varchar(20) |
NO |
|
expiration_date |
datetime |
NO |
datetime |
NO |
|
notification_date |
datetime |
YES |
datetime |
YES |
|
concepts |
varchar(5000) |
YES |
varchar(5000) |
YES |
|
payment_methods |
varchar(5000) |
YES |
varchar(5000) |
YES |
|
fee_details |
varchar(5000) |
YES |
varchar(5000) |
YES |
|
last_change |
datetime |
NO |
datetime |
NO |
|
error |
varchar(100) |
NO |
varchar(100) |
NO |
|
error_description |
varchar(250) |
NO |
varchar(250) |
NO |