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

Campo	Tipo	Null
CONSTRAINT_CATALOG	varchar(512)	NO
CONSTRAINT_SCHEMA	varchar(64)	NO
CONSTRAINT_NAME	varchar(64)	NO
TABLE_CATALOG	varchar(512)	NO
TABLE_SCHEMA	varchar(64)	NO
TABLE_NAME	varchar(64)	NO
COLUMN_NAME	varchar(64)	NO
ORDINAL_POSITION	bigint(10)	NO
POSITION_IN_UNIQUE_CONSTRAINT	bigint(10)	YES
REFERENCED_TABLE_SCHEMA	varchar(64)	YES
REFERENCED_TABLE_NAME	varchar(64)	YES
REFERENCED_COLUMN_NAME	varchar(64)	YES

🔬 Muestra de datos

20 filas

CONSTRAINT_CATALOG	CONSTRAINT_SCHEMA	CONSTRAINT_NAME	TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	ORDINAL_POSITION
def	prestashop	PRIMARY	def	prestashop	ps_supply_order_receipt_history	id_supply_order_receipt_history	1
def	prestashop	PRIMARY	def	prestashop	ps_shop_url	id_shop_url	1
def	prestashop	PRIMARY	def	prestashop	ps_range_price	id_range_price	1
def	prestashop	id_carrier	def	prestashop	ps_range_price	id_carrier	1
def	prestashop	id_carrier	def	prestashop	ps_range_price	delimiter1	2
def	prestashop	id_carrier	def	prestashop	ps_range_price	delimiter2	3
def	prestashop	PRIMARY	def	prestashop	ps_quick_access	id_quick_access	1
def	prestashop	PRIMARY	def	prestashop	ps_layered_product_attribute	id_attribute	1
def	prestashop	PRIMARY	def	prestashop	ps_layered_product_attribute	id_product	2
def	prestashop	PRIMARY	def	prestashop	ps_layered_product_attribute	id_shop	3
def	prestashop	id_attribute_group	def	prestashop	ps_layered_product_attribute	id_attribute_group	1
def	prestashop	id_attribute_group	def	prestashop	ps_layered_product_attribute	id_attribute	2
def	prestashop	id_attribute_group	def	prestashop	ps_layered_product_attribute	id_product	3
def	prestashop	id_attribute_group	def	prestashop	ps_layered_product_attribute	id_shop	4
def	prestashop	PRIMARY	def	prestashop	ps_statssearch	id_statssearch	1
def	prestashop	PRIMARY	def	prestashop	ps_link_block	id_link_block	1
def	prestashop	PRIMARY	def	prestashop	ps_homeslider	id_homeslider_slides	1
def	prestashop	PRIMARY	def	prestashop	ps_homeslider	id_shop	2
def	prestashop	PRIMARY	def	prestashop	ps_customized_data	id_customization	1
def	prestashop	PRIMARY	def	prestashop	ps_customized_data	type	2