Data Dictionary

List of tables in Cassandra database used in Groups service

sunbird_groups.group [PRIMARY KEY: id]

Column Name	Data Type	Description	Sample Value
id	text	UUID of the group	ad2ffd12-ee05-46fc-bbe7-f5a67bd0534e
activities	list<frozen<map<text, text>>>	Activities that are published with in the group	[{'id': 'do_2132889347963535361756', 'type': 'Course'}, {'id': 'do_2133016209522933761354', 'type': 'Course'}, {'id': 'do_21333644232679424012289', 'type': 'Course'}, {'id': 'do_21331802990687027216', 'type': 'Course'}, {'id': 'do_2133483390278287361856', 'type': 'Course'}, {'id': 'do_2133817803741347841999', 'type': 'Content Playlist'}, {'id': 'do_213375362019328000129', 'type': 'Teacher Resource'}, {'id': 'do_21333645138176409618', 'type': 'Course'}, {'id': 'do_2132734144209469441409', 'type': 'Course'}, {'id': 'do_2132882557402644481743', 'type': 'Course'}, {'id': 'do_2133187549468098561201', 'type': 'Course'}, {'id': 'do_21334149144616960013071', 'type': 'Course'}]
createdby	text	UUID of the group created user	fbe926ac-a395-40e4-a65b-9b4f711d7642
createdon	timestamp	Group created on	2021-05-31 11:04:58.580000+0000
description	text	Description of the Group	EditedGroup
membershiptype	text	Type of member to the group, Possible values: moderated, invite_only	invite_only
name	text	Name of the Group	dashletEditedGroup
status	text	Staus of the group	active
updatedby	text	Last updated by	fca2925f-1eee-4654-9177-fece3fd6afc9
updatedon	timestamp	Last updated timestamp	2021-11-03 04:28:30.528000+0000

sunbird_groups.group_member [PRIMARY KEY (groupid, userid)]

Column Name	Data Type	Description	Sample Value
groupid	text	UUID, id of the group	ad2ffd12-ee05-46fc-bbe7-f5a67bd0534e
userid	text	UUID, id of the user	7557fd26-5b7c-4dd7-bd60-8e13ac856652
createdby	text	UUID, created user id	fca2925f-1eee-4654-9177-fece3fd6afc9
createdon	timestamp	Created on timestamp	2021-10-21 14:41:23.654000+0000
removedby	text	UUID, of the user that triggered the event	fca2925f-1eee-4654-9177-fece3fd6afc9
removedon	timestamp	removed timestamp	2021-12-03 04:29:09.182000+0000
role	text	Role of the person in the group, possible values are: member, admin	member
status	text	Status of the user with respect to the group	active
updatedby	text	UUID, of the last updated user	fbe926ac-a395-40e4-a65b-9b4f711d7642
updatedon	timestamp	Last updated timestamp	2021-09-08 07:02:12.553000+0000
visited	boolean	Member visited the group	True

sunbird_groups.user_group [PRIMARY KEY: userid]

Column Name	Data Type	Description	Sample Value
userid	text	UUID, id of the user	10e2cac0-1757-47d3-a010-b9bca8d2d5d0
groupid	set<text>	UUID of the groups, groups id's of the user that are linked to	{'95cea74a-2647-44a4-98e1-a4337b9e67b2', 'c535cd6a-f03d-4484-9b48-5cce6f935d78'}