student_details

993574 rows


Description

Stores Student details

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
user_id VARCHAR 36 √ null
date_of_birth DATE 10 √ null
gender VARCHAR 25 √ null
marital_status VARCHAR 45 √ null
educational_qualification_id VARCHAR 36 √ null
created_at DATETIME 19 √ null
updated_at DATETIME 19 √ null
experience VARCHAR 127 √ null
guardian_name VARCHAR 100 √ null
guardian_mobile VARCHAR 100 √ null
guardian_email VARCHAR 127 √ null
guardian_city VARCHAR 100 √ null
guardian_pincode VARCHAR 15 √ null
guardian_income VARCHAR 100 √ null
guardian_occupation VARCHAR 100 √ null
updated_email VARCHAR 61 √ null
updated_mobile VARCHAR 63 √ null
trade_id VARCHAR 36 √ null
batch_id VARCHAR 36 √ null
old_data_id VARCHAR 36 √ null
placement_status_id VARCHAR 36 √ null
last_month_salary VARCHAR 36 √ null
contactability VARCHAR 36 √ null
not_contactable_reason VARCHAR 100 √ null
interview1_company_name VARCHAR 100 √ null
interview1_date DATETIME 19 √ null
interview1_result VARCHAR 36 √ null
interview2_company_name VARCHAR 100 √ null
interview2_date DATETIME 19 √ null
interview2_result VARCHAR 36 √ null
interview3_company_name VARCHAR 100 √ null
interview3_date DATETIME 19 √ null
interview3_result VARCHAR 36 √ null
placed VARCHAR 50 √ null
month_of_joining VARCHAR 50 √ null
date_of_updation VARCHAR 36 √ null
remarks VARCHAR 50 √ null
active_year TINYINT 3 √ 0
year_of_admission INT 10 √ null
graduation_year INT 10 √ null
placement_support TINYINT 3 √ 0
is_submit TINYINT 3 √ 0
is_vtipoc_approve TINYINT 3 √ 0
is_mande_approve TINYINT 3 √ 0
submitted_at TIMESTAMP 19 √ null
vti_poc_notified_at TIMESTAMP 19 √ null
vti_poc_reviewed_at TIMESTAMP 19 √ null
mande_reviewed_at TIMESTAMP 19 √ null
centre_admin_vti_reject_notified_at TIMESTAMP 19 √ null
mande_vti_approve_notified_at TIMESTAMP 19 √ null
centre_admin_vti_approve_notified_at TIMESTAMP 19 √ null
vti_poc_mande_approve_notified_at TIMESTAMP 19 √ null
centre_admin_mande_approve_notified_at TIMESTAMP 19 √ null
centre_admin_mande_reject_notified_at TIMESTAMP 19 √ null
vti_poc_mande_reject_notified_at TIMESTAMP 19 √ null
submitted_by VARCHAR 36 √ null
created_by VARCHAR 36 √ null
updated_by VARCHAR 36 √ null
deleted_by VARCHAR 36 √ null
deleted_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
contactability Performance Asc contactability
date_of_birth Performance Asc date_of_birth
date_of_updation Performance Asc date_of_updation
educational_qualification_id Performance Asc educational_qualification_id
experience Performance Asc experience
fk_student_details_1_idx Performance Asc user_id
fk_student_details_2_idx Performance Asc batch_id
guardian_income Performance Asc guardian_income
guardian_mobile Performance Asc guardian_mobile
guardian_name Performance Asc guardian_name
guardian_occupation Performance Asc guardian_occupation
idx_sd_user_trade_batch_year Performance Asc/Asc/Asc/Asc user_id + trade_id + batch_id + year_of_admission
interview1_company_name Performance Asc interview1_company_name
interview1_date Performance Asc interview1_date
interview1_result Performance Asc interview1_result
interview2_company_name Performance Asc interview2_company_name
interview2_date Performance Asc interview2_date
interview2_result Performance Asc interview2_result
interview3_company_name Performance Asc interview3_company_name
interview3_date Performance Asc interview3_date
interview3_result Performance Asc interview3_result
last_month_salary Performance Asc last_month_salary
marital_status Performance Asc marital_status
month_of_joining Performance Asc month_of_joining
not_contactable_reason Performance Asc not_contactable_reason
placed Performance Asc placed
student_details_batch_id_IDX Performance Asc batch_id
student_details_id_IDX Performance Asc id
student_details_user_id_IDX Performance Asc user_id
trade_id Performance Asc trade_id

Relationships