Medical

essential medical tables \<font color="#4ccfe2">these tables are required for medical records of the patient \</font> \<font color="#93a2dd">medical data can be associated to the visit (appointment table) and the related sales (sales table) \</font> new file cases > soap record sale id = sale id pet id = pet id responsible id = soap vet (vet id) appointments id = appointments id record status 1 = draft 2 = saved 3 = closed 4 = hospitalized vets > clinic user information id = new file cases vet id id = new file cases responsible id (starred/favorite soap vet) pet > pet information id = new file cases pet id sale > sale information id = new file cases sale id appointments > appointment information id = new file cases appointment id