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. I tend to prefix these "link tables" with LKP_ and I got into the habbit > because they were tend to be used for "looking up" related data. Probably > not the best of naming conventions but just the one I use and have stuck > with. I think the consistency is the main point. So long as something fits a format, it's pretty easy to modify. What gets you (or at least me) into trouble is when you do it willy-nilly like, say userID here, user_ID there, LNK_here, there_X. My main trouble is I've got projects I've been doing for several years now, and the code is like some weird time-line of knowledge gained (and lost). When I have the time, I refactor and try to make it more manageable- in case I die horribly (or even not so horribly), or just plain hop in that VW van and start touring, to quote a pal. Refactoring isn't as fun as doing new stuff most times tho... but man it's nice when stuff conforms to a pre-defined pattern vs. a self defined one. You don't have to keep so much stuff in your head. There are still a couple of projects I kind of have to meditate with before I start doing anything on, but I've found consistency is my friend. Why, just the other day, consistency was like: "Long time no see". :D ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238455 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
