[Using Sakai] More on DB

[Steve Swinsburg]

Hi,

There are some architecture documents in the source code at /reference/docs/architecture. Some are a bit dated though.
As for table naming conventions, developers are free to do what they like, however the adopted practice is that tools prefix their own tables. So the tables for Profile2 all start with PROFILE_. Site Stats all start with SST_ for example.

One thing to note is that if your app doesn't 'own' the table in your own tool/service, you shouldn't directly touch it. You should instead use the API that the app provides. This goes for the rest of the Sakai DB tables as well. Never directly modify the tables, use the API.

cheers,
Steve



On 05/03/2011, at 7:52 AM, Chandrika Harathi wrote:

> We are evaluating sakai. We have installed sakai 2.7 to evaluate/test. Where can I find the more information on the DBschema : ER diagram ,  table naming convention or similar.
> Thanks,
> Chandrika
> 
> 
> -- 
> Chandrika Harathi
> Programmer Analyst II
> IST-AST
> 1 Worlds Fair Drive, Suite 3900, Somerset, NJ 08873
> Ph: (732) 743-2554
> Fax:(732) 745-4525
> 
>  
> CONFIDENTIALITY NOTICE: This email communication may contain private, confidential, or legally privileged information intended for the sole use of the designated and/or duly authorized recipient(s). If you are not the intended recipient or have received this email in error, please notify the sender immediately by email and permanently delete all copies of this email including all attachments without reading them. If you are the intended recipient, secure the contents in a manner that conforms to all applicable state and/or federal requirements related to privacy and confidentiality of such information.
> 
>  
> <harathch.vcf>_______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
> 
> TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20110305/260520dc/attachment.html