| id |
int(11)
|
|
|
|
| es_familiar |
tinyint(1)
|
|
|
|
| nombre |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| edad |
int(11)
|
|
|
|
| email |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| telefono |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| nombre_tutor |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| nombre_alumno |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| edad_alumno |
int(11)
|
|
|
|
| email_tutor |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| telefono_tutor |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| programa |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| modalidad |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| referencia |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| mensaje |
text
|
utf8mb4_general_ci
|
|
|
| ip_address |
varchar(45)
|
utf8mb4_general_ci
|
|
|
| user_agent |
text
|
utf8mb4_general_ci
|
|
|
| utm_source |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| utm_medium |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| utm_campaign |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| promo_id |
int(11)
|
|
|
|
| estado |
enum('nuevo', 'contactado', 'en_proceso', 'convertido', 'descartado')
|
utf8mb4_general_ci
|
|
|
| notas |
text
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| idioma |
varchar(2)
|
utf8mb4_general_ci
|
|
|