Re: Best approach for DB-based event logging?

[nigel wood]

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