Medical

essential medical tables these tables are required for medical records of the patient these tables are required for medical records of the patient medical data can be associated to the visit (appointment table) and the related sales (sales table) medical data can be associated to the visit (appointment table) and the related sales (sales table) 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