id | int(4) |
|
|
|
name | varchar(50) |
|
|
|
reg_id | varchar(10) |
|
|
|
app_no | int(10) |
|
|
|
lib_id | varchar(10) |
|
|
|
dob | date |
|
|
|
role | tinyint(4) |
|
|
|
program_type | tinyint(4) |
|
|
|
program_code | varchar(6) |
|
|
|
reg_number | varchar(15) |
|
|
|
year_joined | year(4) |
|
|
|
program_id | int(3) |
|
|
|
dept_id | int(3) |
|
|
|
password | varchar(100) |
|
|
|
finalized | tinyint(1) |
|
|
0
|
created | datetime |
|
|
|
date_modified | timestamp |
|
|
CURRENT_TIMESTAMP
|
locked | int(1) |
|
|
0
|
password_reset | int(1) |
|
|
0
|
status | int(1) |
|
|
1
|