Downloading Orders

Hi All, I’m wondering which set of woocommererce tables will have the data needed to pull orders directly from MySql. We have been using plug ins and getting by but today up dates have caused failure. My current process is to download orders then import to a SQL db and generate reports for production and shipping inventory ect…. I’m digging in now pulling all tables but I’m hoping somebody might be able to shorten the dev time with some tips or tricks. Plug ins are clunky and we will eventually out grow them anyway. Thanks for your help.