I am working on an assignment to add some extra columns to Order entity when order save into database. But it's using database table name _SitecoreCommerce.SharedEnviornment table and data store in db like given below:
Where to add a new column in this scenario? Can we solve this by creating a new plugin for order customization? If yes then how to define columns and assign the values while order capturing?