LYCEES (FACT)
lycee_id (PK)
lycee_name
lycee_code
lycee_type
department_id (FK)
ia_id (FK)
student_capacity
current_enrollment
success_rate_bac
has_boarding
status
LYCEE_SERIES
lycee_id (PK,FK)
series_id (PK,FK)
year_introduced
is_active
student_capacity
current_enrollment
success_rate
teacher_count
infrastructure_quality
STUDENT_STATISTICS
stat_id (PK)
academic_year
lycee_id (FK)
department_id (FK)
gender
grade_level
student_count
dropout_rate
SERIES (FACT)
series_id (PK)
series_code
series_name
filiere_id (FK)
description
objectives
career_prospects
dominant_subjects
teaching_rate
status
FILIERES
filiere_id (PK)
filiere_name
filiere_code
description
career_prospects
objectives
teaching_rate
popularity_rank
SUBJECTS
subject_id (PK)
subject_name
subject_code
subject_category
description
difficulty_level
typical_hours_per_week
prerequisite_subjects
LYCEE_SERIES
lycee_id (PK,FK)
series_id (PK,FK)
year_introduced
is_active
student_capacity
current_enrollment
success_rate
teacher_count
SERIES_SUBJECTS
series_id (PK,FK)
subject_id (PK,FK)
coefficient
is_dominant
is_optional
hours_per_week
exam_type
passing_grade
FORMATION_SERIES_REQUIREMENTS
formation_id (PK,FK)
series_id (PK,FK)
requirement_type
minimum_grade
priority_order
exam_score_weight
STUDENT_STATISTICS
stat_id (PK)
academic_year
series_id (FK)
department_id (FK)
stat_type
gender
student_count
percentage_of_total
pass_rate
TEACHING_STATISTICS
stat_id (PK)
academic_year
series_id (FK)
filiere_id (FK)
teaching_rate
total_lycees_in_scope
lycees_teaching_count
utilization_rate
REGIONS
region_id (PK)
region_name
region_code
capital_city
population
area_km2
education_infrastructure_score
major_industries
DEPARTMENTS
department_id (PK)
department_name
region_id (FK)
chef_lieu
population
area_km2
lycee_count
higher_ed_count
INSPECTION_ACADEMIES
ia_id (PK)
ia_name
ia_code
department_id (FK)
inspector_name
lycees_supervised
students_supervised
SERIES
series_id (PK)
series_code
series_name
filiere_id (FK)
description
LYCEES
lycee_id (PK)
lycee_name
lycee_type
department_id (FK)
ia_id (FK)
INSTITUTIONS
institution_id (PK)
institution_name
category_id (FK)
region_id (FK)
anaq_accredited
CAREERS
career_id (PK)
career_name
sector_id (FK)
employment_rate
salary_range
LYCEE_SERIES
lycee_id (PK,FK)
series_id (PK,FK)
is_active
FORMATIONS
formation_id (PK)
institution_id (FK)
diploma_id (FK)
FORMATION_SERIES_REQ
formation_id (PK,FK)
series_id (PK,FK)
requirement_type
FORMATION_CAREER_PROS
formation_id (PK,FK)
career_id (PK,FK)
relevance_score
INSTITUTION_CATEGORIES
category_id (PK)
category_name
category_code
description
funding_type
average_duration_years
accreditation_body
REGIONS
region_id (PK)
region_name
region_code
capital_city
DIPLOMA_TYPES
diploma_id (PK)
diploma_name
level_name
duration_years
entry_level
exit_level
ects_credits
HIGHER_EDUCATION_INSTITUTIONS (FACT)
institution_id (PK)
institution_name
institution_code
institution_category_id (FK)
region_id (FK)
student_capacity
current_enrollment
anaq_accredited
tuition_range_min
tuition_range_max
status
FORMATIONS
formation_id (PK)
formation_name
institution_id (FK)
diploma_id (FK)
is_public
duration_years
admission_mode
tuition_annual
anaq_accredited
job_placement_rate
FORMATION_SERIES_REQUIREMENTS
formation_id (PK,FK)
series_id (PK,FK)
requirement_type
minimum_grade
priority_order
FORMATION_CAREER_PROSPECTS
formation_id (PK,FK)
career_id (PK,FK)
relevance_score
market_demand
starting_salary_range
skills_alignment_score
SECTORS
sector_id (PK)
sector_name
sector_code
parent_sector_id (FK)
growth_rate
employment_share
average_salary
skill_demand
government_priority
COMPANIES
company_id (PK)
company_name
sector_id (FK)
region_id (FK)
company_size
is_active_recruiter
internship_programs
graduate_programs
CAREERS (FACT)
career_id (PK)
career_name
career_code
sector_id (FK)
career_level
employment_rate_senegal
salary_range_min
salary_range_max
growth_prospects
remote_work_possible
status
CAREER_FORMATIONS
career_id (PK,FK)
formation_id (PK,FK)
relevance_score
preparation_adequacy
success_rate
time_to_proficiency_months
CAREER_COMPANIES
career_id (PK,FK)
company_id (PK,FK)
hiring_frequency
average_salary
projected_openings
work_environment_score
CAREER_SIMILARITIES
career_id (PK,FK)
similar_career_id (PK,FK)
similarity_type
similarity_score
transition_difficulty
time_to_transition_months
REFERENCE_PROFILES
profile_id (PK)
profile_name
current_career_id (FK)
series_id (FK)
brief_description
current_job_title
featured
inspiration_score
PROFILE_EMPLOYMENT
employment_id (PK)
profile_id (FK)
company_id (FK)
position_title
is_current
start_date
end_date
sequence_order
PROFILE_EDUCATION
education_id (PK)
profile_id (FK)
institution_id (FK)
formation_id (FK)
start_year
end_year
is_completed
sequence_order