Activity #1312: Global server DB setup - Digitally Connected Tribal Colonies (MeitY) - Health and Technology Group

Actions

Copy link

Activity #1312

closed

Feature #63: DigiPatho Web -- Development, Validation, Certification and Deployment

Feature #3602: Development of DigiPatho.Global Application

Global server DB setup

Added by Thara S Pillai almost 3 years ago. Updated about 1 year ago.

Status:

Closed

Priority:

Normal

Assignee:

Sherin Sebastian

Start date:

01/04/2024

Due date:

01/04/2024

% Done:

100%

Estimated time:

(Total: 0:00 h)

Planned Due Date:

Description

Install EMS PostgreSQL IDE from hstgshare\EMSPostgresqlIDE
Add Server 10.176.14.181
Register Databases DCTCGlo and ehealthrevamp030723

copy the DDL scripts of following tables from ehealthrevamp030723

mas_lsg
mas_lsg_type
mas_taluk
mas_village
mas_ward
and use it in DCTCGlo to create the tables in DCTCGlo database

Subtasks 2 (0 open — 2 closed)

Actions

Copy link

Updated by Thara S Pillai almost 3 years ago

Parent task changed from #64 to #809

Actions

Copy link

Updated by Sherin Sebastian almost 3 years ago

% Done changed from 0 to 100

Actions

Copy link

Updated by Sherin Sebastian almost 3 years ago

Download the EMS PostgreSQL IDE from the provided source. Add a new server connection using the IP address ,Register the databases DCTCGlo and ehealthrevamp030723 using the database connection details. Executed the DDL scripts for the tables to create them in the DCTCGlo database.

Actions

Copy link

Updated by Sherin Sebastian almost 3 years ago

Status changed from New to Resolved

Actions

Copy link

Updated by Thara S Pillai almost 3 years ago

Status changed from Resolved to In Progress
% Done changed from 100 to 60

Actions

Copy link

Updated by Thara S Pillai over 2 years ago

Update activity status

Actions

Copy link

Updated by Thara S Pillai over 2 years ago

Due date changed from 10/10/2023 to 11/22/2023

Actions

Copy link

Updated by Sherin Sebastian over 2 years ago

I have successfully completed the task of setting up the administration tables for the global server database. As per the provided document, I have created the necessary table and implemented the required stored procedures to facilitate web API upload and download functionalities.

Actions

Copy link

Updated by Thara S Pillai over 2 years ago

Subject changed from Global server DB setup - administration tables to Global server DB setup
Due date changed from 11/22/2023 to 12/05/2023
Parent task changed from #809 to #64