Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Doc] - Documentation for Database Schema #18

Closed
pankajjangid05 opened this issue Jul 10, 2023 · 5 comments
Closed

[Doc] - Documentation for Database Schema #18

pankajjangid05 opened this issue Jul 10, 2023 · 5 comments
Assignees
@pankajjangid05
Labels
documentation Improvements or additions to documentation

Comments

@pankajjangid05
Copy link
Contributor

We require comprehensive documentation for the Cassandra and PostgreSQL database schemas.
@pankajjangid05 pankajjangid05 added the documentation Improvements or additions to documentation label Jul 10, 2023
@pankajjangid05 pankajjangid05 mentioned this issue Jul 10, 2023
Closed
10 tasks
@pankajjangid05 pankajjangid05 self-assigned this Jul 14, 2023
@pankajjangid05
Copy link
Contributor Author

pankajjangid05 commented Sep 7, 2023 •
edited
Loading

Databases Used by UCI:

  • Cassandra (DB - Xmessage) - Used to archive bot conversation history.
  • Postgres (DB - formsdb) - Stores questions and user-associated answers.
  • Postgres (DB - user_analytics) - Manages delivery reports for notifications.
  • Postgres (DB - comms) - Houses essential bot data, including Adapter, Transformer, Conversation logic, User Segment, and related information.

@aakashyadav-kgp
Copy link

WIP. Planning to close this today.

@pankajjangid05 pankajjangid05 mentioned this issue Sep 7, 2023
Merged
@pankajjangid05
Copy link
Contributor Author

Hey @chinmoy12c

Please review this PR : samagra-comms/community#70

@chinmoy12c
Copy link
Member

Changes to be integrated according to review.

@pankajjangid05
Copy link
Contributor Author

This is merged with the main branch so we can close this ticket.

Document URL : https://uci.sunbird.org/use/developer/database-schema

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@pankajjangid05 pankajjangid05

Labels
documentation Improvements or additions to documentation
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@chinmoy12c @pankajjangid05 @aakashyadav-kgp