| id |
int(11)
|
|
|
|
| employee_id |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| full_name |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| date_of_joining |
date
|
|
|
|
| time_of_joining |
time
|
|
|
|
| designation |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| working_status |
enum('active', 'vacation', 'resigned', 'terminated')
|
utf8mb4_unicode_ci
|
|
|
| salary |
decimal(12,2)
|
|
|
|
| mobile_number |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| date_of_birth |
date
|
|
|
|
| iqama_id |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| iqama_expiry_date |
date
|
|
|
|
| baladiya_id |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| baladiya_expiry_date |
date
|
|
|
|
| qafala |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| passport_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| passport_expiry_date |
date
|
|
|
|
| nationality |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| address |
text
|
utf8mb4_unicode_ci
|
|
|
| relative_name |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| relative_relation |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| relative_mobile_number |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| employee_photo |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| email_address |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| marital_status |
enum('single', 'married', 'divorced', 'widowed')
|
utf8mb4_unicode_ci
|
|
|
| passport_copy_side_1 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| passport_copy_side_2 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| iqama_copy |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| documents_checklist |
text
|
utf8mb4_unicode_ci
|
|
|
| bank_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| iban_number |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(11)
|
|
|
 Browse foreign values
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
