| id |
int(11)
|
|
|
|
| faculty_id |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| national_id |
varchar(14)
|
utf8mb4_general_ci
|
|
|
| name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| email |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| password |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| phone |
varchar(15)
|
utf8mb4_general_ci
|
|
|
| address |
text
|
utf8mb4_general_ci
|
|
|
| date_of_birth |
date
|
|
|
|
| gender |
enum('male', 'female')
|
utf8mb4_general_ci
|
|
|
| department_id |
int(11)
|
|
|
|
| position |
enum('أستاذ', 'أستاذ مساعد', 'مدرس', 'مدرس مساعد', 'معيد')
|
utf8mb4_general_ci
|
|
|
| academic_degree |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| specialization |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| office_number |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| office_hours |
text
|
utf8mb4_general_ci
|
|
|
| salary |
decimal(10,2)
|
|
|
|
| hire_date |
date
|
|
|
|
| status |
enum('نشط', 'إجازة', 'معاش', 'منتهي الخدمة')
|
utf8mb4_general_ci
|
|
|
| profile_image |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
