Table schema_generation.algozone_fraud_queries
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
order_id varchar 6
ip_address varchar 30
last_date_queried datetime 19  √  0000-00-00 00:00:00
fraud_level varchar 5  √ 
err_message varchar 150  √ 
distance_m varchar 10  √ 
distance_k varchar 10  √ 
country_code varchar 21  √ 
is_country_match char 3  √ 
is_free_email char 3  √ 
is_customer_phone_inloc char 3  √ 
proxy_level varchar 5  √ 
spam_level varchar 5  √ 
is_high_risk_country varchar 5  √ 
is_anonymous_proxy char 3  √ 
ip_city varchar 21  √ 
ip_region varchar 21  √ 
ip_isp varchar 30  √ 
ip_org varchar 30  √ 
ip_latitude varchar 21  √ 
ip_longitude varchar 21  √ 
bin_country_code varchar 5  √ 
is_bin_match varchar 5  √ 
is_bank_name_match varchar 5  √ 
bank_name varchar 20  √ 
is_bank_phone_match varchar 5  √ 
bank_phone varchar 15  √ 

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

Indexes:
Column(s) Type Sort Constraint Name
order_id Performance Asc order_id