Database Configurations

Overview

This document outlines the PostgreSQL database configuration for the Smart360 platform, detailing the setup of two PostgreSQL instances across development and QA environments with service-specific database architecture.

Database Instances

Development Environment

Instance Name: dev-smart360-postgresql

• vCPUs: 2
• Memory: 8 GB
• Storage: 20 GB HDD
• Environment: Development
• Master User: authuser

QA Environment

Instance Name: qa-smart360-postgresql

• vCPUs: 2
• Memory: 8 GB
• Storage: 15 GB HDD
• Environment: QA/Testing
• Master User: authuser

Database Architecture

Service-Wise Databases

Both PostgreSQL instances contain identical database schemas organized by service domains:

auth
ax
bx
cx
mx
onboarding
wx
report
notification

Master User Configuration

• Username: authuser
• Privileges: Full administrative access to all databases
• Responsibilities:
  • Database creation and management
  • User access control
  • Schema modifications
  • Backup and maintenance operations