user-consent.md

User Consent

sunbird.user_consent [PRIMARY KEY (user_id, consumer_id, object_id)]

Table used to store user consent to share PII

Column Name	Data Type	Description	Sample Data
user_id	text	UUID of the user	0dd78c26-4226-4cd5-b883-23e7dc277047
consumer_id	text	organisation Identifier	01269878797503692810
object_id	text	object Identifier on which consent is provided on	01269878797503692810 OR do_2130448790797926401216
categories	list<text>
consent_data	text
consumer_type	text		ORGANISATION
created_on	timestamp	Record created on	2021-12-06 11:03:09.059000+0000
expiry	timestamp	Record expires on	2022-03-16 11:03:09.057000+0000
id	text	consent identifier	usr-consent:ed9d0289-8d5b-4d39-89d2-1a1b5ce69828:01269878797503692810:01269878797503692810
last_updated_on	timestamp	record recently updated on	2021-12-06 11:03:09.059000+0000
object_type	text	Object type on which user has provided consent to share PII	Organisation/Collection
status	text	Consent status	ACTIVE/REVOKED

sunbird.user_declarations [PRIMARY KEY (userid, orgid, persona)]

Table used to store user declared fields details

Column Name	Data Type	Description	Sample Data
userid	text	UUID of the user	ed9d0289-8d5b-4d39-89d2-1a1b5ce69828
orgid	text	Organisation Identifier to which user belongs to	01269878797503692810
persona	text	Type of the teacher: default/teacher	teacher
createdby	text	Not used
createdon	timestamp	record created on	2020-12-07 12:06:59.467000+0000
errortype	text	Declared record validation error type	ERROR-DISTRICT, ERROR-PHONE, ERROR-EMAIL, ERROR-SCHOOL ORG NAME, ERROR-SCHOOL ORG ID, ERROR-ID, ERROR-NAME, ERROR-STATE
status	text	Status of the declaration: SUBMITTED, VALIDATED, REJECTED, ERROR	SUBMITTED
updatedby	text	Not used
updatedon	timestamp	Not used
userinfo	map<text, text>	User declared information	{'declared-email': '', 'declared-ext-id': '987654321', 'declared-phone': '', 'declared-school-name': 'PUPS, REDDIYARPATTI', 'declared-school-udise-code': '33291500301'}