E7ke - Laravel Schema Designer

fields

id increments
timestamps timestamps
name string
description text
short_description text

doctors

id increments
timestamps timestamps
name string
email string
phone string
password string
cv string
field_id ^FK integer
lang string
specialties text
main_focus string
experiences text
certificates text
gender tinyInteger
status tinyInteger

appointments

id increments
timestamps timestamps
title string
start_date datetime
end_date datetime
doctor_id ^FK integer
patient_id ^FK integer

blogs

id increments
timestamps timestamps
title string
descriptions text
image string

patients

id increments
timestamps timestamps
name string
email string
password string
phone string
image string
gender tinyInteger
status tinyInteger
address string
dob date

asks

id increments
timestamps timestamps
text text
patient_id ^FK integer
field_id ^FK integer

answers

id increments
timestamps timestamps
text text
ask_id ^FK integer
doctor_id ^FK integer

doctor_schedules

id increments
timestamps timestamps
doctor_id ^FK integer
date date
start_time string
end_time string
average_consulting_time string
status tinyInteger
day enum

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