doctors - Laravel Schema Designer

users

id increments
name string
email string
phone string
address string
timestamps timestamps

speciality

id increments
name string (200)
status enum
timestamps timestamps
softDeletes softDeletes

doctors

id increments
category_id integer
subcategory_id integer
name string
phone string (15)
address string
latitude string
longitude string (200)
description longText
profile_image string
working_hours string (250)
avg_rating float (8,2)
status enum
timestamps timestamps
softDeletes softDeletes

diagnostic_center

id increments
category_id integer
subcategory_id integer
name string
phone string
address string
description longText
latitude string
longitude string
image string
status enum
avg_rating float (8,2)
timestamps timestamps

page_content

id increments
key string
description longText
contents longText
image string (200)
page string
timestamps timestamps

doctors_review

id increments
doctor_id ^FK integer
name string (200)
comments longText
rating float (8,2)
status enum
timestamps timestamps

diagnostic_reviews

id increments
diagnostic_id ^FK integer
name string
comments longText
rating float (8,2)
status enum
timestamps timestamps

diagnostic_gallery

id increments
diagnostic_id ^FK integer
image string
status enum
timestamps timestamps

categories

id increments
name string
image string
status enum
timestamps timestamps

subcategories

id increments
category_id ^FK integer
name string
image string
status enum
timestamps timestamps

hospitals

id increments
category_id integer
subcategory_id integer
name string
address string
phone string
description longText
latitude string
longitude string
image string
status enum
timestamps timestamps

doctors_speciality_map

id increments
doctor_id ^FK integer
speciality_id ^FK integer
timestamps timestamps

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