| id |
int(11)
|
|
|
|
| UserName_User |
varchar(255)
|
latin1_swedish_ci
|
|
|
| Password_User |
varchar(255)
|
latin1_swedish_ci
|
|
|
| Password_User_web |
varchar(255)
|
latin1_swedish_ci
|
|
|
| Type_User |
varchar(255)
|
latin1_swedish_ci
|
|
|
| person_id |
int(11)
|
|
|
|
| Employee_id |
int(11)
|
|
|
|
| dept_id |
varchar(50)
|
latin1_swedish_ci
|
|
|
| ACCESSED |
varchar(255)
|
latin1_swedish_ci
|
|
|
| title_id |
int(11)
|
|
|
|
| project_id |
int(11)
|
|
|
|
| status |
varchar(50)
|
latin1_swedish_ci
|
|
|
| last_login |
timestamp
|
|
|
|
| last_logout |
timestamp
|
|
|
|
| RESTRICT |
varchar(225)
|
latin1_swedish_ci
|
|
|
| email_address |
varchar(50)
|
latin1_swedish_ci
|
|
|
| digital_signature |
longblob
|
|
|
|
| position_id |
int(11)
|
|
|
|
| override |
varchar(50)
|
latin1_swedish_ci
|
|
|
| security |
varchar(50)
|
latin1_swedish_ci
|
|
|
| un_issued |
varchar(20)
|
latin1_swedish_ci
|
|
|
| savedate |
timestamp
|
|
|
|
| IsReset |
int(1)
|
|
|
|
| IMG |
longblob
|
|
|
|
| UserFull_Name |
varchar(255)
|
latin1_swedish_ci
|
|
|
| IsLogin |
int(1)
|
|
|
|
| market_type |
varchar(30)
|
latin1_swedish_ci
|
|
|
| approve_electronic |
varchar(10)
|
latin1_swedish_ci
|
|
|
| leave_approval |
varchar(10)
|
latin1_swedish_ci
|
|
|
| can_upload_esig |
varchar(10)
|
latin1_swedish_ci
|
|
|
| can_access_bio_reg |
varchar(10)
|
latin1_swedish_ci
|
|
|
| auto_head_approved |
varchar(10)
|
latin1_swedish_ci
|
|
|