What tables are affected by "drush cc all"?
The list is dynamic, there's a convention to use cache_ as a prefix but it's not enforced. Modules can implement hook_flush_caches to register names of tables to clear:


  This hook allows your module to add cache table names to the list of cache tables that will be cleared by the Clear button on the Performance page or whenever drupal_flush_all_caches is invoked.


So basically the answer lies in the code for the modules you have installed, and you'll need to invoke that hook to get an accurate list of tables used as cache bins.