tek_doc - Laravel Schema Designer

users

role_id ^FK integer
id bigIncrements
first_name string (299)
last_name string (299)
email string (299)
dob date
gender string (10)
password string (299)
status tinyInteger
stripe_id string (299)
phone_number string (20)
profile_pic text
subscription_status tinyInteger
timestamps timestamps
initial_status tinyInteger

roles

id increments
role string (50)
timestamps timestamps

medical_histories

id bigIncrements
user_id bigInteger
whose_status tinyInteger
timestamps timestamps
height_in_feet double
height_in_inch double
relative_id ^FK integer
weight double
smoke tinyInteger
alcohol_status tinyInteger
traveled_over_sea tinyInteger
doc_last_visit date

relative_infos

id increments
user_id ^FK bigInteger
relative_name string (299)
relative_email string (299)
relative_dob date
relation ^FK integer
timestamps timestamps

booking_infos

id bigIncrements
history_id ^FK bigInteger
medical_problem text
doctor_id ^FK bigInteger
image_url string (299)
status tinyInteger
slot_id ^FK integer
update_status tinyInteger
timestamps timestamps

doctors_slots

id increments
sloted_date_id ^FK integer
doctor_id ^FK bigInteger
date date
start_time time
end_time time
timestamps timestamps

prescriptions

id increments
booking_id ^FK bigInteger
prescription text
comment string (299)
timestamps timestamps

payments

id increments
user_id ^FK bigInteger
booking_id ^FK bigInteger
discount_percentage integer
discount_amount decimal
total_amount double
amount double
payment_status tinyInteger
timestamps timestamps

reviews

id increments
booking_id ^FK bigInteger
doctor_id ^FK bigInteger
patient_id ^FK bigInteger
doctor_satisfaction tinyInteger
timestamps timestamps
patient_satisfaction tinyInteger

password_resets

id increments
email string (299)
token text
otp string (10)
timestamps timestamps

medications

id increments
history_id ^FK bigInteger
medication text
timestamps timestamps

allergies

id increments
history_id ^FK bigInteger
allergy string (299)
timestamps timestamps

health_prolems

id increments
health_problem string (299)
timestamps timestamps

patient_family_prolems

id increments
history_id ^FK bigInteger
family_problem_id ^FK integer
timestamps timestamps

patient_health_problems

id increments
history_id ^FK bigInteger
health_problem_id ^FK integer
timestamps timestamps

family_problems

id increments
family_problem string (299)
timestamps timestamps

doctor_infos

id increments
doctor_id ^FK bigInteger
document_name text
clinic_name string (299)
speciality string (299)
description text
timestamps timestamps

diabetes

id increments
history_id ^FK bigInteger
who_has ^FK integer
timestamps timestamps

possible_members_list

id increments
member string (299)
timestamps timestamps

sloted_dates

id increments
timestamps timestamps
sloted_date date
doctor_id ^FK bigInteger

e_prescriptions

id increments
booking_id ^FK integer
npi integer
dea string (10)
pharmacy_name string (299)
pharmacy_address string (299)
pharmacy_phone string (299)
pharmacy_fax string (299)
notes text
timestamps timestamps
verification_status tinyInteger

prescription_medication

id increments
timestamps timestamps
prescription_id ^FK integer
tablet_name string (299)
tablet_quantity string (299)
supply_days integer
substitution tinyInteger
sig text

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