In CiviCASE how do I restore a deleted case?
CiviCase normally doesn't delete anything it just marks it deleted. You should be able to use advanced search and search for deleted contacts and restore the contact from there. Ditto Find Cases and check the box for deleted cases.

But if the records were truly deleted then you also need:

civicrm_activity_contact
civicrm_log
and then there's a couple if you want the contact details too - civicrm_email, civicrm_address, civicrm_phone, civicrm_website (might be missing one or two)


Also if you have custom fields the records in civicrm_value_XXX.