| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| ID |
integer |
10 |
|
|
|
|
|
| DATETIME |
timestamp |
19 |
√ |
|
null |
|
|
| SOID |
integer |
10 |
|
|
|
|
|
| PAYMENTMETHODID |
integer |
10 |
|
|
|
|
|
| REFERENCE |
varchar |
60 |
√ |
|
null |
|
|
| CONFIRMATION |
varchar |
30 |
√ |
|
null |
|
|
| EXPDATE |
timestamp |
19 |
√ |
|
null |
|
|
| DEPOSITTOACCOUNTID |
integer |
10 |
√ |
|
0 |
|
|
| TRANSACTIONID |
varchar |
20 |
√ |
|
null |
|
|
| AUTHCODE |
varchar |
20 |
√ |
|
null |
|
|
| MERCHANTACTNUM |
varchar |
20 |
√ |
|
null |
|
|
| MISCCREDITCARD |
blob sub_type 1 |
0 |
√ |
|
null |
|
|
| AMOUNT |
double precision |
15 |
√ |
|
0 |
|
|
| CHANGE |
double precision |
15 |
√ |
|
0 |
|
|
| USERID |
integer |
10 |
√ |
|
null |
|
|
Analyzed at Mon Jul 01 09:44 PDT 2013
|
