===========================================
AUTONOMOUS COLLEGE DATABASE READER (CLI)
===========================================

📊 Total Tables: 99
🗄️  Database: autonomous_college
🔗 Status: Connected


🎯 FOCUS: STAFF TABLE WITH EXTERNAL STAFF PROFILE FIELDS
========================================================

📋 TABLE: staff
──────────────
Columns (18):
  • staff_id (int(11)) NOT NULL [PRI]
  • college_id (int(11)) NULL [MUL]
  • external_college_name (varchar(255)) NULL
  • staff_code (varchar(20)) NOT NULL [UNI]
  • first_name (varchar(100)) NOT NULL
  • last_name (varchar(100)) NOT NULL
  • email (varchar(255)) NOT NULL [UNI]
  • phone (varchar(15)) NOT NULL
  • designation (varchar(150)) NULL
  • institution_address (text) NULL
  • specialization_ug (varchar(255)) NULL
  • specialization_pg (varchar(255)) NULL
  • teaching_experience_years (int(11)) NULL
  • subjects_taught (text) NULL
  • other_information (text) NULL
  • role (varchar(255)) NOT NULL
  • status (enum('Active','Inactive')) NOT NULL
  • department_id (int(11)) NULL
Records: 52
Sample Data:
  Record 1:
    staff_id: 2
    college_id: 2
<br />
<b>Deprecated</b>:  strlen(): Passing null to parameter #1 ($string) of type string is deprecated in <b>/home2/santhos2/public_html/bharath-coe.firstmatrix.in.net/read_database_cli.php</b> on line <b>51</b><br />
    external_college_name: NULL
    staff_code: STF002
    ... and 14 more fields

  Record 2:
    staff_id: 3
    college_id: 2
<br />
<b>Deprecated</b>:  strlen(): Passing null to parameter #1 ($string) of type string is deprecated in <b>/home2/santhos2/public_html/bharath-coe.firstmatrix.in.net/read_database_cli.php</b> on line <b>51</b><br />
    external_college_name: NULL
    staff_code: STF003
    ... and 14 more fields


🔍 CHECKING FOR EXTERNAL STAFF PROFILE FIELDS:
✅ designation (VARCHAR(150)) - EXISTS
✅ institution_address (TEXT) - EXISTS
✅ specialization_ug (VARCHAR(255)) - EXISTS
✅ specialization_pg (VARCHAR(255)) - EXISTS
✅ teaching_experience_years (INT) - EXISTS
✅ subjects_taught (TEXT) - EXISTS
✅ other_information (TEXT) - EXISTS

📚 OTHER IMPORTANT TABLES:
==========================

📋 TABLE: students
─────────────────
Columns (12):
  • student_id (int(11)) NOT NULL [PRI]
  • university_rollno (varchar(20)) NOT NULL [UNI]
  • college_id (int(11)) NOT NULL [MUL]
  • course_id (int(11)) NOT NULL [MUL]
  • academic_year_id (int(11)) NULL [MUL]
  • first_name (varchar(100)) NOT NULL
  • last_name (varchar(100)) NOT NULL
  • date_of_joining (date) NOT NULL
  • current_semester (int(11)) NOT NULL
  • status (enum('Active','Completed','Dropped Out')) NOT NULL
  • photo (varchar(255)) NULL
  • folio_prefix (varchar(10)) NULL
Records: 165
Sample Data:
  Record 1:
    student_id: 1
    university_rollno: NursinBSC066
    college_id: 2
    course_id: 1
    ... and 8 more fields

  Record 2:
    student_id: 2
    university_rollno: Nursing BSC087
    college_id: 2
    course_id: 1
    ... and 8 more fields


📋 TABLE: courses
────────────────
Columns (9):
  • course_id (int(11)) NOT NULL [PRI]
  • college_id (int(11)) NOT NULL [MUL]
  • category_id (int(11)) NOT NULL [MUL]
  • course_name (varchar(255)) NOT NULL
  • course_code (varchar(20)) NOT NULL [UNI]
  • regulation_year (year(4)) NOT NULL
  • duration_years (int(11)) NOT NULL
  • total_semesters (int(11)) NOT NULL
  • status (enum('Active','Inactive')) NOT NULL
Records: 4
Sample Data:
  Record 1:
    course_id: 1
    college_id: 2
    category_id: 1
    course_name: HOTEL MANAHEMENT
    ... and 5 more fields

  Record 2:
    course_id: 2
    college_id: 2
    category_id: 1
    course_name: BSC Computer Science
    ... and 5 more fields


📋 TABLE: exams
──────────────
Columns (10):
  • exam_id (int(11)) NOT NULL [PRI]
  • exam_name (varchar(255)) NOT NULL [MUL]
  • exam_type_id (int(11)) NOT NULL [MUL]
  • academic_year_id (int(11)) NOT NULL [MUL]
  • academic_year (varchar(20)) NOT NULL [MUL]
  • semester (int(11)) NULL
  • status (enum('Draft','Announced','In Progress','Completed','Results Published')) NOT NULL
  • is_arrear_allowed (tinyint(1)) NOT NULL
  • mark_conversion_type (enum('Best of 2','Average of 3','Percentage (e.g., 80%)')) NULL
  • conversion_value (decimal(5,2)) NULL
Records: 1
Sample Data:
  Record 1:
    exam_id: 1
    exam_name: APR/MAY 2025
    exam_type_id: 1
    academic_year_id: 4
    ... and 6 more fields


📋 TABLE: colleges
─────────────────
Columns (8):
  • college_id (int(11)) NOT NULL [PRI]
  • college_code (varchar(10)) NOT NULL [UNI]
  • college_name (varchar(255)) NOT NULL
  • status (enum('Active','Inactive')) NOT NULL
  • logo (varchar(255)) NULL
  • seal (varchar(255)) NULL
  • address (text) NULL [MUL]
  • location (varchar(255)) NULL [MUL]
Records: 1
Sample Data:
  Record 1:
    college_id: 2
    college_code: Barath
    college_name: Bharath College of Science and...
    status: Active
    ... and 4 more fields


📋 TABLE: subjects
─────────────────
Columns (12):
  • subject_id (int(11)) NOT NULL [PRI]
  • course_id (int(11)) NOT NULL [MUL]
  • department_id (int(11)) NULL [MUL]
  • subject_code (varchar(20)) NOT NULL [MUL]
  • subject_name (varchar(255)) NOT NULL
  • regulation_year (year(4)) NOT NULL
  • type (varchar(50)) NOT NULL
  • credits (int(11)) NOT NULL
  • is_lab (tinyint(1)) NOT NULL
  • semester (int(11)) NOT NULL [MUL]
  • part_no (int(11)) NOT NULL
  • sem_type (enum('Odd','Even')) NOT NULL
Records: 62
Sample Data:
  Record 1:
    subject_id: 1
    course_id: 2
    department_id: 1
    subject_code: CS101
    ... and 8 more fields

  Record 2:
    subject_id: 2
    course_id: 2
    department_id: 1
    subject_code: CS102
    ... and 8 more fields


📋 ALL DATABASE TABLES:
======================
• academic_years (4 records)
• audit_logs (2075 records)
• batches (10 records)
• blooms_taxonomy_action_verbs (143 records)
• categories (3 records)
• certificate_issuance (0 records)
• certificate_sequence (0 records)
• ci_assessment_settings (3 records)
• co_po_mapping (0 records)
• colleges (1 records)
• consolidated_folio_sequence (2 records)
• consolidated_marksheets (2 records)
• course_assessment_settings (3 records)
• course_fee_structure (1 records)
• courses (4 records)
• departments (2 records)
• email_attachments (0 records)
• email_logs (0 records)
• email_message_logs (122 records)
• email_message_templates (4 records)
• email_queue (0 records)
• email_templates (0 records)
• exam_attendance (0 records)
• exam_subjects (62 records)
• exam_timetable (62 records)
• exam_types (5 records)
• exams (1 records)
• external_staff (1 records)
• external_staff_applications (0 records)
• fee_types (1 records)
• folio_sequence (2 records)
• grades (28 records)
• grading_systems (4 records)
• hall_allocations (25 records)
• hall_settings (8 records)
• halls (8 records)
• holidays (1 records)
• internal_ci_attendance (0 records)
• internal_exams (39 records)
• internal_marks (555 records)
• internal_marks_summary (0 records)
• invigilation_duties (25 records)
• invigilation_duty (0 records)
• mark_entry_assignments (0 records)
• mark_entry_progress (0 records)
• mark_entry_sessions (0 records)
• pattern_questions (92 records)
• pattern_sections (14 records)
• people_sync_history (280 records)
• permission (125 records)
• permission_modules (7 records)
• qp_setter_assignments (1 records)
• qp_setter_biodata (1 records)
• qp_setter_claims (1 records)
• qp_setter_declarations (2 records)
• qp_setter_login_tokens (16 records)
• qp_setter_otps (44 records)
• qp_setter_submissions (0 records)
• question_paper_assignments (1 records)
• question_paper_orders (0 records)
• question_pattern_templates (1 records)
• question_patterns (1 records)
• result_announcements (0 records)
• revaluation_applications (0 records)
• roles (11 records)
• semester_results (0 records)
• smtp_settings (8 records)
• squad_assignments (0 records)
• squads (0 records)
• staff (52 records)
• staff_privileges (56 records)
• staff_role_types (10 records)
• staff_roles (73 records)
• student_certificates (0 records)
• student_enrollments (165 records)
• student_marks_entry (0 records)
• student_marks_summary (0 records)
• student_marksheets (1 records)
• student_question_marks (0 records)
• student_registrations (580 records)
• student_seating (580 records)
• students (165 records)
• subject_assessment_settings (9 records)
• subject_results (0 records)
• subject_types (8 records)
• subjects (62 records)
• tbl_branch (2 records)
• tbl_department (0 records)
• tbl_employee (0 records)
• tbl_exam_attendance (0 records)
• tbl_settings (1 records)
• tbl_state (2 records)
• tbl_user (1 records)
• valuation_duties (0 records)
• valuation_marks (180 records)
• valuation_rooms (2 records)
• valuation_salary (0 records)
• valuation_timetable (0 records)
• valuator_allocation (0 records)

===========================================
Database reading completed!
===========================================