safetraveladvisory - Laravel Schema Designer

companies

id increments
category_id ^FK bigInteger
name string
created_by ^FK bigInteger
timestamps timestamps
source_url string
updated_by ^FK bigInteger

routes

id increments
timestamps timestamps
added_by ^FK bigInteger
from_country_id ^FK bigInteger
to_country_id ^FK bigInteger
from_state_id ^FK bigInteger
to_state_id ^FK bigInteger

countries

id increments
timestamps timestamps
name string
continent_id ^FK bigInteger

categories

id increments
timestamps timestamps
name string

parameters

id increments
role_id ^FK bigInteger
timestamps timestamps
name string

cities

id increments
timestamps timestamps
name string
state_id ^FK bigInteger

roles

id increments
timestamps timestamps
name string
category_id ^FK bigInteger

continents

id increments
timestamps timestamps
name string

category_parameters

id increments
timestamps timestamps
category_id ^FK bigInteger
parameter_id ^FK bigInteger

states

id increments
timestamps timestamps
country_id ^FK bigInteger

company_parameter_values

id increments
timestamps timestamps
parameter_id ^FK bigInteger
company_id ^FK bigInteger
created_by ^FK bigInteger
value_text text
updated_by ^FK bigInteger
value string

users

id increments
timestamps timestamps
name string
email string

route_parameter_values

id increments
timestamps timestamps
parameter_id ^FK bigInteger
place_id ^FK bigInteger
parameter_option_id ^FK bigInteger
value_text text

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