





















const db = require('../models');
const Users = db.users;






const SchoolSettings = db.school_settings;

const Pages = db.pages;

const SchoolYears = db.school_years;

const Grades = db.grades;

const Streams = db.streams;

const Subjects = db.subjects;

const SubjectOfferings = db.subject_offerings;

const StaffMembers = db.staff_members;

const Students = db.students;

const ClassSections = db.class_sections;

const Enrollments = db.enrollments;

const Terms = db.terms;

const Events = db.events;

const Announcements = db.announcements;

const NewsPosts = db.news_posts;

const Galleries = db.galleries;

const StudyMaterials = db.study_materials;

const Exams = db.exams;

const ExamResults = db.exam_results;

const AttendanceSessions = db.attendance_sessions;

const AttendanceRecords = db.attendance_records;

const ClassSchedules = db.class_schedules;

const Assignments = db.assignments;

const AssignmentSubmissions = db.assignment_submissions;

const LessonPlans = db.lesson_plans;

const Messages = db.messages;

const AdmissionApplications = db.admission_applications;

const ContactMessages = db.contact_messages;

const Alumni = db.alumni;

const SchoolStatistics = db.school_statistics;

const ExamPerformanceSummaries = db.exam_performance_summaries;

const TopStudentFeatures = db.top_student_features;







const SchoolSettingsData = [
    
    {
    
        
        
            
                "school_name_om": "Mana Barumsaa Sadarkaa Lammaffaa fi Qophii Limmu Gennet",
            
        
    
        
        
            
                "school_name_am": "ሊሙ ገነት 2ኛ ደረጃ እና መሰናዶ ትምህርት ቤት",
            
        
    
        
        
            
                "school_name_en": "Limmu Gennet High School & Preparatory",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "welcome_message_om": "Baga nagaan dhuftan gara marsariitii barnootaa keenyaatti.",
            
        
    
        
        
            
                "welcome_message_am": "እንኳን ወደ ትምህርት ቤታችን ድህረ ገጽ በደህና መጡ።",
            
        
    
        
        
            
                "welcome_message_en": "Welcome to our official school website where learning and community come together.",
            
        
    
        
        
            
                "address_text": "Limmu Gennet area, Oromia Region, Ethiopia",
            
        
    
        
        
            
                "map_embed_url": "https://maps.google.com/?q=Limmu+Gennet",
            
        
    
        
        
            
                "public_phone_numbers": "+251911000001, +251911000003",
            
        
    
        
        
            
                "public_emails": "info@limmugennet.edu.et, registrar@limmugennet.edu.et",
            
        
    
        
        
            
                "social_links": "https://facebook.com/limmugennet",
            
        
    
    },
    
    {
    
        
        
            
                "school_name_om": "Marie Curie",
            
        
    
        
        
            
                "school_name_am": "Grace Hopper",
            
        
    
        
        
            
                "school_name_en": "Marie Curie",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "welcome_message_om": "Ada Lovelace",
            
        
    
        
        
            
                "welcome_message_am": "Grace Hopper",
            
        
    
        
        
            
                "welcome_message_en": "Alan Turing",
            
        
    
        
        
            
                "address_text": "Alan Turing",
            
        
    
        
        
            
                "map_embed_url": "Ada Lovelace",
            
        
    
        
        
            
                "public_phone_numbers": "Grace Hopper",
            
        
    
        
        
            
                "public_emails": "Ada Lovelace",
            
        
    
        
        
            
                "social_links": "Alan Turing",
            
        
    
    },
    
    {
    
        
        
            
                "school_name_om": "Grace Hopper",
            
        
    
        
        
            
                "school_name_am": "Alan Turing",
            
        
    
        
        
            
                "school_name_en": "Ada Lovelace",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "welcome_message_om": "Alan Turing",
            
        
    
        
        
            
                "welcome_message_am": "Grace Hopper",
            
        
    
        
        
            
                "welcome_message_en": "Marie Curie",
            
        
    
        
        
            
                "address_text": "Alan Turing",
            
        
    
        
        
            
                "map_embed_url": "Grace Hopper",
            
        
    
        
        
            
                "public_phone_numbers": "Marie Curie",
            
        
    
        
        
            
                "public_emails": "Marie Curie",
            
        
    
        
        
            
                "social_links": "Grace Hopper",
            
        
    
    },
    
    {
    
        
        
            
                "school_name_om": "Grace Hopper",
            
        
    
        
        
            
                "school_name_am": "Alan Turing",
            
        
    
        
        
            
                "school_name_en": "Alan Turing",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "welcome_message_om": "Grace Hopper",
            
        
    
        
        
            
                "welcome_message_am": "Marie Curie",
            
        
    
        
        
            
                "welcome_message_en": "Grace Hopper",
            
        
    
        
        
            
                "address_text": "Grace Hopper",
            
        
    
        
        
            
                "map_embed_url": "Ada Lovelace",
            
        
    
        
        
            
                "public_phone_numbers": "Alan Turing",
            
        
    
        
        
            
                "public_emails": "Grace Hopper",
            
        
    
        
        
            
                "social_links": "Marie Curie",
            
        
    
    },
    
];



const PagesData = [
    
    {
    
        
        
            
                "page_type": "about_facilities",
            
        
    
        
        
            
                "title_om": "Seenaa Mana Barumsaa",
            
        
    
        
        
            
                "title_am": "የትምህርት ቤቱ ታሪክ",
            
        
    
        
        
            
                "title_en": "School History",
            
        
    
        
        
            
                "content_om": "Mana barumsaan keenya tajaajila barnootaa waggoota hedduuf kennaa ture.",
            
        
    
        
        
            
                "content_am": "ትምህርት ቤታችን ለብዙ ዓመታት የትምህርት አገልግሎት ሲሰጥ ቆይቷል።",
            
        
    
        
        
            
                "content_en": "Our school has served the community for many years, expanding access to quality education.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "published": true,
            
        
    
        
        
            
                "published_at": new Date('2026-01-15T10:00:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                "page_type": "contact",
            
        
    
        
        
            
                "title_om": "Ergama fi Mulata",
            
        
    
        
        
            
                "title_am": "ተልእኮ እና ራዕይ",
            
        
    
        
        
            
                "title_en": "Mission and Vision",
            
        
    
        
        
            
                "content_om": "Ergama keenya barattoota hojii fi beekumsaaf qopheessuu dha.",
            
        
    
        
        
            
                "content_am": "ተልእኮአችን ተማሪዎችን ለእውቀትና ለሥራ ማዘጋጀት ነው።",
            
        
    
        
        
            
                "content_en": "Our mission is to prepare students for knowledge, life skills, and responsible citizenship.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "published": true,
            
        
    
        
        
            
                "published_at": new Date('2026-01-15T10:05:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                "page_type": "admissions",
            
        
    
        
        
            
                "title_om": "Ergaa Hogganaa",
            
        
    
        
        
            
                "title_am": "የአስተዳዳሪ መልእክት",
            
        
    
        
        
            
                "title_en": "Principal Message",
            
        
    
        
        
            
                "content_om": "Barnootni qulqulluun bu’uura badhaadhinaa dha.",
            
        
    
        
        
            
                "content_am": "ጥራት ያለው ትምህርት የስኬት መሠረት ነው።",
            
        
    
        
        
            
                "content_en": "Quality education is the foundation for opportunity and community development.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "published": true,
            
        
    
        
        
            
                "published_at": new Date('2026-01-15T10:10:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                "page_type": "student_guide",
            
        
    
        
        
            
                "title_om": "Galmee Barattootaa",
            
        
    
        
        
            
                "title_am": "ምዝገባ",
            
        
    
        
        
            
                "title_en": "Admissions",
            
        
    
        
        
            
                "content_om": "Ulaagaa fi adeemsa galmee ilaalaa.",
            
        
    
        
        
            
                "content_am": "የመግቢያ መስፈርትና ሂደት ይመልከቱ።",
            
        
    
        
        
            
                "content_en": "View entry requirements, timelines, and required documents for admission.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "published": true,
            
        
    
        
        
            
                "published_at": new Date('2026-01-20T09:00:00Z'),
            
        
    
    },
    
];



const SchoolYearsData = [
    
    {
    
        
        
            
                "name": "2024/2025",
            
        
    
        
        
            
                "starts_at": new Date('2024-09-11T00:00:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2025-06-20T00:00:00Z'),
            
        
    
        
        
            
                "current": false,
            
        
    
    },
    
    {
    
        
        
            
                "name": "2025/2026",
            
        
    
        
        
            
                "starts_at": new Date('2025-09-11T00:00:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2026-06-20T00:00:00Z'),
            
        
    
        
        
            
                "current": true,
            
        
    
    },
    
    {
    
        
        
            
                "name": "2026/2027",
            
        
    
        
        
            
                "starts_at": new Date('2026-09-11T00:00:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2027-06-20T00:00:00Z'),
            
        
    
        
        
            
                "current": false,
            
        
    
    },
    
    {
    
        
        
            
                "name": "2023/2024",
            
        
    
        
        
            
                "starts_at": new Date('2023-09-11T00:00:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2024-06-20T00:00:00Z'),
            
        
    
        
        
            
                "current": true,
            
        
    
    },
    
];



const GradesData = [
    
    {
    
        
        
            
                "grade_number": 9,
            
        
    
        
        
            
                "level": "high_school",
            
        
    
        
        
            
                "label": "Grade 9",
            
        
    
    },
    
    {
    
        
        
            
                "grade_number": 10,
            
        
    
        
        
            
                "level": "preparatory",
            
        
    
        
        
            
                "label": "Grade 10",
            
        
    
    },
    
    {
    
        
        
            
                "grade_number": 11,
            
        
    
        
        
            
                "level": "preparatory",
            
        
    
        
        
            
                "label": "Grade 11",
            
        
    
    },
    
    {
    
        
        
            
                "grade_number": 12,
            
        
    
        
        
            
                "level": "preparatory",
            
        
    
        
        
            
                "label": "Grade 12",
            
        
    
    },
    
];



const StreamsData = [
    
    {
    
        
        
            
                "name_om": "Waliigala",
            
        
    
        
        
            
                "name_am": "አጠቃላይ",
            
        
    
        
        
            
                "name_en": "General",
            
        
    
        
        
            
                "stream_type": "natural",
            
        
    
    },
    
    {
    
        
        
            
                "name_om": "Saayinsii Uumamaa",
            
        
    
        
        
            
                "name_am": "የተፈጥሮ ሳይንስ",
            
        
    
        
        
            
                "name_en": "Natural Science",
            
        
    
        
        
            
                "stream_type": "natural",
            
        
    
    },
    
    {
    
        
        
            
                "name_om": "Saayinsii Hawaasaa",
            
        
    
        
        
            
                "name_am": "ማህበራዊ ሳይንስ",
            
        
    
        
        
            
                "name_en": "Social Science",
            
        
    
        
        
            
                "stream_type": "natural",
            
        
    
    },
    
    {
    
        
        
            
                "name_om": "Qophii Saayinsii Uumamaa",
            
        
    
        
        
            
                "name_am": "መሰናዶ የተፈጥሮ ሳይንስ",
            
        
    
        
        
            
                "name_en": "Preparatory Natural",
            
        
    
        
        
            
                "stream_type": "social",
            
        
    
    },
    
];



const SubjectsData = [
    
    {
    
        
        
            
                "name_om": "Herrega",
            
        
    
        
        
            
                "name_am": "ሒሳብ",
            
        
    
        
        
            
                "name_en": "Mathematics",
            
        
    
        
        
            
                "overview_om": "Barnoota herregaa bu’uuraa fi furmaata rakkoo ni cimsina.",
            
        
    
        
        
            
                "overview_am": "መሠረታዊ ሒሳብና የችግኝ መፍትሄ ክህሎት እናጠናክራለን።",
            
        
    
        
        
            
                "overview_en": "We strengthen numeracy, logic, and problem-solving skills.",
            
        
    
        
        
            
                "textbook_references": "Ethiopian MOE Mathematics textbooks",
            
        
    
        
        
            
                "active": true,
            
        
    
    },
    
    {
    
        
        
            
                "name_om": "Fiziksii",
            
        
    
        
        
            
                "name_am": "ፊዚክስ",
            
        
    
        
        
            
                "name_en": "Physics",
            
        
    
        
        
            
                "overview_om": "Seera uumamaa fi hojiirra oolmaa isaanii ni baranna.",
            
        
    
        
        
            
                "overview_am": "የተፈጥሮ ህጎችንና ተግባራዊ አፈፃፀማቸውን እንማራለን።",
            
        
    
        
        
            
                "overview_en": "We study physical laws and their applications.",
            
        
    
        
        
            
                "textbook_references": "Ethiopian MOE Physics textbooks",
            
        
    
        
        
            
                "active": true,
            
        
    
    },
    
    {
    
        
        
            
                "name_om": "Keemistirii",
            
        
    
        
        
            
                "name_am": "ኬሚስትሪ",
            
        
    
        
        
            
                "name_en": "Chemistry",
            
        
    
        
        
            
                "overview_om": "Qaamolee, walitti makamu fi deebii kemikaalaa ni qoranna.",
            
        
    
        
        
            
                "overview_am": "ንጥረ ነገሮችን፣ ውህዶችን እና ኬሚካላዊ ምላሾችን እንመለከታለን።",
            
        
    
        
        
            
                "overview_en": "We explore matter, reactions, and laboratory skills.",
            
        
    
        
        
            
                "textbook_references": "Ethiopian MOE Chemistry textbooks",
            
        
    
        
        
            
                "active": true,
            
        
    
    },
    
    {
    
        
        
            
                "name_om": "Ingiliffa",
            
        
    
        
        
            
                "name_am": "እንግሊዝኛ",
            
        
    
        
        
            
                "name_en": "English",
            
        
    
        
        
            
                "overview_om": "Dubbisuu, barreessuu fi haasa'uu ni fooyyessina.",
            
        
    
        
        
            
                "overview_am": "ንባብ፣ ጽሁፍ እና ንግግር ክህሎት እናበረታታለን።",
            
        
    
        
        
            
                "overview_en": "We improve reading, writing, speaking, and comprehension.",
            
        
    
        
        
            
                "textbook_references": "Ethiopian MOE English textbooks",
            
        
    
        
        
            
                "active": true,
            
        
    
    },
    
];



const SubjectOfferingsData = [
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "learning_objectives_om": "Herrega bu’uuraa fi aljebra ni cimsina.",
            
        
    
        
        
            
                "learning_objectives_am": "መሠረታዊ ሒሳብና አልጀብራ እናጠናክራለን።",
            
        
    
        
        
            
                "learning_objectives_en": "Build foundation in algebra, geometry, and problem solving.",
            
        
    
        
        
            
                "topics_outline": "Integers, algebraic expressions, equations, geometry basics",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "learning_objectives_om": "Kinetiksii fi elekitirisitii bu’uuraa ni baranna.",
            
        
    
        
        
            
                "learning_objectives_am": "ኪኔቲክስና መሠረታዊ ኤሌክትሪሲቲ እንማራለን።",
            
        
    
        
        
            
                "learning_objectives_en": "Understand motion, forces, energy, and basic electricity.",
            
        
    
        
        
            
                "topics_outline": "Motion, Newton laws, work energy power, electricity basics",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "learning_objectives_om": "Walitti makamu, stoikiometri fi laaboraatorii ni cimsina.",
            
        
    
        
        
            
                "learning_objectives_am": "ውህዶችን፣ ስቶይኪዮሜትሪን እና የላቦራቶሪ ክህሎት እናጠናክራለን።",
            
        
    
        
        
            
                "learning_objectives_en": "Strengthen stoichiometry, bonding, and lab skills.",
            
        
    
        
        
            
                "topics_outline": "Mole concept, bonding, reactions, acids and bases",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "learning_objectives_om": "Barreeffama akademikii fi dubbisa ni fooyyessina.",
            
        
    
        
        
            
                "learning_objectives_am": "አካዳሚክ ጽሁፍና ንባብ እናበረታታለን።",
            
        
    
        
        
            
                "learning_objectives_en": "Improve academic writing and exam-focused comprehension.",
            
        
    
        
        
            
                "topics_outline": "Essay writing, comprehension, vocabulary, speaking practice",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
    },
    
];



const StaffMembersData = [
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "full_name": "Tadesse Bekele",
            
        
    
        
        
            
                "staff_role": "librarian",
            
        
    
        
        
            
                "bio": "Leads school improvement, community engagement, and academic excellence.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "phone_number": "+251911000001",
            
        
    
        
        
            
                "email": "director@limmugennet.edu.et",
            
        
    
        
        
            
                // type code here for "relation_many" field
            
        
    
        
        
            
                "public_profile": true,
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "full_name": "Hanna Tesfaye",
            
        
    
        
        
            
                "staff_role": "admin_staff",
            
        
    
        
        
            
                "bio": "Coordinates curriculum delivery, assessments, and teacher support.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "phone_number": "+251911000002",
            
        
    
        
        
            
                "email": "academics@limmugennet.edu.et",
            
        
    
        
        
            
                // type code here for "relation_many" field
            
        
    
        
        
            
                "public_profile": true,
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "full_name": "Mulugeta Alemu",
            
        
    
        
        
            
                "staff_role": "principal",
            
        
    
        
        
            
                "bio": "Manages student records, admissions documentation, and reporting.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "phone_number": "+251911000003",
            
        
    
        
        
            
                "email": "registrar@limmugennet.edu.et",
            
        
    
        
        
            
                // type code here for "relation_many" field
            
        
    
        
        
            
                "public_profile": true,
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "full_name": "Selamawit Girma",
            
        
    
        
        
            
                "staff_role": "librarian",
            
        
    
        
        
            
                "bio": "Mathematics teacher for Grades 9-12 with a focus on exam preparation.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "phone_number": "+251911000004",
            
        
    
        
        
            
                "email": "math.teacher@limmugennet.edu.et",
            
        
    
        
        
            
                // type code here for "relation_many" field
            
        
    
        
        
            
                "public_profile": true,
            
        
    
    },
    
];



const StudentsData = [
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "full_name": "Abel Tulu",
            
        
    
        
        
            
                "student_code": "LG-2025-0091",
            
        
    
        
        
            
                "gender": "male",
            
        
    
        
        
            
                "date_of_birth": new Date('2009-03-15T00:00:00Z'),
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "guardian_name": "Tulu Gemechu",
            
        
    
        
        
            
                "guardian_phone": "+251922100101",
            
        
    
        
        
            
                "address_text": "Limmu Gennet kebele, near health post",
            
        
    
        
        
            
                "active": true,
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "full_name": "Lensa Worku",
            
        
    
        
        
            
                "student_code": "LG-2025-0104",
            
        
    
        
        
            
                "gender": "male",
            
        
    
        
        
            
                "date_of_birth": new Date('2009-11-02T00:00:00Z'),
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "guardian_name": "Worku Daba",
            
        
    
        
        
            
                "guardian_phone": "+251922100102",
            
        
    
        
        
            
                "address_text": "Limmu Gennet kebele, main road",
            
        
    
        
        
            
                "active": true,
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "full_name": "Rahel Mekonnen",
            
        
    
        
        
            
                "student_code": "LG-2025-0120",
            
        
    
        
        
            
                "gender": "female",
            
        
    
        
        
            
                "date_of_birth": new Date('2008-06-21T00:00:00Z'),
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "guardian_name": "Mekonnen Assefa",
            
        
    
        
        
            
                "guardian_phone": "+251922100103",
            
        
    
        
        
            
                "address_text": "Limmu Gennet area, behind market",
            
        
    
        
        
            
                "active": true,
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "full_name": "Kedir Ahmed",
            
        
    
        
        
            
                "student_code": "LG-2025-0135",
            
        
    
        
        
            
                "gender": "male",
            
        
    
        
        
            
                "date_of_birth": new Date('2008-01-08T00:00:00Z'),
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "guardian_name": "Ahmed Nur",
            
        
    
        
        
            
                "guardian_phone": "+251922100104",
            
        
    
        
        
            
                "address_text": "Limmu Gennet area, near church",
            
        
    
        
        
            
                "active": true,
            
        
    
    },
    
];



const ClassSectionsData = [
    
    {
    
        
        
            
                "name": "Grade 9 A",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "capacity": 55,
            
        
    
    },
    
    {
    
        
        
            
                "name": "Grade 9 B",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "capacity": 55,
            
        
    
    },
    
    {
    
        
        
            
                "name": "Grade 10 A",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "capacity": 50,
            
        
    
    },
    
    {
    
        
        
            
                "name": "Grade 11 Natural A",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "capacity": 45,
            
        
    
    },
    
];



const EnrollmentsData = [
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "enrolled_at": new Date('2025-09-15T08:00:00Z'),
            
        
    
        
        
            
                "status": "transferred",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "enrolled_at": new Date('2025-09-15T08:10:00Z'),
            
        
    
        
        
            
                "status": "active",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "enrolled_at": new Date('2025-09-15T08:20:00Z'),
            
        
    
        
        
            
                "status": "active",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "enrolled_at": new Date('2025-09-15T08:25:00Z'),
            
        
    
        
        
            
                "status": "dropped",
            
        
    
    },
    
];



const TermsData = [
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "term_name": "term_2",
            
        
    
        
        
            
                "starts_at": new Date('2025-09-11T00:00:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2025-12-20T00:00:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "term_name": "term_3",
            
        
    
        
        
            
                "starts_at": new Date('2026-01-10T00:00:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2026-03-25T00:00:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "term_name": "term_2",
            
        
    
        
        
            
                "starts_at": new Date('2026-04-10T00:00:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2026-06-20T00:00:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "term_name": "term_1",
            
        
    
        
        
            
                "starts_at": new Date('2024-09-11T00:00:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2024-12-20T00:00:00Z'),
            
        
    
    },
    
];



const EventsData = [
    
    {
    
        
        
            
                "title_om": "Guyyaa Ispoortii",
            
        
    
        
        
            
                "title_am": "የስፖርት ቀን",
            
        
    
        
        
            
                "title_en": "Sports Day",
            
        
    
        
        
            
                "description_om": "Dorgommii fi bashannana barattootaa fi maatii.",
            
        
    
        
        
            
                "description_am": "የተማሪዎችና ወላጆች ውድድር እና መዝናኛ።",
            
        
    
        
        
            
                "description_en": "Student competitions and community activities.",
            
        
    
        
        
            
                "starts_at": new Date('2026-03-05T06:00:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2026-03-05T12:00:00Z'),
            
        
    
        
        
            
                "location_text": "School Field",
            
        
    
        
        
            
                "visibility": "students_only",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "published": true,
            
        
    
    },
    
    {
    
        
        
            
                "title_om": "Walgahii Maatii fi Barsiisaa",
            
        
    
        
        
            
                "title_am": "የወላጅ እና መምህር ስብሰባ",
            
        
    
        
        
            
                "title_en": "Parent Teacher Meeting",
            
        
    
        
        
            
                "description_om": "Haala barnootaa fi qalmaa barattootaa irratti marii.",
            
        
    
        
        
            
                "description_am": "የትምህርትና የተማሪ እድገት ውይይት።",
            
        
    
        
        
            
                "description_en": "Discuss student progress and school updates.",
            
        
    
        
        
            
                "starts_at": new Date('2026-02-22T07:00:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2026-02-22T10:00:00Z'),
            
        
    
        
        
            
                "location_text": "Main Hall",
            
        
    
        
        
            
                "visibility": "public",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "published": true,
            
        
    
    },
    
    {
    
        
        
            
                "title_om": "Sirna Xumura Barnootaa",
            
        
    
        
        
            
                "title_am": "የምረቃ ስነ ስርዓት",
            
        
    
        
        
            
                "title_en": "Graduation Ceremony",
            
        
    
        
        
            
                "description_om": "Barattoota kutaa 12ffaa kabajuu.",
            
        
    
        
        
            
                "description_am": "የ12ኛ ክፍል ተማሪዎች ማክበር።",
            
        
    
        
        
            
                "description_en": "Celebrating Grade 12 graduates.",
            
        
    
        
        
            
                "starts_at": new Date('2026-06-25T07:00:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2026-06-25T11:00:00Z'),
            
        
    
        
        
            
                "location_text": "School Compound",
            
        
    
        
        
            
                "visibility": "public",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "published": false,
            
        
    
    },
    
    {
    
        
        
            
                "title_om": "Qormaata giddu-galeessaa",
            
        
    
        
        
            
                "title_am": "የመካከለኛ ፈተና",
            
        
    
        
        
            
                "title_en": "Midterm Exams Week",
            
        
    
        
        
            
                "description_om": "Qormaata giddu-galeessaa kutaa hundaaf.",
            
        
    
        
        
            
                "description_am": "ለሁሉም ክፍሎች የመካከለኛ ፈተና ሳምንት።",
            
        
    
        
        
            
                "description_en": "Midterm examination schedule week.",
            
        
    
        
        
            
                "starts_at": new Date('2026-02-03T00:00:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2026-02-07T00:00:00Z'),
            
        
    
        
        
            
                "location_text": "Classrooms",
            
        
    
        
        
            
                "visibility": "staff_only",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "published": true,
            
        
    
    },
    
];



const AnnouncementsData = [
    
    {
    
        
        
            
                "title_om": "Beeksisa Qormaata",
            
        
    
        
        
            
                "title_am": "የፈተና ማስታወቂያ",
            
        
    
        
        
            
                "title_en": "Exam Notice",
            
        
    
        
        
            
                "content_om": "Qormaanni ji'a kanaa torban kana keessa ni geggeeffama.",
            
        
    
        
        
            
                "content_am": "የዚህ ወር ፈተና በዚህ ሳምንት ይካሄዳል።",
            
        
    
        
        
            
                "content_en": "Monthly tests will be conducted this week. Please check schedules.",
            
        
    
        
        
            
                "visibility": "public",
            
        
    
        
        
            
                "publish_from": new Date('2026-02-01T00:00:00Z'),
            
        
    
        
        
            
                "publish_until": new Date('2026-02-08T00:00:00Z'),
            
        
    
        
        
            
                "pinned": true,
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
    },
    
    {
    
        
        
            
                "title_om": "Galmeen Barattootaa Banameera",
            
        
    
        
        
            
                "title_am": "ምዝገባ ተከፍቷል",
            
        
    
        
        
            
                "title_en": "Registration Open",
            
        
    
        
        
            
                "content_om": "Galmeen barattootaa kutaa 9ffaa ni jalqabe.",
            
        
    
        
        
            
                "content_am": "የ9ኛ ክፍል ምዝገባ ተጀምሯል።",
            
        
    
        
        
            
                "content_en": "Grade 9 registration has opened. Submit required documents to the registrar.",
            
        
    
        
        
            
                "visibility": "staff_only",
            
        
    
        
        
            
                "publish_from": new Date('2026-01-25T00:00:00Z'),
            
        
    
        
        
            
                "publish_until": new Date('2026-02-20T00:00:00Z'),
            
        
    
        
        
            
                "pinned": true,
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
    },
    
    {
    
        
        
            
                "title_om": "Beeksisa Keessaa Barsiisotaa",
            
        
    
        
        
            
                "title_am": "የመምህራን ውስጣዊ ማስታወቂያ",
            
        
    
        
        
            
                "title_en": "Internal Staff Notice",
            
        
    
        
        
            
                "content_om": "Walgahii hojjettoota guyyoota murtaa'an irratti argamaa.",
            
        
    
        
        
            
                "content_am": "በተመደቡ ቀናት የሰራተኞች ስብሰባ ይካሄዳል።",
            
        
    
        
        
            
                "content_en": "Staff meeting scheduled. Please attend on time.",
            
        
    
        
        
            
                "visibility": "students_only",
            
        
    
        
        
            
                "publish_from": new Date('2026-02-15T00:00:00Z'),
            
        
    
        
        
            
                "publish_until": new Date('2026-02-19T00:00:00Z'),
            
        
    
        
        
            
                "pinned": false,
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
    },
    
    {
    
        
        
            
                "title_om": "Barattootaaf Qajeelfama",
            
        
    
        
        
            
                "title_am": "ለተማሪዎች መመሪያ",
            
        
    
        
        
            
                "title_en": "Student Guidance",
            
        
    
        
        
            
                "content_om": "Seera uffannaa fi yeroo galmaa'uu akka kabajtan ni yaadachiifna.",
            
        
    
        
        
            
                "content_am": "የደንብ ልብስና የመግቢያ ሰዓት እንዲከበር እናሳስባለን።",
            
        
    
        
        
            
                "content_en": "Please follow the uniform policy and arrival time rules.",
            
        
    
        
        
            
                "visibility": "students_only",
            
        
    
        
        
            
                "publish_from": new Date('2026-02-05T00:00:00Z'),
            
        
    
        
        
            
                "publish_until": new Date('2026-03-01T00:00:00Z'),
            
        
    
        
        
            
                "pinned": false,
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
    },
    
];



const NewsPostsData = [
    
    {
    
        
        
            
                "title_om": "Shaampiyoonaa Ispoortii Mana Barumsaa",
            
        
    
        
        
            
                "title_am": "የትምህርት ቤት የስፖርት ሻምፒዮና",
            
        
    
        
        
            
                "title_en": "Inter-Class Sports Championship",
            
        
    
        
        
            
                "excerpt_om": "Barattoonni keenya dorgommii ispoortii keessatti hirmaatan.",
            
        
    
        
        
            
                "excerpt_am": "ተማሪዎቻችን በስፖርት ውድድር ተሳትፈዋል።",
            
        
    
        
        
            
                "excerpt_en": "Students competed in inter-class games and athletics.",
            
        
    
        
        
            
                "content_om": "Dorgommichi waliin hojjetanii fi jaalala ispoortii cimsuuf gargaareera.",
            
        
    
        
        
            
                "content_am": "ውድድሩ በጋራ መስራትና የስፖርት ፍቅር ማበርታት ረዳ።",
            
        
    
        
        
            
                "content_en": "The championship strengthened teamwork, discipline, and school spirit.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "status": "draft",
            
        
    
        
        
            
                "published_at": new Date('2026-02-06T09:00:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                "title_om": "Hojii Hawaasummaa Barattootaa",
            
        
    
        
        
            
                "title_am": "የተማሪዎች የማህበረሰብ አገልግሎት",
            
        
    
        
        
            
                "title_en": "Student Community Outreach",
            
        
    
        
        
            
                "excerpt_om": "Hojii qulqullina naannoo irratti hirmaanne.",
            
        
    
        
        
            
                "excerpt_am": "በአካባቢ ጽዳት ስራ ተሳትፈናል።",
            
        
    
        
        
            
                "excerpt_en": "Students joined a community clean-up activity.",
            
        
    
        
        
            
                "content_om": "Barattoonni fi barsiisotni tajaajila hawaasaaf waliin hojjetan.",
            
        
    
        
        
            
                "content_am": "ተማሪዎችና መምህራን ለማህበረሰብ አገልግሎት በጋራ ሰሩ።",
            
        
    
        
        
            
                "content_en": "Teachers and students worked together to support the local community.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "status": "published",
            
        
    
        
        
            
                "published_at": new Date('2026-01-28T11:00:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                "title_om": "Bu'aa Qormaata Mid-Term",
            
        
    
        
        
            
                "title_am": "የመካከለኛ ፈተና ውጤት",
            
        
    
        
        
            
                "title_en": "Midterm Performance Summary",
            
        
    
        
        
            
                "excerpt_om": "Bu'aan waliigalaa fooyya'aa jira.",
            
        
    
        
        
            
                "excerpt_am": "አጠቃላይ ውጤት መሻሻል አሳይቷል።",
            
        
    
        
        
            
                "excerpt_en": "Overall performance showed improvement.",
            
        
    
        
        
            
                "content_om": "Kutaan herregaa fi ingiliffaa keessatti fooyya'insi mul'ateera.",
            
        
    
        
        
            
                "content_am": "በሒሳብና በእንግሊዝኛ ክፍሎች ልዩ ማሻሻያ ታይቷል።",
            
        
    
        
        
            
                "content_en": "Notable improvement was observed in Mathematics and English.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "status": "draft",
            
        
    
        
        
            
                "published_at": new Date('2026-02-12T08:30:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                "title_om": "Barattoota Olaanaa Kabajuu",
            
        
    
        
        
            
                "title_am": "ከፍተኛ ውጤት ያሳዩ ተማሪዎች ማክበር",
            
        
    
        
        
            
                "title_en": "Recognizing Top Students",
            
        
    
        
        
            
                "excerpt_om": "Barattoota cimaa kabajne.",
            
        
    
        
        
            
                "excerpt_am": "ከፍተኛ ውጤት ያሳዩ ተማሪዎችን አክበርን።",
            
        
    
        
        
            
                "excerpt_en": "The school recognized high achievers.",
            
        
    
        
        
            
                "content_om": "Kabajni kun barattoota biroo jajjabeessa.",
            
        
    
        
        
            
                "content_am": "ይህ ክብር ሌሎች ተማሪዎችን ያበረታታል።",
            
        
    
        
        
            
                "content_en": "The recognition motivates peers and promotes academic excellence.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "status": "draft",
            
        
    
        
        
            
                "published_at": new Date('2026-02-01T10:15:00Z'),
            
        
    
    },
    
];



const GalleriesData = [
    
    {
    
        
        
            
                "title_om": "Suuraawwan Guyyaa Ispoortii",
            
        
    
        
        
            
                "title_am": "የስፖርት ቀን ፎቶዎች",
            
        
    
        
        
            
                "title_en": "Sports Day Photos",
            
        
    
        
        
            
                "description_om": "Suuraawwan dorgommii fi bashannanaa.",
            
        
    
        
        
            
                "description_am": "የውድድርና መዝናኛ ፎቶዎች።",
            
        
    
        
        
            
                "description_en": "Highlights from sports competitions and activities.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "published": true,
            
        
    
        
        
            
                "published_at": new Date('2026-03-06T08:00:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                "title_om": "Hojii Hawaasummaa",
            
        
    
        
        
            
                "title_am": "የማህበረሰብ አገልግሎት",
            
        
    
        
        
            
                "title_en": "Community Outreach",
            
        
    
        
        
            
                "description_om": "Hojii qulqullina naannoo fi biqiltuu dhaabuu.",
            
        
    
        
        
            
                "description_am": "የአካባቢ ጽዳትና የዛፍ ተከላ ስራ።",
            
        
    
        
        
            
                "description_en": "Clean-up and tree planting activities.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "published": true,
            
        
    
        
        
            
                "published_at": new Date('2026-01-29T08:00:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                "title_om": "Guyyaa Eebbisaa",
            
        
    
        
        
            
                "title_am": "የምረቃ ቀን",
            
        
    
        
        
            
                "title_en": "Graduation Day",
            
        
    
        
        
            
                "description_om": "Kabaja barattoota kutaa 12ffaa.",
            
        
    
        
        
            
                "description_am": "የ12ኛ ክፍል ተማሪዎች ክብር።",
            
        
    
        
        
            
                "description_en": "Celebration of Grade 12 students.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "published": false,
            
        
    
        
        
            
                "published_at": new Date('2026-06-26T08:00:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                "title_om": "Bakka Barnootaa fi Laaboraatorii",
            
        
    
        
        
            
                "title_am": "ክፍሎችና ላቦራቶሪ",
            
        
    
        
        
            
                "title_en": "Classrooms and Labs",
            
        
    
        
        
            
                "description_om": "Bakka barnootaa fi qopheessuu hojii laaboraatorii.",
            
        
    
        
        
            
                "description_am": "ክፍሎችና የላቦራቶሪ ዝግጅት።",
            
        
    
        
        
            
                "description_en": "Learning spaces and laboratory preparations.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "published": true,
            
        
    
        
        
            
                "published_at": new Date('2026-02-10T08:00:00Z'),
            
        
    
    },
    
];



const StudyMaterialsData = [
    
    {
    
        
        
            
                "title_om": "Qormaata Darbe Herrega Kutaa 10",
            
        
    
        
        
            
                "title_am": "የቀድሞ ፈተና ሒሳብ 10ኛ",
            
        
    
        
        
            
                "title_en": "Past Exam Paper Math Grade 10",
            
        
    
        
        
            
                "material_type": "other",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "description": "Past paper for revision and exam practice.",
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "external_url": "https://example.com/math-g10-past-paper",
            
        
    
        
        
            
                "visibility": "students_only",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "published_at": new Date('2026-01-18T09:00:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                "title_om": "Yaadannoo Fiziksii Kutaa 10",
            
        
    
        
        
            
                "title_am": "የፊዚክስ እርምጃ ማስታወሻ 10ኛ",
            
        
    
        
        
            
                "title_en": "Physics Revision Notes Grade 10",
            
        
    
        
        
            
                "material_type": "video_link",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "description": "Concise notes for motion and energy units.",
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "external_url": "https://example.com/physics-g10-notes",
            
        
    
        
        
            
                "visibility": "students_only",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "published_at": new Date('2026-02-02T09:00:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                "title_om": "Gaaffii Shaakala Keemistirii Kutaa 11",
            
        
    
        
        
            
                "title_am": "የኬሚስትሪ ልምምድ ጥያቄዎች 11ኛ",
            
        
    
        
        
            
                "title_en": "Chemistry Practice Questions Grade 11",
            
        
    
        
        
            
                "material_type": "revision_notes",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "description": "Practice questions with answer key for mole concept.",
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "external_url": "https://example.com/chem-g11-practice",
            
        
    
        
        
            
                "visibility": "students_only",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "published_at": new Date('2026-01-30T09:00:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                "title_om": "Tarree Kitaabota Qabxii",
            
        
    
        
        
            
                "title_am": "የማጣቀሻ መጽሐፍት ዝርዝር",
            
        
    
        
        
            
                "title_en": "Reference Books List",
            
        
    
        
        
            
                "material_type": "revision_notes",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "description": "Suggested reference books for academic reading and writing.",
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "external_url": "https://example.com/reference-books",
            
        
    
        
        
            
                "visibility": "public",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "published_at": new Date('2026-01-12T09:00:00Z'),
            
        
    
    },
    
];



const ExamsData = [
    
    {
    
        
        
            
                "name": "Grade 10 Monthly Test 1",
            
        
    
        
        
            
                "exam_type": "national_grade_10",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "starts_at": new Date('2026-02-06T00:00:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2026-02-07T00:00:00Z'),
            
        
    
        
        
            
                "public_results": false,
            
        
    
    },
    
    {
    
        
        
            
                "name": "Grade 11 Midterm Exam",
            
        
    
        
        
            
                "exam_type": "midterm",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "starts_at": new Date('2026-02-03T00:00:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2026-02-07T00:00:00Z'),
            
        
    
        
        
            
                "public_results": false,
            
        
    
    },
    
    {
    
        
        
            
                "name": "Grade 12 Final Exam",
            
        
    
        
        
            
                "exam_type": "national_grade_12",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "starts_at": new Date('2026-06-01T00:00:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2026-06-10T00:00:00Z'),
            
        
    
        
        
            
                "public_results": true,
            
        
    
    },
    
    {
    
        
        
            
                "name": "National Exam Grade 10 2025",
            
        
    
        
        
            
                "exam_type": "national_grade_10",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "starts_at": new Date('2025-06-15T00:00:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2025-06-20T00:00:00Z'),
            
        
    
        
        
            
                "public_results": true,
            
        
    
    },
    
];



const ExamResultsData = [
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "score": 78.5,
            
        
    
        
        
            
                "out_of": 100,
            
        
    
        
        
            
                "result_status": "submitted",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "entered_at": new Date('2026-02-08T09:00:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "score": 84.0,
            
        
    
        
        
            
                "out_of": 100,
            
        
    
        
        
            
                "result_status": "approved",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "entered_at": new Date('2026-02-08T09:05:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "score": 72.0,
            
        
    
        
        
            
                "out_of": 100,
            
        
    
        
        
            
                "result_status": "published",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "entered_at": new Date('2026-02-10T08:00:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "score": 69.5,
            
        
    
        
        
            
                "out_of": 100,
            
        
    
        
        
            
                "result_status": "draft",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "entered_at": new Date('2026-02-09T14:00:00Z'),
            
        
    
    },
    
];



const AttendanceSessionsData = [
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "session_at": new Date('2026-02-12T06:30:00Z'),
            
        
    
        
        
            
                "session_type": "exam",
            
        
    
        
        
            
                "note": "Algebra practice session",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "session_at": new Date('2026-02-12T07:30:00Z'),
            
        
    
        
        
            
                "session_type": "homeroom",
            
        
    
        
        
            
                "note": "Motion and forces",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "session_at": new Date('2026-02-11T06:30:00Z'),
            
        
    
        
        
            
                "session_type": "period",
            
        
    
        
        
            
                "note": "Mole concept exercises",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "session_at": new Date('2026-02-11T07:30:00Z'),
            
        
    
        
        
            
                "session_type": "homeroom",
            
        
    
        
        
            
                "note": "Reading comprehension",
            
        
    
    },
    
];



const AttendanceRecordsData = [
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "status": "excused",
            
        
    
        
        
            
                "remark": "On time",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "status": "present",
            
        
    
        
        
            
                "remark": "Arrived 10 minutes late",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "status": "absent",
            
        
    
        
        
            
                "remark": "Participated actively",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "status": "late",
            
        
    
        
        
            
                "remark": "Completed classwork",
            
        
    
    },
    
];



const ClassSchedulesData = [
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "weekday": "wednesday",
            
        
    
        
        
            
                "period_label": "Period 1",
            
        
    
        
        
            
                "starts_at": new Date('2026-02-16T06:30:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2026-02-16T07:10:00Z'),
            
        
    
        
        
            
                "room": "Room 10A",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "weekday": "friday",
            
        
    
        
        
            
                "period_label": "Period 2",
            
        
    
        
        
            
                "starts_at": new Date('2026-02-16T07:20:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2026-02-16T08:00:00Z'),
            
        
    
        
        
            
                "room": "Room 10A",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "weekday": "wednesday",
            
        
    
        
        
            
                "period_label": "Period 1",
            
        
    
        
        
            
                "starts_at": new Date('2026-02-17T06:30:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2026-02-17T07:10:00Z'),
            
        
    
        
        
            
                "room": "Lab 1",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "weekday": "thursday",
            
        
    
        
        
            
                "period_label": "Period 2",
            
        
    
        
        
            
                "starts_at": new Date('2026-02-17T07:20:00Z'),
            
        
    
        
        
            
                "ends_at": new Date('2026-02-17T08:00:00Z'),
            
        
    
        
        
            
                "room": "Room 11S",
            
        
    
    },
    
];



const AssignmentsData = [
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "title": "Algebra Worksheet 3",
            
        
    
        
        
            
                "instructions": "Complete questions 1 to 20 and show steps.",
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "assigned_at": new Date('2026-02-10T09:00:00Z'),
            
        
    
        
        
            
                "due_at": new Date('2026-02-14T15:00:00Z'),
            
        
    
        
        
            
                "visibility": "public",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "title": "Forces and Motion Questions",
            
        
    
        
        
            
                "instructions": "Solve the problems and write brief explanations.",
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "assigned_at": new Date('2026-02-10T10:00:00Z'),
            
        
    
        
        
            
                "due_at": new Date('2026-02-15T15:00:00Z'),
            
        
    
        
        
            
                "visibility": "public",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "title": "Mole Concept Practice Set",
            
        
    
        
        
            
                "instructions": "Attempt all questions and submit calculations clearly.",
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "assigned_at": new Date('2026-02-09T09:00:00Z'),
            
        
    
        
        
            
                "due_at": new Date('2026-02-13T15:00:00Z'),
            
        
    
        
        
            
                "visibility": "public",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "title": "Reading Summary Task",
            
        
    
        
        
            
                "instructions": "Read the passage and submit a 200 word summary.",
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "assigned_at": new Date('2026-02-09T11:00:00Z'),
            
        
    
        
        
            
                "due_at": new Date('2026-02-13T15:00:00Z'),
            
        
    
        
        
            
                "visibility": "students_only",
            
        
    
    },
    
];



const AssignmentSubmissionsData = [
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "comment": "Completed all questions with steps.",
            
        
    
        
        
            
                "submitted_at": new Date('2026-02-13T12:00:00Z'),
            
        
    
        
        
            
                "status": "returned",
            
        
    
        
        
            
                "grade_value": 0,
            
        
    
        
        
            
                "teacher_feedback": "Pending review",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "comment": "Solved questions 1 to 18.",
            
        
    
        
        
            
                "submitted_at": new Date('2026-02-13T13:30:00Z'),
            
        
    
        
        
            
                "status": "returned",
            
        
    
        
        
            
                "grade_value": 0,
            
        
    
        
        
            
                "teacher_feedback": "Pending review",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "comment": "Submitted with clear calculations.",
            
        
    
        
        
            
                "submitted_at": new Date('2026-02-12T16:10:00Z'),
            
        
    
        
        
            
                "status": "reviewed",
            
        
    
        
        
            
                "grade_value": 85,
            
        
    
        
        
            
                "teacher_feedback": "Good work, check units in question 4",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "comment": "Summary attached.",
            
        
    
        
        
            
                "submitted_at": new Date('2026-02-13T14:30:00Z'),
            
        
    
        
        
            
                "status": "returned",
            
        
    
        
        
            
                "grade_value": 62,
            
        
    
        
        
            
                "teacher_feedback": "Improve structure and avoid repetition",
            
        
    
    },
    
];



const LessonPlansData = [
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "week_start_at": new Date('2026-02-16T00:00:00Z'),
            
        
    
        
        
            
                "week_end_at": new Date('2026-02-20T00:00:00Z'),
            
        
    
        
        
            
                "plan_content": "Focus on linear equations, practice and group work, quick quiz Friday.",
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "status": "submitted",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "week_start_at": new Date('2026-02-16T00:00:00Z'),
            
        
    
        
        
            
                "week_end_at": new Date('2026-02-20T00:00:00Z'),
            
        
    
        
        
            
                "plan_content": "Motion graphs, problem solving, short demonstration with simple tools.",
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "status": "draft",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "week_start_at": new Date('2026-02-16T00:00:00Z'),
            
        
    
        
        
            
                "week_end_at": new Date('2026-02-20T00:00:00Z'),
            
        
    
        
        
            
                "plan_content": "Mole calculations, limiting reagents introduction, lab safety reminder.",
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "status": "draft",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "week_start_at": new Date('2026-02-16T00:00:00Z'),
            
        
    
        
        
            
                "week_end_at": new Date('2026-02-20T00:00:00Z'),
            
        
    
        
        
            
                "plan_content": "Reading strategies, vocabulary building, short essay practice.",
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "status": "draft",
            
        
    
    },
    
];



const MessagesData = [
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "subject": "Assignment Reminder",
            
        
    
        
        
            
                "body": "Please submit Algebra Worksheet 3 by the due date.",
            
        
    
        
        
            
                "status": "archived",
            
        
    
        
        
            
                "sent_at": new Date('2026-02-12T13:00:00Z'),
            
        
    
        
        
            
                "read_at": new Date('2026-02-12T18:25:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "subject": "Question on Worksheet",
            
        
    
        
        
            
                "body": "Could you clarify question 12 about factoring?",
            
        
    
        
        
            
                "status": "archived",
            
        
    
        
        
            
                "sent_at": new Date('2026-02-12T18:40:00Z'),
            
        
    
        
        
            
                "read_at": new Date('2026-02-12T19:05:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "subject": "Enrollment Update",
            
        
    
        
        
            
                "body": "Grade 10 A enrollment updated with two new students.",
            
        
    
        
        
            
                "status": "read",
            
        
    
        
        
            
                "sent_at": new Date('2026-02-11T09:20:00Z'),
            
        
    
        
        
            
                "read_at": new Date('2026-02-11T10:00:00Z'),
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "subject": "Schedule Confirmation",
            
        
    
        
        
            
                "body": "Please confirm term 2 exam dates for posting.",
            
        
    
        
        
            
                "status": "sent",
            
        
    
        
        
            
                "sent_at": new Date('2026-02-11T10:15:00Z'),
            
        
    
        
        
            
                "read_at": new Date('2026-02-11T10:30:00Z'),
            
        
    
    },
    
];



const AdmissionApplicationsData = [
    
    {
    
        
        
            
                "entry_type": "transfer",
            
        
    
        
        
            
                "applicant_full_name": "Sofia Gemechu",
            
        
    
        
        
            
                "gender": "female",
            
        
    
        
        
            
                "date_of_birth": new Date('2011-05-10T00:00:00Z'),
            
        
    
        
        
            
                "previous_school": "Limmu Gennet Primary School",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "guardian_full_name": "Gemechu Abdisa",
            
        
    
        
        
            
                "guardian_phone": "+251922200201",
            
        
    
        
        
            
                "guardian_email": "gemechu.g@example.com",
            
        
    
        
        
            
                "address_text": "Limmu Gennet area, near water point",
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "submitted_at": new Date('2026-02-01T09:30:00Z'),
            
        
    
        
        
            
                "status": "waitlisted",
            
        
    
    },
    
    {
    
        
        
            
                "entry_type": "grade_9_entry",
            
        
    
        
        
            
                "applicant_full_name": "Musa Ali",
            
        
    
        
        
            
                "gender": "male",
            
        
    
        
        
            
                "date_of_birth": new Date('2010-08-12T00:00:00Z'),
            
        
    
        
        
            
                "previous_school": "Bedele Secondary School",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "guardian_full_name": "Ali Mohammed",
            
        
    
        
        
            
                "guardian_phone": "+251922200202",
            
        
    
        
        
            
                "guardian_email": "ali.m@example.com",
            
        
    
        
        
            
                "address_text": "Limmu Gennet area, near clinic",
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "submitted_at": new Date('2026-02-03T10:00:00Z'),
            
        
    
        
        
            
                "status": "rejected",
            
        
    
    },
    
    {
    
        
        
            
                "entry_type": "grade_9_entry",
            
        
    
        
        
            
                "applicant_full_name": "Hawi Tesema",
            
        
    
        
        
            
                "gender": "male",
            
        
    
        
        
            
                "date_of_birth": new Date('2011-01-25T00:00:00Z'),
            
        
    
        
        
            
                "previous_school": "Kebele Primary School",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "guardian_full_name": "Tesema Dinka",
            
        
    
        
        
            
                "guardian_phone": "+251922200203",
            
        
    
        
        
            
                "guardian_email": "tesema.d@example.com",
            
        
    
        
        
            
                "address_text": "Limmu Gennet area, behind cooperative",
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "submitted_at": new Date('2026-02-04T08:45:00Z'),
            
        
    
        
        
            
                "status": "under_review",
            
        
    
    },
    
    {
    
        
        
            
                "entry_type": "grade_9_entry",
            
        
    
        
        
            
                "applicant_full_name": "Bereket Solomon",
            
        
    
        
        
            
                "gender": "female",
            
        
    
        
        
            
                "date_of_birth": new Date('2009-04-18T00:00:00Z'),
            
        
    
        
        
            
                "previous_school": "Agaro Secondary School",
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "guardian_full_name": "Solomon Abate",
            
        
    
        
        
            
                "guardian_phone": "+251922200204",
            
        
    
        
        
            
                "guardian_email": "solomon.a@example.com",
            
        
    
        
        
            
                "address_text": "Limmu Gennet area, near mosque",
            
        
    
        
        
            
                // type code here for "files" field
            
        
    
        
        
            
                "submitted_at": new Date('2026-02-05T12:10:00Z'),
            
        
    
        
        
            
                "status": "submitted",
            
        
    
    },
    
];



const ContactMessagesData = [
    
    {
    
        
        
            
                "full_name": "Abdi Roba",
            
        
    
        
        
            
                "phone_number": "+251923300301",
            
        
    
        
        
            
                "email": "abdi.roba@example.com",
            
        
    
        
        
            
                "topic": "results",
            
        
    
        
        
            
                "message": "Please confirm the registration dates for Grade 9 entry.",
            
        
    
        
        
            
                "submitted_at": new Date('2026-02-02T07:20:00Z'),
            
        
    
        
        
            
                "status": "in_progress",
            
        
    
    },
    
    {
    
        
        
            
                "full_name": "Meseret Taye",
            
        
    
        
        
            
                "phone_number": "+251923300302",
            
        
    
        
        
            
                "email": "meseret.t@example.com",
            
        
    
        
        
            
                "topic": "general",
            
        
    
        
        
            
                "message": "Where can I view Grade 10 national exam results by year?",
            
        
    
        
        
            
                "submitted_at": new Date('2026-02-04T09:10:00Z'),
            
        
    
        
        
            
                "status": "new",
            
        
    
    },
    
    {
    
        
        
            
                "full_name": "Kebede Olana",
            
        
    
        
        
            
                "phone_number": "+251923300303",
            
        
    
        
        
            
                "email": "kebede.o@example.com",
            
        
    
        
        
            
                "topic": "technical",
            
        
    
        
        
            
                "message": "Do you have a student council and clubs information available?",
            
        
    
        
        
            
                "submitted_at": new Date('2026-02-05T10:05:00Z'),
            
        
    
        
        
            
                "status": "new",
            
        
    
    },
    
    {
    
        
        
            
                "full_name": "Sara Mohammed",
            
        
    
        
        
            
                "phone_number": "+251923300304",
            
        
    
        
        
            
                "email": "sara.m@example.com",
            
        
    
        
        
            
                "topic": "admissions",
            
        
    
        
        
            
                "message": "Please share the Grade 11 stream subject combinations.",
            
        
    
        
        
            
                "submitted_at": new Date('2026-02-06T08:30:00Z'),
            
        
    
        
        
            
                "status": "resolved",
            
        
    
    },
    
];



const AlumniData = [
    
    {
    
        
        
            
                "full_name": "Alemu Negeri",
            
        
    
        
        
            
                "graduation_year": "2012",
            
        
    
        
        
            
                "current_role": "Civil Engineer",
            
        
    
        
        
            
                "organization": "Regional Construction Office",
            
        
    
        
        
            
                "bio": "Supports student mentorship and school development projects.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "phone_number": "+251911555101",
            
        
    
        
        
            
                "email": "alemu.n@example.com",
            
        
    
        
        
            
                "notable": true,
            
        
    
        
        
            
                "published": true,
            
        
    
    },
    
    {
    
        
        
            
                "full_name": "Hirut Shiferaw",
            
        
    
        
        
            
                "graduation_year": "2010",
            
        
    
        
        
            
                "current_role": "Nurse",
            
        
    
        
        
            
                "organization": "District Hospital",
            
        
    
        
        
            
                "bio": "Advocates for student health and community wellness programs.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "phone_number": "+251911555102",
            
        
    
        
        
            
                "email": "hirut.s@example.com",
            
        
    
        
        
            
                "notable": true,
            
        
    
        
        
            
                "published": true,
            
        
    
    },
    
    {
    
        
        
            
                "full_name": "Kenenisa Tolera",
            
        
    
        
        
            
                "graduation_year": "2015",
            
        
    
        
        
            
                "current_role": "Teacher",
            
        
    
        
        
            
                "organization": "Local Primary School",
            
        
    
        
        
            
                "bio": "Volunteers in tutoring programs during exam seasons.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "phone_number": "+251911555103",
            
        
    
        
        
            
                "email": "kenenisa.t@example.com",
            
        
    
        
        
            
                "notable": false,
            
        
    
        
        
            
                "published": true,
            
        
    
    },
    
    {
    
        
        
            
                "full_name": "Selam Tesfaye",
            
        
    
        
        
            
                "graduation_year": "2013",
            
        
    
        
        
            
                "current_role": "Entrepreneur",
            
        
    
        
        
            
                "organization": "Small Agribusiness",
            
        
    
        
        
            
                "bio": "Contributes to school fundraising and entrepreneurship talks.",
            
        
    
        
        
            
                // type code here for "images" field
            
        
    
        
        
            
                "phone_number": "+251911555104",
            
        
    
        
        
            
                "email": "selam.t@example.com",
            
        
    
        
        
            
                "notable": false,
            
        
    
        
        
            
                "published": true,
            
        
    
    },
    
];



const SchoolStatisticsData = [
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "student_count": 820,
            
        
    
        
        
            
                "teacher_count": 48,
            
        
    
        
        
            
                "pass_rate": 0.86,
            
        
    
        
        
            
                "notes": "Current year enrollment and pass rate estimate",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "student_count": 790,
            
        
    
        
        
            
                "teacher_count": 46,
            
        
    
        
        
            
                "pass_rate": 0.84,
            
        
    
        
        
            
                "notes": "Improved pass rate after tutorial program",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "student_count": 760,
            
        
    
        
        
            
                "teacher_count": 44,
            
        
    
        
        
            
                "pass_rate": 0.82,
            
        
    
        
        
            
                "notes": "Stable performance with increased resources",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "student_count": 740,
            
        
    
        
        
            
                "teacher_count": 42,
            
        
    
        
        
            
                "pass_rate": 0.8,
            
        
    
        
        
            
                "notes": "Focus on attendance and remedial classes",
            
        
    
    },
    
];



const ExamPerformanceSummariesData = [
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "average_score": 63.2,
            
        
    
        
        
            
                "highest_score": 91.0,
            
        
    
        
        
            
                "lowest_score": 34.5,
            
        
    
        
        
            
                "pass_rate": 0.79,
            
        
    
        
        
            
                "student_count": 210,
            
        
    
        
        
            
                "published": true,
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "average_score": 61.5,
            
        
    
        
        
            
                "highest_score": 89.0,
            
        
    
        
        
            
                "lowest_score": 30.0,
            
        
    
        
        
            
                "pass_rate": 0.76,
            
        
    
        
        
            
                "student_count": 165,
            
        
    
        
        
            
                "published": true,
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "average_score": 66.8,
            
        
    
        
        
            
                "highest_score": 92.5,
            
        
    
        
        
            
                "lowest_score": 28.0,
            
        
    
        
        
            
                "pass_rate": 0.81,
            
        
    
        
        
            
                "student_count": 180,
            
        
    
        
        
            
                "published": false,
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "average_score": 70.4,
            
        
    
        
        
            
                "highest_score": 96.0,
            
        
    
        
        
            
                "lowest_score": 40.0,
            
        
    
        
        
            
                "pass_rate": 0.88,
            
        
    
        
        
            
                "student_count": 220,
            
        
    
        
        
            
                "published": false,
            
        
    
    },
    
];



const TopStudentFeaturesData = [
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "total_score": 545.0,
            
        
    
        
        
            
                "rank": 1,
            
        
    
        
        
            
                "consent_to_publish": true,
            
        
    
        
        
            
                "published": true,
            
        
    
        
        
            
                "note": "Top scorer with consistent performance",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "total_score": 532.0,
            
        
    
        
        
            
                "rank": 2,
            
        
    
        
        
            
                "consent_to_publish": true,
            
        
    
        
        
            
                "published": true,
            
        
    
        
        
            
                "note": "Strong results in Mathematics and English",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "total_score": 518.0,
            
        
    
        
        
            
                "rank": 3,
            
        
    
        
        
            
                "consent_to_publish": true,
            
        
    
        
        
            
                "published": true,
            
        
    
        
        
            
                "note": "Excellent in science subjects",
            
        
    
    },
    
    {
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                // type code here for "relation_one" field
            
        
    
        
        
            
                "total_score": 486.0,
            
        
    
        
        
            
                "rank": 1,
            
        
    
        
        
            
                "consent_to_publish": false,
            
        
    
        
        
            
                "published": false,
            
        
    
        
        
            
                "note": "Pending consent for publication",
            
        
    
    },
    
];




    
    
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
            // Similar logic for "relation_many"
        
    

    
    
    
    
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    

    
    
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    

    
    
    
        
    
        
    
        
    
        
    

    
    
    
        
    
        
    
        
    

    
    
    
        
    
        
    
        
    
        
    

    
    
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    

    
    
    
        
            
            async function associateSubjectOfferingWithSubject() {
            
                const relatedSubject0 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const SubjectOffering0 = await SubjectOfferings.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (SubjectOffering0?.setSubject)
                {
                    await
                    SubjectOffering0.
                    setSubject(relatedSubject0);
                }
            
                const relatedSubject1 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const SubjectOffering1 = await SubjectOfferings.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (SubjectOffering1?.setSubject)
                {
                    await
                    SubjectOffering1.
                    setSubject(relatedSubject1);
                }
            
                const relatedSubject2 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const SubjectOffering2 = await SubjectOfferings.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (SubjectOffering2?.setSubject)
                {
                    await
                    SubjectOffering2.
                    setSubject(relatedSubject2);
                }
            
                const relatedSubject3 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const SubjectOffering3 = await SubjectOfferings.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (SubjectOffering3?.setSubject)
                {
                    await
                    SubjectOffering3.
                    setSubject(relatedSubject3);
                }
            
        }
        
    
        
            
            async function associateSubjectOfferingWithGrade() {
            
                const relatedGrade0 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const SubjectOffering0 = await SubjectOfferings.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (SubjectOffering0?.setGrade)
                {
                    await
                    SubjectOffering0.
                    setGrade(relatedGrade0);
                }
            
                const relatedGrade1 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const SubjectOffering1 = await SubjectOfferings.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (SubjectOffering1?.setGrade)
                {
                    await
                    SubjectOffering1.
                    setGrade(relatedGrade1);
                }
            
                const relatedGrade2 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const SubjectOffering2 = await SubjectOfferings.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (SubjectOffering2?.setGrade)
                {
                    await
                    SubjectOffering2.
                    setGrade(relatedGrade2);
                }
            
                const relatedGrade3 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const SubjectOffering3 = await SubjectOfferings.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (SubjectOffering3?.setGrade)
                {
                    await
                    SubjectOffering3.
                    setGrade(relatedGrade3);
                }
            
        }
        
    
        
            
            async function associateSubjectOfferingWithStream() {
            
                const relatedStream0 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const SubjectOffering0 = await SubjectOfferings.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (SubjectOffering0?.setStream)
                {
                    await
                    SubjectOffering0.
                    setStream(relatedStream0);
                }
            
                const relatedStream1 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const SubjectOffering1 = await SubjectOfferings.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (SubjectOffering1?.setStream)
                {
                    await
                    SubjectOffering1.
                    setStream(relatedStream1);
                }
            
                const relatedStream2 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const SubjectOffering2 = await SubjectOfferings.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (SubjectOffering2?.setStream)
                {
                    await
                    SubjectOffering2.
                    setStream(relatedStream2);
                }
            
                const relatedStream3 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const SubjectOffering3 = await SubjectOfferings.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (SubjectOffering3?.setStream)
                {
                    await
                    SubjectOffering3.
                    setStream(relatedStream3);
                }
            
        }
        
    
        
    
        
    
        
    
        
    
        
            
            async function associateSubjectOfferingWithResponsible_teacher() {
            
                const relatedResponsible_teacher0 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const SubjectOffering0 = await SubjectOfferings.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (SubjectOffering0?.setResponsible_teacher)
                {
                    await
                    SubjectOffering0.
                    setResponsible_teacher(relatedResponsible_teacher0);
                }
            
                const relatedResponsible_teacher1 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const SubjectOffering1 = await SubjectOfferings.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (SubjectOffering1?.setResponsible_teacher)
                {
                    await
                    SubjectOffering1.
                    setResponsible_teacher(relatedResponsible_teacher1);
                }
            
                const relatedResponsible_teacher2 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const SubjectOffering2 = await SubjectOfferings.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (SubjectOffering2?.setResponsible_teacher)
                {
                    await
                    SubjectOffering2.
                    setResponsible_teacher(relatedResponsible_teacher2);
                }
            
                const relatedResponsible_teacher3 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const SubjectOffering3 = await SubjectOfferings.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (SubjectOffering3?.setResponsible_teacher)
                {
                    await
                    SubjectOffering3.
                    setResponsible_teacher(relatedResponsible_teacher3);
                }
            
        }
        
    

    
    
    
        
            
            async function associateStaffMemberWithUser() {
            
                const relatedUser0 = await Users.findOne({
                    offset: Math.floor(Math.random() * (await Users.count())),
                });
                const StaffMember0 = await StaffMembers.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (StaffMember0?.setUser)
                {
                    await
                    StaffMember0.
                    setUser(relatedUser0);
                }
            
                const relatedUser1 = await Users.findOne({
                    offset: Math.floor(Math.random() * (await Users.count())),
                });
                const StaffMember1 = await StaffMembers.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (StaffMember1?.setUser)
                {
                    await
                    StaffMember1.
                    setUser(relatedUser1);
                }
            
                const relatedUser2 = await Users.findOne({
                    offset: Math.floor(Math.random() * (await Users.count())),
                });
                const StaffMember2 = await StaffMembers.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (StaffMember2?.setUser)
                {
                    await
                    StaffMember2.
                    setUser(relatedUser2);
                }
            
                const relatedUser3 = await Users.findOne({
                    offset: Math.floor(Math.random() * (await Users.count())),
                });
                const StaffMember3 = await StaffMembers.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (StaffMember3?.setUser)
                {
                    await
                    StaffMember3.
                    setUser(relatedUser3);
                }
            
        }
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
            // Similar logic for "relation_many"
        
    
        
    

    
    
    
        
            
            async function associateStudentWithUser() {
            
                const relatedUser0 = await Users.findOne({
                    offset: Math.floor(Math.random() * (await Users.count())),
                });
                const Student0 = await Students.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (Student0?.setUser)
                {
                    await
                    Student0.
                    setUser(relatedUser0);
                }
            
                const relatedUser1 = await Users.findOne({
                    offset: Math.floor(Math.random() * (await Users.count())),
                });
                const Student1 = await Students.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (Student1?.setUser)
                {
                    await
                    Student1.
                    setUser(relatedUser1);
                }
            
                const relatedUser2 = await Users.findOne({
                    offset: Math.floor(Math.random() * (await Users.count())),
                });
                const Student2 = await Students.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (Student2?.setUser)
                {
                    await
                    Student2.
                    setUser(relatedUser2);
                }
            
                const relatedUser3 = await Users.findOne({
                    offset: Math.floor(Math.random() * (await Users.count())),
                });
                const Student3 = await Students.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (Student3?.setUser)
                {
                    await
                    Student3.
                    setUser(relatedUser3);
                }
            
        }
        
    
        
    
        
    
        
    
        
    
        
            
            async function associateStudentWithCurrent_grade() {
            
                const relatedCurrent_grade0 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const Student0 = await Students.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (Student0?.setCurrent_grade)
                {
                    await
                    Student0.
                    setCurrent_grade(relatedCurrent_grade0);
                }
            
                const relatedCurrent_grade1 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const Student1 = await Students.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (Student1?.setCurrent_grade)
                {
                    await
                    Student1.
                    setCurrent_grade(relatedCurrent_grade1);
                }
            
                const relatedCurrent_grade2 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const Student2 = await Students.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (Student2?.setCurrent_grade)
                {
                    await
                    Student2.
                    setCurrent_grade(relatedCurrent_grade2);
                }
            
                const relatedCurrent_grade3 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const Student3 = await Students.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (Student3?.setCurrent_grade)
                {
                    await
                    Student3.
                    setCurrent_grade(relatedCurrent_grade3);
                }
            
        }
        
    
        
            
            async function associateStudentWithCurrent_stream() {
            
                const relatedCurrent_stream0 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const Student0 = await Students.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (Student0?.setCurrent_stream)
                {
                    await
                    Student0.
                    setCurrent_stream(relatedCurrent_stream0);
                }
            
                const relatedCurrent_stream1 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const Student1 = await Students.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (Student1?.setCurrent_stream)
                {
                    await
                    Student1.
                    setCurrent_stream(relatedCurrent_stream1);
                }
            
                const relatedCurrent_stream2 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const Student2 = await Students.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (Student2?.setCurrent_stream)
                {
                    await
                    Student2.
                    setCurrent_stream(relatedCurrent_stream2);
                }
            
                const relatedCurrent_stream3 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const Student3 = await Students.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (Student3?.setCurrent_stream)
                {
                    await
                    Student3.
                    setCurrent_stream(relatedCurrent_stream3);
                }
            
        }
        
    
        
    
        
    
        
    
        
    

    
    
    
        
    
        
            
            async function associateClassSectionWithSchool_year() {
            
                const relatedSchool_year0 = await SchoolYears.findOne({
                    offset: Math.floor(Math.random() * (await SchoolYears.count())),
                });
                const ClassSection0 = await ClassSections.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (ClassSection0?.setSchool_year)
                {
                    await
                    ClassSection0.
                    setSchool_year(relatedSchool_year0);
                }
            
                const relatedSchool_year1 = await SchoolYears.findOne({
                    offset: Math.floor(Math.random() * (await SchoolYears.count())),
                });
                const ClassSection1 = await ClassSections.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (ClassSection1?.setSchool_year)
                {
                    await
                    ClassSection1.
                    setSchool_year(relatedSchool_year1);
                }
            
                const relatedSchool_year2 = await SchoolYears.findOne({
                    offset: Math.floor(Math.random() * (await SchoolYears.count())),
                });
                const ClassSection2 = await ClassSections.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (ClassSection2?.setSchool_year)
                {
                    await
                    ClassSection2.
                    setSchool_year(relatedSchool_year2);
                }
            
                const relatedSchool_year3 = await SchoolYears.findOne({
                    offset: Math.floor(Math.random() * (await SchoolYears.count())),
                });
                const ClassSection3 = await ClassSections.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (ClassSection3?.setSchool_year)
                {
                    await
                    ClassSection3.
                    setSchool_year(relatedSchool_year3);
                }
            
        }
        
    
        
            
            async function associateClassSectionWithGrade() {
            
                const relatedGrade0 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const ClassSection0 = await ClassSections.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (ClassSection0?.setGrade)
                {
                    await
                    ClassSection0.
                    setGrade(relatedGrade0);
                }
            
                const relatedGrade1 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const ClassSection1 = await ClassSections.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (ClassSection1?.setGrade)
                {
                    await
                    ClassSection1.
                    setGrade(relatedGrade1);
                }
            
                const relatedGrade2 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const ClassSection2 = await ClassSections.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (ClassSection2?.setGrade)
                {
                    await
                    ClassSection2.
                    setGrade(relatedGrade2);
                }
            
                const relatedGrade3 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const ClassSection3 = await ClassSections.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (ClassSection3?.setGrade)
                {
                    await
                    ClassSection3.
                    setGrade(relatedGrade3);
                }
            
        }
        
    
        
            
            async function associateClassSectionWithStream() {
            
                const relatedStream0 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const ClassSection0 = await ClassSections.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (ClassSection0?.setStream)
                {
                    await
                    ClassSection0.
                    setStream(relatedStream0);
                }
            
                const relatedStream1 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const ClassSection1 = await ClassSections.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (ClassSection1?.setStream)
                {
                    await
                    ClassSection1.
                    setStream(relatedStream1);
                }
            
                const relatedStream2 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const ClassSection2 = await ClassSections.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (ClassSection2?.setStream)
                {
                    await
                    ClassSection2.
                    setStream(relatedStream2);
                }
            
                const relatedStream3 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const ClassSection3 = await ClassSections.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (ClassSection3?.setStream)
                {
                    await
                    ClassSection3.
                    setStream(relatedStream3);
                }
            
        }
        
    
        
            
            async function associateClassSectionWithHomeroom_teacher() {
            
                const relatedHomeroom_teacher0 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const ClassSection0 = await ClassSections.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (ClassSection0?.setHomeroom_teacher)
                {
                    await
                    ClassSection0.
                    setHomeroom_teacher(relatedHomeroom_teacher0);
                }
            
                const relatedHomeroom_teacher1 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const ClassSection1 = await ClassSections.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (ClassSection1?.setHomeroom_teacher)
                {
                    await
                    ClassSection1.
                    setHomeroom_teacher(relatedHomeroom_teacher1);
                }
            
                const relatedHomeroom_teacher2 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const ClassSection2 = await ClassSections.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (ClassSection2?.setHomeroom_teacher)
                {
                    await
                    ClassSection2.
                    setHomeroom_teacher(relatedHomeroom_teacher2);
                }
            
                const relatedHomeroom_teacher3 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const ClassSection3 = await ClassSections.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (ClassSection3?.setHomeroom_teacher)
                {
                    await
                    ClassSection3.
                    setHomeroom_teacher(relatedHomeroom_teacher3);
                }
            
        }
        
    
        
    

    
    
    
        
            
            async function associateEnrollmentWithStudent() {
            
                const relatedStudent0 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const Enrollment0 = await Enrollments.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (Enrollment0?.setStudent)
                {
                    await
                    Enrollment0.
                    setStudent(relatedStudent0);
                }
            
                const relatedStudent1 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const Enrollment1 = await Enrollments.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (Enrollment1?.setStudent)
                {
                    await
                    Enrollment1.
                    setStudent(relatedStudent1);
                }
            
                const relatedStudent2 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const Enrollment2 = await Enrollments.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (Enrollment2?.setStudent)
                {
                    await
                    Enrollment2.
                    setStudent(relatedStudent2);
                }
            
                const relatedStudent3 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const Enrollment3 = await Enrollments.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (Enrollment3?.setStudent)
                {
                    await
                    Enrollment3.
                    setStudent(relatedStudent3);
                }
            
        }
        
    
        
            
            async function associateEnrollmentWithClass_section() {
            
                const relatedClass_section0 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const Enrollment0 = await Enrollments.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (Enrollment0?.setClass_section)
                {
                    await
                    Enrollment0.
                    setClass_section(relatedClass_section0);
                }
            
                const relatedClass_section1 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const Enrollment1 = await Enrollments.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (Enrollment1?.setClass_section)
                {
                    await
                    Enrollment1.
                    setClass_section(relatedClass_section1);
                }
            
                const relatedClass_section2 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const Enrollment2 = await Enrollments.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (Enrollment2?.setClass_section)
                {
                    await
                    Enrollment2.
                    setClass_section(relatedClass_section2);
                }
            
                const relatedClass_section3 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const Enrollment3 = await Enrollments.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (Enrollment3?.setClass_section)
                {
                    await
                    Enrollment3.
                    setClass_section(relatedClass_section3);
                }
            
        }
        
    
        
    
        
    

    
    
    
        
            
            async function associateTermWithSchool_year() {
            
                const relatedSchool_year0 = await SchoolYears.findOne({
                    offset: Math.floor(Math.random() * (await SchoolYears.count())),
                });
                const Term0 = await Terms.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (Term0?.setSchool_year)
                {
                    await
                    Term0.
                    setSchool_year(relatedSchool_year0);
                }
            
                const relatedSchool_year1 = await SchoolYears.findOne({
                    offset: Math.floor(Math.random() * (await SchoolYears.count())),
                });
                const Term1 = await Terms.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (Term1?.setSchool_year)
                {
                    await
                    Term1.
                    setSchool_year(relatedSchool_year1);
                }
            
                const relatedSchool_year2 = await SchoolYears.findOne({
                    offset: Math.floor(Math.random() * (await SchoolYears.count())),
                });
                const Term2 = await Terms.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (Term2?.setSchool_year)
                {
                    await
                    Term2.
                    setSchool_year(relatedSchool_year2);
                }
            
                const relatedSchool_year3 = await SchoolYears.findOne({
                    offset: Math.floor(Math.random() * (await SchoolYears.count())),
                });
                const Term3 = await Terms.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (Term3?.setSchool_year)
                {
                    await
                    Term3.
                    setSchool_year(relatedSchool_year3);
                }
            
        }
        
    
        
    
        
    
        
    

    
    
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    

    
    
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    

    
    
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
            
            async function associateNewsPostWithAuthor() {
            
                const relatedAuthor0 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const NewsPost0 = await NewsPosts.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (NewsPost0?.setAuthor)
                {
                    await
                    NewsPost0.
                    setAuthor(relatedAuthor0);
                }
            
                const relatedAuthor1 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const NewsPost1 = await NewsPosts.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (NewsPost1?.setAuthor)
                {
                    await
                    NewsPost1.
                    setAuthor(relatedAuthor1);
                }
            
                const relatedAuthor2 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const NewsPost2 = await NewsPosts.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (NewsPost2?.setAuthor)
                {
                    await
                    NewsPost2.
                    setAuthor(relatedAuthor2);
                }
            
                const relatedAuthor3 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const NewsPost3 = await NewsPosts.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (NewsPost3?.setAuthor)
                {
                    await
                    NewsPost3.
                    setAuthor(relatedAuthor3);
                }
            
        }
        
    
        
    
        
    

    
    
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    

    
    
    
        
    
        
    
        
    
        
    
        
            
            async function associateStudyMaterialWithGrade() {
            
                const relatedGrade0 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const StudyMaterial0 = await StudyMaterials.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (StudyMaterial0?.setGrade)
                {
                    await
                    StudyMaterial0.
                    setGrade(relatedGrade0);
                }
            
                const relatedGrade1 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const StudyMaterial1 = await StudyMaterials.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (StudyMaterial1?.setGrade)
                {
                    await
                    StudyMaterial1.
                    setGrade(relatedGrade1);
                }
            
                const relatedGrade2 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const StudyMaterial2 = await StudyMaterials.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (StudyMaterial2?.setGrade)
                {
                    await
                    StudyMaterial2.
                    setGrade(relatedGrade2);
                }
            
                const relatedGrade3 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const StudyMaterial3 = await StudyMaterials.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (StudyMaterial3?.setGrade)
                {
                    await
                    StudyMaterial3.
                    setGrade(relatedGrade3);
                }
            
        }
        
    
        
            
            async function associateStudyMaterialWithSubject() {
            
                const relatedSubject0 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const StudyMaterial0 = await StudyMaterials.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (StudyMaterial0?.setSubject)
                {
                    await
                    StudyMaterial0.
                    setSubject(relatedSubject0);
                }
            
                const relatedSubject1 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const StudyMaterial1 = await StudyMaterials.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (StudyMaterial1?.setSubject)
                {
                    await
                    StudyMaterial1.
                    setSubject(relatedSubject1);
                }
            
                const relatedSubject2 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const StudyMaterial2 = await StudyMaterials.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (StudyMaterial2?.setSubject)
                {
                    await
                    StudyMaterial2.
                    setSubject(relatedSubject2);
                }
            
                const relatedSubject3 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const StudyMaterial3 = await StudyMaterials.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (StudyMaterial3?.setSubject)
                {
                    await
                    StudyMaterial3.
                    setSubject(relatedSubject3);
                }
            
        }
        
    
        
            
            async function associateStudyMaterialWithStream() {
            
                const relatedStream0 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const StudyMaterial0 = await StudyMaterials.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (StudyMaterial0?.setStream)
                {
                    await
                    StudyMaterial0.
                    setStream(relatedStream0);
                }
            
                const relatedStream1 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const StudyMaterial1 = await StudyMaterials.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (StudyMaterial1?.setStream)
                {
                    await
                    StudyMaterial1.
                    setStream(relatedStream1);
                }
            
                const relatedStream2 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const StudyMaterial2 = await StudyMaterials.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (StudyMaterial2?.setStream)
                {
                    await
                    StudyMaterial2.
                    setStream(relatedStream2);
                }
            
                const relatedStream3 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const StudyMaterial3 = await StudyMaterials.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (StudyMaterial3?.setStream)
                {
                    await
                    StudyMaterial3.
                    setStream(relatedStream3);
                }
            
        }
        
    
        
    
        
    
        
    
        
    
        
            
            async function associateStudyMaterialWithUploaded_by() {
            
                const relatedUploaded_by0 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const StudyMaterial0 = await StudyMaterials.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (StudyMaterial0?.setUploaded_by)
                {
                    await
                    StudyMaterial0.
                    setUploaded_by(relatedUploaded_by0);
                }
            
                const relatedUploaded_by1 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const StudyMaterial1 = await StudyMaterials.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (StudyMaterial1?.setUploaded_by)
                {
                    await
                    StudyMaterial1.
                    setUploaded_by(relatedUploaded_by1);
                }
            
                const relatedUploaded_by2 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const StudyMaterial2 = await StudyMaterials.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (StudyMaterial2?.setUploaded_by)
                {
                    await
                    StudyMaterial2.
                    setUploaded_by(relatedUploaded_by2);
                }
            
                const relatedUploaded_by3 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const StudyMaterial3 = await StudyMaterials.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (StudyMaterial3?.setUploaded_by)
                {
                    await
                    StudyMaterial3.
                    setUploaded_by(relatedUploaded_by3);
                }
            
        }
        
    
        
    

    
    
    
        
    
        
    
        
            
            async function associateExamWithSchool_year() {
            
                const relatedSchool_year0 = await SchoolYears.findOne({
                    offset: Math.floor(Math.random() * (await SchoolYears.count())),
                });
                const Exam0 = await Exams.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (Exam0?.setSchool_year)
                {
                    await
                    Exam0.
                    setSchool_year(relatedSchool_year0);
                }
            
                const relatedSchool_year1 = await SchoolYears.findOne({
                    offset: Math.floor(Math.random() * (await SchoolYears.count())),
                });
                const Exam1 = await Exams.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (Exam1?.setSchool_year)
                {
                    await
                    Exam1.
                    setSchool_year(relatedSchool_year1);
                }
            
                const relatedSchool_year2 = await SchoolYears.findOne({
                    offset: Math.floor(Math.random() * (await SchoolYears.count())),
                });
                const Exam2 = await Exams.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (Exam2?.setSchool_year)
                {
                    await
                    Exam2.
                    setSchool_year(relatedSchool_year2);
                }
            
                const relatedSchool_year3 = await SchoolYears.findOne({
                    offset: Math.floor(Math.random() * (await SchoolYears.count())),
                });
                const Exam3 = await Exams.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (Exam3?.setSchool_year)
                {
                    await
                    Exam3.
                    setSchool_year(relatedSchool_year3);
                }
            
        }
        
    
        
            
            async function associateExamWithTerm() {
            
                const relatedTerm0 = await Terms.findOne({
                    offset: Math.floor(Math.random() * (await Terms.count())),
                });
                const Exam0 = await Exams.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (Exam0?.setTerm)
                {
                    await
                    Exam0.
                    setTerm(relatedTerm0);
                }
            
                const relatedTerm1 = await Terms.findOne({
                    offset: Math.floor(Math.random() * (await Terms.count())),
                });
                const Exam1 = await Exams.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (Exam1?.setTerm)
                {
                    await
                    Exam1.
                    setTerm(relatedTerm1);
                }
            
                const relatedTerm2 = await Terms.findOne({
                    offset: Math.floor(Math.random() * (await Terms.count())),
                });
                const Exam2 = await Exams.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (Exam2?.setTerm)
                {
                    await
                    Exam2.
                    setTerm(relatedTerm2);
                }
            
                const relatedTerm3 = await Terms.findOne({
                    offset: Math.floor(Math.random() * (await Terms.count())),
                });
                const Exam3 = await Exams.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (Exam3?.setTerm)
                {
                    await
                    Exam3.
                    setTerm(relatedTerm3);
                }
            
        }
        
    
        
            
            async function associateExamWithGrade() {
            
                const relatedGrade0 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const Exam0 = await Exams.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (Exam0?.setGrade)
                {
                    await
                    Exam0.
                    setGrade(relatedGrade0);
                }
            
                const relatedGrade1 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const Exam1 = await Exams.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (Exam1?.setGrade)
                {
                    await
                    Exam1.
                    setGrade(relatedGrade1);
                }
            
                const relatedGrade2 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const Exam2 = await Exams.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (Exam2?.setGrade)
                {
                    await
                    Exam2.
                    setGrade(relatedGrade2);
                }
            
                const relatedGrade3 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const Exam3 = await Exams.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (Exam3?.setGrade)
                {
                    await
                    Exam3.
                    setGrade(relatedGrade3);
                }
            
        }
        
    
        
            
            async function associateExamWithStream() {
            
                const relatedStream0 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const Exam0 = await Exams.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (Exam0?.setStream)
                {
                    await
                    Exam0.
                    setStream(relatedStream0);
                }
            
                const relatedStream1 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const Exam1 = await Exams.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (Exam1?.setStream)
                {
                    await
                    Exam1.
                    setStream(relatedStream1);
                }
            
                const relatedStream2 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const Exam2 = await Exams.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (Exam2?.setStream)
                {
                    await
                    Exam2.
                    setStream(relatedStream2);
                }
            
                const relatedStream3 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const Exam3 = await Exams.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (Exam3?.setStream)
                {
                    await
                    Exam3.
                    setStream(relatedStream3);
                }
            
        }
        
    
        
    
        
    
        
    

    
    
    
        
            
            async function associateExamResultWithExam() {
            
                const relatedExam0 = await Exams.findOne({
                    offset: Math.floor(Math.random() * (await Exams.count())),
                });
                const ExamResult0 = await ExamResults.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (ExamResult0?.setExam)
                {
                    await
                    ExamResult0.
                    setExam(relatedExam0);
                }
            
                const relatedExam1 = await Exams.findOne({
                    offset: Math.floor(Math.random() * (await Exams.count())),
                });
                const ExamResult1 = await ExamResults.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (ExamResult1?.setExam)
                {
                    await
                    ExamResult1.
                    setExam(relatedExam1);
                }
            
                const relatedExam2 = await Exams.findOne({
                    offset: Math.floor(Math.random() * (await Exams.count())),
                });
                const ExamResult2 = await ExamResults.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (ExamResult2?.setExam)
                {
                    await
                    ExamResult2.
                    setExam(relatedExam2);
                }
            
                const relatedExam3 = await Exams.findOne({
                    offset: Math.floor(Math.random() * (await Exams.count())),
                });
                const ExamResult3 = await ExamResults.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (ExamResult3?.setExam)
                {
                    await
                    ExamResult3.
                    setExam(relatedExam3);
                }
            
        }
        
    
        
            
            async function associateExamResultWithStudent() {
            
                const relatedStudent0 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const ExamResult0 = await ExamResults.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (ExamResult0?.setStudent)
                {
                    await
                    ExamResult0.
                    setStudent(relatedStudent0);
                }
            
                const relatedStudent1 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const ExamResult1 = await ExamResults.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (ExamResult1?.setStudent)
                {
                    await
                    ExamResult1.
                    setStudent(relatedStudent1);
                }
            
                const relatedStudent2 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const ExamResult2 = await ExamResults.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (ExamResult2?.setStudent)
                {
                    await
                    ExamResult2.
                    setStudent(relatedStudent2);
                }
            
                const relatedStudent3 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const ExamResult3 = await ExamResults.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (ExamResult3?.setStudent)
                {
                    await
                    ExamResult3.
                    setStudent(relatedStudent3);
                }
            
        }
        
    
        
            
            async function associateExamResultWithSubject() {
            
                const relatedSubject0 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const ExamResult0 = await ExamResults.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (ExamResult0?.setSubject)
                {
                    await
                    ExamResult0.
                    setSubject(relatedSubject0);
                }
            
                const relatedSubject1 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const ExamResult1 = await ExamResults.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (ExamResult1?.setSubject)
                {
                    await
                    ExamResult1.
                    setSubject(relatedSubject1);
                }
            
                const relatedSubject2 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const ExamResult2 = await ExamResults.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (ExamResult2?.setSubject)
                {
                    await
                    ExamResult2.
                    setSubject(relatedSubject2);
                }
            
                const relatedSubject3 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const ExamResult3 = await ExamResults.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (ExamResult3?.setSubject)
                {
                    await
                    ExamResult3.
                    setSubject(relatedSubject3);
                }
            
        }
        
    
        
    
        
    
        
    
        
            
            async function associateExamResultWithEntered_by() {
            
                const relatedEntered_by0 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const ExamResult0 = await ExamResults.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (ExamResult0?.setEntered_by)
                {
                    await
                    ExamResult0.
                    setEntered_by(relatedEntered_by0);
                }
            
                const relatedEntered_by1 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const ExamResult1 = await ExamResults.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (ExamResult1?.setEntered_by)
                {
                    await
                    ExamResult1.
                    setEntered_by(relatedEntered_by1);
                }
            
                const relatedEntered_by2 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const ExamResult2 = await ExamResults.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (ExamResult2?.setEntered_by)
                {
                    await
                    ExamResult2.
                    setEntered_by(relatedEntered_by2);
                }
            
                const relatedEntered_by3 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const ExamResult3 = await ExamResults.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (ExamResult3?.setEntered_by)
                {
                    await
                    ExamResult3.
                    setEntered_by(relatedEntered_by3);
                }
            
        }
        
    
        
    

    
    
    
        
            
            async function associateAttendanceSessionWithClass_section() {
            
                const relatedClass_section0 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const AttendanceSession0 = await AttendanceSessions.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (AttendanceSession0?.setClass_section)
                {
                    await
                    AttendanceSession0.
                    setClass_section(relatedClass_section0);
                }
            
                const relatedClass_section1 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const AttendanceSession1 = await AttendanceSessions.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (AttendanceSession1?.setClass_section)
                {
                    await
                    AttendanceSession1.
                    setClass_section(relatedClass_section1);
                }
            
                const relatedClass_section2 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const AttendanceSession2 = await AttendanceSessions.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (AttendanceSession2?.setClass_section)
                {
                    await
                    AttendanceSession2.
                    setClass_section(relatedClass_section2);
                }
            
                const relatedClass_section3 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const AttendanceSession3 = await AttendanceSessions.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (AttendanceSession3?.setClass_section)
                {
                    await
                    AttendanceSession3.
                    setClass_section(relatedClass_section3);
                }
            
        }
        
    
        
            
            async function associateAttendanceSessionWithSubject() {
            
                const relatedSubject0 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const AttendanceSession0 = await AttendanceSessions.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (AttendanceSession0?.setSubject)
                {
                    await
                    AttendanceSession0.
                    setSubject(relatedSubject0);
                }
            
                const relatedSubject1 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const AttendanceSession1 = await AttendanceSessions.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (AttendanceSession1?.setSubject)
                {
                    await
                    AttendanceSession1.
                    setSubject(relatedSubject1);
                }
            
                const relatedSubject2 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const AttendanceSession2 = await AttendanceSessions.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (AttendanceSession2?.setSubject)
                {
                    await
                    AttendanceSession2.
                    setSubject(relatedSubject2);
                }
            
                const relatedSubject3 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const AttendanceSession3 = await AttendanceSessions.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (AttendanceSession3?.setSubject)
                {
                    await
                    AttendanceSession3.
                    setSubject(relatedSubject3);
                }
            
        }
        
    
        
            
            async function associateAttendanceSessionWithTeacher() {
            
                const relatedTeacher0 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const AttendanceSession0 = await AttendanceSessions.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (AttendanceSession0?.setTeacher)
                {
                    await
                    AttendanceSession0.
                    setTeacher(relatedTeacher0);
                }
            
                const relatedTeacher1 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const AttendanceSession1 = await AttendanceSessions.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (AttendanceSession1?.setTeacher)
                {
                    await
                    AttendanceSession1.
                    setTeacher(relatedTeacher1);
                }
            
                const relatedTeacher2 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const AttendanceSession2 = await AttendanceSessions.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (AttendanceSession2?.setTeacher)
                {
                    await
                    AttendanceSession2.
                    setTeacher(relatedTeacher2);
                }
            
                const relatedTeacher3 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const AttendanceSession3 = await AttendanceSessions.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (AttendanceSession3?.setTeacher)
                {
                    await
                    AttendanceSession3.
                    setTeacher(relatedTeacher3);
                }
            
        }
        
    
        
    
        
    
        
    

    
    
    
        
            
            async function associateAttendanceRecordWithAttendance_session() {
            
                const relatedAttendance_session0 = await AttendanceSessions.findOne({
                    offset: Math.floor(Math.random() * (await AttendanceSessions.count())),
                });
                const AttendanceRecord0 = await AttendanceRecords.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (AttendanceRecord0?.setAttendance_session)
                {
                    await
                    AttendanceRecord0.
                    setAttendance_session(relatedAttendance_session0);
                }
            
                const relatedAttendance_session1 = await AttendanceSessions.findOne({
                    offset: Math.floor(Math.random() * (await AttendanceSessions.count())),
                });
                const AttendanceRecord1 = await AttendanceRecords.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (AttendanceRecord1?.setAttendance_session)
                {
                    await
                    AttendanceRecord1.
                    setAttendance_session(relatedAttendance_session1);
                }
            
                const relatedAttendance_session2 = await AttendanceSessions.findOne({
                    offset: Math.floor(Math.random() * (await AttendanceSessions.count())),
                });
                const AttendanceRecord2 = await AttendanceRecords.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (AttendanceRecord2?.setAttendance_session)
                {
                    await
                    AttendanceRecord2.
                    setAttendance_session(relatedAttendance_session2);
                }
            
                const relatedAttendance_session3 = await AttendanceSessions.findOne({
                    offset: Math.floor(Math.random() * (await AttendanceSessions.count())),
                });
                const AttendanceRecord3 = await AttendanceRecords.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (AttendanceRecord3?.setAttendance_session)
                {
                    await
                    AttendanceRecord3.
                    setAttendance_session(relatedAttendance_session3);
                }
            
        }
        
    
        
            
            async function associateAttendanceRecordWithStudent() {
            
                const relatedStudent0 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const AttendanceRecord0 = await AttendanceRecords.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (AttendanceRecord0?.setStudent)
                {
                    await
                    AttendanceRecord0.
                    setStudent(relatedStudent0);
                }
            
                const relatedStudent1 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const AttendanceRecord1 = await AttendanceRecords.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (AttendanceRecord1?.setStudent)
                {
                    await
                    AttendanceRecord1.
                    setStudent(relatedStudent1);
                }
            
                const relatedStudent2 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const AttendanceRecord2 = await AttendanceRecords.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (AttendanceRecord2?.setStudent)
                {
                    await
                    AttendanceRecord2.
                    setStudent(relatedStudent2);
                }
            
                const relatedStudent3 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const AttendanceRecord3 = await AttendanceRecords.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (AttendanceRecord3?.setStudent)
                {
                    await
                    AttendanceRecord3.
                    setStudent(relatedStudent3);
                }
            
        }
        
    
        
    
        
    

    
    
    
        
            
            async function associateClassScheduleWithClass_section() {
            
                const relatedClass_section0 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const ClassSchedule0 = await ClassSchedules.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (ClassSchedule0?.setClass_section)
                {
                    await
                    ClassSchedule0.
                    setClass_section(relatedClass_section0);
                }
            
                const relatedClass_section1 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const ClassSchedule1 = await ClassSchedules.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (ClassSchedule1?.setClass_section)
                {
                    await
                    ClassSchedule1.
                    setClass_section(relatedClass_section1);
                }
            
                const relatedClass_section2 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const ClassSchedule2 = await ClassSchedules.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (ClassSchedule2?.setClass_section)
                {
                    await
                    ClassSchedule2.
                    setClass_section(relatedClass_section2);
                }
            
                const relatedClass_section3 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const ClassSchedule3 = await ClassSchedules.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (ClassSchedule3?.setClass_section)
                {
                    await
                    ClassSchedule3.
                    setClass_section(relatedClass_section3);
                }
            
        }
        
    
        
            
            async function associateClassScheduleWithSubject() {
            
                const relatedSubject0 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const ClassSchedule0 = await ClassSchedules.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (ClassSchedule0?.setSubject)
                {
                    await
                    ClassSchedule0.
                    setSubject(relatedSubject0);
                }
            
                const relatedSubject1 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const ClassSchedule1 = await ClassSchedules.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (ClassSchedule1?.setSubject)
                {
                    await
                    ClassSchedule1.
                    setSubject(relatedSubject1);
                }
            
                const relatedSubject2 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const ClassSchedule2 = await ClassSchedules.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (ClassSchedule2?.setSubject)
                {
                    await
                    ClassSchedule2.
                    setSubject(relatedSubject2);
                }
            
                const relatedSubject3 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const ClassSchedule3 = await ClassSchedules.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (ClassSchedule3?.setSubject)
                {
                    await
                    ClassSchedule3.
                    setSubject(relatedSubject3);
                }
            
        }
        
    
        
            
            async function associateClassScheduleWithTeacher() {
            
                const relatedTeacher0 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const ClassSchedule0 = await ClassSchedules.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (ClassSchedule0?.setTeacher)
                {
                    await
                    ClassSchedule0.
                    setTeacher(relatedTeacher0);
                }
            
                const relatedTeacher1 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const ClassSchedule1 = await ClassSchedules.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (ClassSchedule1?.setTeacher)
                {
                    await
                    ClassSchedule1.
                    setTeacher(relatedTeacher1);
                }
            
                const relatedTeacher2 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const ClassSchedule2 = await ClassSchedules.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (ClassSchedule2?.setTeacher)
                {
                    await
                    ClassSchedule2.
                    setTeacher(relatedTeacher2);
                }
            
                const relatedTeacher3 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const ClassSchedule3 = await ClassSchedules.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (ClassSchedule3?.setTeacher)
                {
                    await
                    ClassSchedule3.
                    setTeacher(relatedTeacher3);
                }
            
        }
        
    
        
    
        
    
        
    
        
    
        
    

    
    
    
        
            
            async function associateAssignmentWithClass_section() {
            
                const relatedClass_section0 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const Assignment0 = await Assignments.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (Assignment0?.setClass_section)
                {
                    await
                    Assignment0.
                    setClass_section(relatedClass_section0);
                }
            
                const relatedClass_section1 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const Assignment1 = await Assignments.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (Assignment1?.setClass_section)
                {
                    await
                    Assignment1.
                    setClass_section(relatedClass_section1);
                }
            
                const relatedClass_section2 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const Assignment2 = await Assignments.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (Assignment2?.setClass_section)
                {
                    await
                    Assignment2.
                    setClass_section(relatedClass_section2);
                }
            
                const relatedClass_section3 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const Assignment3 = await Assignments.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (Assignment3?.setClass_section)
                {
                    await
                    Assignment3.
                    setClass_section(relatedClass_section3);
                }
            
        }
        
    
        
            
            async function associateAssignmentWithSubject() {
            
                const relatedSubject0 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const Assignment0 = await Assignments.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (Assignment0?.setSubject)
                {
                    await
                    Assignment0.
                    setSubject(relatedSubject0);
                }
            
                const relatedSubject1 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const Assignment1 = await Assignments.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (Assignment1?.setSubject)
                {
                    await
                    Assignment1.
                    setSubject(relatedSubject1);
                }
            
                const relatedSubject2 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const Assignment2 = await Assignments.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (Assignment2?.setSubject)
                {
                    await
                    Assignment2.
                    setSubject(relatedSubject2);
                }
            
                const relatedSubject3 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const Assignment3 = await Assignments.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (Assignment3?.setSubject)
                {
                    await
                    Assignment3.
                    setSubject(relatedSubject3);
                }
            
        }
        
    
        
            
            async function associateAssignmentWithTeacher() {
            
                const relatedTeacher0 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const Assignment0 = await Assignments.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (Assignment0?.setTeacher)
                {
                    await
                    Assignment0.
                    setTeacher(relatedTeacher0);
                }
            
                const relatedTeacher1 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const Assignment1 = await Assignments.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (Assignment1?.setTeacher)
                {
                    await
                    Assignment1.
                    setTeacher(relatedTeacher1);
                }
            
                const relatedTeacher2 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const Assignment2 = await Assignments.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (Assignment2?.setTeacher)
                {
                    await
                    Assignment2.
                    setTeacher(relatedTeacher2);
                }
            
                const relatedTeacher3 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const Assignment3 = await Assignments.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (Assignment3?.setTeacher)
                {
                    await
                    Assignment3.
                    setTeacher(relatedTeacher3);
                }
            
        }
        
    
        
    
        
    
        
    
        
    
        
    
        
    

    
    
    
        
            
            async function associateAssignmentSubmissionWithAssignment() {
            
                const relatedAssignment0 = await Assignments.findOne({
                    offset: Math.floor(Math.random() * (await Assignments.count())),
                });
                const AssignmentSubmission0 = await AssignmentSubmissions.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (AssignmentSubmission0?.setAssignment)
                {
                    await
                    AssignmentSubmission0.
                    setAssignment(relatedAssignment0);
                }
            
                const relatedAssignment1 = await Assignments.findOne({
                    offset: Math.floor(Math.random() * (await Assignments.count())),
                });
                const AssignmentSubmission1 = await AssignmentSubmissions.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (AssignmentSubmission1?.setAssignment)
                {
                    await
                    AssignmentSubmission1.
                    setAssignment(relatedAssignment1);
                }
            
                const relatedAssignment2 = await Assignments.findOne({
                    offset: Math.floor(Math.random() * (await Assignments.count())),
                });
                const AssignmentSubmission2 = await AssignmentSubmissions.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (AssignmentSubmission2?.setAssignment)
                {
                    await
                    AssignmentSubmission2.
                    setAssignment(relatedAssignment2);
                }
            
                const relatedAssignment3 = await Assignments.findOne({
                    offset: Math.floor(Math.random() * (await Assignments.count())),
                });
                const AssignmentSubmission3 = await AssignmentSubmissions.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (AssignmentSubmission3?.setAssignment)
                {
                    await
                    AssignmentSubmission3.
                    setAssignment(relatedAssignment3);
                }
            
        }
        
    
        
            
            async function associateAssignmentSubmissionWithStudent() {
            
                const relatedStudent0 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const AssignmentSubmission0 = await AssignmentSubmissions.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (AssignmentSubmission0?.setStudent)
                {
                    await
                    AssignmentSubmission0.
                    setStudent(relatedStudent0);
                }
            
                const relatedStudent1 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const AssignmentSubmission1 = await AssignmentSubmissions.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (AssignmentSubmission1?.setStudent)
                {
                    await
                    AssignmentSubmission1.
                    setStudent(relatedStudent1);
                }
            
                const relatedStudent2 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const AssignmentSubmission2 = await AssignmentSubmissions.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (AssignmentSubmission2?.setStudent)
                {
                    await
                    AssignmentSubmission2.
                    setStudent(relatedStudent2);
                }
            
                const relatedStudent3 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const AssignmentSubmission3 = await AssignmentSubmissions.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (AssignmentSubmission3?.setStudent)
                {
                    await
                    AssignmentSubmission3.
                    setStudent(relatedStudent3);
                }
            
        }
        
    
        
    
        
    
        
    
        
    
        
    
        
    

    
    
    
        
            
            async function associateLessonPlanWithTeacher() {
            
                const relatedTeacher0 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const LessonPlan0 = await LessonPlans.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (LessonPlan0?.setTeacher)
                {
                    await
                    LessonPlan0.
                    setTeacher(relatedTeacher0);
                }
            
                const relatedTeacher1 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const LessonPlan1 = await LessonPlans.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (LessonPlan1?.setTeacher)
                {
                    await
                    LessonPlan1.
                    setTeacher(relatedTeacher1);
                }
            
                const relatedTeacher2 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const LessonPlan2 = await LessonPlans.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (LessonPlan2?.setTeacher)
                {
                    await
                    LessonPlan2.
                    setTeacher(relatedTeacher2);
                }
            
                const relatedTeacher3 = await StaffMembers.findOne({
                    offset: Math.floor(Math.random() * (await StaffMembers.count())),
                });
                const LessonPlan3 = await LessonPlans.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (LessonPlan3?.setTeacher)
                {
                    await
                    LessonPlan3.
                    setTeacher(relatedTeacher3);
                }
            
        }
        
    
        
            
            async function associateLessonPlanWithClass_section() {
            
                const relatedClass_section0 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const LessonPlan0 = await LessonPlans.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (LessonPlan0?.setClass_section)
                {
                    await
                    LessonPlan0.
                    setClass_section(relatedClass_section0);
                }
            
                const relatedClass_section1 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const LessonPlan1 = await LessonPlans.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (LessonPlan1?.setClass_section)
                {
                    await
                    LessonPlan1.
                    setClass_section(relatedClass_section1);
                }
            
                const relatedClass_section2 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const LessonPlan2 = await LessonPlans.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (LessonPlan2?.setClass_section)
                {
                    await
                    LessonPlan2.
                    setClass_section(relatedClass_section2);
                }
            
                const relatedClass_section3 = await ClassSections.findOne({
                    offset: Math.floor(Math.random() * (await ClassSections.count())),
                });
                const LessonPlan3 = await LessonPlans.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (LessonPlan3?.setClass_section)
                {
                    await
                    LessonPlan3.
                    setClass_section(relatedClass_section3);
                }
            
        }
        
    
        
            
            async function associateLessonPlanWithSubject() {
            
                const relatedSubject0 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const LessonPlan0 = await LessonPlans.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (LessonPlan0?.setSubject)
                {
                    await
                    LessonPlan0.
                    setSubject(relatedSubject0);
                }
            
                const relatedSubject1 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const LessonPlan1 = await LessonPlans.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (LessonPlan1?.setSubject)
                {
                    await
                    LessonPlan1.
                    setSubject(relatedSubject1);
                }
            
                const relatedSubject2 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const LessonPlan2 = await LessonPlans.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (LessonPlan2?.setSubject)
                {
                    await
                    LessonPlan2.
                    setSubject(relatedSubject2);
                }
            
                const relatedSubject3 = await Subjects.findOne({
                    offset: Math.floor(Math.random() * (await Subjects.count())),
                });
                const LessonPlan3 = await LessonPlans.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (LessonPlan3?.setSubject)
                {
                    await
                    LessonPlan3.
                    setSubject(relatedSubject3);
                }
            
        }
        
    
        
    
        
    
        
    
        
    
        
    

    
    
    
        
            
            async function associateMessageWithSender() {
            
                const relatedSender0 = await Users.findOne({
                    offset: Math.floor(Math.random() * (await Users.count())),
                });
                const Message0 = await Messages.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (Message0?.setSender)
                {
                    await
                    Message0.
                    setSender(relatedSender0);
                }
            
                const relatedSender1 = await Users.findOne({
                    offset: Math.floor(Math.random() * (await Users.count())),
                });
                const Message1 = await Messages.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (Message1?.setSender)
                {
                    await
                    Message1.
                    setSender(relatedSender1);
                }
            
                const relatedSender2 = await Users.findOne({
                    offset: Math.floor(Math.random() * (await Users.count())),
                });
                const Message2 = await Messages.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (Message2?.setSender)
                {
                    await
                    Message2.
                    setSender(relatedSender2);
                }
            
                const relatedSender3 = await Users.findOne({
                    offset: Math.floor(Math.random() * (await Users.count())),
                });
                const Message3 = await Messages.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (Message3?.setSender)
                {
                    await
                    Message3.
                    setSender(relatedSender3);
                }
            
        }
        
    
        
            
            async function associateMessageWithRecipient() {
            
                const relatedRecipient0 = await Users.findOne({
                    offset: Math.floor(Math.random() * (await Users.count())),
                });
                const Message0 = await Messages.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (Message0?.setRecipient)
                {
                    await
                    Message0.
                    setRecipient(relatedRecipient0);
                }
            
                const relatedRecipient1 = await Users.findOne({
                    offset: Math.floor(Math.random() * (await Users.count())),
                });
                const Message1 = await Messages.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (Message1?.setRecipient)
                {
                    await
                    Message1.
                    setRecipient(relatedRecipient1);
                }
            
                const relatedRecipient2 = await Users.findOne({
                    offset: Math.floor(Math.random() * (await Users.count())),
                });
                const Message2 = await Messages.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (Message2?.setRecipient)
                {
                    await
                    Message2.
                    setRecipient(relatedRecipient2);
                }
            
                const relatedRecipient3 = await Users.findOne({
                    offset: Math.floor(Math.random() * (await Users.count())),
                });
                const Message3 = await Messages.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (Message3?.setRecipient)
                {
                    await
                    Message3.
                    setRecipient(relatedRecipient3);
                }
            
        }
        
    
        
    
        
    
        
    
        
    
        
    

    
    
    
        
    
        
    
        
    
        
    
        
    
        
            
            async function associateAdmissionApplicationWithRequested_grade() {
            
                const relatedRequested_grade0 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const AdmissionApplication0 = await AdmissionApplications.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (AdmissionApplication0?.setRequested_grade)
                {
                    await
                    AdmissionApplication0.
                    setRequested_grade(relatedRequested_grade0);
                }
            
                const relatedRequested_grade1 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const AdmissionApplication1 = await AdmissionApplications.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (AdmissionApplication1?.setRequested_grade)
                {
                    await
                    AdmissionApplication1.
                    setRequested_grade(relatedRequested_grade1);
                }
            
                const relatedRequested_grade2 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const AdmissionApplication2 = await AdmissionApplications.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (AdmissionApplication2?.setRequested_grade)
                {
                    await
                    AdmissionApplication2.
                    setRequested_grade(relatedRequested_grade2);
                }
            
                const relatedRequested_grade3 = await Grades.findOne({
                    offset: Math.floor(Math.random() * (await Grades.count())),
                });
                const AdmissionApplication3 = await AdmissionApplications.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (AdmissionApplication3?.setRequested_grade)
                {
                    await
                    AdmissionApplication3.
                    setRequested_grade(relatedRequested_grade3);
                }
            
        }
        
    
        
            
            async function associateAdmissionApplicationWithRequested_stream() {
            
                const relatedRequested_stream0 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const AdmissionApplication0 = await AdmissionApplications.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (AdmissionApplication0?.setRequested_stream)
                {
                    await
                    AdmissionApplication0.
                    setRequested_stream(relatedRequested_stream0);
                }
            
                const relatedRequested_stream1 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const AdmissionApplication1 = await AdmissionApplications.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (AdmissionApplication1?.setRequested_stream)
                {
                    await
                    AdmissionApplication1.
                    setRequested_stream(relatedRequested_stream1);
                }
            
                const relatedRequested_stream2 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const AdmissionApplication2 = await AdmissionApplications.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (AdmissionApplication2?.setRequested_stream)
                {
                    await
                    AdmissionApplication2.
                    setRequested_stream(relatedRequested_stream2);
                }
            
                const relatedRequested_stream3 = await Streams.findOne({
                    offset: Math.floor(Math.random() * (await Streams.count())),
                });
                const AdmissionApplication3 = await AdmissionApplications.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (AdmissionApplication3?.setRequested_stream)
                {
                    await
                    AdmissionApplication3.
                    setRequested_stream(relatedRequested_stream3);
                }
            
        }
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    

    
    
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    

    
    
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    
        
    

    
    
    
        
            
            async function associateSchoolStatisticWithSchool_year() {
            
                const relatedSchool_year0 = await SchoolYears.findOne({
                    offset: Math.floor(Math.random() * (await SchoolYears.count())),
                });
                const SchoolStatistic0 = await SchoolStatistics.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (SchoolStatistic0?.setSchool_year)
                {
                    await
                    SchoolStatistic0.
                    setSchool_year(relatedSchool_year0);
                }
            
                const relatedSchool_year1 = await SchoolYears.findOne({
                    offset: Math.floor(Math.random() * (await SchoolYears.count())),
                });
                const SchoolStatistic1 = await SchoolStatistics.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (SchoolStatistic1?.setSchool_year)
                {
                    await
                    SchoolStatistic1.
                    setSchool_year(relatedSchool_year1);
                }
            
                const relatedSchool_year2 = await SchoolYears.findOne({
                    offset: Math.floor(Math.random() * (await SchoolYears.count())),
                });
                const SchoolStatistic2 = await SchoolStatistics.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (SchoolStatistic2?.setSchool_year)
                {
                    await
                    SchoolStatistic2.
                    setSchool_year(relatedSchool_year2);
                }
            
                const relatedSchool_year3 = await SchoolYears.findOne({
                    offset: Math.floor(Math.random() * (await SchoolYears.count())),
                });
                const SchoolStatistic3 = await SchoolStatistics.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (SchoolStatistic3?.setSchool_year)
                {
                    await
                    SchoolStatistic3.
                    setSchool_year(relatedSchool_year3);
                }
            
        }
        
    
        
    
        
    
        
    
        
    

    
    
    
        
            
            async function associateExamPerformanceSummaryWithExam() {
            
                const relatedExam0 = await Exams.findOne({
                    offset: Math.floor(Math.random() * (await Exams.count())),
                });
                const ExamPerformanceSummary0 = await ExamPerformanceSummaries.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (ExamPerformanceSummary0?.setExam)
                {
                    await
                    ExamPerformanceSummary0.
                    setExam(relatedExam0);
                }
            
                const relatedExam1 = await Exams.findOne({
                    offset: Math.floor(Math.random() * (await Exams.count())),
                });
                const ExamPerformanceSummary1 = await ExamPerformanceSummaries.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (ExamPerformanceSummary1?.setExam)
                {
                    await
                    ExamPerformanceSummary1.
                    setExam(relatedExam1);
                }
            
                const relatedExam2 = await Exams.findOne({
                    offset: Math.floor(Math.random() * (await Exams.count())),
                });
                const ExamPerformanceSummary2 = await ExamPerformanceSummaries.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (ExamPerformanceSummary2?.setExam)
                {
                    await
                    ExamPerformanceSummary2.
                    setExam(relatedExam2);
                }
            
                const relatedExam3 = await Exams.findOne({
                    offset: Math.floor(Math.random() * (await Exams.count())),
                });
                const ExamPerformanceSummary3 = await ExamPerformanceSummaries.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (ExamPerformanceSummary3?.setExam)
                {
                    await
                    ExamPerformanceSummary3.
                    setExam(relatedExam3);
                }
            
        }
        
    
        
    
        
    
        
    
        
    
        
    
        
    

    
    
    
        
            
            async function associateTopStudentFeatureWithExam() {
            
                const relatedExam0 = await Exams.findOne({
                    offset: Math.floor(Math.random() * (await Exams.count())),
                });
                const TopStudentFeature0 = await TopStudentFeatures.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (TopStudentFeature0?.setExam)
                {
                    await
                    TopStudentFeature0.
                    setExam(relatedExam0);
                }
            
                const relatedExam1 = await Exams.findOne({
                    offset: Math.floor(Math.random() * (await Exams.count())),
                });
                const TopStudentFeature1 = await TopStudentFeatures.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (TopStudentFeature1?.setExam)
                {
                    await
                    TopStudentFeature1.
                    setExam(relatedExam1);
                }
            
                const relatedExam2 = await Exams.findOne({
                    offset: Math.floor(Math.random() * (await Exams.count())),
                });
                const TopStudentFeature2 = await TopStudentFeatures.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (TopStudentFeature2?.setExam)
                {
                    await
                    TopStudentFeature2.
                    setExam(relatedExam2);
                }
            
                const relatedExam3 = await Exams.findOne({
                    offset: Math.floor(Math.random() * (await Exams.count())),
                });
                const TopStudentFeature3 = await TopStudentFeatures.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (TopStudentFeature3?.setExam)
                {
                    await
                    TopStudentFeature3.
                    setExam(relatedExam3);
                }
            
        }
        
    
        
            
            async function associateTopStudentFeatureWithStudent() {
            
                const relatedStudent0 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const TopStudentFeature0 = await TopStudentFeatures.findOne({
                    order: [['id', 'ASC']],
                    offset: 0
                });
                if (TopStudentFeature0?.setStudent)
                {
                    await
                    TopStudentFeature0.
                    setStudent(relatedStudent0);
                }
            
                const relatedStudent1 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const TopStudentFeature1 = await TopStudentFeatures.findOne({
                    order: [['id', 'ASC']],
                    offset: 1
                });
                if (TopStudentFeature1?.setStudent)
                {
                    await
                    TopStudentFeature1.
                    setStudent(relatedStudent1);
                }
            
                const relatedStudent2 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const TopStudentFeature2 = await TopStudentFeatures.findOne({
                    order: [['id', 'ASC']],
                    offset: 2
                });
                if (TopStudentFeature2?.setStudent)
                {
                    await
                    TopStudentFeature2.
                    setStudent(relatedStudent2);
                }
            
                const relatedStudent3 = await Students.findOne({
                    offset: Math.floor(Math.random() * (await Students.count())),
                });
                const TopStudentFeature3 = await TopStudentFeatures.findOne({
                    order: [['id', 'ASC']],
                    offset: 3
                });
                if (TopStudentFeature3?.setStudent)
                {
                    await
                    TopStudentFeature3.
                    setStudent(relatedStudent3);
                }
            
        }
        
    
        
    
        
    
        
    
        
    
        
    


module.exports = {
    up: async (queryInterface, Sequelize) => {
        
            
            
            
            
            
                
                await SchoolSettings.bulkCreate(SchoolSettingsData);
                
            
            
                
                await Pages.bulkCreate(PagesData);
                
            
            
                
                await SchoolYears.bulkCreate(SchoolYearsData);
                
            
            
                
                await Grades.bulkCreate(GradesData);
                
            
            
                
                await Streams.bulkCreate(StreamsData);
                
            
            
                
                await Subjects.bulkCreate(SubjectsData);
                
            
            
                
                await SubjectOfferings.bulkCreate(SubjectOfferingsData);
                
            
            
                
                await StaffMembers.bulkCreate(StaffMembersData);
                
            
            
                
                await Students.bulkCreate(StudentsData);
                
            
            
                
                await ClassSections.bulkCreate(ClassSectionsData);
                
            
            
                
                await Enrollments.bulkCreate(EnrollmentsData);
                
            
            
                
                await Terms.bulkCreate(TermsData);
                
            
            
                
                await Events.bulkCreate(EventsData);
                
            
            
                
                await Announcements.bulkCreate(AnnouncementsData);
                
            
            
                
                await NewsPosts.bulkCreate(NewsPostsData);
                
            
            
                
                await Galleries.bulkCreate(GalleriesData);
                
            
            
                
                await StudyMaterials.bulkCreate(StudyMaterialsData);
                
            
            
                
                await Exams.bulkCreate(ExamsData);
                
            
            
                
                await ExamResults.bulkCreate(ExamResultsData);
                
            
            
                
                await AttendanceSessions.bulkCreate(AttendanceSessionsData);
                
            
            
                
                await AttendanceRecords.bulkCreate(AttendanceRecordsData);
                
            
            
                
                await ClassSchedules.bulkCreate(ClassSchedulesData);
                
            
            
                
                await Assignments.bulkCreate(AssignmentsData);
                
            
            
                
                await AssignmentSubmissions.bulkCreate(AssignmentSubmissionsData);
                
            
            
                
                await LessonPlans.bulkCreate(LessonPlansData);
                
            
            
                
                await Messages.bulkCreate(MessagesData);
                
            
            
                
                await AdmissionApplications.bulkCreate(AdmissionApplicationsData);
                
            
            
                
                await ContactMessages.bulkCreate(ContactMessagesData);
                
            
            
                
                await Alumni.bulkCreate(AlumniData);
                
            
            
                
                await SchoolStatistics.bulkCreate(SchoolStatisticsData);
                
            
            
                
                await ExamPerformanceSummaries.bulkCreate(ExamPerformanceSummariesData);
                
            
            
                
                await TopStudentFeatures.bulkCreate(TopStudentFeaturesData);
                
            
            await Promise.all([
            
                
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                        // Similar logic for "relation_many"
                    
                
            
                
                
                
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                
                    
                
                    
                
            
                
                
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                        
                        await associateSubjectOfferingWithSubject(),
                    
                
                    
                        
                        await associateSubjectOfferingWithGrade(),
                    
                
                    
                        
                        await associateSubjectOfferingWithStream(),
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                        
                        await associateSubjectOfferingWithResponsible_teacher(),
                    
                
            
                
                
                    
                        
                        await associateStaffMemberWithUser(),
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                        // Similar logic for "relation_many"
                    
                
                    
                
            
                
                
                    
                        
                        await associateStudentWithUser(),
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                        
                        await associateStudentWithCurrent_grade(),
                    
                
                    
                        
                        await associateStudentWithCurrent_stream(),
                    
                
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                
                    
                        
                        await associateClassSectionWithSchool_year(),
                    
                
                    
                        
                        await associateClassSectionWithGrade(),
                    
                
                    
                        
                        await associateClassSectionWithStream(),
                    
                
                    
                        
                        await associateClassSectionWithHomeroom_teacher(),
                    
                
                    
                
            
                
                
                    
                        
                        await associateEnrollmentWithStudent(),
                    
                
                    
                        
                        await associateEnrollmentWithClass_section(),
                    
                
                    
                
                    
                
            
                
                
                    
                        
                        await associateTermWithSchool_year(),
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                        
                        await associateNewsPostWithAuthor(),
                    
                
                    
                
                    
                
            
                
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                
                    
                
                    
                
                    
                
                    
                        
                        await associateStudyMaterialWithGrade(),
                    
                
                    
                        
                        await associateStudyMaterialWithSubject(),
                    
                
                    
                        
                        await associateStudyMaterialWithStream(),
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                        
                        await associateStudyMaterialWithUploaded_by(),
                    
                
                    
                
            
                
                
                    
                
                    
                
                    
                        
                        await associateExamWithSchool_year(),
                    
                
                    
                        
                        await associateExamWithTerm(),
                    
                
                    
                        
                        await associateExamWithGrade(),
                    
                
                    
                        
                        await associateExamWithStream(),
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                        
                        await associateExamResultWithExam(),
                    
                
                    
                        
                        await associateExamResultWithStudent(),
                    
                
                    
                        
                        await associateExamResultWithSubject(),
                    
                
                    
                
                    
                
                    
                
                    
                        
                        await associateExamResultWithEntered_by(),
                    
                
                    
                
            
                
                
                    
                        
                        await associateAttendanceSessionWithClass_section(),
                    
                
                    
                        
                        await associateAttendanceSessionWithSubject(),
                    
                
                    
                        
                        await associateAttendanceSessionWithTeacher(),
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                        
                        await associateAttendanceRecordWithAttendance_session(),
                    
                
                    
                        
                        await associateAttendanceRecordWithStudent(),
                    
                
                    
                
                    
                
            
                
                
                    
                        
                        await associateClassScheduleWithClass_section(),
                    
                
                    
                        
                        await associateClassScheduleWithSubject(),
                    
                
                    
                        
                        await associateClassScheduleWithTeacher(),
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                        
                        await associateAssignmentWithClass_section(),
                    
                
                    
                        
                        await associateAssignmentWithSubject(),
                    
                
                    
                        
                        await associateAssignmentWithTeacher(),
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                        
                        await associateAssignmentSubmissionWithAssignment(),
                    
                
                    
                        
                        await associateAssignmentSubmissionWithStudent(),
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                        
                        await associateLessonPlanWithTeacher(),
                    
                
                    
                        
                        await associateLessonPlanWithClass_section(),
                    
                
                    
                        
                        await associateLessonPlanWithSubject(),
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                        
                        await associateMessageWithSender(),
                    
                
                    
                        
                        await associateMessageWithRecipient(),
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                        
                        await associateAdmissionApplicationWithRequested_grade(),
                    
                
                    
                        
                        await associateAdmissionApplicationWithRequested_stream(),
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                        
                        await associateSchoolStatisticWithSchool_year(),
                    
                
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                        
                        await associateExamPerformanceSummaryWithExam(),
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
            
                
                
                    
                        
                        await associateTopStudentFeatureWithExam(),
                    
                
                    
                        
                        await associateTopStudentFeatureWithStudent(),
                    
                
                    
                
                    
                
                    
                
                    
                
                    
                
            
            ]);
        
    },

    down: async (queryInterface, Sequelize) => {
        
            
            
            
            
            
            await queryInterface.bulkDelete('school_settings', null, {});
            
            
            await queryInterface.bulkDelete('pages', null, {});
            
            
            await queryInterface.bulkDelete('school_years', null, {});
            
            
            await queryInterface.bulkDelete('grades', null, {});
            
            
            await queryInterface.bulkDelete('streams', null, {});
            
            
            await queryInterface.bulkDelete('subjects', null, {});
            
            
            await queryInterface.bulkDelete('subject_offerings', null, {});
            
            
            await queryInterface.bulkDelete('staff_members', null, {});
            
            
            await queryInterface.bulkDelete('students', null, {});
            
            
            await queryInterface.bulkDelete('class_sections', null, {});
            
            
            await queryInterface.bulkDelete('enrollments', null, {});
            
            
            await queryInterface.bulkDelete('terms', null, {});
            
            
            await queryInterface.bulkDelete('events', null, {});
            
            
            await queryInterface.bulkDelete('announcements', null, {});
            
            
            await queryInterface.bulkDelete('news_posts', null, {});
            
            
            await queryInterface.bulkDelete('galleries', null, {});
            
            
            await queryInterface.bulkDelete('study_materials', null, {});
            
            
            await queryInterface.bulkDelete('exams', null, {});
            
            
            await queryInterface.bulkDelete('exam_results', null, {});
            
            
            await queryInterface.bulkDelete('attendance_sessions', null, {});
            
            
            await queryInterface.bulkDelete('attendance_records', null, {});
            
            
            await queryInterface.bulkDelete('class_schedules', null, {});
            
            
            await queryInterface.bulkDelete('assignments', null, {});
            
            
            await queryInterface.bulkDelete('assignment_submissions', null, {});
            
            
            await queryInterface.bulkDelete('lesson_plans', null, {});
            
            
            await queryInterface.bulkDelete('messages', null, {});
            
            
            await queryInterface.bulkDelete('admission_applications', null, {});
            
            
            await queryInterface.bulkDelete('contact_messages', null, {});
            
            
            await queryInterface.bulkDelete('alumni', null, {});
            
            
            await queryInterface.bulkDelete('school_statistics', null, {});
            
            
            await queryInterface.bulkDelete('exam_performance_summaries', null, {});
            
            
            await queryInterface.bulkDelete('top_student_features', null, {});
            
        
    },
};