doconline - Laravel Schema Designer

admins

id increments
name string
email string
password string
is_active boolean
is_super boolean
rememberToken rememberToken
timestamps timestamps

patient_profiles

id increments
user_id ^FK integer
type_of tinyInteger
first_name string
last_name string
height integer
weight integer
does_smoke boolean
mobile_no string
email string
gender enum
date_of_birth date
address_street string
city string
state_id integer
pincode string (10)
medical_history string (500)
timestamps timestamps

doctors

id increments
name string
email string
mobile_no string (14)
password string
is_active boolean
rememberToken rememberToken
timestamps timestamps

users

id increments
kind tinyInteger
name string
email string
mobile_no string (14)
password string
is_active boolean
rememberToken rememberToken
timestamps timestamps
is_verified boolean

employers

id increments
name string
profile_name string
email string
mobile_no string (14)
password string
is_active boolean
rememberToken rememberToken
timestamps timestamps
is_verified boolean

employer_users

id increments
timestamps timestamps
employer_id ^FK integer
user_id ^FK integer

doctor_time_slots

id increments
doctor_id integer
time_slot_id ^FK integer
applicable_on tinyInteger
capacity integer
timestamps timestamps

patient_appointments

id increments
call_type tinyInteger
doctor_time_slot_id ^FK integer
patient_profile_id ^FK integer
scheduled_on date
status tinyInteger
attached_file string
notes string (500)
started_at timestamp
finished_at timestamp
timestamps timestamps

patient_alergies

id increments
patient_id ^FK integer
name string
timestamps timestamps

patient_medications

id increments
patient_id ^FK integer
name string
timestamps timestamps

doctor_unavailables

id increments
doctor_time_slot_id ^FK integer
applicable_date date
timestamps timestamps

doctor_holidays

id increments
doctor_id ^FK integer
start_from datetime
ends_on datetime
is_approved boolean
timestamps timestamps

user_questions

id increments
user_id ^FK integer
question string (500)
timestamps timestamps
softDeletes softDeletes

user_question_chats

id increments
user_question_id ^FK integer
doctor_id ^FK integer
message string (500)
timestamps timestamps

doctor_appointment_notifications

id increments
timestamps timestamps

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