| id |
int(11)
|
|
|
|
| employee_code |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| salutation |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| first_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| last_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| middle_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| extension_name |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| nickname |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| gender |
enum('Male', 'Female')
|
utf8mb4_general_ci
|
|
|
| birth_date |
date
|
|
|
|
| nationality |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| marital_status |
enum('Single', 'Married', 'Widowed', 'Separated', 'Divorced')
|
utf8mb4_general_ci
|
|
|
| personal_email |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| work_email |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| mobile_number |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| telephone_number |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| address_street |
text
|
utf8mb4_general_ci
|
|
|
| city |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| province |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| zip_code |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| country |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| emergency_contact_name |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| emergency_contact_relation |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| emergency_contact_phone |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| sss_number |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| philhealth_number |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| pagibig_number |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| tin_number |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| drivers_license |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| passport_number |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| department_id |
int(11)
|
|
|
|
| position |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| department_id_2 |
int(11)
|
|
|
|
| position_2 |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| employment_status |
enum('Regular', 'Probationary', 'Contractual', 'Seasonal', 'Casual', 'Fixed Term', 'Project Based', 'Part Time', 'Full Time')
|
utf8mb4_general_ci
|
|
|
| status |
enum('Active', 'Inactive', 'AWOL', 'Resigned', 'Terminated', 'End of Contract')
|
utf8mb4_general_ci
|
|
|
| date_hired |
date
|
|
|
|
| date_regularized |
date
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| profile_picture |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| sss_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| philhealth_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| pagibig_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| tin_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| branch |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| holiday_exempted |
enum('Yes', 'No')
|
utf8mb4_general_ci
|
|
|
| picture_2x2_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| coe_tor_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| birth_cert_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| nbi_clearance_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| police_clearance_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| cutoff_1 |
int(11)
|
|
|
|
| cutoff_2 |
int(11)
|
|
|
|
| payroll_1 |
int(11)
|
|
|
|
| payroll_2 |
int(11)
|
|
|
|
| salary_type |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| basic_salary |
decimal(10,2)
|
|
|
|
| hourly_rate |
decimal(10,2)
|
|
|
|
| fixed_rate |
decimal(10,2)
|
|
|
|
| daily_rate |
decimal(10,2)
|
|
|
|
