قم إفلات الملفات هنا

SQL upload ( 0 ) x -

الإعدادات المتعلقة بالصفحة انقر على الشريط للتمرير إلى أعلى الصفحة
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
تصحيح SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
تحديث
إضافة
لا توجد إشارات مرجعية
إضافة للمفضلة
خيارات
Set default





Collapse Expand Requery تعديل Explain جانبي Bookmark Query failed قاعدة البيانات : Queried time :
بدون عنوان *
v Show/Hide tables list View in fullscreen اضافة جداول من قواعد بيانات اخري New page فتح الصفحة احفظ الصفحة حفظ الصفحة في صيغة Delete pages أنشئ الجدول Create relationship اختر الحقل لإظهاره Reload مساعدة Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > نقل القائمة > Pin text
v v
عدد الجداول: 0
v school_db_v2 academic_years
* id : int(11)
* year_name : varchar(50)
v school_db_v2 attendance
* id : int(11)
* person_type : enum('teacher','employee')
* person_id : int(11)
* att_date : date
* check_in : time
* check_out : time
* status : enum('present','absent','late','holiday','leave')
* notes : varchar(255)
v school_db_v2 budget_categories
* id : int(11)
* category_name : varchar(100)
* category_type : enum('income','expense')
* description : varchar(255)
* is_active : tinyint(1)
* created_at : timestamp
v school_db_v2 budget_transactions
* id : int(11)
* transaction_type : enum('income','expense')
* category_id : int(11)
* amount : decimal(12,2)
* transaction_date : date
* description : varchar(255)
* reference_number : varchar(50)
* payment_method : enum('cash','bank_transfer','check','online')
* related_person_type : varchar(50)
* related_person_id : int(11)
* related_student_id : int(11)
* related_salary_id : int(11)
* related_lesson_payment_id : int(11)
* created_by : varchar(100)
* created_at : timestamp
v school_db_v2 classes
* id : int(11)
* class_name : varchar(80)
* grade_level_id : int(11)
* section : varchar(20)
* section_name : varchar(100)
* academic_year : varchar(50)
* created_at : timestamp
v school_db_v2 employees
* id : int(11)
* employee_code : varchar(20)
* name : varchar(150)
* job_title : varchar(50)
* salary : decimal(10,2)
* work_days : varchar(100)
* annual_leave_days : int(11)
* used_leave_days : int(11)
* created_at : timestamp
v school_db_v2 fee_installments
* id : int(11)
* student_fee_id : int(11)
* installment_number : int(11)
* amount : decimal(10,2)
* due_date : date
* paid_date : date
* status : enum('pending','paid','overdue','cancelled')
* payment_method : enum('cash','bank_transfer','check','online')
* receipt_number : varchar(50)
* notes : varchar(255)
* confirmed_by : varchar(100)
* confirmed_at : timestamp
* created_at : timestamp
v school_db_v2 fee_notifications
* id : int(11)
* guardian_id : int(11)
* student_id : int(11)
* installment_id : int(11)
* notification_type : enum('due_soon','overdue','payment_confirmed','new_installment')
* title : varchar(150)
* message : text
* is_read : tinyint(1)
* read_at : timestamp
* created_at : timestamp
v school_db_v2 fee_payments
* id : int(11)
* installment_id : int(11)
* student_fee_id : int(11)
* amount : decimal(10,2)
* payment_date : date
* payment_method : enum('cash','bank_transfer','check','online')
* receipt_number : varchar(50)
* received_by : varchar(100)
* notes : varchar(255)
* created_at : timestamp
v school_db_v2 fee_types
* id : int(11)
* fee_name : varchar(100)
* fee_description : varchar(255)
* academic_year : varchar(50)
* grade_level_id : int(11)
* class_id : int(11)
* total_amount : decimal(10,2)
* installments_count : int(11)
* first_installment_amount : decimal(10,2)
* is_active : tinyint(1)
* created_at : timestamp
v school_db_v2 grades
* id : int(11)
* student_id : int(11)
* subject_id : int(11)
* semester : enum('first','second')
* year : int(11)
* academic_year : varchar(50)
* coursework : decimal(5,2)
* final_exam : decimal(5,2)
* total : decimal(5,2)
* listening : decimal(5,2)
* reading : decimal(5,2)
* writing : decimal(5,2)
* speaking : decimal(5,2)
* grammar : decimal(5,2)
* phonics : decimal(5,2)
v school_db_v2 grade_levels
* id : int(11)
* academic_year : varchar(50)
* created_at : timestamp
v school_db_v2 guardians
* id : int(11)
* full_name : varchar(150)
* phone : varchar(20)
* reference_code : varchar(20)
* student_id : int(11)
* created_at : timestamp
v school_db_v2 holidays
* id : int(11)
* holiday_name : varchar(100)
* holiday_date : date
* description : varchar(255)
v school_db_v2 kg2_term_evaluations
* id : int(11)
* student_id : int(11)
* academic_year : varchar(50)
* attendance : varchar(100)
* teacher_name : varchar(150)
* ratings_data : longtext
* signatures_data : longtext
* final_result : varchar(255)
* result_date : date
* created_at : timestamp
* updated_at : timestamp
v school_db_v2 leave_balance
* id : int(11)
* person_type : enum('teacher','employee')
* person_id : int(11)
* year : int(11)
* annual_entitlement : int(11)
* annual_used : int(11)
* sick_used : int(11)
* emergency_used : int(11)
* unpaid_used : int(11)
v school_db_v2 leave_requests
* id : int(11)
* person_type : enum('teacher','employee')
* person_id : int(11)
* leave_type : enum('annual','sick','emergency','unpaid')
* start_date : date
* end_date : date
* days_count : int(11)
* reason : text
* status : enum('pending','approved','rejected')
* approved_by : varchar(100)
* approved_at : timestamp
* created_at : timestamp
v school_db_v2 monthly_evaluations
* id : int(11)
* student_id : int(11)
* academic_year : varchar(50)
* english_data : longtext
* math_data : longtext
* science_data : longtext
* kg_english_data : longtext
* kg_math_data : longtext
* kg_islamic_data : longtext
* kg_arabic_data : longtext
* kg_local_math_data : longtext
* kg_crafts_data : longtext
* general_behavior_data : longtext
* notes_signatures_data : longtext
* local_data : longtext
* local_notes_data : longtext
* created_at : timestamp
* updated_at : timestamp
v school_db_v2 notes
* id : int(11)
* person_type : enum('student','teacher','employee')
* person_id : int(11)
* note : text
* note_date : date
* created_by : varchar(100)
* created_at : timestamp
v school_db_v2 password_resets
* id : int(11)
* user_type : enum('user','guardian')
* user_id : int(11)
* phone : varchar(30)
* code : varchar(10)
* expires_at : datetime
* used : tinyint(1)
* created_at : timestamp
v school_db_v2 promotions
* id : int(11)
* student_id : int(11)
* from_class_id : int(11)
* to_class_id : int(11)
* from_grade_level : int(11)
* to_grade_level : int(11)
* academic_year : varchar(50)
* avg_score : decimal(5,2)
* status : enum('passed','failed')
* promoted_at : timestamp
* promoted_by : varchar(100)
v school_db_v2 salaries
* id : int(11)
* person_type : enum('teacher','employee')
* person_id : int(11)
* month : varchar(20)
* year : int(11)
* basic_salary : decimal(10,2)
* bonus : decimal(10,2)
* deduction : decimal(10,2)
* absence_days : int(11)
* absence_deduction : decimal(10,2)
* net_salary : decimal(10,2)
* paid_date : date
* status : enum('paid','pending')
* created_at : timestamp
v school_db_v2 settings
* id : int(11)
* setting_key : varchar(50)
* setting_value : varchar(255)
v school_db_v2 students
* id : int(11)
* student_code : varchar(20)
* name : varchar(150)
* national_id : varchar(30)
* birth_date : date
* gender : enum('male','female')
* class_id : int(11)
* academic_year : varchar(50)
* semester : enum('first','second')
* guardian_name : varchar(150)
* guardian_phone : varchar(20)
* address : text
* enroll_date : date
* status : enum('active','graduated','failed','withdrawn')
v school_db_v2 student_audio_clips
* id : int(11)
* title : varchar(200)
* note : varchar(500)
* file_name : varchar(120)
* original_name : varchar(255)
* mime_type : varchar(100)
* file_size : int(11)
* uploaded_by : varchar(100)
* created_at : timestamp
v school_db_v2 student_audio_targets
* clip_id : int(11)
* class_id : int(11)
v school_db_v2 student_fees
* id : int(11)
* student_id : int(11)
* fee_type_id : int(11)
* academic_year : varchar(50)
* semester : enum('first','second')
* total_amount : decimal(10,2)
* paid_amount : decimal(10,2)
* remaining_amount : decimal(10,2)
* status : enum('pending','partial','paid','overdue')
* created_at : timestamp
v school_db_v2 subjects
* id : int(11)
* subject_name : varchar(50)
* academic_year : varchar(50)
* grade_level_id : int(11)
* class_id : int(11)
* max_grade : int(11)
* coursework_max : int(11)
* final_max : int(11)
* subject_type : enum('local','international')
* is_english : tinyint(1)
* created_at : timestamp
v school_db_v2 teachers
* id : int(11)
* employee_code : varchar(20)
* name : varchar(150)
* national_id : varchar(30)
* phone : varchar(20)
* email : varchar(100)
* subject : varchar(50)
* hire_date : date
* salary : decimal(10,2)
* address : text
* work_days : varchar(100)
* work_start : time
* work_end : time
* annual_leave_days : int(11)
* used_leave_days : int(11)
* lesson_price : decimal(10,2)
* lesson_days : varchar(100)
* created_at : timestamp
v school_db_v2 teacher_lessons
* id : int(11)
* teacher_id : int(11)
* subject_name : varchar(150)
* lesson_date : date
* lesson_day : varchar(20)
* lesson_price : decimal(10,2)
* timetable_id : int(11)
* payment_id : int(11)
* completed : tinyint(1)
* notes : varchar(255)
* recorded_by : varchar(100)
* created_at : timestamp
v school_db_v2 teacher_lesson_payments
* id : int(11)
* teacher_id : int(11)
* amount : decimal(12,2)
* lesson_count : int(11)
* payment_date : date
* payment_method : enum('cash','bank_transfer','check','online')
* reference_number : varchar(50)
* budget_transaction_id : int(11)
* created_by : varchar(100)
* created_at : timestamp
v school_db_v2 timetables
* id : int(11)
* grade_level_id : int(11)
* class_id : int(11)
* section_id : int(11)
* teacher_id : int(11)
* subject_name : varchar(100)
* school_name : varchar(100)
* day_of_week : varchar(20)
* period_number : int(11)
* start_time : time
* end_time : time
* notes : varchar(255)
* created_at : timestamp
v school_db_v2 users
* id : int(11)
* username : varchar(50)
* password : varchar(255)
* full_name : varchar(100)
* phone : varchar(30)
* role : enum('admin','accountant','data_entry','supervisor','parent')
* created_at : timestamp
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship