🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
🧬 Columnas: prestashop / ps_address
24| Campo | Tipo | Null | Key | Default | Extra |
|---|
| id_address | int(10) unsigned | NO | PRI | | auto_increment |
| id_country | int(10) unsigned | NO | MUL | | |
| id_state | int(10) unsigned | YES | MUL | | |
| id_customer | int(10) unsigned | NO | MUL | 0 | |
| id_manufacturer | int(10) unsigned | NO | MUL | 0 | |
| id_supplier | int(10) unsigned | NO | MUL | 0 | |
| id_warehouse | int(10) unsigned | NO | MUL | 0 | |
| alias | varchar(32) | NO | | | |
| company | varchar(255) | YES | | | |
| lastname | varchar(255) | NO | | | |
| firstname | varchar(255) | NO | | | |
| address1 | varchar(128) | NO | | | |
| address2 | varchar(128) | YES | | | |
| postcode | varchar(12) | YES | | | |
| city | varchar(64) | NO | | | |
| other | mediumtext | YES | | | |
| phone | varchar(32) | YES | | | |
| phone_mobile | varchar(32) | YES | | | |
| vat_number | varchar(32) | YES | | | |
| dni | varchar(16) | YES | | | |
| date_add | datetime | NO | | | |
| date_upd | datetime | NO | | | |
| active | tinyint(1) unsigned | NO | | 1 | |
| deleted | tinyint(1) unsigned | NO | | 0 | |
🔬 Muestra de datos
6 filas
| id_address | id_country | id_state | id_customer | id_manufacturer | id_supplier | id_warehouse | alias | company | lastname | firstname | address1 | address2 | postcode | city | other | phone | phone_mobile | vat_number | dni | date_add | date_upd | active | deleted |
|---|
| 1 | 44 | 0 | 1 | 0 | 0 | 0 | Anonymous | Anonymous | Anonymous | Anonymous | Anonymous | | 00000 | Anonymous | | 0000000000 | 0000000000 | 0000 | 0000 | 2026-06-11 14:35:50 | 2026-06-11 14:35:50 | 1 | 0 |
| 2 | 8 | 0 | 2 | 0 | 0 | 0 | Mon adresse | My Company | DOE | John | 16, Main street | 2nd floor | 75002 | Paris | | 0102030405 | | | | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 1 | 0 |
| 3 | 21 | 35 | 0 | 0 | 1 | 0 | supplier | Fashion | supplier | supplier | 767 Fifth Ave. | | 10153 | New York | | (212) 336-1440 | | | | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 1 | 0 |
| 4 | 21 | 35 | 0 | 1 | 0 | 0 | manufacturer | Fashion | manufacturer | manufacturer | 767 Fifth Ave. | | 10154 | New York | | (212) 336-1666 | | | | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 1 | 0 |
| 5 | 21 | 12 | 2 | 0 | 0 | 0 | My address | My Company | DOE | John | 16, Main street | 2nd floor | 33133 | Miami | | 0102030405 | | | | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 1 | 0 |
| 6 | 8 | 0 | 0 | 0 | 2 | 0 | accessories_supplier | Accessories and Co | accessories | accessories | 42 Avenue Maréchal Soult | | 64990 | Bayonne | | 0102030405 | | | | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 1 | 0 |