| id |
int(11)
|
|
|
|
| admision |
varchar(255)
|
utf8_spanish_ci
|
|
|
| tipo_consulta |
varchar(255)
|
utf8_spanish_ci
|
|
|
| finalidad |
varchar(255)
|
utf8_spanish_ci
|
|
|
| motivo_de_la_consulta |
varchar(255)
|
utf8_spanish_ci
|
|
|
| numero_autorizacion |
varchar(255)
|
utf8_spanish_ci
|
|
|
| acompañante |
varchar(255)
|
utf8_spanish_ci
|
|
|
| parentesco |
varchar(255)
|
utf8_spanish_ci
|
|
|
| motivo_consulta |
text
|
utf8_spanish_ci
|
|
|
| enfermedad_actual |
text
|
utf8_spanish_ci
|
|
|
| patologicos |
varchar(255)
|
utf8_spanish_ci
|
|
|
| quirurgico |
varchar(255)
|
utf8_spanish_ci
|
|
|
| transfucionales |
varchar(255)
|
utf8_spanish_ci
|
|
|
| inmunologicos |
varchar(255)
|
utf8_spanish_ci
|
|
|
| alergico |
varchar(255)
|
utf8_spanish_ci
|
|
|
| traumatico |
varchar(255)
|
utf8_spanish_ci
|
|
|
| psicologicos |
varchar(255)
|
utf8_spanish_ci
|
|
|
| farmacologicos |
varchar(255)
|
utf8_spanish_ci
|
|
|
| familiares |
varchar(255)
|
utf8_spanish_ci
|
|
|
| toxicos |
varchar(255)
|
utf8_spanish_ci
|
|
|
| ginecologicos |
varchar(255)
|
utf8_spanish_ci
|
|
|
| menarquia |
varchar(255)
|
utf8_spanish_ci
|
|
|
| fum |
date
|
|
|
|
| ciclo |
varchar(255)
|
utf8_spanish_ci
|
|
|
| duracion |
varchar(255)
|
utf8_spanish_ci
|
|
|
| citología_cervico_uterina |
varchar(255)
|
utf8_spanish_ci
|
|
|
| mamografia |
varchar(255)
|
utf8_spanish_ci
|
|
|
| metodo_de_planificación_familiar |
varchar(255)
|
utf8_spanish_ci
|
|
|
| g |
varchar(255)
|
utf8_spanish_ci
|
|
|
| p |
varchar(255)
|
utf8_spanish_ci
|
|
|
| a |
varchar(255)
|
utf8_spanish_ci
|
|
|
| c |
varchar(255)
|
utf8_spanish_ci
|
|
|
| e |
varchar(255)
|
utf8_spanish_ci
|
|
|
| v |
varchar(255)
|
utf8_spanish_ci
|
|
|
| m |
varchar(255)
|
utf8_spanish_ci
|
|
|
| otros |
varchar(255)
|
utf8_spanish_ci
|
|
|
| aparato_digestivo |
text
|
utf8_spanish_ci
|
|
|
| aparato_cardiovascular |
text
|
utf8_spanish_ci
|
|
|
| aparato_respiratorio |
text
|
utf8_spanish_ci
|
|
|
| aparato_urinario |
text
|
utf8_spanish_ci
|
|
|
| aparato_genital |
text
|
utf8_spanish_ci
|
|
|
| aparato_hematologico |
text
|
utf8_spanish_ci
|
|
|
| sistema_endocrino |
text
|
utf8_spanish_ci
|
|
|
| sistema_osteomuscular |
text
|
utf8_spanish_ci
|
|
|
| sistema_nervioso |
text
|
utf8_spanish_ci
|
|
|
| sistema_sensorial |
text
|
utf8_spanish_ci
|
|
|
| psicosomatico |
text
|
utf8_spanish_ci
|
|
|
| trigliceridos |
varchar(255)
|
utf8_spanish_ci
|
|
|
| colesterol_total |
varchar(255)
|
utf8_spanish_ci
|
|
|
| colesterol_hdl |
varchar(255)
|
utf8_spanish_ci
|
|
|
| colesterol_ldl |
varchar(255)
|
utf8_spanish_ci
|
|
|
| presion_sistolica |
varchar(255)
|
utf8_spanish_ci
|
|
|
| presion_diastolica |
varchar(255)
|
utf8_spanish_ci
|
|
|
| presion_media |
varchar(255)
|
utf8_spanish_ci
|
|
|
| frecuencia_cardiaca |
varchar(255)
|
utf8_spanish_ci
|
|
|
| frecuencia_respiratoria |
varchar(255)
|
utf8_spanish_ci
|
|
|
| temperatura |
varchar(255)
|
utf8_spanish_ci
|
|
|
| peso |
varchar(255)
|
utf8_spanish_ci
|
|
|
| talla |
varchar(255)
|
utf8_spanish_ci
|
|
|
| imc |
varchar(255)
|
utf8_spanish_ci
|
|
|
| saturacion_02 |
varchar(255)
|
utf8_spanish_ci
|
|
|
| tacto_rectal |
varchar(255)
|
utf8_spanish_ci
|
|
|
| cabeza |
text
|
utf8_spanish_ci
|
|
|
| ojos |
text
|
utf8_spanish_ci
|
|
|
| orl |
text
|
utf8_spanish_ci
|
|
|
| cuello |
text
|
utf8_spanish_ci
|
|
|
| torax |
text
|
utf8_spanish_ci
|
|
|
| abdomen |
text
|
utf8_spanish_ci
|
|
|
| genitourinario |
text
|
utf8_spanish_ci
|
|
|
| extremidades |
text
|
utf8_spanish_ci
|
|
|
| neurologia |
text
|
utf8_spanish_ci
|
|
|
| piel |
text
|
utf8_spanish_ci
|
|
|
| observaciones |
text
|
utf8_spanish_ci
|
|
|
| sintomatico_respiratorio |
varchar(255)
|
utf8_spanish_ci
|
|
|
| sintomatico_piel |
varchar(255)
|
utf8_spanish_ci
|
|
|
| diagnostico_PPAL |
varchar(255)
|
utf8_spanish_ci
|
|
|
| diagnostico_relacionado_1 |
varchar(255)
|
utf8_spanish_ci
|
|
|
| diagnostico_relacionado_2 |
varchar(255)
|
utf8_spanish_ci
|
|
|
| diagnostico_relacionado_3 |
varchar(255)
|
utf8_spanish_ci
|
|
|
| analisis |
text
|
utf8_spanish_ci
|
|
|
| plan_de_manejo |
text
|
utf8_spanish_ci
|
|
|
| ordenes_medicamentos |
varchar(255)
|
utf8_spanish_ci
|
|
|
| laboratorio_clinico |
varchar(255)
|
utf8_spanish_ci
|
|
|
| imagenes_dx |
varchar(255)
|
utf8_spanish_ci
|
|
|
| incapacidad |
varchar(255)
|
utf8_spanish_ci
|
|
|
| recomendaciones |
varchar(255)
|
utf8_spanish_ci
|
|
|
| remision |
varchar(255)
|
utf8_spanish_ci
|
|
|
| procedimientos |
varchar(255)
|
utf8_spanish_ci
|
|
|
| control |
varchar(255)
|
utf8_spanish_ci
|
|
|
| primera_infancia |
varchar(255)
|
utf8_spanish_ci
|
|
|
| infancia |
varchar(255)
|
utf8_spanish_ci
|
|
|
| adolescencia |
varchar(255)
|
utf8_spanish_ci
|
|
|
| juventud |
varchar(255)
|
utf8_spanish_ci
|
|
|
| adultez |
varchar(255)
|
utf8_spanish_ci
|
|
|
| planificacion_familiar |
varchar(255)
|
utf8_spanish_ci
|
|
|
| ruta_materna_perinatal |
varchar(255)
|
utf8_spanish_ci
|
|
|
| agudeza_visual |
varchar(255)
|
utf8_spanish_ci
|
|
|
| tipo_diagnostico_consulta |
varchar(255)
|
utf8_spanish_ci
|
|
|
| medico |
varchar(255)
|
utf8_spanish_ci
|
|
|
| fecha_historia |
timestamp
|
|
|
|
