List:General Discussion« Previous MessageNext Message »
From:nigel wood Date:July 3 2009 10:39am
Subject:Re: Best approach for DB-based event logging?
View as plain text  
nigel wood wrote:
>
> Here's a rough table stucture. The  indexes in events tables would be  
> TargetId. But problably TargetId+EventDate probably eventId+event date 
> as you found more uses/added paging.
>
Well that didn't format very well :-( The tables structures are:

User/Actor
=======
TargetId
Username

EventType
======
EventTypeId
LogMesssageText (optional)

CurrentEvents,ArchivedEventsNN,MergedEvents
=============================
EventId
TargetId
EventTypeId
EventData
EventDate


HTH

Nigel
Thread
Best approach for DB-based event logging?Marcus Bointon1 Jul
  • Re: Best approach for DB-based event logging?Johan De Meersman3 Jul
    • Re: Best approach for DB-based event logging?Marcus Bointon3 Jul
      • Re: Best approach for DB-based event logging?Johan De Meersman3 Jul
  • Re: Best approach for DB-based event logging?nigel wood3 Jul
    • Re: Best approach for DB-based event logging?nigel wood3 Jul
      • RE: Best approach for DB-based event logging?Martin Gainty3 Jul