منصة المدارس المتكاملة

school_groups

id, name, education_office, supervisor_id

schools

id, group_id, name, stage, gender

profiles

id, full_name, gender, job_title, school_id

user_roles

user_id, role, group_id

council_meetings

id, group_id, number, date, agenda, status

decisions

id, meeting_id, number, text, owner_id, status

plans

id, group_id, type, year, status, version

initiatives

id, group_id, proposer_id, priority, status

indicators / indicator_values

domain, name · school_id, period, value

teams / team_members

kind, mandate, approved_by_decision_id

support_requests

school_id, category, assigned_to, status

official_documents

type, ref_no, template_id, entity, status

document_versions

document_id, version, file, hash, locked

workflow_actions

entity, kind(review|approval|signature|ack), actor, at

audit_log

actor_id, action, entity, before, after, at