| id |
int(11)
|
|
|
|
| id_ejercicio |
int(11)
|
|
|
|
| modo |
enum('scripted', 'spontaneous')
|
utf8mb4_general_ci
|
|
|
| reference_text |
text
|
utf8mb4_general_ci
|
|
|
| topic_prompt |
text
|
utf8mb4_general_ci
|
|
|
| locale |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| audio_referencia_url |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| audio_referencia_origen |
enum('tts_elevenlabs', 'tts_azure', 'manual')
|
utf8mb4_general_ci
|
|
|
| granularity |
enum('Phoneme', 'Word', 'FullText')
|
utf8mb4_general_ci
|
|
|
| enable_prosody |
tinyint(1)
|
|
|
|
| enable_miscue |
tinyint(1)
|
|
|
|
| nivel_cefr |
varchar(4)
|
utf8mb4_general_ci
|
|
|
| max_duracion_segundos |
int(11)
|
|
|
|
| max_intentos |
int(11)
|
|
|
|
| min_passing_score |
int(11)
|
|
|
|
| grade_weight |
decimal(4,2)
|
|
|
|
| rubrica_accuracy |
decimal(4,2)
|
|
|
|
| rubrica_fluency |
decimal(4,2)
|
|
|
|
| rubrica_completeness |
decimal(4,2)
|
|
|
|
| rubrica_prosody |
decimal(4,2)
|
|
|
|
| regla_calificacion |
enum('mejor_intento', 'promedio', 'ultimo_intento')
|
utf8mb4_general_ci
|
|
|
| enabled |
tinyint(1)
|
|
|
|
| fecha_creacion |
timestamp
|
|
|
|
| fecha_actualizacion |
timestamp
|
|
|
|