safeTravelAdvisor - Laravel Schema Designer

categories

id increments
timestamps timestamps
name string

companies

id increments
category_id ^FK integer
parameter json
country_id integer
state_id ^FK integer
city_id ^FK integer
timestamps timestamps

countries

id increments
timestamps timestamps
name string
parameter json
continent_id ^FK integer

continents

id increments
timestamps timestamps
name string

states

id increments
timestamps timestamps
country_id ^FK integer
name string

cities

id increments
timestamps timestamps
state_id ^FK integer
name string

places

id increments
timestamps timestamps
name string
cities_id ^FK integer

category_parameter

id increments
timestamps timestamps
category_id ^FK integer

country_destination

timestamps timestamps
country_from ^FK integer
country_to ^FK integer

category_parameter_value

id increments
companies_id ^FK integer
timestamps timestamps

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