| description |
|---|
List of tables in Cassandra database used in Groups service |
| 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 |
| 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 |
| 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'} |