id | int(11) |
|
|
|
emp_id | int(11) |
|
|
|
pen_id | varchar(6) |
|
|
|
first_name | varchar(255) |
|
|
|
last_name | varchar(255) |
|
|
|
username | varchar(20) |
|
|
|
password | varchar(100) |
|
|
|
temp_password | varchar(100) |
|
|
|
email | varchar(255) |
|
|
|
gender | varchar(10) |
|
|
|
dob | date |
|
|
|
picture_url | varchar(255) |
|
|
|
profile_url | varchar(255) |
|
|
|
created | datetime |
|
|
CURRENT_TIMESTAMP
|
modified | datetime |
|
|
|
status | varchar(10) |
|
|
|
role | int(1) |
|
|
|
dept | int(2) |
|
|
|
school_id | int(2) |
|
|
|
designation | varchar(100) |
|
|
|
weight | int(2) |
|
|
|
date_modified | timestamp |
|
|
CURRENT_TIMESTAMP
|
mobile | varchar(50) |
|
|
|
intercom | varchar(25) |
|
|
|
phd_supervisor | int(11) |
|
|
1
|
user_type | varchar(10) |
|
|
internal
|