[Building Sakai] Course enrollment information

[Brian Baillargeon]

I just did a quick search on confluence.sakaiproject.org and found a 
little documentation that hasn't been modified since 2006, but it might 
be useful nonetheless:
https://confluence.sakaiproject.org/display/CM/CM+API+Design+-+Round+1

Anyway, the table that stores roster memberships is CM_MEMBERSHIP_T

mysql> describe cm_membership_t;
+---------------------+--------------+------+-----+---------+----------------+
| Field               | Type         | Null | Key | Default | 
Extra          |
+---------------------+--------------+------+-----+---------+----------------+
| MEMBER_ID           | bigint(20)   | NO   | PRI | NULL    | 
auto_increment |
| VERSION             | int(11)      | NO   |     | NULL |                |
| USER_ID             | varchar(255) | NO   | MUL | NULL |                |
| ROLE                | varchar(255) | NO   |     | NULL |                |
| MEMBER_CONTAINER_ID | bigint(20)   | YES  | MUL | NULL |                |
| STATUS              | varchar(255) | YES  |     | NULL |                |
+---------------------+--------------+------+-----+---------+----------------+

Note: the CM_ tables store information about official rosters, which 
might not necessarily map to users' current role in the site if a role 
has been changed. Also, you won't find any unofficial participants in 
these tables. If you want the union of official and unofficial 
participants, I think they can be found in sakai_realm_rl_gr, but there 
might be a more authoritative source.

On 14-09-10 06:46 PM, Venkat Ravikanti wrote:
> Hi,
>
> I am new to Sakai. Need your help on the Sakai Tables.
>
> I am looking to find the mysql tables where the course enrollment 
> information stored.
>
> Here is my scenario:
>
> 1. Created Course Site with couple of courses
> 2. Created Users
> 3. Added the Users to the above created courses as Participants
>
> Now when I am trying to query for the participants information in 
> CM_ENROLLMENT_T or CM_ENROLLMENT_SET_T. No Luck.  These two tables are 
> empty
>
> Can someone help with me following:
>
> 1. Data dictionary for Sakai tables with some notes on which table 
> stands for what
> 2. Which table stores the participants or enrollment information.
>
>
> Thanks for your help.
> Venkat
>
>
> _______________________________________________
> 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/20140911/97482735/attachment.html