| id |
int(11)
|
|
|
|
| employee_no |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| english_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| quote_owner_code |
varchar(5)
|
utf8mb4_general_ci
|
|
|
| department_id |
int(11)
|
|
|
|
| position |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| email |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| tel |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| ext |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| mobile |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| hire_date |
date
|
|
|
|
| resign_date |
date
|
|
|
|
| status |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| emergency_contact |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| emergency_phone |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| address |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| photo_path |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| note |
text
|
utf8mb4_general_ci
|
|
|
| user_id |
int(11)
|
|
|
|
| created_by |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| sort_order |
int(11)
|
|
|
|
| manager_id |
int(11)
|
|
|
|
| position_id |
int(11)
|
|
|
|
| gender |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| birthday |
date
|
|
|
|
| id_no |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| line_id |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| nationality |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| blood_type |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| bank_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| bank_account |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| insurance_no |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| labor_insurance_mode |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| labor_fixed_deduction |
decimal(12,2)
|
|
|
|
| health_insurance_mode |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| health_fixed_deduction |
decimal(12,2)
|
|
|
|
| health_dependents |
int(11)
|
|
|
|
| annual_leave_policy |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| annual_leave_extra_days |
int(11)
|
|
|
|
| annual_leave_extra_note |
text
|
utf8mb4_general_ci
|
|
|
