erDiagram
employees {
int id_employee PK
int age
varchar genre
int revenu_mensuel
varchar statut_marital
varchar departement
varchar poste
int annee_experience_totale
int annees_dans_l_entreprise
int satisfaction_employee_environnement
int note_evaluation_precedente
int satisfaction_employee_nature_travail
int satisfaction_employee_equipe
int satisfaction_employee_equilibre_pro_perso
int note_evaluation_actuelle
varchar heure_supplementaires
int augementation_salaire_precedente
int nombre_participation_pee
int nb_formations_suivies
int distance_domicile_travail
int niveau_education
varchar frequence_deplacement
int annees_depuis_la_derniere_promotion
varchar a_quitte_l_entreprise
}
prediction_inputs {
int id PK
timestamp created_at
int id_employee
int age
varchar genre
int revenu_mensuel
varchar statut_marital
varchar departement
varchar poste
int annee_experience_totale
int annees_dans_l_entreprise
int satisfaction_employee_environnement
int note_evaluation_precedente
int satisfaction_employee_nature_travail
int satisfaction_employee_equipe
int satisfaction_employee_equilibre_pro_perso
int note_evaluation_actuelle
varchar heure_supplementaires
int augementation_salaire_precedente
int nombre_participation_pee
int nb_formations_suivies
int distance_domicile_travail
int niveau_education
varchar frequence_deplacement
int annees_depuis_la_derniere_promotion
}
prediction_inputs ||--|| prediction_outputs : "1:1"
prediction_outputs {
int id PK
int input_id FK
varchar prediction
float probabilite
int classe
}
api_logs {
int id PK
timestamp created_at
varchar operation
varchar table_cible
varchar details
varchar statut
}