| id |
int(11)
|
|
|
|
| id_leccion |
int(11)
|
|
|
|
| tipo |
enum('writing', 'speaking', 'listening', 'reading', 'multiple_choice', 'grammar', 'vocabulary', 'pronunciation', 'interview')
|
utf8mb4_general_ci
|
|
|
| titulo |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| contenido_html |
longtext
|
utf8mb4_general_ci
|
|
|
| dificultad |
int(11)
|
|
|
|
| orden_en_leccion |
int(11)
|
|
|
|
| recipe |
longtext
|
utf8mb4_general_ci
|
|
|
| respuesta_correcta |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| opciones |
longtext
|
utf8mb4_general_ci
|
|
|
| criterios_evaluacion |
longtext
|
utf8mb4_general_ci
|
|
|
| id_template_evaluacion |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| puntaje_aprobatorio |
int(11)
|
|
|
|
| metadatos |
longtext
|
utf8mb4_general_ci
|
|
|
| enabled |
tinyint(1)
|
|
|
|
| fecha_creacion |
timestamp
|
|
|
|