id | int(11) |
|
|
|
student_id | int(11) |
|
|
|
program_id | int(11) |
|
|
|
reg_number | varchar(20) |
|
|
|
name | varchar(200) |
|
|
|
year_joined | int(11) |
|
|
|
program | varchar(200) |
|
|
|
department | varchar(200) |
|
|
|
hardcore_credit | int(11) |
|
|
|
softcore_credit | int(11) |
|
|
|
total_credit | int(11) |
|
|
|
cgpa | varchar(10) |
|
|
|
class | varchar(20) |
|
|
|
session | varchar(10) |
|
|
|
year_passing | int(11) |
|
|
|
date_created | datetime |
|
|
|
date_modified | datetime |
|
|
CURRENT_TIMESTAMP
|