Is it a good idea to add a column to the posts table?

Adding another column wouldn’t break the code at all .. but it might create issues while updating WordPress to a new version ..

It’s better to add another table having fields (ID PK Auto Increment, post_id FK, <your-custom-column>) .. the post_id field will point to ID field in wp_posts table as a foreign key!