🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
🧬 Columnas: prestashop / ps_orders
46| Campo | Tipo | Null | Key | Default | Extra |
|---|
| id_order | int(10) unsigned | NO | PRI | | auto_increment |
| reference | varchar(9) | YES | MUL | | |
| id_shop_group | int(11) unsigned | NO | MUL | 1 | |
| id_shop | int(11) unsigned | NO | MUL | 1 | |
| id_carrier | int(10) unsigned | NO | MUL | | |
| id_lang | int(10) unsigned | NO | MUL | | |
| id_customer | int(10) unsigned | NO | MUL | | |
| id_cart | int(10) unsigned | NO | MUL | | |
| id_currency | int(10) unsigned | NO | MUL | | |
| id_address_delivery | int(10) unsigned | NO | MUL | | |
| id_address_invoice | int(10) unsigned | NO | MUL | | |
| current_state | int(10) unsigned | NO | MUL | | |
| secure_key | varchar(32) | NO | | -1 | |
| payment | varchar(255) | NO | | | |
| conversion_rate | decimal(13,6) | NO | | 1.000000 | |
| module | varchar(255) | YES | | | |
| recyclable | tinyint(1) unsigned | NO | | 0 | |
| gift | tinyint(1) unsigned | NO | | 0 | |
| gift_message | mediumtext | YES | | | |
| mobile_theme | tinyint(1) | NO | | 0 | |
| total_discounts | decimal(20,6) | NO | | 0.000000 | |
| total_discounts_tax_incl | decimal(20,6) | NO | | 0.000000 | |
| total_discounts_tax_excl | decimal(20,6) | NO | | 0.000000 | |
| total_paid | decimal(20,6) | NO | | 0.000000 | |
| total_paid_tax_incl | decimal(20,6) | NO | | 0.000000 | |
| total_paid_tax_excl | decimal(20,6) | NO | | 0.000000 | |
| total_paid_real | decimal(20,6) | NO | | 0.000000 | |
| total_products | decimal(20,6) | NO | | 0.000000 | |
| total_products_wt | decimal(20,6) | NO | | 0.000000 | |
| total_shipping | decimal(20,6) | NO | | 0.000000 | |
| total_shipping_tax_incl | decimal(20,6) | NO | | 0.000000 | |
| total_shipping_tax_excl | decimal(20,6) | NO | | 0.000000 | |
| carrier_tax_rate | decimal(10,3) | NO | | 0.000 | |
| total_wrapping | decimal(20,6) | NO | | 0.000000 | |
| total_wrapping_tax_incl | decimal(20,6) | NO | | 0.000000 | |
| total_wrapping_tax_excl | decimal(20,6) | NO | | 0.000000 | |
| round_mode | tinyint(1) | NO | | 2 | |
| round_type | tinyint(1) | NO | | 1 | |
| invoice_number | int(10) unsigned | NO | MUL | 0 | |
| delivery_number | int(10) unsigned | NO | | 0 | |
| invoice_date | datetime | NO | | | |
| delivery_date | datetime | NO | | | |
| valid | int(1) unsigned | NO | | 0 | |
| date_add | datetime | NO | MUL | | |
| date_upd | datetime | NO | | | |
| note | mediumtext | YES | | | |
🔬 Muestra de datos
5 filas
| id_order | reference | id_shop_group | id_shop | id_carrier | id_lang | id_customer | id_cart | id_currency | id_address_delivery | id_address_invoice | current_state | secure_key | payment | conversion_rate | module | recyclable | gift | gift_message | mobile_theme | total_discounts | total_discounts_tax_incl | total_discounts_tax_excl | total_paid | total_paid_tax_incl | total_paid_tax_excl | total_paid_real | total_products | total_products_wt | total_shipping | total_shipping_tax_incl | total_shipping_tax_excl | carrier_tax_rate | total_wrapping | total_wrapping_tax_incl | total_wrapping_tax_excl | round_mode | round_type | invoice_number | delivery_number | invoice_date | delivery_date | valid | date_add | date_upd | note |
|---|
| 1 | XKBKNABJK | 1 | 1 | 2 | 1 | 2 | 1 | 1 | 5 | 5 | 6 | b44a6d9efd7a0076a0fbce6b15eaf3b1 | Payment by check | 1.000000 | ps_checkpayment | 0 | 0 | | 0 | 0.000000 | 0.000000 | 0.000000 | 61.800000 | 68.200000 | 66.800000 | 0.000000 | 59.800000 | 59.800000 | 7.000000 | 8.400000 | 7.000000 | 0.000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | 0 | 2026-06-11 14:36:44 | 2026-06-11 14:36:44 | Test |
| 2 | OHSATSERP | 1 | 1 | 2 | 1 | 2 | 2 | 1 | 5 | 5 | 1 | b44a6d9efd7a0076a0fbce6b15eaf3b1 | Payment by check | 1.000000 | ps_checkpayment | 0 | 0 | | 0 | 0.000000 | 0.000000 | 0.000000 | 169.900000 | 169.900000 | 169.900000 | 0.000000 | 169.900000 | 169.900000 | 0.000000 | 0.000000 | 0.000000 | 0.000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | 0 | 2026-06-11 14:36:44 | 2026-06-11 14:36:44 | |
| 3 | UOYEVOLI | 1 | 1 | 2 | 1 | 2 | 3 | 1 | 5 | 5 | 8 | b44a6d9efd7a0076a0fbce6b15eaf3b1 | Payment by check | 1.000000 | ps_checkpayment | 0 | 0 | | 0 | 0.000000 | 0.000000 | 0.000000 | 14.900000 | 21.300000 | 19.900000 | 0.000000 | 12.900000 | 12.900000 | 7.000000 | 8.400000 | 7.000000 | 0.000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | 0 | 2026-06-11 14:36:44 | 2026-06-11 14:36:44 | |
| 4 | FFATNOMMJ | 1 | 1 | 2 | 1 | 2 | 4 | 1 | 5 | 5 | 1 | b44a6d9efd7a0076a0fbce6b15eaf3b1 | Payment by check | 1.000000 | ps_checkpayment | 0 | 0 | | 0 | 0.000000 | 0.000000 | 0.000000 | 14.900000 | 21.300000 | 19.900000 | 0.000000 | 12.900000 | 12.900000 | 7.000000 | 8.400000 | 7.000000 | 0.000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | 0 | 2026-06-11 14:36:44 | 2026-06-11 14:36:44 | |
| 5 | KHWLILZLL | 1 | 1 | 2 | 1 | 2 | 5 | 1 | 5 | 5 | 10 | b44a6d9efd7a0076a0fbce6b15eaf3b1 | Bank wire | 1.000000 | ps_wirepayment | 0 | 0 | | 0 | 0.000000 | 0.000000 | 0.000000 | 20.900000 | 27.300000 | 25.900000 | 0.000000 | 18.900000 | 18.900000 | 7.000000 | 8.400000 | 7.000000 | 0.000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | 0 | 2026-06-11 14:36:44 | 2026-06-11 14:36:44 | |