| id |
int(11)
|
|
|
|
| employee_code |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| biometric_id |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| bank_account_no |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| bank_account_name |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| payroll_account_status |
enum('pending', 'active', 'inactive', 'closed')
|
utf8mb4_general_ci
|
|
|
| bank_name |
varchar(60)
|
utf8mb4_general_ci
|
|
|
| first_name |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| middle_name |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| last_name |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| suffix |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| nickname |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| position |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| job_title |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| branch_location |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| department |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| payroll_type |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| shift_id |
int(11)
|
|
|
|
| rest_day |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| daily_rate |
decimal(12,2)
|
|
|
|
| salary_type |
enum('daily', 'monthly', 'hourly')
|
utf8mb4_general_ci
|
|
|
| monthly_salary |
decimal(12,2)
|
|
|
|
| hourly_rate |
decimal(12,4)
|
|
|
|
| date_hired |
date
|
|
|
|
| date_regularized |
date
|
|
|
|
| contract_start_date |
date
|
|
|
|
| contract_end_date |
date
|
|
|
|
| probationary_end_date |
date
|
|
|
|
| supervisor_id |
int(11)
|
|
|
|
| birthdate |
date
|
|
|
|
| gender |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| civil_status |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| nationality |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| religion |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| contact_no |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| personal_email |
varchar(160)
|
utf8mb4_general_ci
|
|
|
| emergency_contact_name |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| emergency_contact_no |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| emergency_relationship |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| emergency_contact_address |
text
|
utf8mb4_general_ci
|
|
|
| address |
text
|
utf8mb4_general_ci
|
|
|
| sss_no |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| philhealth_no |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| pagibig_no |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| tin_no |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| bir_tax_status |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| rdo_code |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| status |
enum('active', 'inactive')
|
utf8mb4_general_ci
|
|
|
| employment_status |
enum('probationary', 'regular', 'project-based', 'contractual', 'resigned', 'terminated')
|
utf8mb4_general_ci
|
|
|
| active_flag |
tinyint(1)
|
|
|
|
| face_image |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| employee_photo |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| face_descriptor |
longtext
|
utf8mb4_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
