school
Tables (24)
admin_info
- id — int — Primary key — NOT NULL
- user_id — varchar(45) — NOT NULL
- password — varchar(45) — NOT NULL
- name — varchar(60) — NOT NULL
- dept_id — varchar(10) — NOT NULL
- email — varchar(60) — NOT NULL
admission_form
- id — int — Primary key — NOT NULL
- form_id — varchar(20) — NOT NULL
- form_status — varchar(25)
- remark — text
- fees_status — varchar(20) — NOT NULL
- first_name — varchar(25) — NOT NULL
- middle_name — varchar(25) — NOT NULL
- last_name — varchar(25) — NOT NULL
- dob — date — NOT NULL
- gender — varchar(10) — NOT NULL
- email — varchar(50) — NOT NULL
- mobile_no — varchar(10) — NOT NULL
- alter_mno — varchar(10)
- aadhar_no — varchar(15) — NOT NULL
- aadhar_path — varchar(100) — NOT NULL
- cast — varchar(10) — NOT NULL
- disability — varchar(10) — NOT NULL
- stream — varchar(25) — NOT NULL
- course — varchar(50) — NOT NULL
- dept_id — varchar(10) — NOT NULL
- ssc_board — varchar(10) — NOT NULL
- ssc_m_y — varchar(10) — NOT NULL
- ssc_percentage — varchar(10) — NOT NULL
- ssc_result_path — varchar(100) — NOT NULL
- hsc_board — varchar(10) — NOT NULL
- hsc_m_y — varchar(10) — NOT NULL
- hsc_percentage — varchar(10) — NOT NULL
- hsc_result_path — varchar(100) — NOT NULL
- application_date — timestamp — NOT NULL
class
- id — int — Primary key — NOT NULL
- class_id — varchar(10) — NOT NULL
- dept_id — varchar(10) — NOT NULL
- course_code — varchar(10) — NOT NULL
- sem — varchar(10) — NOT NULL
- division — varchar(10) — NOT NULL
- no_of_student — varchar(10) — NOT NULL
- teacher_code — varchar(10)
class_result
- class_result_id — int — Primary key — NOT NULL
- enrollment_no — varchar(30) — NOT NULL
- course_code — varchar(30) — NOT NULL
- subject_code — varchar(10) — NOT NULL
- semester — varchar(11) — NOT NULL
- total_marks — varchar(11) — NOT NULL
- obtain_marks — varchar(11) — NOT NULL
- result_date — varchar(10) — NOT NULL
courses
- course_id — int — Primary key — NOT NULL
- course_code — varchar(10) — NOT NULL
- course_name — varchar(50) — NOT NULL
- no_of_semester — varchar(10) — NOT NULL
- dept_id — varchar(10) — NOT NULL
- stream_id — varchar(10) — NOT NULL
- fees_per_sem — varchar(6) — NOT NULL
department
- id — int — Primary key — NOT NULL
- dept_id — varchar(10) — NOT NULL
- dept_name — varchar(100) — NOT NULL
exam
- id — varchar(10) — NOT NULL
- exam_type — varchar(25) — NOT NULL
- exam_fees — varchar(10) — NOT NULL
exam_fee
- exam_fee_voucher — varchar(10) — NOT NULL
- enrollment_no — varchar(15) — NOT NULL
- exam_type — varchar(25) — NOT NULL
- paid_sem — varchar(10) — NOT NULL
- amount — varchar(5) — NOT NULL
- status — varchar(10) — NOT NULL
- payment_date — timestamp — NOT NULL
mytable
- id — varchar(20) — Primary key — NOT NULL
- name — varchar(30) — NOT NULL
- course_code — varchar(10) — NOT NULL
notifications
- notification_id — int — Primary key — NOT NULL
- title — varchar(250) — NOT NULL
- message — text — NOT NULL
- sender_id — varchar(110)
- receiver_id — varchar(110)
- usertype — varchar(100) — NOT NULL
- created_at — timestamp — NOT NULL
- duration — varchar(50) — NOT NULL
sessions
- session_id — int — Primary key — NOT NULL
- session — varchar(30) — NOT NULL
- created_date — timestamp — NOT NULL
stream
- id — int — Primary key — NOT NULL
- stream_name — varchar(50) — NOT NULL
student_attendance
- attendance_id — int — Primary key — NOT NULL
- course_code — varchar(10) — NOT NULL
- subject_code — varchar(10) — NOT NULL
- semester — int — NOT NULL
- class_id — varchar(10) — NOT NULL
- student_id — varchar(20) — NOT NULL
- attendance — int — NOT NULL
- attendance_date — varchar(11) — NOT NULL
- time — varchar(25) — NOT NULL
student_fee
- fee_voucher — int — Primary key — NOT NULL
- transaction_id — varchar(100) — NOT NULL
- enrollment_no — varchar(30) — NOT NULL
- paid_sem — varchar(10) — NOT NULL
- amount — int — NOT NULL
- posting_date — timestamp — NOT NULL
- status — varchar(10) — NOT NULL
student_info
- id — int — Primary key — NOT NULL
- user_id — varchar(45) — NOT NULL
- password — varchar(45) — NOT NULL
- enrollment_no_genrator — varchar(100) — NOT NULL
- enrollment_no — varchar(15) — NOT NULL
- dept_id — varchar(10) — NOT NULL
- course_code — varchar(50) — NOT NULL
- first_name — varchar(30) — NOT NULL
- middle_name — varchar(30)
- last_name — varchar(30)
- father_name — varchar(30)
- dob — date — NOT NULL
- blood_group — varchar(10) — NOT NULL
- place_of_birth — varchar(50)
- gender — varchar(10) — NOT NULL
- email — varchar(30) — NOT NULL
- mobile_no — varchar(11)
- alter_mno — varchar(10)
- aadhar_no — varchar(12) — NOT NULL
- aadhar_path — varchar(100) — NOT NULL
- cast — varchar(10) — NOT NULL
- disability — varchar(10) — NOT NULL
- ssc_board — varchar(50)
- ssc_m_y — varchar(10)
- ssc_percentage — varchar(10)
- ssc_result_path — varchar(100)
- hsc_board — varchar(50)
- hsc_m_y — varchar(10)
- hsc_percentage — varchar(10)
- hsc_result_path — varchar(100)
- profile_image — varchar(100)
- current_address — varchar(150)
- state — varchar(20)
- permanent_address — varchar(150)
- fees_status — varchar(15) — NOT NULL
- exam_status — varchar(10) — NOT NULL
- current_semester — int
- graduation_date — varchar(20) — NOT NULL
- class_id — varchar(10) — NOT NULL
- session — varchar(50) — NOT NULL
- admission_date — timestamp — NOT NULL
subjects
- subjects_code — varchar(100) — NOT NULL
- subjects_name — varchar(255) — NOT NULL
- dept_id — int — NOT NULL
- course_code — varchar(255) — NOT NULL
- semester — int — NOT NULL
- credits — int — NOT NULL
- type — varchar(25) — NOT NULL
teacher_attendance
- attendance_id — int — Primary key — NOT NULL
- teacher_code — varchar(30) — NOT NULL
- dept_id — varchar(10) — NOT NULL
- attendance — int — NOT NULL
- attendance_date — varchar(11) — NOT NULL
teacher_courses
- teacher_courses_id — int — Primary key — NOT NULL
- course_code — varchar(10) — NOT NULL
- semester — int — NOT NULL
- teacher_code — varchar(10) — NOT NULL
- subject_code — varchar(10) — NOT NULL
- assign_date — varchar(10) — NOT NULL
- total_classes — int — NOT NULL
teacher_info
- id — int — Primary key — NOT NULL
- teacher_code — varchar(10) — NOT NULL
- user_id — varchar(45) — NOT NULL
- password — varchar(45) — NOT NULL
- first_name — varchar(30)
- middle_name — varchar(30)
- last_name — varchar(30)
- email — varchar(30) — NOT NULL
- phone_no — varchar(11)
- dept_id — varchar(10) — NOT NULL
- profile_image — varchar(100)
- teacher_status — varchar(10)
- aadhar_no — varchar(15)
- dob — varchar(15)
- other_phone — int
- gender — varchar(10)
- permanent_address — varchar(100)
- current_address — varchar(100)
- place_of_birth — varchar(50)
- hire_date — varchar(100)
- teaching_subject — varchar(255)
- teaching_level — varchar(255)
- education_level — varchar(255)
- certification — varchar(255)
- experience — int
- contract_start_date — date
- contract_end_date — date
- salary — decimal(10,2)
- emergency_contact_name — varchar(100)
- emergency_contact_phone — varchar(20)
- emergency_contact_relationship — varchar(100)
- teaching_schedule — varchar(255)
- classroom_resources — varchar(255)
- notes — varchar(255)
teacher_salary_allowances
- teacher_code — int — Primary key — NOT NULL
- basic_salary — int — NOT NULL
- medical_allowance — int — NOT NULL
- hr_allowance — int — NOT NULL
- scale — int — NOT NULL
teacher_salary_report
- salary_id — int — Primary key — NOT NULL
- teacher_code — int — Foreign key → teacher_salary_allowances.teacher_code — NOT NULL
- total_amount — int — NOT NULL
- status — varchar(11) — NOT NULL
- paid_date — timestamp — NOT NULL
time_table
- id — varchar(10) — Primary key — NOT NULL
- class_id — varchar(10) — NOT NULL
- day — varchar(15) — NOT NULL
- time — varchar(20) — NOT NULL
- subject_code — varchar(20) — NOT NULL
- course_code — varchar(10) — NOT NULL
- sem — varchar(10) — NOT NULL
- room — varchar(20) — NOT NULL
uniadmin_info
- id — int — Primary key — NOT NULL
- user_id — varchar(45) — NOT NULL
- password — varchar(45) — NOT NULL
- name — varchar(45) — NOT NULL
- email — varchar(60) — NOT NULL
weekdays
- day_id — int — Primary key — NOT NULL
- day_name — varchar(15) — NOT NULL