What is the difference between these 2 dB tables? I can see for the data the sales_order_grid appears to be a subset of sales_order. Is this true? What is the process of have duplicate tables (I assume it is to prevent lock ups).

If I have a custom module and which to add a field to an order, which table do I need to add the field to? And how do I ensure the data is consistent?