[Building Sakai] Course enrollment information

[Venkat Ravikanti]

Thanks Brian.


I looked into table CM_MEMBERSHIP_T. There are no records in it.

I also added Official Participants to Course.

No records in CM_MEMBERSHIP_T or any Enrollment tables.

Can someone shed more light on SAKAI_REALM tables.  I am not getting any clue.

Thanks,
Venkat





On Thursday, September 11, 2014 10:26 AM, Brian Baillargeon <bbailla2 at uwo.ca> wrote:
 


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/f8a73507/attachment.html