How do I completely uninstall a custom entity implemented by my module?
The tables declared by the hook_schema() will be automatically remove when you uninstall your module. 

If you need to remove other tables or variables use the hook_uninstall()