I am trying to sync WP with another service that offers an API that allows me to hook up their table's Update, Create, Delete to my sites.
So when they create, update, or delete a row on their server, I get details about that update, including the row ID.
The way I am thinking of syncing is by using custom post types, and either add a new separate table with post -> api relation like
post_id:1 = api_id:53.
wp_posts table by adding a column containing the api_id.
I know I can add metabox which will add that as post_meta but I am not sure how effective will that be and I am pretty sure if I alter
wp_posts, querying will be a lot faster.
So how can I alter
wp_posts in the WordPress way? If that's not possible, should I add meta boxes or create an entirely new table just for the relation ?