🗃️ 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
18| Campo | Tipo | Null | Key | Default | Extra |
|---|
| id_product_attribute | int(10) unsigned | NO | PRI | | auto_increment |
| id_product | int(10) unsigned | NO | MUL | | |
| reference | varchar(64) | YES | MUL | | |
| supplier_reference | varchar(64) | YES | MUL | | |
| ean13 | varchar(13) | YES | | | |
| isbn | varchar(32) | YES | | | |
| upc | varchar(12) | YES | | | |
| mpn | varchar(40) | YES | | | |
| 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_attribute | id_product | reference | supplier_reference | ean13 | isbn | upc | mpn | wholesale_price | price | ecotax | weight | unit_price_impact | default_on | minimal_quantity | low_stock_threshold | low_stock_alert | available_date |
|---|
| 1 | 1 | demo_1 | | | | | | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1 | 1 | 0 | 0 | 0000-00-00 |
| 2 | 1 | demo_1 | | | | | | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 3 | 1 | demo_1 | | | | | | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 4 | 1 | demo_1 | | | | | | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 5 | 1 | demo_1 | | | | | | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 6 | 1 | demo_1 | | | | | | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 7 | 1 | demo_1 | | | | | | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 8 | 1 | demo_1 | | | | | | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 9 | 2 | demo_3 | | | | | | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1 | 1 | 0 | 0 | 0000-00-00 |
| 10 | 2 | demo_3 | | | | | | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 11 | 2 | demo_3 | | | | | | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 12 | 2 | demo_3 | | | | | | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 13 | 3 | demo_6 | | | | | | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1 | 1 | 0 | 0 | 0000-00-00 |
| 14 | 3 | demo_6 | | | | | | 0.000000 | 20.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 15 | 3 | demo_6 | | | | | | 0.000000 | 50.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 16 | 4 | demo_5 | | | | | | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1 | 1 | 0 | 0 | 0000-00-00 |
| 17 | 4 | demo_5 | | | | | | 0.000000 | 20.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 18 | 4 | demo_5 | | | | | | 0.000000 | 50.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |
| 19 | 5 | demo_7 | | | | | | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1 | 1 | 0 | 0 | 0000-00-00 |
| 20 | 5 | demo_7 | | | | | | 0.000000 | 20.000000 | 0.000000 | 0.000000 | 0.000000 | | 1 | 0 | 0 | 0000-00-00 |