| id |
int(10)
|
|
|
|
| company_id |
int(10)
|
|
|
|
| employee_id |
int(10)
|
|
|
|
| wage_type |
enum('monthly', 'hourly')
|
utf8mb4_czech_ci
|
|
|
| base_wage |
decimal(12,2)
|
|
|
|
| personal_bonus |
decimal(12,2)
|
|
|
|
| avg_earning |
decimal(12,2)
|
|
|
|
| meal_allowance |
decimal(10,2)
|
|
|
|
| birth_number |
varchar(15)
|
utf8mb4_czech_ci
|
|
|
| birth_date |
date
|
|
|
|
| birth_place |
varchar(100)
|
utf8mb4_czech_ci
|
|
|
| birth_surname |
varchar(60)
|
utf8mb4_czech_ci
|
|
|
| birth_country |
char(2)
|
utf8mb4_czech_ci
|
|
|
| education |
char(1)
|
utf8mb4_czech_ci
|
|
|
| cz_isco |
char(5)
|
utf8mb4_czech_ci
|
|
|
| is_manager |
tinyint(1)
|
|
|
|
| work_mode |
tinyint(3)
|
|
|
|
| continuous_op |
tinyint(1)
|
|
|
|
| work_place |
varchar(200)
|
utf8mb4_czech_ci
|
|
|
| work_municode |
char(6)
|
utf8mb4_czech_ci
|
|
|
| pension_type |
char(1)
|
utf8mb4_czech_ci
|
|
|
| pension_from |
date
|
|
|
|
| pension_early |
tinyint(1)
|
|
|
|
| pension_reduced_age |
tinyint(1)
|
|
|
|
| health_restriction |
char(1)
|
utf8mb4_czech_ci
|
|
|
| health_restriction_from |
date
|
|
|
|
| citizenship |
varchar(3)
|
utf8mb4_czech_ci
|
|
|
| gender |
enum('M', 'F')
|
utf8mb4_czech_ci
|
|
|
| street |
varchar(150)
|
utf8mb4_czech_ci
|
|
|
| city |
varchar(100)
|
utf8mb4_czech_ci
|
|
|
| zip |
varchar(10)
|
utf8mb4_czech_ci
|
|
|
| country |
varchar(3)
|
utf8mb4_czech_ci
|
|
|
| health_insurer |
varchar(3)
|
utf8mb4_czech_ci
|
|
|
| si_participation |
tinyint(1)
|
|
|
|
| hi_participation |
tinyint(1)
|
|
|
|
| hi_state_insured |
tinyint(1)
|
|
|
|
| tax_declaration |
tinyint(1)
|
|
|
|
| credit_taxpayer |
tinyint(1)
|
|
|
|
| credit_disability |
enum('none', 'level12', 'level3', 'ztpp')
|
utf8mb4_czech_ci
|
|
|
| credit_student |
tinyint(1)
|
|
|
|
| contract_start |
date
|
|
|
|
| contract_end |
date
|
|
|
|
| contract_signed |
date
|
|
|
|
| weekly_hours |
decimal(5,2)
|
|
|
|
| payout_method |
enum('bank', 'cash')
|
utf8mb4_czech_ci
|
|
|
| bank_account |
varchar(30)
|
utf8mb4_czech_ci
|
|
|
| bank_code |
varchar(5)
|
utf8mb4_czech_ci
|
|
|
| note |
text
|
utf8mb4_czech_ci
|
|
|
| updated_at |
datetime
|
|
|
|
| ik_mpsv |
char(10)
|
utf8mb4_czech_ci
|
|
|
| id_ppv |
varchar(22)
|
utf8mb4_czech_ci
|
|
|
