I'd like to request the addition of a field in the Stands table named "Origin" [NVARCHAR(50)] that allows the user to define the stand origin (planted, natural, unknown). This could potentially be constrained to match planting actions in the Rules section of Assisi (and updated when a rule is implemented during growth?).
Thoughts?
Do you think Origin should have an "Allowed" values table too so that spellings and cascade updates occur? Or just a free floating field?
Related to this is building out the History tables more. History is meant to hold all the history of a stand from establishment to disposal. Stands can be recompiled from original cruise and regrown to arbitrary dates carrying out whatever is in the History tables: harvest, thins, planting, fertilization etc. Adding summaries of history to stand grids and reports might be best so that other historical actions can be show as well.