| id |
int(11)
|
|
|
|
| numero_socio |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| id_usuario |
int(11)
|
|
|
|
| tipo_socio |
enum('socio_pago', 'american_spaces', 'alumni', 'encargado')
|
utf8mb4_general_ci
|
|
|
| nombres |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| apellidos |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| ine |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| foto_ine |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| telefono |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| correo |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| genero |
char(1)
|
utf8mb4_general_ci
|
|
|
| rango_edad |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| empresa |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| observaciones |
text
|
utf8mb4_general_ci
|
|
|
| rfc |
varchar(15)
|
utf8mb4_general_ci
|
|
|
| razon_social |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| regimen_fiscal |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| codigo_postal_fiscal |
varchar(5)
|
utf8mb4_general_ci
|
|
|
| requiere_factura |
tinyint(1)
|
|
|
|
| acepto_terminos |
tinyint(1)
|
|
|
|
| fecha_acepto_terminos |
datetime
|
|
|
|
| email_bienvenida_enviado |
tinyint(1)
|
|
|
|
| metadatos |
longtext
|
utf8mb4_general_ci
|
|
|
| fecha_registro |
datetime
|
|
|
|
| registrado_por |
int(11)
|
|
|
|
| enabled |
tinyint(1)
|
|
|
|