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