Lifebox M&E System Database Schema Documentation

This documentation provides a comprehensive overview of the lifebox_mesystem PostgreSQL database schema. Designed to support a comprehensive monitoring and evaluation system with features for tracking projects, indicators, beneficiaries, and evaluations.

Database Connection

To connect to the lifebox_mesystem database, use the following connection parameters:

// PHP PDO Connection for PostgreSQL
$db_host = '127.0.0.1';
$db_port = '5432';
$db_name = 'lifebox_mesystem';
$db_user = 'postgres';
$db_pass = 'mikeintosh';

try {
    $pdo = new PDO("pgsql:host=$db_host;port=$db_port;dbname=$db_name", $db_user, $db_pass);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    echo "Connected successfully";
} catch(PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}

Database Schema

The database follows a relational model with proper normalization. Key entities include:

The interactive Entity Relationship Diagram (ERD) below provides a visual representation of the database structure and relationships. Click and drag to navigate, scroll to zoom, and click on tables to see details.

This section provides detailed documentation for each table in the database, including column definitions, relationships, and sample data.