Appointments

essential appointment tables \<font color="#4ccfe2">these tables are focused on appointments and related information \</font> \<font color="#93a2dd">appointment source, status and type track business volume \</font> appointment > basic appointment information patient id = pet id service id = appointment services id occassion = appointment type status 0 = created at clinic 1 = created by client (online request) 2 = created by client (mobile app) 3 = clinic rescheduled 4 = client requested reschedule 5 = confirmed 6 = client cancelled 7 = clinic cancelled 8 = auto created 9 = no show source 0 = clinic 1 = web 2 = mobile app appointment reschedules > reschedule information on appointment status 3 and 4 appointment id = appointment id appointment requests > online requests web and mobile app appointment id = appointment id status 0 = request pending 1 = accepted 1 = cancelled available services > visit types id = appointments service id