nutrisaas - Laravel Schema Designer

users

id increments
timestamps timestamps
name string
role string
email string
password string
gender string
phone string
country string
profession string
dob date
patientRecordId string
email_verified_at datetime

specializations

id increments
timestamps timestamps
name string

specializations_users

id increments
timestamps timestamps
user_id ^FK integer
specialization_id ^FK integer

locations

id increments
timestamps timestamps
name string
address string
location string
user_id ^FK integer

credits

id increments
timestamps timestamps
count integer
expiry_time datetime
user_id ^FK integer

appointments

id increments
timestamps timestamps
time datetime
type string
doctor_id ^FK integer
patient_id ^FK integer
consultation_place_id ^FK integer

food_submissions

id increments
timestamps timestamps
userId ^FK integer
image string
rating integer
nutritionSummary json
food_plan_id ^FK integer

food_plans

id increments
timestamps timestamps
patientID ^FK integer
doctorId ^FK integer
type string

nutrition_lists

id increments
timestamps timestamps
name string
description string
doctor_id ^FK integer

nutrition_summarys

id increments
timestamps timestamps
name string
gram string
units string
nutrition_list_id ^FK integer

food_plan_details

id increments
timestamps timestamps
food_plan_id ^FK integer
nutrition_summary_id ^FK integer

messages

id increments
timestamps timestamps
sender_id ^FK integer
receiver_id ^FK integer
message string
isRead boolean

recommendations

id increments
timestamps timestamps
patient_id ^FK integer
doctor_id ^FK integer
execise json
sleep json
supplementation json
water json
exam json
food_to_avoid json
other json

doctor_patient

id increments
timestamps timestamps
patient_id ^FK integer
doctor_id ^FK integer

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