On-line therapy database
Patients will be referred to on-line therapy company by medical providers who work for health care institutions
The referral will be made to a team leader associated with the particular institution
Team leader will assign patient to suitable therapist from a list based on licensure.
The following dates must be recorded: date of initial referral, date of assignment, date of patient/therapist agreement, date of first appointment, date of termination
Therapists have different types of licenses (LICSW, LMHC, LADC, LMFT, LMMC, Pastoral, Psy. D, Ph.D.). Each therapist has one license.
Therapists have different specialities and may specialize in more than one (child, family, couples, adult, senior, trauma, drug & alcohol, gender/sexual orientation)
Patients have status (new, assigned, contracted, in- therapy, terminated, and refused)
Administrators have authority to add and update therapists
We need to know who the providers are, who they work for, and which therapist is assigned to each patient.
Submit the ERD and a .sql file
20 freelancers are bidding on average $41 for this job
Hey A Database expert is here I have good advanced expertise in database design I can draw the ERD and implement the database for your Feel free to message me Regards
I' am Very experienced DB designer in Sri Lanka, I'm working as a Software Senior Executive in the largest power company in sri lanka and having more than 10+ years of DB designing experience