|
id
|
int(11)
|
|
|
|
|
DeptCode
|
varchar(15)
|
|
|
|
|
EmployeeName
|
text
|
|
|
|
|
firstname
|
varchar(150)
|
|
|
|
|
lastname
|
varchar(150)
|
|
|
|
|
phone
|
varchar(200)
|
|
|
|
|
EmployeeId
|
varchar(6)
|
|
|
|
|
Password
|
varchar(255)
|
|
|
|
|
EmployeeActive
|
text
|
|
|
|
|
Reporting
|
varchar(50)
|
|
|
|
|
Lastupddt
|
date
|
|
|
|
|
Lastupdby
|
varchar(25)
|
|
|
|
|
EmployeeEmail
|
varchar(255)
|
|
|
|