id | int(11) |
|
|
|
reg_id | int(11) |
|
|
|
username | varchar(100) |
|
|
|
name | varchar(100) |
|
|
|
mobile | varchar(50) |
|
|
|
email | varchar(200) |
|
|
|
dob | date |
|
|
|
role | int(11) |
|
|
|
dept_id | int(11) |
|
|
|
status | tinyint(2) |
|
|
0
|
password | varchar(100) |
|
|
|
photo | varchar(250) |
|
|
|
application_submission | tinyint(2) |
|
|
0
|
parta_general_lock | tinyint(4) |
|
|
0
|
already_applied | int(11) |
|
|
|
date_modified | timestamp |
|
|
CURRENT_TIMESTAMP
|
date_created | timestamp |
|
|
0000-00-00 00:00:00.000000
|