| 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)
|
|
|
|
| max_score |
decimal(5,2)
|
|
|
|
| percentage |
decimal(5,2)
|
|
|
|
| grade |
enum('excellent', 'very_good', 'good', 'acceptable', 'poor')
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| strengths |
text
|
utf8mb4_unicode_ci
|
|
|
| improvements |
text
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('draft', 'submitted', 'approved')
|
utf8mb4_unicode_ci
|
|
|
| approved_by |
int(11)
|
|
|
|
| approved_at |
timestamp
|
|
|
|
| created_at |
timestamp
|
|
|
|