| id |
int(11)
|
|
|
|
| matricula |
varchar(25)
|
utf8mb4_general_ci
|
|
|
| numcliente_microsip |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| nombres |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| apellidos |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| genero |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| fecha_nacimiento |
date
|
|
|
|
| foto |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| email |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| pwd |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| celular |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| empresa |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| curp |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| rfc |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| fecha_alta |
date
|
|
|
|
| fecha_baja |
date
|
|
|
|
| tipo_perfil |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| rol_general |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| id_organizacion |
int(11)
|
|
|
|
| id_jefe_directo |
int(11)
|
|
|
|
| enabled |
tinyint(1)
|
|
|
|
| fecha_registro |
datetime
|
|
|
|
| ultimo_status |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| pin |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| customer_stripe |
varchar(255)
|
utf8mb4_general_ci
|
|
|