[thelist] Doing things just once -- tracking in database.
Jack Timmons
jorachim at gmail.com
Tue May 26 13:42:28 CDT 2009
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
More information about the thelist
mailing list