🗃️ BASES / MARIADB

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

Conexión DB

276

Tablas visibles

prestashop

Nivel actual

🧬 Columnas: prestashop / ps_stock_available

Campo	Tipo	Null	Key	Default	Extra
id_stock_available	int(11) unsigned	NO	PRI		auto_increment
id_product	int(11) unsigned	NO	MUL
id_product_attribute	int(11) unsigned	NO	MUL
id_shop	int(11) unsigned	NO	MUL
id_shop_group	int(11) unsigned	NO	MUL
quantity	int(10)	NO		0
physical_quantity	int(11)	NO		0
reserved_quantity	int(11)	NO		0
depends_on_stock	tinyint(1) unsigned	NO		0
out_of_stock	tinyint(1) unsigned	NO		0
location	varchar(255)	NO

20 filas

id_stock_available	id_product	id_product_attribute	id_shop	quantity	physical_quantity	reserved_quantity	out_of_stock
1	1	0	1	2400	2400	0	2
2	2	0	1	2100	2100	0	2
3	3	0	1	1500	1500	0	2
4	4	0	1	1500	1500	0	2
5	5	0	1	900	900	0	2
6	6	0	1	300	300	0	2
7	7	0	1	300	300	0	2
8	8	0	1	300	301	1	2
9	9	0	1	600	600	0	2
10	10	0	1	600	600	0	2
11	11	0	1	600	600	0	2
12	12	0	1	300	300	0	1
13	13	0	1	300	300	0	1
14	14	0	1	300	300	0	1
15	15	0	1	100	100	0	2
16	16	0	1	1200	1200	0	2
17	17	0	1	1200	1200	0	2
18	18	0	1	1200	1200	0	2
19	19	0	1	300	300	0	2
20	1	1	1	300	300	0	2