|
id
|
int(11)
|
|
|
|
|
employee_id
|
int(11)
|
|
|
|
|
template_id
|
int(11)
|
|
|
|
|
evaluator_id
|
int(11)
|
|
|
|
|
period_year
|
smallint(6)
|
|
|
|
|
period_quarter
|
tinyint(4)
|
|
|
|
|
period_month
|
tinyint(4)
|
|
|
|
|
eval_date
|
date
|
|
|
|
|
total_score
|
decimal(5,2)
|
|
|
0.00
|
|
max_score
|
decimal(5,2)
|
|
|
100.00
|
|
percentage
|
decimal(5,2)
|
|
|
0.00
|
|
grade
|
enum
|
-- |
|
good
|
|
notes
|
text
|
|
|
|
|
strengths
|
text
|
|
|
|
|
improvements
|
text
|
|
|
|
|
status
|
enum
|
-- |
|
draft
|
|
approved_by
|
int(11)
|
|
|
|
|
approved_at
|
timestamp
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|