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