🗃️ 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 / STATISTICS

Campo	Tipo	Null
TABLE_CATALOG	varchar(512)	NO
TABLE_SCHEMA	varchar(64)	NO
TABLE_NAME	varchar(64)	NO
NON_UNIQUE	bigint(1)	NO
INDEX_SCHEMA	varchar(64)	NO
INDEX_NAME	varchar(64)	NO
SEQ_IN_INDEX	int(2) unsigned	NO
COLUMN_NAME	varchar(64)	NO
COLLATION	varchar(1)	YES
CARDINALITY	bigint(21)	YES
SUB_PART	bigint(3)	YES
PACKED	varchar(10)	YES
NULLABLE	varchar(3)	NO
INDEX_TYPE	varchar(16)	NO
COMMENT	varchar(16)	YES
INDEX_COMMENT	varchar(1024)	NO
IGNORED	varchar(3)	NO

🔬 Muestra de datos

20 filas

TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	NON_UNIQUE	INDEX_SCHEMA	INDEX_NAME	SEQ_IN_INDEX	COLUMN_NAME	COLLATION	CARDINALITY	INDEX_TYPE	IGNORED
def	prestashop	ps_supply_order_receipt_history	0	prestashop	PRIMARY	1	id_supply_order_receipt_history	A	0	BTREE	NO
def	prestashop	ps_supply_order_receipt_history	1	prestashop	id_supply_order_detail	1	id_supply_order_detail	A	0	BTREE	NO
def	prestashop	ps_supply_order_receipt_history	1	prestashop	id_supply_order_state	1	id_supply_order_state	A	0	BTREE	NO
def	prestashop	ps_shop_url	0	prestashop	PRIMARY	1	id_shop_url	A	0	BTREE	NO
def	prestashop	ps_shop_url	1	prestashop	IDX_279F19DA274A50A0	1	id_shop	A	0	BTREE	NO
def	prestashop	ps_range_price	0	prestashop	PRIMARY	1	id_range_price	A	4	BTREE	NO
def	prestashop	ps_range_price	0	prestashop	id_carrier	1	id_carrier	A	4	BTREE	NO
def	prestashop	ps_range_price	0	prestashop	id_carrier	2	delimiter1	A	4	BTREE	NO
def	prestashop	ps_range_price	0	prestashop	id_carrier	3	delimiter2	A	4	BTREE	NO
def	prestashop	ps_quick_access	0	prestashop	PRIMARY	1	id_quick_access	A	6	BTREE	NO
def	prestashop	ps_layered_product_attribute	0	prestashop	PRIMARY	1	id_attribute	A	37	BTREE	NO
def	prestashop	ps_layered_product_attribute	0	prestashop	PRIMARY	2	id_product	A	37	BTREE	NO
def	prestashop	ps_layered_product_attribute	0	prestashop	PRIMARY	3	id_shop	A	37	BTREE	NO
def	prestashop	ps_layered_product_attribute	0	prestashop	id_attribute_group	1	id_attribute_group	A	9	BTREE	NO
def	prestashop	ps_layered_product_attribute	0	prestashop	id_attribute_group	2	id_attribute	A	37	BTREE	NO
def	prestashop	ps_layered_product_attribute	0	prestashop	id_attribute_group	3	id_product	A	37	BTREE	NO
def	prestashop	ps_layered_product_attribute	0	prestashop	id_attribute_group	4	id_shop	A	37	BTREE	NO
def	prestashop	ps_statssearch	0	prestashop	PRIMARY	1	id_statssearch	A	4	BTREE	NO
def	prestashop	ps_link_block	0	prestashop	PRIMARY	1	id_link_block	A	2	BTREE	NO
def	prestashop	ps_homeslider	0	prestashop	PRIMARY	1	id_homeslider_slides	A	3	BTREE	NO