Пример на одном USA шопе 2016. Антифрауд в MySQL выглядит так:
table=algzone_fraud_queries
order_id
ip_address
last_date_queried
fraud_level
err_message
distance_m
distance_k
country_code
is_country_match
is_free_email
is_customer_phone_inloc
proxy_level
spam_level
is_high_risk_country
is_anonymous_proxy
ip_city
ip_region
ip_isp
ip_org
ip_latitude
ip_longitude
bin_country_code
is_bin_match
is_bank_name_match
bank_name
is_bank_phone_match
bank_phone
Antifraud 2012
table=SagePay
Sage Pay Reference ID:########################
Order Status: OK
Details: 0000 : The Authorisation was Successful.
Card Type: VISA
Security Checks: ALL MATCH
CV2 Result: MATCHED
3D Result: NOTCHECKED
Address Result: MATCHED
Post Code Result: MATCHED
table=algzone_fraud_queries
order_id
ip_address
last_date_queried
fraud_level
err_message
distance_m
distance_k
country_code
is_country_match
is_free_email
is_customer_phone_inloc
proxy_level
spam_level
is_high_risk_country
is_anonymous_proxy
ip_city
ip_region
ip_isp
ip_org
ip_latitude
ip_longitude
bin_country_code
is_bin_match
is_bank_name_match
bank_name
is_bank_phone_match
bank_phone
Antifraud 2012
table=SagePay
Sage Pay Reference ID:########################
Order Status: OK
Details: 0000 : The Authorisation was Successful.
Card Type: VISA
Security Checks: ALL MATCH
CV2 Result: MATCHED
3D Result: NOTCHECKED
Address Result: MATCHED
Post Code Result: MATCHED