+1 On Thu, Jul 17, 2008 at 1:58 PM, Jacopo Cappellato < [EMAIL PROTECTED]> 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 >> >> > -- Ashish Vijaywargiya Indore, India http://en.wikipedia.org/wiki/Indore