Database schema

Here is the list of existing databases in the AMRIT platform.

1. db_identity -> Stores all beneficiary data.

2. db_1097_identity -> Stores 1097 helpline beneficiary data.

3. db_iemr-> Stores all master & transaction data of 104, 1097, TM, MMU, HWC, ECD service lines.

4. db_reporting -> Stores All AMRIT service lines reporting related data.

Setting up DB Schema

The AMRIT DB Service simplifies the initial setup of database schemas across all AMRIT modules by automating the creation of tables, relationships, and seed data. It ensures consistency and reduces manual effort, making the platform ready for use in various environments. The service leverages Flyway migrations for version control and compatibility. Explore the code and contribute via the GitHub repository.

---

Setting up a Dummy Database

Download a pre-configured dummy database to quickly restore and simulate the AMRIT platform's functionality for testing or local development. The zip file includes SQL scripts to populate data for different modules.

63MB

Amrit_MastersData.zip

archive

Dummy username and passwords

Module	Username	password
1097	1097User	Test@123
ECD Supervisor	ECDSupervisor2, ecdsupervisor	Test@123
ECD Associate	ECDAssociate	Test@123
ECD ANM	ECDANM	Test@123
ECD MO	ECDMedicalOfficer	Test@123
ECD quality Supervisor	ECDQualitySupervisor	Test@123
ECD Quality Auditor	ECDQualityAuditor	Test@123
104HAO	104hao	Test@123
104MO	104mo	Test@123
104 supervisor	104Supervisor	Test@123
104SIO(service improvement officer)	104SIO	Test@123
104CO(CounsellingOfficer)	104psmri,104co	Test@123
104 Surveyor	104Surveyor	Test@123
TM(Telemedicine)	TMUser	Test@123
Admin(ECD, 104)	104ECDAdmin	P@ssword@07
Admin(TM,HWC)	HWCTMAdmin	Test@123
Admin(1097)	1097Admin	Test@123
Admin(MMU)	MMUAdmin	Test@123
HWC	HWCUser	Test@123
MMU	MMUUser	Test@123

AMRIT DB Architecture

Here is the AMRIT DB Architecture diagram.

DB Tables

Beneficiary Registration Tables

104 Tables

MMU & TM Tables

1097 Tables

Inventory Tables

HWC Screening Tables