Database: glrcf_unified
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(200) | NO | NULL | ||
| unique_name | varchar(150) | YES | UNI | NULL | |
| worker_code | varchar(50) | YES | UNI | NULL | |
| role_type | varchar(50) | YES | specialist | ||
| department | varchar(100) | YES | NULL | ||
| specialization | varchar(255) | YES | NULL | ||
| gender | enum('male','female','other') | YES | other | ||
| voice_id | varchar(100) | YES | NULL | ||
| voice_provider | varchar(50) | YES | elevenlabs | ||
| voice_quality | varchar(50) | YES | masterpiece | ||
| voice_accent | varchar(50) | YES | NULL | ||
| voice_tone | varchar(100) | YES | NULL | ||
| education_level | varchar(100) | YES | world_expert | ||
| specialist_rank | varchar(100) | YES | unparalleled | ||
| field_of_study_primary | varchar(150) | YES | NULL | ||
| years_experience_equivalent | int(11) | YES | 150 | ||
| knowledge_depth | int(11) | YES | 100 | ||
| analytical_thinking | int(11) | YES | 100 | ||
| critical_thinking | int(11) | YES | 100 | ||
| problem_solving_ability | int(11) | YES | 100 | ||
| creativity_score | int(11) | YES | 100 | ||
| memory_capacity | varchar(100) | YES | unlimited | ||
| processing_speed | varchar(100) | YES | instantaneous | ||
| superior_to_humans | tinyint(1) | YES | 1 | ||
| superior_to_collective | tinyint(1) | YES | 1 | ||
| superior_to_world | tinyint(1) | YES | 1 | ||
| appearance_rating | int(11) | YES | 100 | ||
| generation_batch | int(11) | YES | NULL | ||
| worker_number | int(11) | YES | NULL | ||
| status | enum('active','paused','idle','training','inactive') | YES | active | ||
| created_by | int(11) | YES | NULL | ||
| created_at | timestamp | NO | CURRENT_TIMESTAMP | ||
| updated_at | timestamp | NO | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |