Appointments

essential appointment tables these tables are focused on appointments and related information these tables are focused on appointments and related information appointment source, status and type track business volume appointment source, status and type track business volume 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