https://discuss.frappe.io/t/mysql-exceptions-programmingerror-1146-table-1bd3e0294da19198-tabpatient-doesnt-exist/31123/6?u=iteerstech
The above solved my problem