delapan-tours - Laravel Schema Designer

partners

id_partners increments
timestamps timestamps
name string (100)
logo string (100)

state

id_state increments
timestamps timestamps
name string (100)

city

id_city increments
timestamps timestamps
id_state integer
name string (100)

destination_pict

id_des_pict increments
timestamps timestamps
id_destination integer
pict string (100)

facility

id_facility increments
timestamps timestamps
name string (100)

destination

id_destination increments
id_des_cat integer
id_city integer
title string (200)
min_purchase string (5)
max_purchase string (5)
price_per_person string (10)
description text
tour_status string (50)
map_lat string (15)
map_lng string (15)
timestamps timestamps

destination_facilities

id_des_fac increments
timestamps timestamps
id_destination integer
id_facility integer

member

id_member increments
timestamps timestamps
email string (50)
password string (100)

reservation

id_reservation increments
id_member integer
id_destination integer
start_date date
end_date date
total_person integer
timestamps timestamps

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