id | int(11) |
|
|
|
student_id | int(11) |
|
|
|
reg_no | varchar(15) |
|
|
|
guide_id | int(11) |
|
|
0
|
guide_type | varchar(10) |
|
|
internal
|
co_guide_id | int(11) |
|
|
0
|
recognized_supervisor | tinyint(4) |
|
|
0
|
research_title | varchar(1000) |
|
|
|
date_registration | date |
|
|
2017-06-01
|
date_joining | date |
|
|
2017-06-01
|
phd_status | tinyint(4) |
|
|
|
phd_type | int(11) |
|
|
|
degree | int(2) |
|
|
|
selection | int(11) |
|
|
|
fellowship_amount | int(6) |
|
|
0
|
fellowship_expiry | date |
|
|
|
phd_stage | tinyint(4) |
|
|
1
|
extension | tinyint(4) |
|
|
0
|
broad_research_field | varchar(1000) |
|
|
|
provisional_registration_status | tinyint(4) |
|
|
0
|
dc_members_constitution_status | tinyint(4) |
|
|
0
|
course_work_exemption | tinyint(4) |
|
|
0
|
course_work_status | tinyint(4) |
|
|
0
|
synopsis_status | tinyint(4) |
|
|
0
|
synopsis_date | datetime |
|
|
|
synopsis_venue | varchar(255) |
|
|
|
examiner_status | tinyint(4) |
|
|
0
|
examiner1 | int(11) |
|
|
|
examiner2 | int(11) |
|
|
|
examiner3 | int(11) |
|
|
|
examiner4 | int(11) |
|
|
|
examiner5 | int(11) |
|
|
|
thesis_status | tinyint(4) |
|
|
0
|
examiner1_communication | tinyint(4) |
|
|
0
|
examiner2_communication | tinyint(4) |
|
|
0
|
examiner3_communication | tinyint(4) |
|
|
0
|
examiner1_review | tinyint(4) |
|
|
0
|
examiner2_review | tinyint(4) |
|
|
0
|
examiner3_review | tinyint(4) |
|
|
0
|
examiner_viva | int(11) |
|
|
0
|
consolidated_report | tinyint(4) |
|
|
0
|
viva_status | tinyint(4) |
|
|
0
|
viva_date | datetime |
|
|
|
viva_venue | varchar(255) |
|
|
|
extension_status1 | tinyint(4) |
|
|
0
|
extension_status2 | tinyint(4) |
|
|
0
|
extension_status3 | tinyint(4) |
|
|
0
|
extension_status4 | tinyint(4) |
|
|
0
|
extension_status5 | tinyint(4) |
|
|
0
|
extension_status6 | tinyint(4) |
|
|
0
|
extension_status7 | tinyint(4) |
|
|
0
|
extension_status8 | tinyint(4) |
|
|
0
|
extension_status9 | tinyint(4) |
|
|
0
|
extension_status10 | tinyint(4) |
|
|
0
|
leave_taken | int(2) |
|
|
0
|
date_modified | datetime |
|
|
CURRENT_TIMESTAMP
|
date_created | timestamp |
|
|
CURRENT_TIMESTAMP
|