Athar el-beka3 - Laravel Schema Designer

clients

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)
phone string (191)
avatar string (191)
email string (191)
code string
lat string
long string
address string

sliders

id increments
timestamps timestamps
image string (191)
title string
desc text

catgories

id increments
timestamps timestamps
name string (191)
image string (191)
desc text

places

id increments
timestamps timestamps
category_id ^FK bigInteger
name string (191)
distance double
lat string
long string
address string
avg_visit_time string
religious_desc longText
historical_desc longText
virtue string (191)
desc longText

fav_places

id increments
timestamps timestamps
client_id ^FK bigInteger
place_id ^FK bigInteger
mac_address string

images

id increments
timestamps timestamps
image string
imageable_id string
imageable_type string (191)
type enum

religious_evidences

id increments
timestamps timestamps
place_id ^FK bigInteger
type enum
desc longText
name string (191)

religious_dates

id increments
timestamps timestamps
place_id ^FK bigInteger
date string
title string (191)
desc longText

services

id increments
timestamps timestamps
place_id ^FK bigInteger
name string (191)
image string (191)

paths

id increments
timestamps timestamps
start_lat string (191)
start_long string (191)
start_address string (191)
status tinyInteger
start_date date
start_time time
end_time time
client_id ^FK bigInteger
total_time string

path_places

id increments
timestamps timestamps
place_id ^FK bigInteger
path_id ^FK bigInteger
status tinyInteger
is_current boolean

ritual_types

id increments
timestamps timestamps
name string
image string (191)

hajj_categories

id increments
timestamps timestamps
title string
desc text

ritual_steps

id increments
timestamps timestamps
name string
icon string (191)
desc text
type string
order integer

ritual_step_places

id increments
timestamps timestamps
name string
lat string (191)
long string (191)
address string (191)
ritual_step_id ^FK bigInteger

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