| id |
int(11)
|
|
|
|
| contract_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| employee_id |
int(11)
|
|
|
|
| contract_type |
enum('permanent', 'temporary', 'part_time', 'probation', 'renewal')
|
utf8mb4_unicode_ci
|
|
|
| start_date |
date
|
|
|
|
| end_date |
date
|
|
|
|
| basic_salary |
decimal(12,2)
|
|
|
|
| housing_allowance |
decimal(10,2)
|
|
|
|
| transport_allowance |
decimal(10,2)
|
|
|
|
| meal_allowance |
decimal(10,2)
|
|
|
|
| other_allowances |
decimal(10,2)
|
|
|
|
| working_hours |
decimal(4,1)
|
|
|
|
| working_days |
tinyint(4)
|
|
|
|
| probation_months |
tinyint(4)
|
|
|
|
| notice_period_days |
int(11)
|
|
|
|
| status |
enum('draft', 'active', 'expired', 'terminated', 'renewed')
|
utf8mb4_unicode_ci
|
|
|
| termination_reason |
text
|
utf8mb4_unicode_ci
|
|
|
| termination_date |
date
|
|
|
|
| journal_entry_id |
int(11)
|
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| attachment |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
