[thelist] Doing things just once -- tracking in database.

[Jack Timmons]

On Tue, May 26, 2009 at 1:19 PM, Bill Moseley <moseley at hank.org> wrote:
> Do you use a table to track processing events?  What columns do you
> include in that table?
>
>
> Thanks for your input,
>
>
> --
> Bill Moseley
> moseley at hank.org
> Sent from my iMutt

If Rudy speaks up, he might have a better approach. Typically, I'll
use an events table for events, accounts table for accounts, and a
join table (say, account_events) that indexes the ID's from both of
them.

That way, you can have pretty names, info, etc that relates to an
event, and you're not duplicating information (say, the same even name
over and over)


-- 
-Jack Timmons
http://www.trotlc.com
Twitter: @codeacula