Dereja M&E System Database Schema Documentation

This documentation provides a comprehensive overview of the me_dereja database schema. This database schema is developed using MariaDB and it is designed to support a comprehensive candidate management system with features for tracking candidates, trainings, events, employment, and more.

Database Connection

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

// PHP PDO Connection
$db_host = '127.0.0.1';
$db_name = 'me_dereja';
$db_user = 'me_dereja';
$db_pass = 'me_dereja';
$db_port = '3306';

try {
    $pdo = new PDO("mysql:host=$db_host;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:

Table Relationships

The database maintains referential integrity through foreign key relationships:

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.

Diagram Controls

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