Data Model
Sample Kafka Event
DB Schema
The schema serves as a blueprint for creating and maintaining the Cassandra database that supports the Program User Info Services data storage and retrieval operations under sunbird_programs keyspace.
An example of program_enrollment table under sunbird_programs keyspace
program_id | user_id | created_at | organisation_id | organisation_name | pii_consent_required | program_externalid | program_name | updated_at | user_locations | user_sub_type | user_type |
---|---|---|---|---|---|---|---|---|---|---|---|
5f362b78af0a4decfa9a106f | ba9aa220-ff1b-4717-b6ea-ace55f04f11 | 2022-01-12 | 0126796199493140480 | Staging Custodian Organization | True | 0126796199493140480 | Staging Custodian | 2023-01-12 | {'block_code': '282262', 'block_id': '966c3be4-c125-467d-aaff-1eb1cd525923', 'block_name': 'AGALI', 'cluster_code': '2822620004', 'cluster_id': 'beb0bcf4-d7cd-4a72-8f35-be8e5b03c0d1', 'cluster_name': 'ZPHS AGALI', 'district_code': '2822', 'district_id': '2f76dcf5-e43b-4f71-a3f2-c8f19e1fce03', 'district_name': 'ANANTAPUR', 'school_code': '28226200816', 'school_id': '01337588247832985613211', 'school_name': 'SMT PRAMEELAMMA AND SRI KGA GUPTA EM UP SCHOOL', 'state_code': '28', 'state_id': 'bc75cc99-9205-463e-a722-5326857838f8', 'state_name': 'Andhra Pradesh'} | deo | administrator |
Last updated