Database Configurations

Database Configuration DocumentationOverview

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