🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
🧬 Columnas: prestashop / ps_product_supplier
7| Campo | Tipo | Null | Key | Default | Extra |
|---|
| id_product_supplier | int(11) unsigned | NO | PRI | | auto_increment |
| id_product | int(11) unsigned | NO | MUL | | |
| id_product_attribute | int(11) unsigned | NO | | 0 | |
| id_supplier | int(11) unsigned | NO | MUL | | |
| product_supplier_reference | varchar(64) | YES | | | |
| product_supplier_price_te | decimal(20,6) | NO | | 0.000000 | |
| id_currency | int(11) unsigned | NO | | | |
🔬 Muestra de datos
20 filas
| id_product_supplier | id_product | id_product_attribute | id_supplier | product_supplier_reference | product_supplier_price_te | id_currency |
|---|
| 1 | 6 | 0 | 2 | demo_11 | 5.490000 | 1 |
| 2 | 7 | 0 | 2 | demo_12 | 5.490000 | 1 |
| 3 | 8 | 0 | 2 | demo_13 | 5.490000 | 1 |
| 4 | 19 | 0 | 2 | demo_14 | 5.490000 | 1 |
| 5 | 12 | 0 | 2 | demo_18 | 5.490000 | 1 |
| 6 | 12 | 0 | 1 | demo_18 | 6.490000 | 1 |
| 7 | 13 | 0 | 2 | demo_19 | 5.490000 | 1 |
| 8 | 13 | 0 | 1 | demo_19 | 6.490000 | 1 |
| 9 | 14 | 0 | 2 | demo_20 | 5.490000 | 1 |
| 10 | 14 | 0 | 1 | demo_20 | 6.490000 | 1 |
| 11 | 1 | 0 | 1 | demo_1_46 | 5.490000 | 1 |
| 12 | 1 | 1 | 1 | demo_1_46 | 5.490000 | 1 |
| 13 | 1 | 2 | 1 | demo_1_47 | 5.490000 | 1 |
| 14 | 1 | 3 | 1 | demo_1_48 | 5.490000 | 1 |
| 15 | 1 | 4 | 1 | demo_1_49 | 5.490000 | 1 |
| 16 | 1 | 5 | 1 | demo_1_50 | 5.490000 | 1 |
| 17 | 1 | 6 | 1 | demo_1_51 | 5.490000 | 1 |
| 18 | 1 | 7 | 1 | demo_1_52 | 5.490000 | 1 |
| 19 | 1 | 8 | 1 | demo_1_53 | 5.490000 | 1 |
| 20 | 2 | 0 | 1 | demo_3_62 | 5.490000 | 1 |