I have users who place Orders. There are some settings that user can decide and that can be applied at User level which means it will be applicable to all future orders that are placed by user or the user can add the setting just for that order. I want to make it generalized that more settings can be added in future. The settings type can be different for different settings and also some settings can have state that can be updated based on some other criteria of order flow.
Need help in designing relational db model for this?