|
userid
|
int(11)
|
|
|
|
|
username
|
varchar(20)
|
|
|
|
|
fullname
|
varchar(50)
|
|
|
|
|
password
|
varchar(20)
|
|
|
|
|
degid
|
int(11)
|
|
|
|
|
phone
|
varchar(25)
|
|
|
|
|
email
|
varchar(50)
|
|
|
|
|
managerid
|
int(11)
|
|
|
|
|
deptid
|
int(11)
|
|
|
|
|
sign
|
varchar(100)
|
|
|
|
|
team
|
varchar(3)
|
|
|
|
|
joindate
|
date
|
|
|
|
|
activate
|
enum
|
-- |
|
Y
|
|
comments
|
varchar(255)
|
|
|
|
|
empuserid
|
int(11)
|
|
|
|
|
passupdate
|
timestamp
|
|
|
|
|
aprovlvid
|
int(11)
|
|
|
0
|
|
isacholder
|
enum
|
-- |
|
N
|
|
isaprovauthority
|
enum
|
-- |
|
N
|
|
user_ref
|
varchar(15)
|
|
|
|
|
usercode
|
varchar(8)
|
|
|
|
|
fab_ana_group
|
varchar(50)
|
|
|
USER
|
|
iom_stock_upd
|
varchar(1)
|
|
|
N
|