|
id
|
int(11)
|
|
|
|
|
em_id
|
varchar(64)
|
latin1_swedish_ci
|
|
|
|
em_code
|
varchar(64)
|
latin1_swedish_ci
|
|
|
|
des_id
|
int(11)
|
|
|
|
|
dep_id
|
int(11)
|
|
|
|
|
first_name
|
varchar(128)
|
latin1_swedish_ci
|
|
|
|
last_name
|
varchar(128)
|
latin1_swedish_ci
|
|
|
|
em_email
|
varchar(64)
|
latin1_swedish_ci
|
|
|
|
em_password
|
varchar(512)
|
latin1_swedish_ci
|
|
|
|
em_role
|
enum('ADMIN', 'EMPLOYEE', 'SUPER ADMIN')
|
latin1_swedish_ci
|
|
|
|
em_address
|
varchar(512)
|
latin1_swedish_ci
|
|
|
|
status
|
enum('ACTIVE', 'INACTIVE')
|
latin1_swedish_ci
|
|
|
|
em_gender
|
enum('Male', 'Female')
|
latin1_swedish_ci
|
|
|
|
em_phone
|
varchar(64)
|
latin1_swedish_ci
|
|
|
|
em_birthday
|
varchar(128)
|
latin1_swedish_ci
|
|
|
|
em_blood_group
|
enum('O+', 'O-', 'A+', 'A-', 'B+', 'B-', 'AB+', 'OB+')
|
latin1_swedish_ci
|
|
|
|
em_joining_date
|
varchar(128)
|
latin1_swedish_ci
|
|
|
|
em_contact_end
|
varchar(128)
|
latin1_swedish_ci
|
|
|
|
em_image
|
varchar(128)
|
latin1_swedish_ci
|
|
|
|
em_nid
|
varchar(64)
|
latin1_swedish_ci
|
|
|
