I should get into that habbit, I am still stuck with things like InsertedBy and UpdatedBy yet for other things I'd do other table name then ID after that. All my PKs tend to just be named ID but that is because the bulk of my work is done at a place using an old RAD tool that assumes they use that name.
On 4/21/06, Denny Valliant <[EMAIL PROTECTED]> wrote: > > On 4/19/06, Aaron Rouse <[EMAIL PROTECTED]> wrote: > > > > What do you do if you have UserID used in a table twice? Such as maybe > if > > you had the need to track the user who did the original record creation > > and > > who the last user to update the record was? > > > I'm kind of liking "user_id_created" and "user_id_modified" currently. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238469 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
