|
id
|
int(11)
|
|
|
|
|
faculty_id
|
varchar(20)
|
|
|
|
|
national_id
|
varchar(14)
|
|
|
|
|
name
|
varchar(100)
|
|
|
|
|
email
|
varchar(100)
|
|
|
|
|
password
|
varchar(255)
|
|
|
|
|
phone
|
varchar(15)
|
|
|
|
|
address
|
text
|
|
|
|
|
date_of_birth
|
date
|
|
|
|
|
gender
|
enum
|
-- |
|
|
|
department_id
|
int(11)
|
|
|
|
|
position
|
enum
|
-- |
|
|
|
academic_degree
|
varchar(100)
|
|
|
|
|
specialization
|
varchar(100)
|
|
|
|
|
office_number
|
varchar(20)
|
|
|
|
|
office_hours
|
text
|
|
|
|
|
salary
|
decimal(10,2)
|
|
|
|
|
hire_date
|
date
|
|
|
|
|
status
|
enum
|
-- |
|
نشط
|
|
profile_image
|
varchar(255)
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|