Countries, Cities, Visitors : access log (geoip) - Laravel Schema Designer

countries

id increments
code string (5)
name_en string
name_ru string

cities

id increments
country_id ^FK integer
region string (5)
timezone string
latitude string
longitude string
name_en string
name_ru string
region_name_en string
region_name_ru string

visitors

id increments
country_id ^FK integer
city_id ^FK integer
ip string (46)
hits integer

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01