| id |
int(11)
|
|
|
|
| cedula |
varchar(13)
|
utf8mb4_unicode_ci
|
|
|
| nombre |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| base_registro_civil |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| cargo |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| departamento |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| telefono |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| email |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| fecha_ingreso |
date
|
|
|
|
| activo |
tinyint(4)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| codigo |
text
|
utf8mb4_unicode_ci
|
|
|
| codcon |
text
|
utf8mb4_unicode_ci
|
|
|
| apel_pater |
text
|
utf8mb4_unicode_ci
|
|
|
| apel_mater |
text
|
utf8mb4_unicode_ci
|
|
|
| nombres |
text
|
utf8mb4_unicode_ci
|
|
|
| razon |
text
|
utf8mb4_unicode_ci
|
|
|
| ruc |
text
|
utf8mb4_unicode_ci
|
|
|
| sexo |
text
|
utf8mb4_unicode_ci
|
|
|
| estado |
text
|
utf8mb4_unicode_ci
|
|
|
| empresa |
text
|
utf8mb4_unicode_ci
|
|
|
| pais |
text
|
utf8mb4_unicode_ci
|
|
|
| ocupacion |
text
|
utf8mb4_unicode_ci
|
|
|
| conyuge |
text
|
utf8mb4_unicode_ci
|
|
|
| cedula_con |
text
|
utf8mb4_unicode_ci
|
|
|
| ciudad |
text
|
utf8mb4_unicode_ci
|
|
|
| zona |
text
|
utf8mb4_unicode_ci
|
|
|
| direcc |
text
|
utf8mb4_unicode_ci
|
|
|
| direcc2 |
text
|
utf8mb4_unicode_ci
|
|
|
| fax |
text
|
utf8mb4_unicode_ci
|
|
|
| observ |
text
|
utf8mb4_unicode_ci
|
|
|
| observ2 |
text
|
utf8mb4_unicode_ci
|
|
|
| limite |
text
|
utf8mb4_unicode_ci
|
|
|
| plazo |
text
|
utf8mb4_unicode_ci
|
|
|
| forma_pago |
text
|
utf8mb4_unicode_ci
|
|
|
| saldo |
text
|
utf8mb4_unicode_ci
|
|
|
| chepro |
text
|
utf8mb4_unicode_ci
|
|
|
| tipo |
text
|
utf8mb4_unicode_ci
|
|
|
| direcc_emp |
text
|
utf8mb4_unicode_ci
|
|
|
| telefo_emp |
text
|
utf8mb4_unicode_ci
|
|
|
| fecha_insc |
text
|
utf8mb4_unicode_ci
|
|
|
| tarifa |
text
|
utf8mb4_unicode_ci
|
|
|
| afiliado |
text
|
utf8mb4_unicode_ci
|
|
|
| tarjeta |
text
|
utf8mb4_unicode_ci
|
|
|
| integrado |
text
|
utf8mb4_unicode_ci
|
|
|
| enviado |
text
|
utf8mb4_unicode_ci
|
|
|
| gafsa |
text
|
utf8mb4_unicode_ci
|
|
|
| notinfpro |
text
|
utf8mb4_unicode_ci
|
|
|
| clinica |
text
|
utf8mb4_unicode_ci
|
|
|
| pordesadi |
text
|
utf8mb4_unicode_ci
|
|
|
| fecha_ingr |
text
|
utf8mb4_unicode_ci
|
|
|
| circuito |
text
|
utf8mb4_unicode_ci
|
|
|
| cupo |
text
|
utf8mb4_unicode_ci
|
|
|
| casa |
text
|
utf8mb4_unicode_ci
|
|
|
| transporte |
text
|
utf8mb4_unicode_ci
|
|
|
| genero |
text
|
utf8mb4_unicode_ci
|
|
|
| fecha_naci |
text
|
utf8mb4_unicode_ci
|
|
|
| nombre_par |
text
|
utf8mb4_unicode_ci
|
|
|
| pariente |
text
|
utf8mb4_unicode_ci
|
|
|
| direcc_par |
text
|
utf8mb4_unicode_ci
|
|
|
| telefo_par |
text
|
utf8mb4_unicode_ci
|
|
|
| iess |
text
|
utf8mb4_unicode_ci
|
|
|
| consultas |
text
|
utf8mb4_unicode_ci
|
|
|
| emplidjef |
text
|
utf8mb4_unicode_ci
|
|
|
| jefe |
text
|
utf8mb4_unicode_ci
|
|
|
| lide |
text
|
utf8mb4_unicode_ci
|
|
|
| refe |
text
|
utf8mb4_unicode_ci
|
|
|
| des_lide |
text
|
utf8mb4_unicode_ci
|
|
|
| des_jefe |
text
|
utf8mb4_unicode_ci
|
|
|
| des_refe |
text
|
utf8mb4_unicode_ci
|
|
|
| celular |
text
|
utf8mb4_unicode_ci
|
|
|
| contacto |
text
|
utf8mb4_unicode_ci
|
|
|
| plazo_real |
text
|
utf8mb4_unicode_ci
|
|
|
| direcc3 |
text
|
utf8mb4_unicode_ci
|
|
|
| direcc4 |
text
|
utf8mb4_unicode_ci
|
|
|
| direcc5 |
text
|
utf8mb4_unicode_ci
|
|
|
| matricula |
text
|
utf8mb4_unicode_ci
|
|
|
| fecha_nac |
text
|
utf8mb4_unicode_ci
|
|
|
| transp |
text
|
utf8mb4_unicode_ci
|
|
|
| lejano |
text
|
utf8mb4_unicode_ci
|
|
|
| con_vive |
text
|
utf8mb4_unicode_ci
|
|
|
| pad_viajan |
text
|
utf8mb4_unicode_ci
|
|
|
| env_sino |
text
|
utf8mb4_unicode_ci
|
|
|
| opera |
text
|
utf8mb4_unicode_ci
|
|
|
| digitado |
text
|
utf8mb4_unicode_ci
|
|
|
| lugar_nac |
text
|
utf8mb4_unicode_ci
|
|
|
| barrio |
text
|
utf8mb4_unicode_ci
|
|
|
| religion |
text
|
utf8mb4_unicode_ci
|
|
|
| par_vive |
text
|
utf8mb4_unicode_ci
|
|
|
| per_financ |
text
|
utf8mb4_unicode_ci
|
|
|
| cua_tiempo |
text
|
utf8mb4_unicode_ci
|
|
|
| cuanto |
text
|
utf8mb4_unicode_ci
|
|
|
| siglas |
text
|
utf8mb4_unicode_ci
|
|
|
| vendedor |
text
|
utf8mb4_unicode_ci
|
|
|
| mens_pen_c |
text
|
utf8mb4_unicode_ci
|
|
|
| mens_tra_c |
text
|
utf8mb4_unicode_ci
|
|
|
| mens_ali_c |
text
|
utf8mb4_unicode_ci
|
|
|
| mens_var_c |
text
|
utf8mb4_unicode_ci
|
|
|
| mens_pen_p |
text
|
utf8mb4_unicode_ci
|
|
|
| mens_tra_p |
text
|
utf8mb4_unicode_ci
|
|
|
| mens_ali_p |
text
|
utf8mb4_unicode_ci
|
|
|
| mens_var_p |
text
|
utf8mb4_unicode_ci
|
|
|
| mens_pen_d |
text
|
utf8mb4_unicode_ci
|
|
|
| mens_tra_d |
text
|
utf8mb4_unicode_ci
|
|
|
| mens_ali_d |
text
|
utf8mb4_unicode_ci
|
|
|
| mens_var_d |
text
|
utf8mb4_unicode_ci
|
|
|
| tarc_num |
text
|
utf8mb4_unicode_ci
|
|
|
| tarc_fec |
text
|
utf8mb4_unicode_ci
|
|
|
| tarc_emi |
text
|
utf8mb4_unicode_ci
|
|
|
| tarc_cod |
text
|
utf8mb4_unicode_ci
|
|
|
| cecorcli |
text
|
utf8mb4_unicode_ci
|
|
|
| pag1cod |
text
|
utf8mb4_unicode_ci
|
|
|
| pag1por |
text
|
utf8mb4_unicode_ci
|
|
|
| pag2cod |
text
|
utf8mb4_unicode_ci
|
|
|
| pag2por |
text
|
utf8mb4_unicode_ci
|
|
|
| foto |
text
|
utf8mb4_unicode_ci
|
|
|
| ret1_ced |
text
|
utf8mb4_unicode_ci
|
|
|
| ret1_nom |
text
|
utf8mb4_unicode_ci
|
|
|
| ret2_ced |
text
|
utf8mb4_unicode_ci
|
|
|
| ret2_nom |
text
|
utf8mb4_unicode_ci
|
|
|
| ret3_ced |
text
|
utf8mb4_unicode_ci
|
|
|
| ret3_nom |
text
|
utf8mb4_unicode_ci
|
|
|
| ret4_ced |
text
|
utf8mb4_unicode_ci
|
|
|
| ret4_nom |
text
|
utf8mb4_unicode_ci
|
|
|
| ret5_ced |
text
|
utf8mb4_unicode_ci
|
|
|
| ret5_nom |
text
|
utf8mb4_unicode_ci
|
|
|
| pernat_jur |
text
|
utf8mb4_unicode_ci
|
|
|
| tipide |
text
|
utf8mb4_unicode_ci
|
|
|
| grupo_id |
int(11)
|
|
|
|
