| id |
bigint(20)
|
|
|
|
| cycle_id |
int(10)
|
|
|
|
| subject_type |
enum('school', 'office')
|
utf8mb4_unicode_ci
|
|
|
| school_id |
int(10)
|
|
|
Browse foreign values
|
| office_id |
int(10)
|
|
|
|
| instrument_code |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| accountable_employee_id |
int(10)
|
|
|
Browse foreign values
|
| rater_user_id |
int(10)
|
|
|
|
| approving_user_id |
int(10)
|
|
|
|
| current_phase |
enum('planning', 'monitoring', 'evaluation', 'development', 'closed')
|
utf8mb4_unicode_ci
|
|
|
| plan_status |
enum('not_started', 'draft', 'submitted', 'returned', 'rater_concurred', 'approved')
|
utf8mb4_unicode_ci
|
|
|
| monitoring_status |
enum('not_started', 'active', 'completed')
|
utf8mb4_unicode_ci
|
|
|
| evaluation_status |
enum('not_started', 'self_assessment', 'rater_review', 'validation', 'approved', 'finalized')
|
utf8mb4_unicode_ci
|
|
|
| overall_rating |
decimal(6,2)
|
|
|
|
| adjectival_rating |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| legacy_rating_id |
int(11)
|
|
|
|
| legacy_rating_source |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(10)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|