| id |
int(11)
|
|
|
|
| staff_code |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| full_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| full_name_en |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| rank_id |
int(11)
|
|
|
|
| department_id |
int(11)
|
|
|
|
| faculty_id |
int(11)
|
|
|
|
| academic_dept_id |
int(11)
|
|
|
|
| section_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| office_location |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| specialization |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| secondary_specialization |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| academic_degree |
enum('phd', 'master', 'bachelor', 'diploma')
|
utf8mb4_unicode_ci
|
|
|
| graduation_university |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| graduation_year |
year(4)
|
|
|
|
| national_id |
varchar(14)
|
utf8mb4_unicode_ci
|
|
|
| email |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| phone |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| hire_date |
date
|
|
|
|
| photo |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| salary_basic |
decimal(12,2)
|
|
|
|
| staff_type |
enum('permanent', 'part_time', 'external', 'delegate')
|
utf8mb4_unicode_ci
|
|
|
| custom_hourly_theory |
decimal(10,2)
|
|
|
|
| custom_hourly_practical |
decimal(10,2)
|
|
|
|
| custom_hourly_extra |
decimal(10,2)
|
|
|
|
| portal_username |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| portal_password |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| portal_active |
tinyint(1)
|
|
|
|
| status |
enum('pending', 'active', 'on_leave', 'suspended', 'retired', 'rejected')
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
timestamp
|
|
|
|
