around_egypt - Laravel Schema Designer

destinations

id increments
timestamps timestamps
softDeletes softDeletes
title string
description longText
slug string

gallery

id increments
timestamps timestamps
softDeletes softDeletes
path string
model_id integer
model string

types

id increments
timestamps timestamps
softDeletes softDeletes
title string
description text
slug string

categories

id increments
timestamps timestamps
softDeletes softDeletes
title string

tours

id increments
timestamps timestamps
softDeletes softDeletes
overview text
description longText
Included longText
Excluded longText
notes longText
Type string
Run string
Duration integer
Facilities longText
Destinations text
start_price integer
discount integer
prices longText
title string
slug string

iteneraries

id increments
timestamps timestamps
softDeletes softDeletes
title string
tour_id ^FK integer

itenerary_days

id increments
timestamps timestamps
softDeletes softDeletes
itenerary_id ^FK integer
title string
description longText
order integer

prices

id increments
timestamps timestamps
softDeletes softDeletes
tour_id ^FK integer
single integer
double integer
triple integer
days integer
type enum

reviews

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string
rate integer
comment text
tour_id ^FK integer
destination_id ^FK integer
active boolean

authors

id increments
timestamps timestamps
softDeletes softDeletes
name string
bio text
image string

posts

id increments
timestamps timestamps
softDeletes softDeletes
title string
description string
image string

comments

id increments
timestamps timestamps
softDeletes softDeletes
post_id ^FK integer
name string
email string
comment text
active boolean

pages

id increments
timestamps timestamps
softDeletes softDeletes
title string
slug string
description longText

contacts

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string
phone string
message string

seo

id increments
timestamps timestamps
softDeletes softDeletes
meta_title string
meta_description string
priority float
frequency float

snippets

id increments
timestamps timestamps
softDeletes softDeletes
icon string
title string
description text
description_id ^FK integer

faq

id increments
timestamps timestamps
softDeletes softDeletes
question string
answer string
description_id ^FK integer

partners

id increments
timestamps timestamps
softDeletes softDeletes
logo string
description_id ^FK integer

inqueries

id increments
timestamps timestamps
softDeletes softDeletes
url string
ip_address string
name string
email string
phone string
start_date string
end_date string
nationality string
comment text
tour_id ^FK integer

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