Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Table: paypal_payment_info
- [32 columns]
- +----------------+----------------------------+
- | Column | Type |
- +----------------+----------------------------+
- | buyer_email | varchar(100) |
- | city | varchar(50) |
- | country | varchar(20) |
- | custom | varchar(255) |
- | datecreation | date |
- | firstname | varchar(100) |
- | ghnote | varchar(255) |
- | itemname | varchar(255) |
- | itemnumber | varchar(50) |
- | lastname | varchar(100) |
- | mc_currency | varchar(5) |
- | mc_fee | varchar(5) |
- | mc_gross | varchar(6) |
- | memo | varchar(255) |
- | on0 | varchar(50) |
- | on1 | varchar(50) |
- | os0 | varchar(20) |
- | os1 | varchar(20) |
- | paymentdate | varchar(50) |
- | paymentstatus | varchar(15) |
- | paymenttype | varchar(10) |
- | pendingreason | varchar(10) |
- | ppipn | enum('VERIFIED','INVALID') |
- | quantity | char(3) |
- | reasoncode | varchar(20) |
- | receiver_email | varchar(256) |
- | state | char(3) |
- | street | varchar(100) |
- | tax | varchar(10) |
- | txnid | varchar(30) |
- | txntype | varchar(10) |
- | zipcode | varchar(11) |
- +----------------+----------------------------+
- +----------+-----------+
- | lastname | firstname |
- +----------+-----------+
- | <blank> | <blank> |
- | Scott | Myriam |
- | Scott | Myriam |
- +----------+-----------+
- +----------------------------+
- | buyer_email |
- +----------------------------+
- +----------------------------+
- +-----------------+
- | paymentstatus |
- +-----------------+
- | Canceled_Revers |
- | Reversed |
- |
- +-----------------+
- +----------+
- | ppipn |
- +----------+
- | VERIFIED |
- | VERIFIED |
- | VERIFIED |
- +----------+
- +-------------------------+
- | receiver_email |
- +-------------------------+
- +-------------------------
Add Comment
Please, Sign In to add comment