database_bc - Laravel Schema Designer

places

id_place increments
timestamps timestamps
softDeletes softDeletes
name string (255)
id_type_place ^FK integer
hashtag string (255)
id_province integer
id_country integer

type_places

id_type_place increments
timestamps timestamps
softDeletes softDeletes
name string (255)

provinces

id increments
province string (255)
id_country ^FK integer

countries

id increments
country string (255)

geo_places

id increments
timestamps timestamps
id_place ^FK integer
lat decimal
long decimal

gallery_schedule

id increments
title string (255)
url_s3 string (255)
id_schedule ^FK integer
is_cover boolean
order smallInteger

schedule

id increments
timestamps timestamps
softDeletes softDeletes
id_place ^FK integer
id_type_activity ^FK integer
title string (255)
address string (255)
lat decimal
long decimal
description text
date_start integer
date_end integer
id_location ^FK integer

type_activity

id increments
name string (255)

locations

id increments
timestamps timestamps
softDeletes softDeletes
id_place ^FK integer
title string (255)
short_description string (255)
description text
address string (255)
lat decimal
long decimal
id_type_activity ^FK integer

gallery_location

id increments
title string (255)
url_s3 string (255)
id_location ^FK integer
is_cover boolean
order smallInteger

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