🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
🧬 Columnas: prestashop / ps_delivery
8| Campo | Tipo | Null | Key | Default | Extra |
|---|
| id_delivery | int(10) unsigned | NO | PRI | | auto_increment |
| id_shop | int(10) unsigned | YES | | | |
| id_shop_group | int(10) unsigned | YES | | | |
| id_carrier | int(10) unsigned | NO | MUL | | |
| id_range_price | int(10) unsigned | YES | MUL | | |
| id_range_weight | int(10) unsigned | YES | MUL | | |
| id_zone | int(10) unsigned | NO | MUL | | |
| price | decimal(20,6) | NO | | | |
🔬 Muestra de datos
16 filas
| id_delivery | id_shop | id_shop_group | id_carrier | id_range_price | id_range_weight | id_zone | price |
|---|
| 1 | | | 2 | 0 | 1 | 1 | 5.000000 |
| 2 | | | 2 | 0 | 1 | 2 | 5.000000 |
| 3 | | | 2 | 1 | 0 | 1 | 5.000000 |
| 4 | | | 2 | 1 | 0 | 2 | 5.000000 |
| 5 | | | 3 | 2 | 0 | 1 | 3.000000 |
| 6 | | | 3 | 2 | 0 | 2 | 4.000000 |
| 7 | | | 3 | 3 | 0 | 1 | 1.000000 |
| 8 | | | 3 | 3 | 0 | 2 | 2.000000 |
| 9 | | | 3 | 4 | 0 | 1 | 0.000000 |
| 10 | | | 3 | 4 | 0 | 2 | 0.000000 |
| 11 | | | 4 | 0 | 2 | 1 | 0.000000 |
| 12 | | | 4 | 0 | 2 | 2 | 0.000000 |
| 13 | | | 4 | 0 | 3 | 1 | 2.000000 |
| 14 | | | 4 | 0 | 3 | 2 | 3.000000 |
| 15 | | | 4 | 0 | 4 | 1 | 5.000000 |
| 16 | | | 4 | 0 | 4 | 2 | 6.000000 |