[Building Sakai] Description of table SAKAI_EVENT

[Steve Swinsburg]

Hi  Luiz,

you pretty much have it all sorted out.
The REF field is where the event occurred ie in a site or in some  
content area. if you browse all the different entries you'll see some  
examples.
The SESSION_ID matches the session of a user in the SAKAI_SESSION table.
The EVENT_CODE is 'm' for a modify action or an 'a' for just an  
'access' type event.

You can query this table to get data out via SQL safely but don't  
write to it directly, use the API, ie:

public void postEvent(String event,String reference,boolean modify) {
	 
eventTrackingService 
.post(eventTrackingService.newEvent(event,reference,modify));
}




cheers,
Steve

---
Steve Swinsburg
Portal Systems Developer
Centre for e-Science
Lancaster University
Lancaster
LA1 4YT

email: s.swinsburg at lancaster.ac.uk
phone: +44 (0) 1524 594870







On 10 Mar 2009, at 13:13, Luiz Antonio Falaguasta Barbosa wrote:

> Hi people,
>
> Please, does anybody know what is the meaning of each field in the  
> SAKAI_EVENT table (Sakai version 2.4) ?
>
> What I could undestand is:
>
> EVENT_ID: autoincrement id
> EVENT_DATE: timestamp for each event recorded in database
> EVENT: <tool>.<event>
> REF: THIS FIELD, I DIDN'T UNDERSTAND
> SESSION_ID: I believe it's an ID session in hexadecimal, where  
> substrings values to be nothing to do with user identification
> EVENT_CODE: I DON'T KNOW WHAT IS IT. I FOUND VALUES m AND a FOR THIS  
> FIELD.
>
> Please, what is right and what is wrong and what should be to that I  
> described in a wrong way?
>
> Thanks in advance!
>
> Regards,
>
> Luiz
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org 
>  with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090310/ee793645/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2437 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090310/ee793645/attachment-0001.bin