The app_id field in the order table does not map to anything, just an id field. It would be useful to have an app mapping table as there can be numerous for a single shopify store.