|
id
|
bigint(20) unsigned
|
|
|
|
|
employee_code
|
varchar(50)
|
|
|
|
|
nationality
|
varchar(80)
|
|
|
|
|
employment_type
|
varchar(80)
|
|
|
|
|
thai_prefix
|
varchar(30)
|
|
|
|
|
thai_first_name
|
varchar(120)
|
|
|
|
|
thai_last_name
|
varchar(120)
|
|
|
|
|
thai_nickname
|
varchar(80)
|
|
|
|
|
en_prefix
|
varchar(30)
|
|
|
|
|
en_first_name
|
varchar(120)
|
|
|
|
|
en_last_name
|
varchar(120)
|
|
|
|
|
en_nickname
|
varchar(80)
|
|
|
|
|
birth_date
|
date
|
|
|
|
|
start_date
|
date
|
|
|
|
|
position
|
varchar(180)
|
|
|
|
|
department
|
varchar(180)
|
|
|
|
|
company
|
varchar(220)
|
|
|
|
|
phone
|
varchar(80)
|
|
|
|
|
raw_json
|
longtext
|
|
|
|
|
updated_at
|
datetime
|
|
|
2026-10-05 14:26:23.000000
|
|
created_at
|
datetime
|
|
|
2026-10-05 14:26:23.000000
|
|
national_id
|
varchar(50)
|
|
|
|
|
day_119
|
varchar(120)
|
|
|
|
|
age
|
varchar(100)
|
|
|
|
|
bank_name
|
varchar(160)
|
|
|
|
|
bank_account_name
|
varchar(220)
|
|
|
|
|
bank_account_number
|
varchar(100)
|
|
|
|
|
address
|
text
|
|
|
|
|
postal_code
|
varchar(20)
|
|
|
|
|
termination_date
|
date
|
|
|
|
|
termination_reason
|
text
|
|
|
|