|
id
|
int(11)
|
|
|
|
|
emp_id
|
int(11)
|
|
|
|
|
pen_id
|
varchar(6)
|
utf8_unicode_ci
|
|
|
|
first_name
|
varchar(255)
|
utf8_unicode_ci
|
|
|
|
last_name
|
varchar(255)
|
utf8_unicode_ci
|
|
|
|
username
|
varchar(50)
|
utf8_unicode_ci
|
|
|
|
password
|
varchar(100)
|
utf8_unicode_ci
|
|
|
|
temp_password
|
varchar(100)
|
utf8_unicode_ci
|
|
|
|
email
|
text
|
utf8_unicode_ci
|
|
|
|
pumail
|
varchar(100)
|
utf8_unicode_ci
|
|
|
|
gender
|
varchar(10)
|
utf8_unicode_ci
|
|
|
|
dob
|
date
|
|
|
|
|
picture_url
|
varchar(255)
|
utf8_unicode_ci
|
|
|
|
profile_url
|
varchar(255)
|
utf8_unicode_ci
|
|
|
|
created
|
datetime
|
|
|
|
|
modified
|
datetime
|
|
|
|
|
status
|
varchar(10)
|
utf8_unicode_ci
|
|
|
|
role
|
int(1)
|
|
|
|
|
dept
|
int(2)
|
|
|
|
|
school_id
|
int(2)
|
|
|
|
|
designation
|
varchar(100)
|
utf8_unicode_ci
|
|
|
|
weight
|
int(2)
|
|
|
|
|
date_modified
|
timestamp
|
|
|
|
|
mobile
|
varchar(50)
|
utf8_unicode_ci
|
|
|
|
intercom
|
varchar(25)
|
utf8_unicode_ci
|
|
|
|
phd_supervisor
|
int(11)
|
|
|
|
|
user_type
|
varchar(10)
|
utf8_unicode_ci
|
|
|
|
oauth_provider
|
varchar(10)
|
utf8_unicode_ci
|
|
|
|
oauth_uid
|
varchar(50)
|
utf8_unicode_ci
|
|
|
|
glogin_id
|
varchar(255)
|
utf8_unicode_ci
|
|
|
|
gpicture
|
varchar(255)
|
utf8_unicode_ci
|
|
|
|
locale
|
varchar(10)
|
utf8_unicode_ci
|
|
|
|
picture
|
varchar(255)
|
utf8_unicode_ci
|
|
|
|
link
|
varchar(255)
|
utf8_unicode_ci
|
|
|
