Please enable JavaScript.
Coggle requires JavaScript to display documents.
Eschool - Coggle Diagram
Eschool
Admin
Tables
Courses
id
Name
Total_Fees
Duration In Months
Image
Description
Batch Allocation
Faculty_ID (Foreign Key)
course_id (Foreign Key)
Starting_Date
Ending Date (Default Running)
Batch_Id (Auto_Increment)
Batch_Timings
Running Batches
Id Auto_Increment
Student_Id (Foreign Key Student)
Batch_ID (Foreign Key Batch Allocation)
student_joining_date
Student_Fees_Status
Fees Have TO BE Paid
Fees
Id auto_increment
Batch_ID (Foreign Key Batch Allocation)
Mode_of_Payment
Date
Student_Registration_ID (Foreign Key Student)
Status (Pending,Completed)
No. Of Total Insatallments (Paid)
Installements Of Student
Id Auto Increment
Student_Id
installment in rupees
Status (Paid/Unpaid)
Batch_Id
Date
Enquiry
Id Auto_increment
Name
College/school
class/semester
Eschool_Course (Updatable)
date
mode_of_enquiry
phone
email (if possible)
Remark (Updatable)
IsRegistered (Yes/No)
Expenses
ID AUTO_Increment
Date
Description
Paid By Whom
Mode_OF_Payment
Fee_Plan
Installment_Amount
Registration_ID (Foreign Key)
Fee_Plan_ID (Auto_increment)
Installment_Date
Fees_Deposit
Registration_ID
Date
Fee_deposit_ID Auto_increment
Student_Amount_Paid
Students
Tables
Students
Email
Phone No.
Name
College/School
Student_Id Auto_increment
Image
Password
My Courses
Course_Name
Mentor-Name
Student DOJ
PDF
Performance
Registrations
Student_ID (Foreign_Key)
Registration_ID (Auto_Increment)
Batch_ID (Foreign Key)
Student_DOJ
Faculty
Tables
(Admin Side)Faculty_Registration
Faculty_ID (Auto_Increment)
Name
Phone No.
Email
Qualification
Image
DOJ (Admin Side)
Address
DefaultPassword
Running Batch
Batch Id
Upload Pdf