Patients

essential patient tables \<font color="#4ccfe2">these tables are required for patient demographics and related information \</font> \<font color="#93a2dd">patients are referred to as pets (based on the mobile app implementation) \</font> 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