|
id
|
int(11)
|
|
|
|
|
id_emp
|
int(11)
|
|
|
|
|
name
|
varchar(100)
|
utf8mb4_general_ci
|
|
|
|
house
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
designation
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
cell
|
varchar(15)
|
utf8mb4_general_ci
|
|
|
|
id_card
|
varchar(200)
|
utf8mb4_general_ci
|
|
|
|
salary_per_month
|
decimal(10,2)
|
|
|
|
|
emergency_contact
|
varchar(15)
|
utf8mb4_general_ci
|
|
|
|
date_of_birth
|
date
|
|
|
|
|
gender
|
varchar(10)
|
utf8mb4_general_ci
|
|
|
|
marital_status
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
current_address
|
varchar(255)
|
utf8mb4_general_ci
|
|
|
|
point
|
varchar(10)
|
utf8mb4_general_ci
|
|
|
|
joining_date
|
date
|
|
|
|
|
bank_transfer_option
|
varchar(10)
|
utf8mb4_general_ci
|
|
|
|
title_name
|
varchar(100)
|
utf8mb4_general_ci
|
|
|
|
BeneficiaryBankCode
|
int(11)
|
|
|
|
|
ProductTypeCode
|
varchar(200)
|
utf8mb4_general_ci
|
|
|
|
bank_name
|
varchar(100)
|
utf8mb4_general_ci
|
|
|
|
account_number
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
uniform_info
|
varchar(100)
|
utf8mb4_general_ci
|
|
|
|
status
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
branch
|
varchar(200)
|
utf8mb4_general_ci
|
|
|
|
post_date
|
date
|
|
|
|
|
hous
|
varchar(100)
|
utf8mb4_general_ci
|
|
|
