🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
🧬 Columnas: prestashop / ps_product_attribute_shop
13| Campo | Tipo | Null | Key | Default | Extra |
|---|
| id_product | int(10) unsigned | NO | MUL | | |
| id_product_attribute | int(10) unsigned | NO | PRI | | |
| id_shop | int(10) unsigned | NO | PRI | | |
| wholesale_price | decimal(20,6) | NO | | 0.000000 | |
| price | decimal(20,6) | NO | | 0.000000 | |
| ecotax | decimal(17,6) | NO | | 0.000000 | |
| weight | decimal(20,6) | NO | | 0.000000 | |
| unit_price_impact | decimal(20,6) | NO | | 0.000000 | |
| default_on | tinyint(1) unsigned | YES | | | |
| minimal_quantity | int(10) unsigned | NO | | 1 | |
| low_stock_threshold | int(10) | YES | | | |
| low_stock_alert | tinyint(1) | NO | | 0 | |
| available_date | date | YES | | | |
🔬 Muestra de datos
20 filas
| id_product | id_product_attribute | id_shop | wholesale_price | price | ecotax | weight | unit_price_impact | default_on | minimal_quantity | low_stock_threshold | low_stock_alert | available_date |
|---|
| 1 | 1 | 1 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1 | 1 | 0 | 0 | 0000-00-00 |
| 1 | 2 | 1 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 1 | 3 | 1 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 1 | 4 | 1 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 1 | 5 | 1 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 1 | 6 | 1 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 1 | 7 | 1 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 1 | 8 | 1 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 2 | 9 | 1 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1 | 1 | 0 | 0 | 0000-00-00 |
| 2 | 10 | 1 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 2 | 11 | 1 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 2 | 12 | 1 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 3 | 13 | 1 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1 | 1 | 0 | 0 | 0000-00-00 |
| 3 | 14 | 1 | 0.000000 | 20.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 3 | 15 | 1 | 0.000000 | 50.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 4 | 16 | 1 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1 | 1 | 0 | 0 | 0000-00-00 |
| 4 | 17 | 1 | 0.000000 | 20.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 4 | 18 | 1 | 0.000000 | 50.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 5 | 19 | 1 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1 | 1 | 0 | 0 | 0000-00-00 |
| 5 | 20 | 1 | 0.000000 | 20.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |