🗃️ BASES / MARIADB

Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.

Conexión DB

Tablas visibles

information_schema

Nivel actual

🧬 Columnas: information_schema / TABLE_CONSTRAINTS

Campo	Tipo	Null
CONSTRAINT_CATALOG	varchar(512)	NO
CONSTRAINT_SCHEMA	varchar(64)	NO
CONSTRAINT_NAME	varchar(64)	NO
TABLE_SCHEMA	varchar(64)	NO
TABLE_NAME	varchar(64)	NO
CONSTRAINT_TYPE	varchar(64)	NO

20 filas

CONSTRAINT_CATALOG	CONSTRAINT_SCHEMA	CONSTRAINT_NAME	TABLE_SCHEMA	TABLE_NAME	CONSTRAINT_TYPE
def	prestashop	PRIMARY	prestashop	ps_supply_order_receipt_history	PRIMARY KEY
def	prestashop	PRIMARY	prestashop	ps_shop_url	PRIMARY KEY
def	prestashop	PRIMARY	prestashop	ps_range_price	PRIMARY KEY
def	prestashop	id_carrier	prestashop	ps_range_price	UNIQUE
def	prestashop	PRIMARY	prestashop	ps_quick_access	PRIMARY KEY
def	prestashop	PRIMARY	prestashop	ps_layered_product_attribute	PRIMARY KEY
def	prestashop	id_attribute_group	prestashop	ps_layered_product_attribute	UNIQUE
def	prestashop	PRIMARY	prestashop	ps_statssearch	PRIMARY KEY
def	prestashop	PRIMARY	prestashop	ps_link_block	PRIMARY KEY
def	prestashop	PRIMARY	prestashop	ps_homeslider	PRIMARY KEY
def	prestashop	PRIMARY	prestashop	ps_customized_data	PRIMARY KEY
def	prestashop	PRIMARY	prestashop	ps_smarty_lazy_cache	PRIMARY KEY
def	prestashop	PRIMARY	prestashop	ps_lang_shop	PRIMARY KEY
def	prestashop	PRIMARY	prestashop	ps_required_field	PRIMARY KEY
def	prestashop	PRIMARY	prestashop	ps_country	PRIMARY KEY
def	prestashop	PRIMARY	prestashop	ps_carrier_group	PRIMARY KEY
def	prestashop	PRIMARY	prestashop	ps_product_supplier	PRIMARY KEY
def	prestashop	id_product	prestashop	ps_product_supplier	UNIQUE
def	prestashop	PRIMARY	prestashop	ps_product_comment_criterion_lang	PRIMARY KEY
def	prestashop	PRIMARY	prestashop	ps_guest	PRIMARY KEY