Patients

essential patient tables these tables are required for patient demographics and related information these tables are required for patient demographics and related information patients are referred to as pets (based on the mobile app implementation) patients are referred to as pets (based on the mobile app implementation) pet > basic pet information nickname = patient name species id = species id breed is = breeds id blood type id = blood types id userpetmapping > client patient relationship user id = users id pet id = pet id vetpetarchive > pet archive relationship pet id = pet id archive type id 1 = deceased 2 = moved away 3 = changed owner 4 = other patients > pets linked to cliic number = digitail patient number / id species > list of available species id = pet species id breeds > list of available breeds id = pet breed id blood types > list of available blood types species id = species id