Since this implementation is so small, I would prefer to see the new inventory fields added to a new table within the action schema rather than a new schema, particularly since Mike noted above that moving the table to a new schema should be easy enough if/when we build out inventory functionality.
Would there be any objection if, for the current implementation, we just store the most recent inventory date/workstation? If somebody then wants to store historical data, we could add the YAOUS at that time.
Thanks for the feedback everyone!
Since this implementation is so small, I would prefer to see the new inventory fields added to a new table within the action schema rather than a new schema, particularly since Mike noted above that moving the table to a new schema should be easy enough if/when we build out inventory functionality.
Would there be any objection if, for the current implementation, we just store the most recent inventory date/workstation? If somebody then wants to store historical data, we could add the YAOUS at that time.
Let me know what you think.