misiones-tour - Laravel Schema Designer

places

id increments
timestamps timestamps
softDeletes softDeletes
name string (50)
shortDescription string (155)
description text
hashtags string (155)
lat decimal (10,8)
long decimal (11,8)
tariff text
isFeatured boolean
id_contact_info ^FK integer
place_type_id ^FK integer

contact_info

id increments
timestamps timestamps
softDeletes softDeletes
phone string (25)
email string (100)
web string (100)
facebook string (100)
twitter string (100)
gplus string (100)

places_types

id increments
timestamps timestamps
softDeletes softDeletes
name string (50)
tags string (255)
canHaveDeals boolean

reviews

id increments
timestamps timestamps
softDeletes softDeletes
title string (120)
comment string (512)
average float
flagCount integer
helpfulCount integer
reviewable_id integer
reviewable_type string (50)

photos

id increments
timestamps timestamps
softDeletes softDeletes
path string (300)
imageable_id integer
imageable_type string (30)

videos

id increments
timestamps timestamps
url string (300)
viewable_id integer
viewable_type string (50)

review_criterias

id increments
timestamps timestamps
softDeletes softDeletes
name string (50)

review_items

id increments
timestamps timestamps
softDeletes softDeletes
value integer
review_criteria_id ^FK integer
review_id ^FK integer

criteriables

id increments
softDeletes softDeletes
review_criteria_id ^FK integer
criteriable_id integer
criteriable_type string

deals

id increments
timestamps timestamps
softDeletes softDeletes
title string (120)
description string (512)
price float
discount integer
endDate datetime
hashtags string (155)
terms string (512)
place_id ^FK integer

contents

id increments
timestamps timestamps
title string (55)
shortDescription string (155)
body string (2048)
hashtags string (155)
content_type_id ^FK integer
contenteable_id integer
contenteable_type string

contents_types

id increments
timestamps timestamps
softDeletes softDeletes
name string (55)
isDeleteable boolean

events

id increments
timestamps timestamps
softDeletes softDeletes
title string (55)
description string (1024)
hashtags string (255)
date date
fromHour time
toHour time
lat decimal (10,8)
long decimal (11,8)
eventeable_id integer
eventeable_type string

statistics

id increments
timestamps timestamps
softDeletes softDeletes
forModel string
sum float
count integer
avg float
statisticable_id integer
statisticeable_type string

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