autorizo
| Column | Type | Null | Default | Comments | MIME |
|---|---|---|---|---|---|
| id | int(11) | No | |||
| tipo | varchar(50) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 5 | A | No |
beneficiario
| Column | Type | Null | Default | Comments | MIME |
|---|---|---|---|---|---|
| id | int(11) | No | |||
| Nombre | varchar(50) | No | |||
| apellido_pat | varchar(50) | No | |||
| apellido_mat | varchar(50) | No | |||
| curp | varchar(18) | No | |||
| rfc | varchar(13) | No | |||
| Monto | int(2) | No | |||
| Motivo | varchar(50) | No | |||
| Status | int(2) | No | |||
| autorizo | int(2) | No | |||
| fecha_cap | timestamp | No | CURRENT_TIMESTAMP | ||
| fechapago | timestamp | No | 0000-00-00 00:00:00 | ||
| direccion | varchar(100) | No | |||
| localidad | varchar(100) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1444 | A | No |
motivo
| Column | Type | Null | Default | Comments | MIME |
|---|---|---|---|---|---|
| id | int(5) | No | |||
| concepto | varchar(40) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 7 | A | No |
personal
| Column | Type | Null | Default | Comments | MIME |
|---|---|---|---|---|---|
| id | int(11) | No | |||
| nombre | varchar(50) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 14 | A | No |
status
| Column | Type | Null | Default | Comments | MIME |
|---|---|---|---|---|---|
| id | int(11) | No | |||
| tipo | varchar(50) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2 | A | No |
tipo_usuario
| Column | Type | Null | Default | Comments | MIME |
|---|---|---|---|---|---|
| id | int(11) | No | |||
| tipo | varchar(50) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 3 | A | No | |
| tipo | FULLTEXT | No | No | tipo | 3 | No |
usuarios
| Column | Type | Null | Default | Comments | MIME |
|---|---|---|---|---|---|
| id | int(11) | No | |||
| usuario | varchar(30) | No | |||
| password | varchar(50) | No | |||
| id_personal | int(11) | No | |||
| id_tipo | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 9 | A | No |