Data model, read orders by third party tool.
i want to poll the Drupal Commerce database periodically for new orders and import them to a backend system for processing.
The data i need for backend processing is, the order including the order lines, the information of the customer and the payment information.
I queried the database but i can not find the line items of the orders. The commerce_order table contains the orders, but where are the line items of that order? In this cryptic 'data' column? Or does the field_data_line_items table map the line_items to the commerce_order entities? Which seem to not be a 'strange' relational database design ;)
And what are the tables 'commerce_order_state' and 'commerce_order_status' for? Both tables are empty in my installation.