Thread: oc_order_fraud
View Single Post
  #1  
Old 05-19-2025, 04:54 PM

Cheburashka Cheburashka is offline
Join Date: May 2022
Posts: 8
Default


Нашел в бд шопа интересную таблицу, особенно позабавили несколько пунктов:
| carder_email | high_risk_password | high_risk_username
возможно кому-то будет полезно к размышлению.
+------------------------------------+---------------+
| Column | Type |
+------------------------------------+---------------+
| anonymous_proxy | varchar(3) |
| bin_country | varchar(2) |
| bin_match | varchar(10) |
| bin_name | varchar(255) |
| bin_name_match | varchar(3) |
| bin_phone | varchar(32) |
| bin_phone_match | varchar(3) |
| carder_email | varchar(3) |
| city_postal_match | varchar(3) |
| country_code | varchar(2) |
| country_match | varchar(3) |
| customer_id | int(11) |
| customer_phone_in_billing_location | varchar(8) |
| date_added | datetime |
| distance | int(11) |
| error | text |
| explanation | text |
| free_mail | varchar(3) |
| high_risk_country | varchar(3) |
| high_risk_password | varchar(3) |
| high_risk_username | varchar(3) |
| ip_accuracy_radius | int(11) |
| ip_area_code | int(3) |
| ip_asnum | int(11) |
| ip_city | varchar(255) |
| ip_city_confidence | varchar(3) |
| ip_continent_code | varchar(2) |
| ip_corporate_proxy | varchar(3) |
| ip_country_confidence | varchar(3) |
| ip_country_name | varchar(255) |
| ip_domain | varchar(255) |
| ip_isp | varchar(255) |
| ip_latitude | decimal(10,6) |
| ip_longitude | decimal(10,6) |
| ip_metro_code | int(3) |
| ip_net_speed_cell | varchar(255) |
| ip_org | varchar(255) |
| ip_postal_code | varchar(10) |
| ip_postal_confidence | varchar(3) |
| ip_region | varchar(255) |
| ip_region_confidence | varchar(3) |
| ip_region_name | varchar(255) |
| ip_time_zone | varchar(255) |
| ip_user_type | varchar(255) |
| is_trans_proxy | varchar(3) |
| maxmind_id | varchar(8) |
| order_id | int(11) |
| proxy_score | int(3) |
| queries_remaining | int(11) |
| risk_score | decimal(10,5) |
| score | decimal(10,5) |
| ship_city_postal_match | varchar(3) |
| ship_forward | varchar(3) |
+------------------------------------+---------------+