I am attempting to migrate the data located on the /admin/commerce/orders page of Drupal Commerce to a custom website that I have created. I am trying to use phpMyAdmin to locate and export any relevant database information in the Drupal database. I have found that the order id/email/timestamp are located in the commerce_order table in the Drupal database. However, I can't find the location (table/table column) of the user's name and shipping information.
Does anyone have an idea of where I could find this information?
I am currently using Drupal 7.53 and Drupal Commerce 7.x-1.13.