quests_db - Laravel Schema Designer

users

id increments
name string (50)
email string (50)
password string (60)
rememberToken rememberToken
timestamps timestamps

quests

id increments
city_id ^FK integer
title string (100)
description text
rules text
duration string (20)
break_time string (20)
softDeletes softDeletes
timestamps timestamps

cities

id increments
title string (50)
start_break_time time
end_break_time time
start_time time
timestamps timestamps

comments

id increments
quest_id ^FK integer
name string (50)
body text
rating tinyInteger
softDeletes softDeletes
timestamps timestamps

orders

id increments
quest_id ^FK integer
date timestamp
amount integer
softDeletes softDeletes
timestamps timestamps

holidays

id increments
title string (100)
timestamps timestamps

quest_prices

id increments
quest_id ^FK integer
price integer
start_time time
end_time time
day_type_id ^FK integer
timestamps timestamps

day_types

id increments
title string (50)
timestamps timestamps

events

id increments
title string (100)
slug string (200)
date timestamp
repeat string (15)
day_type_id ^FK integer
timestamps timestamps

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