Total Tables: 99
Database Name: autonomous_college
Connection Status: Connected
| Field | Type | Null | Key | Default |
|---|---|---|---|---|
| staff_id | int(11) | NO | PRI | NULL |
| college_id | int(11) | YES | MUL | NULL |
| external_college_name | varchar(255) | YES | NULL | |
| staff_code | varchar(20) | NO | UNI | NULL |
| first_name | varchar(100) | NO | NULL | |
| last_name | varchar(100) | NO | NULL | |
| varchar(255) | NO | UNI | NULL | |
| phone | varchar(15) | NO | NULL | |
| designation | varchar(150) | YES | NULL | |
| institution_address | text | YES | NULL | |
| specialization_ug | varchar(255) | YES | NULL | |
| specialization_pg | varchar(255) | YES | NULL | |
| teaching_experience_years | int(11) | YES | NULL | |
| subjects_taught | text | YES | NULL | |
| other_information | text | YES | NULL | |
| role | varchar(255) | NO | NULL | |
| status | enum('Active','Inactive') | NO | NULL | |
| department_id | int(11) | YES | NULL |
Total Records: 52
Records: 165
| Field | Type |
|---|---|
| student_id | int(11) |
| university_rollno | varchar(20) |
| college_id | int(11) |
| course_id | int(11) |
| academic_year_id | int(11) |
| ... and 7 more fields | |
Records: 4
| Field | Type |
|---|---|
| course_id | int(11) |
| college_id | int(11) |
| category_id | int(11) |
| course_name | varchar(255) |
| course_code | varchar(20) |
| ... and 4 more fields | |
Records: 1
| Field | Type |
|---|---|
| exam_id | int(11) |
| exam_name | varchar(255) |
| exam_type_id | int(11) |
| academic_year_id | int(11) |
| academic_year | varchar(20) |
| ... and 5 more fields | |
Records: 1
| Field | Type |
|---|---|
| college_id | int(11) |
| college_code | varchar(10) |
| college_name | varchar(255) |
| status | enum('Active','Inactive') |
| logo | varchar(255) |
| ... and 3 more fields | |
Records: 62
| Field | Type |
|---|---|
| subject_id | int(11) |
| course_id | int(11) |
| department_id | int(11) |
| subject_code | varchar(20) |
| subject_name | varchar(255) |
| ... and 7 more fields | |