My_School - Laravel Schema Designer

Student

id increments
user_id ^FK bigInteger
Student_number string (50)
status enum
timestamps timestamps

Teacher

id increments
user_id ^FK bigInteger
subject_id ^FK bigInteger
Academic_qualification string (50)
Employment_status enum
Payment_type enum
Contract_type enum
The_beginning_of_the_contract date
End_of_contract date
number_of_lesson_in_week tinyInteger
wages_per_lesson tinyInteger
timestamps timestamps

Qr_Codes

id increments
Unique_code string (255)
Code_type enum
Class_Name char
Active_code boolean
timestamps timestamps

Staff_Attendance

id increments
QR_id ^FK bigInteger
user_id ^FK bigInteger
Attendance_status enum
nots text
timestamps timestamps

subjects

id increments
name string (50)

Class_Session

id increments
treacher_id ^FK bigInteger
class_id ^FK bigInteger
subject_id ^FK bigInteger
session_day enum
start_time time
end_time time
timestamps timestamps

Staff_leaves

id increments
user_id ^FK bigInteger
start_date date
End_date date
leave_type enum
status enum
notes text
timestamps timestamps

Staff_Salary_Deductions

id increments
user_id ^FK bigInteger
role enum
amount integer
reason text
timestamps timestamps

Student_Profile

id increments
student_id ^FK bigInteger
academic_year_id bigInteger
total_absences integer
unexcused_absences integer
score decimal
behavior_notes text
health_notes text
interests json
activities_participated json
achievements json
guardian_feedback text
teacher_feedback text
timestamps timestamps
skills json

Class_Room

id increments
name string (50)
capacity integer
current_count integer
floor tinyInteger
timestamps timestamps

Class_Teacher

id increments
class_id ^FK bigInteger
teacher_id ^FK bigInteger
notes text
is_primary_teacher boolean
weekly_lessons_count integer
timestamps timestamps

Supervisors

id increments
user_id ^FK bigInteger
status enum
timestamps timestamps

Mark

id increments
student_id ^FK bigInteger
subject_id ^FK bigInteger
class_id ^FK bigInteger
exam_type enum
score integer
max_score integer
date date
teacher_note text
teacher_id ^FK bigInteger
timestamps timestamps

Educational_Content

id increments
title string (50)
description text
teacher_id ^FK bigInteger
subject_id ^FK bigInteger
class_id ^FK bigInteger
content_type enum
file_url string (500)
timestamps timestamps

Activitie

id increments
timestamps timestamps
Title string (255)
Description text
activity_type enum
date date
location string (255)
target_group enum
class_id ^FK bigInteger
stage_id ^FK bigInteger
is_paid boolean
cost integer
seats_limit integer
registration_deadline date
is_open boolean
gallery_urls json
required_skills json
auto_filter_participants boolean

Activity_Participant

id increments
timestamps timestamps
activity_id ^FK bigInteger
Student_id ^FK bigInteger
payment_status enum
attendance boolean
payment_method enum
notes text

Cultural_Book

id increments
timestamps timestamps
title string (50)
author string (50)
publisher string (50)
publication_year date
type enum
format_url text
category_id ^FK bigInteger
copies_available integer
avg_student_rating decimal
avg_teacher_rating string
total_student_reviews integer
total_teacher_reviews bigInteger
description text

Book_Category

id increments
timestamps timestamps

Book_Loan

id increments
timestamps timestamps
name string

Book_Reservation

id increments
student_id ^FK bigInteger
book_id ^FK bigInteger
reservation_date date
expiration_date date
status enum
timestamps timestamps

Text_Book

id increments
timestamps timestamps
title string (50)
subject_id ^FK bigInteger
stage_id ^FK bigInteger
total_quantity integer
sold_quantity integer
price integer
available_quantity integer

Student_Textbook_Sale

id increments
timestamps timestamps
student_id ^FK bigInteger
textbook_id ^FK bigInteger
sale_date date
quantity integer
total_price integer

Public_Content

id increments
content_type enum
content longText
timestamps timestamps

School_Post

id increments
timestamps timestamps
title string (255)
description text
post_type enum
file_url string (500)
is_public boolean

Pre_Registration

id increments
timestamps timestamps
student_name string (50)
student_email string (50)
parent_name string (50)
parent_email string (50)
phone_number string (50)
stagr_id ^FK bigInteger
status enum
documents json

User

id increments
name string (50)
email string (100)
password string (50)
role enum
hire_date date
ID_documents string
phone_number string
birth_date date
gender enum
address text
timestamps timestamps

Payment_Method

id increments
timestamps timestamps
name string
description text

Transaction

id increments
user_id ^FK bigInteger
amount decimal
type enum
transaction_source enum
source_id bigInteger
payment_method_id ^FK bigInteger
status enum
timestamps timestamps
is_installment boolean
installment_number integer
payment_reference string

Installment_Plan

id increments
timestamps timestamps
name string (50)
total_amount decimal
number_of_installments tinyInteger
count_of_days_per_each_installment tinyInteger
description text

Installment_Payment

id increments
timestamps timestamps
student_id ^FK bigInteger
plan_id ^FK bigInteger
due_date date
amount decimal
paid boolean
payment_date date
payment_method_id ^FK bigInteger
transaction_id ^FK bigInteger

Salary

id increments
timestamps timestamps
user_id ^FK bigInteger
Base_salary decimal
bonus decimal
deductions decimal
net_salary decimal
pay_date date
status enum
notes text