camaras
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| folio (Primary) | int(11) | No | ||||
| fecha | varchar(20) | No | ||||
| id_cliente | varchar(40) | No | ||||
| usuarioapp | varchar(40) | Yes | NULL | |||
| usuario | varchar(30) | No | ||||
| clave | varchar(30) | No | ||||
| p2p | varchar(20) | Yes | NULL | |||
| qr | varchar(100) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | folio | 49 | A | No |
clientes
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_cliente (Primary) | int(11) | No | ||||
| nombre | varchar(255) | Yes | NULL | |||
| telefono1 | varchar(255) | Yes | NULL | |||
| telefono2 | varchar(255) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_cliente | 5999 | A | No | |
| id_cliente | BTREE | No | No | id_cliente | 5999 | A | No |
ordene
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| folio (Primary) | smallint(11) | No | ||||
| fecha | date | No | ||||
| cliente | varchar(50) | No | ||||
| conceptos | text | No | ||||
| notas | text | Yes | NULL | |||
| telefono | varchar(10) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | folio | 2288 | A | No |
recepcion
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| folio (Primary) | int(11) | No | ||||
| id_cliente | int(11) | Yes | NULL | |||
| equipo | varchar(255) | Yes | NULL | |||
| serie | varchar(255) | Yes | NULL | |||
| problema | varchar(255) | Yes | NULL | |||
| clave | varchar(255) | Yes | NULL | |||
| cpu | varchar(255) | Yes | NULL | |||
| impresora | varchar(255) | Yes | NULL | |||
| cargador | varchar(255) | Yes | NULL | |||
| monitor | varchar(255) | Yes | NULL | |||
| laptop | varchar(255) | Yes | NULL | |||
| maletin | varchar(255) | Yes | NULL | |||
| otros | varchar(255) | Yes | NULL | |||
| recibio | varchar(255) | Yes | NULL | |||
| fecha | datetime | Yes | CURRENT_TIMESTAMP | |||
| pago | varchar(255) | Yes | NULL | |||
| diagnostico | varchar(200) | Yes | NULL | |||
| estado | varchar(50) | Yes | NULL | |||
| fechaentrega | varchar(40) | Yes | NULL | |||
| cobro | varchar(5) | Yes | NULL | |||
| realizo | varchar(30) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | folio | 10568 | A | No | |
| id_cliente | BTREE | No | No | id_cliente | 5284 | A | Yes |
recepcion_detalles
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_detalle (Primary) | int(11) | No | ||||
| folio | int(11) | No | ||||
| equipo | varchar(255) | No | ||||
| serie | varchar(255) | Yes | NULL | |||
| clave | varchar(255) | Yes | NULL | |||
| problema | varchar(255) | No | ||||
| cpu | varchar(255) | Yes | NO | |||
| monitor | varchar(255) | Yes | NO | |||
| cargador | varchar(255) | Yes | NO | |||
| laptop | varchar(255) | Yes | NO | |||
| impresora | varchar(255) | Yes | NO | |||
| maletin | varchar(255) | Yes | NO | |||
| otros | varchar(255) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_detalle | 0 | A | No |