|
id
|
int(11)
|
|
|
|
|
id_ejercicio
|
int(11)
|
|
|
|
|
modo
|
enum
|
-- |
|
scripted
|
|
reference_text
|
text
|
|
|
|
|
topic_prompt
|
text
|
|
|
|
|
locale
|
varchar(10)
|
|
|
en-US
|
|
audio_referencia_url
|
varchar(500)
|
|
|
|
|
audio_referencia_origen
|
enum
|
-- |
|
|
|
granularity
|
enum
|
-- |
|
Phoneme
|
|
enable_prosody
|
tinyint(1)
|
|
|
1
|
|
enable_miscue
|
tinyint(1)
|
|
|
1
|
|
nivel_cefr
|
varchar(4)
|
|
|
|
|
max_duracion_segundos
|
int(11)
|
|
|
60
|
|
max_intentos
|
int(11)
|
|
|
5
|
|
min_passing_score
|
int(11)
|
|
|
70
|
|
grade_weight
|
decimal(4,2)
|
|
|
1.00
|
|
rubrica_accuracy
|
decimal(4,2)
|
|
|
0.40
|
|
rubrica_fluency
|
decimal(4,2)
|
|
|
0.30
|
|
rubrica_completeness
|
decimal(4,2)
|
|
|
0.20
|
|
rubrica_prosody
|
decimal(4,2)
|
|
|
0.10
|
|
regla_calificacion
|
enum
|
-- |
|
mejor_intento
|
|
enabled
|
tinyint(1)
|
|
|
1
|
|
fecha_creacion
|
timestamp
|
|
|
current_timestamp()
|
|
fecha_actualizacion
|
timestamp
|
|
|
current_timestamp()
|