I agree with Jacopo. From/Thru dates should be used in entities that are
expected to keep historical data.
-Adrian
Jacopo Cappellato wrote:
Hi Bilgin ,
from/thru dates (with from date in the primary key) are useful when you
have to record the history of roles associated to an entity (e.g. "who
was the administrator of the product store in 2004?").
That said, ProductStoreRole, ProductStoreGroupRole, FacilityGroupRole
seem all good canditates for the from/thru dates fields addition; IMO
this is not the case with PicklistRole: picklists lifecycle usually
lasts a few days (or hours) and I don't think that the information about
expired roles would be useful.
Jacopo
On Jul 17, 2008, at 10:17 AM, Bilgin Ibryam wrote:
Hi all,
I'm looking at various role entities and noticed that some of them has
fromDate - thruDate, but others don't have.
I just wanted to know what is the pattern/best practice to follow when
adding fromDate - thruDate fields?
What do you think about these changes:
1) ProductStoreRole has fromDate - thruDate, but FacilityRole don't. I
think FacilityRole should also has fromDate - thruDate.
2) May be ProductStoreGroupRole and FacilityGroupRole should also have
fromDate - thruDate?
3) Is it needed fromDate - thruDate fields in PicklistRole?
Thanks in advance,
Bilgin Ibryam
