Table schema_generation.paypal
InnoDB free: 7168 kB

 Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
paypal_id int 11  √ 
paypal_payment_status_history.paypal_id paypal_payment_status_history_ibfk_1
txn_type varchar 10
reason_code varchar 15  √  null
payment_type varchar 7
payment_status varchar 17
pending_reason varchar 14  √  null
invoice varchar 64  √  null
mc_currency char 3
first_name varchar 32
last_name varchar 32
payer_business_name varchar 64  √  null
address_name varchar 32  √  null
address_street varchar 64  √  null
address_city varchar 32  √  null
address_state varchar 32  √  null
address_zip varchar 10  √  null
address_country varchar 64  √  null
address_status varchar 11  √  null
payer_email varchar 96
payer_id varchar 32
payer_status varchar 10
payment_date datetime 19  √  null
payment_time_zone varchar 4
business varchar 96
receiver_email varchar 96
receiver_id varchar 32
txn_id varchar 17
parent_txn_id varchar 17  √  null
num_cart_items tinyint unsigned 4 1
mc_gross decimal 7,2 0.00
mc_fee decimal 7,2 0.00
payment_gross decimal 7,2  √  null
payment_fee decimal 7,2  √  null
settle_amount decimal 7,2  √  null
settle_currency char 3  √  null
exchange_rate decimal 4,2  √  null
for_auction varchar 5 false
auction_buyer_id varchar 64
auction_closing_date datetime 19 0000-00-00 00:00:00
auction_multi_item tinyint 4 0
quantity int 11 0
tax decimal 7,2  √  null
notify_version decimal 2,1 0.0
verify_sign varchar 128
last_modified datetime 19  √  null
date_added datetime 19  √  null
memo text 65535  √  null

Table contained 0 rows at Mon Jun 18 16:54 CDT 2007

Indexes:
Column(s) Type Sort Constraint Name
paypal_id + txn_id Primary key Asc/Asc PRIMARY
paypal_id Performance Asc idx_paypal_paypal_id

Close relationships: