www.cabello.ws / localhost / cabecab4_joomla_3_9_11_helix

There are no favorite tables.

New
aaa
- aaa
- aaa_fabricas_pruebas
abanq
- abanq_23
- abanq_23 experimental
articulos
autocompleta
azulejoscabello.com
- azulejoscabello.com
- azulejoscabello.com_tienda
azulejoscabello_com
book_sc
cabecab4
cabello-enterprises
- cabello-enterprises
- cabello-enterprises_exp
contabilidad
datatablesv03
durstone
eneboo
grespania
information_schema
intermediaria_online
jplist
keraben
letodms
letodms experimental
magazine
mydms
mydms experimental
mysql
pamesa_filter
performance_schema
php_producto
- php_producto
- php_producto_prueba
sys
tutorial
wordpress
- wordpress
- wordpress_desarrollo

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Untitled *

v		cabecab4_joomla_3_9_11_helix bano_roca_web
auto : bigint
ruta : varchar(500)
product_brand : varchar(500)
product_image : varchar(500)
product_name : varchar(500)
product_storage : varchar(500)
product_ram : varchar(500)
basura : varchar(500)
product_price : varchar(500)
product_status : int

v		cabecab4_joomla_3_9_11_helix cer_bellacasa_cruce_limpia
cruce_limpia_id : int
Column1 : varchar(12)
Column2 : varchar(12)

v		cabecab4_joomla_3_9_11_helix cer_bellacasa_product
product_id : int
product_storage : varchar(25)
product_brand : varchar(45)
product_status : int
product_image : varchar(12)
ARTICULO_-_DESCR._CORTA : varchar(25)
product_name : varchar(45)
product_ram : varchar(12)
product_camera : double
KG/CJ-PZ : double
TIPO_ARTICULO : varchar(5)
UNIDADES : varchar(5)
PIEZAS/CAJA : int
DIMENSIONES : int
CAJAS/PALLET : int
GRUPO_TARIFA : int
SUBGRUPO_TARIFA : int
product_price : double
FECHA_CREACIÓN_PRODUCTO : datetime
EAN_13 : bigint

v		cabecab4_joomla_3_9_11_helix cer_bellacasa_product_limpio
product_id : int
product_storage : varchar(25)
product_brand : varchar(45)
product_status : int
product_image : varchar(12)
ARTICULO_-_DESCR._CORTA : varchar(25)
product_name : varchar(45)
product_ram : varchar(12)
product_camera : double
KG/CJ-PZ : double
TIPO_ARTICULO : varchar(5)
UNIDADES : varchar(5)
PIEZAS/CAJA : int
DIMENSIONES : int
CAJAS/PALLET : int
GRUPO_TARIFA : int
SUBGRUPO_TARIFA : int
product_price : double
FECHA_CREACIÓN_PRODUCTO : datetime
EAN_13 : bigint

v		cabecab4_joomla_3_9_11_helix cer_cristacer_cristacer_codigos
cer_cristacer_cristacer_codigos_id : int
Cod._Tar : varchar(5)
Unidad_de_venta : varchar(5)
Precio_-_1_Pal : varchar(5)

v		cabecab4_joomla_3_9_11_helix cer_cristacer_cristacer_fab
id : int
Artículo : varchar(45)
Formato : varchar(12)
Color : varchar(12)
Cod._Tar : varchar(5)
Unidad_de_venta : varchar(5)
Precio_+_1_Pal : double
Precio_-_1_Pal : double
M2/Caja : double
Pz/Caja : int
Peso_de_la_Caja : double
M2/Pallet : double
Nª_Cajas/Pallet : int
Peso/Pallet : double

v		cabecab4_joomla_3_9_11_helix cer_cristacer_cristacer_web
auto : bigint
ruta : varchar(300)
nombre : varchar(300)
codigo_articulo : varchar(300)
codigo_precio : varchar(300)
formato : varchar(300)
color : varchar(300)
precio : varchar(300)
img_pequeña : varchar(300)
img_grande : varchar(300)

v		cabecab4_joomla_3_9_11_helix cer_cristacer_cristacer_web_amb
auto : bigint
ruta : varchar(300)
amb1 : varchar(500)
amb2 : varchar(500)
amb3 : varchar(500)
nombre : varchar(300)
codigo_articulo : varchar(300)
codigo_precio : varchar(300)
formato : varchar(300)
color : varchar(300)
precio : varchar(300)
img_pequeña : varchar(300)
img_grande : varchar(300)

v		cabecab4_joomla_3_9_11_helix cer_cristacer_product
Column1 : int
Column2 : int
product_status : int
Column4 : varchar(45)
product_image : varchar(255)
Column6 : varchar(255)
Column7 : varchar(255)
product_name : varchar(255)
product_price : varchar(5)
product_ram : varchar(45)
Column11 : varchar(255)
Column12 : varchar(255)

v		cabecab4_joomla_3_9_11_helix cer_grespania_grespania_fab
id : int
FAMILIA : varchar(45)
SUBFAMILIA : varchar(45)
CODIGO : varchar(12)
ARTICULO_-_DESCR._CORTA : varchar(25)
ARTICULO-DESCR._LARGA : varchar(45)
FORMATO : varchar(12)
M2/CAJA : int
KG/CAJA : int
TIPO_ARTICULO : varchar(5)
UNIDADES : varchar(5)
PIEZAS/CAJA : int
CAJAS/PALLET : int
GRUPO_TARIFA : int
SUBGRUPO_TARIFA : int
€/M2 : double
FECHA_CREACIÓN_PRODUCTO : datetime
EAN_13 : bigint

v		cabecab4_joomla_3_9_11_helix cer_grespania_grespania_web
auto : bigint
ruta : varchar(300)
nombre : varchar(300)
codigo_articulo : varchar(300)
codigo_precio : varchar(300)
formato : varchar(300)
color : varchar(300)
precio : varchar(300)
img_pequeña : varchar(300)
img_grande : varchar(300)

v		cabecab4_joomla_3_9_11_helix cer_grespania_product
product_id : int
id : int
product_status : int
product_storage : varchar(45)
product_brand : varchar(45)
CODIGO : varchar(12)
product_image : varchar(45)
ARTICULO_-_DESCR._CORTA : varchar(25)
product_name : varchar(45)
product_ram : varchar(12)
product_camera : int
KG/CAJA : int
TIPO_ARTICULO : varchar(5)
UNIDADES : varchar(5)
PIEZAS/CAJA : int
CAJAS/PALLET : int
GRUPO_TARIFA : int
SUBGRUPO_TARIFA : int
product_price : double
FECHA_CREACIÓN_PRODUCTO : datetime
EAN_13 : bigint

v		cabecab4_joomla_3_9_11_helix cer_marazzi_marazzi_fab
marazzi_fab_id : int
SERIE : varchar(25)
CATAL : varchar(12)
CODIGO_SERIE : varchar(5)
TIPOLOGIA : varchar(25)
FORMATO : varchar(12)
DESCRIPCION : varchar(45)
CODIGO : varchar(5)
UOM : varchar(5)
PVP__€_2019 : decimal(65,30)
PZ_CAJA : int
CAJA_PL : int
M2_CAJA : double
M2_PL : double
KG_CAJA : double
KG_PL : double
ESPESOR : varchar(5)
COD_BARRA : varchar(25)

v		cabecab4_joomla_3_9_11_helix cer_marazzi_marazzi_web
ID : int
Ruta : varchar(500)
Imagen : varchar(500)
Codigo : varchar(500)
Descripcion : varchar(500)
Medidas : varchar(500)

v		cabecab4_joomla_3_9_11_helix cer_pamesa_pamesa_fab
id : int
Familia : varchar(5)
Formato : varchar(5)
Color : varchar(5)
Modelo : varchar(5)
Imágen : varchar(5)
Desc. Familia : varchar(5)
Desc. Articulo : varchar(45)
Desc. Resumen : varchar(25)
Estado : varchar(5)
Tarifa : varchar(5)
Pamesa : varchar(5)
Grupo Tarifa : varchar(5)
Serie : varchar(5)
Descripcion : varchar(25)
Marca : varchar(5)
Descripcion1 : varchar(12)
Envase : varchar(5)
EAN13 : varchar(25)
UM : varchar(5)
Pz/Caja : varchar(5)
M2/Caja : varchar(5)
Cj/Pallet : varchar(5)
M2/Pallet : varchar(5)
Kg/Caja : varchar(5)
Kg/Pallet : varchar(12)
Fecha de alta : varchar(12)
Marca web : varchar(5)
Descripcion2 : varchar(12)
Familia web : varchar(5)
Descripcion3 : varchar(25)
Id. Articulo : varchar(25)
Coleccion web : varchar(45)
Serie web : varchar(25)
Tipo de uso : varchar(25)
Tipo complementario : varchar(255)
Acabado superficial : varchar(12)
Variacion Cromatica : varchar(25)
Colocacion : varchar(25)
Abrasion P.E.I. : varchar(12)
Clase UNE-ENV 12633 : varchar(12)
Deslizamiento DIN 51130 : varchar(255)
Grupo BX UNE-EN 14411 : varchar(255)

v		cabecab4_joomla_3_9_11_helix cer_pamesa_pamesa_web
auto : bigint
ruta : varchar(300)
nombre : varchar(500)
formato : varchar(500)
color : varchar(500)
precio : varchar(500)
img_pequena : varchar(500)
img_grande : varchar(500)

v		cabecab4_joomla_3_9_11_helix cer_pamesa_product
product_id : int
Familia : varchar(5)
product_brand : varchar(25)
product_image : varchar(25)
product_name : varchar(45)
product_ram : varchar(5)
product_storage : varchar(25)
product_camera : varchar(5)
product_status : varchar(5)
Formato : varchar(5)
Color : varchar(5)
Modelo : varchar(5)
Imagen : varchar(5)
Desc Familia : varchar(5)
Desc Articulo : varchar(45)
Desc Resumen : varchar(25)
Estado : varchar(5)
Tarifa : varchar(5)
Tarifa Cial : varchar(5)
Grupo Tarifa : varchar(5)
Caja : varchar(5)
Descripcion4 : varchar(25)
Marca : varchar(5)
Descripcion5 : varchar(12)
EAN13 : varchar(25)
UM : varchar(5)
Pz/Caja : varchar(5)
M2/Caja : varchar(5)
Cj/Pallet : varchar(5)
M2/Pallet : varchar(5)
Kg/Caja : varchar(5)
Kg/Pallet : varchar(12)
Fecha de alta : varchar(12)
Marca web : varchar(5)
Descripcion1 : varchar(12)
Serie promocion : varchar(255)
Descripcion2 : varchar(255)
Familia web : varchar(5)
Descripcion3 : varchar(25)
Id_ Articulo : varchar(25)
Coleccion web : varchar(45)
Serie web : varchar(25)
Efecto web : varchar(12)
Tipo de uso : varchar(25)
Tipo complementario : varchar(255)
Acabado superficial : varchar(12)
Variacion Cromatica : varchar(25)
Colocacion : varchar(25)
Abrasion P_E_I_ : varchar(12)
Clase UNE-ENV 12633 : varchar(12)
Deslizamiento DIN 51130 : varchar(255)
Grupo BX UNE-EN 14411 : varchar(255)
PTV DRY : varchar(255)
PTV WET : varchar(255)

v		cabecab4_joomla_3_9_11_helix nu0qz_action_logs
id : int unsigned
message_language_key : varchar(255)
message : text
log_date : datetime
extension : varchar(50)
user_id : int
item_id : int
ip_address : varchar(40)

v		cabecab4_joomla_3_9_11_helix nu0qz_action_logs_extensions
id : int unsigned
extension : varchar(255)

v		cabecab4_joomla_3_9_11_helix nu0qz_action_logs_users
user_id : int unsigned
notify : tinyint unsigned
extensions : text

v		cabecab4_joomla_3_9_11_helix nu0qz_action_log_config
id : int unsigned
type_title : varchar(255)
type_alias : varchar(255)
id_holder : varchar(255)
title_holder : varchar(255)
table_name : varchar(255)
text_prefix : varchar(255)

v		cabecab4_joomla_3_9_11_helix nu0qz_assets
id : int unsigned
parent_id : int
lft : int
rgt : int
level : int unsigned
name : varchar(50)
title : varchar(100)
rules : varchar(5120)

v		cabecab4_joomla_3_9_11_helix nu0qz_associations
id : int
context : varchar(50)
key : char(32)

v		cabecab4_joomla_3_9_11_helix nu0qz_banners
id : int
cid : int
type : int
name : varchar(255)
alias : varchar(400)
imptotal : int
impmade : int
clicks : int
clickurl : varchar(200)
state : tinyint
catid : int unsigned
description : text
custombannercode : varchar(2048)
sticky : tinyint unsigned
ordering : int
metakey : text
params : text
own_prefix : tinyint(1)
metakey_prefix : varchar(400)
purchase_type : tinyint
track_clicks : tinyint
track_impressions : tinyint
checked_out : int unsigned
checked_out_time : datetime
publish_up : datetime
publish_down : datetime
reset : datetime
created : datetime
language : char(7)
created_by : int unsigned
created_by_alias : varchar(255)
modified : datetime
modified_by : int unsigned
version : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_banner_clients
id : int
name : varchar(255)
contact : varchar(255)
email : varchar(255)
extrainfo : text
state : tinyint
checked_out : int unsigned
checked_out_time : datetime
metakey : text
own_prefix : tinyint
metakey_prefix : varchar(400)
purchase_type : tinyint
track_clicks : tinyint
track_impressions : tinyint

v		cabecab4_joomla_3_9_11_helix nu0qz_banner_tracks
track_date : datetime
track_type : int unsigned
banner_id : int unsigned
count : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_categories
id : int
asset_id : int unsigned
parent_id : int unsigned
lft : int
rgt : int
level : int unsigned
path : varchar(400)
extension : varchar(50)
title : varchar(255)
alias : varchar(400)
note : varchar(255)
description : mediumtext
published : tinyint(1)
checked_out : int unsigned
checked_out_time : datetime
access : int unsigned
params : text
metadesc : varchar(1024)
metakey : varchar(1024)
metadata : varchar(2048)
created_user_id : int unsigned
created_time : datetime
modified_user_id : int unsigned
modified_time : datetime
hits : int unsigned
language : char(7)
version : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_contact_details
id : int
name : varchar(255)
alias : varchar(400)
con_position : varchar(255)
address : text
suburb : varchar(100)
state : varchar(100)
country : varchar(100)
postcode : varchar(100)
telephone : varchar(255)
fax : varchar(255)
misc : mediumtext
image : varchar(255)
email_to : varchar(255)
default_con : tinyint unsigned
published : tinyint(1)
checked_out : int unsigned
checked_out_time : datetime
ordering : int
params : text
user_id : int
catid : int
access : int unsigned
mobile : varchar(255)
webpage : varchar(255)
sortname1 : varchar(255)
sortname2 : varchar(255)
sortname3 : varchar(255)
language : varchar(7)
created : datetime
created_by : int unsigned
created_by_alias : varchar(255)
modified : datetime
modified_by : int unsigned
metakey : text
metadesc : text
metadata : text
featured : tinyint unsigned
xreference : varchar(50)
publish_up : datetime
publish_down : datetime
version : int unsigned
hits : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_content
id : int unsigned
asset_id : int unsigned
title : varchar(255)
alias : varchar(400)
introtext : mediumtext
fulltext : mediumtext
state : tinyint
catid : int unsigned
created : datetime
created_by : int unsigned
created_by_alias : varchar(255)
modified : datetime
modified_by : int unsigned
checked_out : int unsigned
checked_out_time : datetime
publish_up : datetime
publish_down : datetime
images : text
urls : text
attribs : varchar(5120)
version : int unsigned
ordering : int
metakey : text
metadesc : text
access : int unsigned
hits : int unsigned
metadata : text
featured : tinyint unsigned
language : char(7)
xreference : varchar(50)
note : varchar(255)

v		cabecab4_joomla_3_9_11_helix nu0qz_contentitem_tag_map
type_alias : varchar(255)
core_content_id : int unsigned
content_item_id : int
tag_id : int unsigned
tag_date : timestamp
type_id : mediumint

v		cabecab4_joomla_3_9_11_helix nu0qz_content_frontpage
content_id : int
ordering : int

v		cabecab4_joomla_3_9_11_helix nu0qz_content_rating
content_id : int
rating_sum : int unsigned
rating_count : int unsigned
lastip : varchar(50)

v		cabecab4_joomla_3_9_11_helix nu0qz_content_types
type_id : int unsigned
type_title : varchar(255)
type_alias : varchar(400)
table : varchar(255)
rules : text
field_mappings : text
router : varchar(255)
content_history_options : varchar(5120)

v		cabecab4_joomla_3_9_11_helix nu0qz_core_log_searches
search_term : varchar(128)
hits : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_extensions
extension_id : int
package_id : int
name : varchar(100)
type : varchar(20)
element : varchar(100)
folder : varchar(100)
client_id : tinyint
enabled : tinyint
access : int unsigned
protected : tinyint
manifest_cache : text
params : text
custom_data : text
system_data : text
checked_out : int unsigned
checked_out_time : datetime
ordering : int
state : int

v		cabecab4_joomla_3_9_11_helix nu0qz_fields
id : int unsigned
asset_id : int unsigned
context : varchar(255)
group_id : int unsigned
title : varchar(255)
name : varchar(255)
label : varchar(255)
default_value : text
type : varchar(255)
note : varchar(255)
description : text
state : tinyint(1)
required : tinyint(1)
checked_out : int
checked_out_time : datetime
ordering : int
params : text
fieldparams : text
language : char(7)
created_time : datetime
created_user_id : int unsigned
modified_time : datetime
modified_by : int unsigned
access : int

v		cabecab4_joomla_3_9_11_helix nu0qz_fields_categories
field_id : int
category_id : int

v		cabecab4_joomla_3_9_11_helix nu0qz_fields_groups
id : int unsigned
asset_id : int unsigned
context : varchar(255)
title : varchar(255)
note : varchar(255)
description : text
state : tinyint(1)
checked_out : int
checked_out_time : datetime
ordering : int
params : text
language : char(7)
created : datetime
created_by : int unsigned
modified : datetime
modified_by : int unsigned
access : int

v		cabecab4_joomla_3_9_11_helix nu0qz_fields_values
field_id : int unsigned
item_id : varchar(255)
value : text

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_filters
filter_id : int unsigned
title : varchar(255)
alias : varchar(255)
state : tinyint(1)
created : datetime
created_by : int unsigned
created_by_alias : varchar(255)
modified : datetime
modified_by : int unsigned
checked_out : int unsigned
checked_out_time : datetime
map_count : int unsigned
data : text
params : mediumtext

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_links
link_id : int unsigned
url : varchar(255)
route : varchar(255)
title : varchar(400)
description : text
indexdate : datetime
md5sum : varchar(32)
published : tinyint(1)
state : int
access : int
language : varchar(8)
publish_start_date : datetime
publish_end_date : datetime
start_date : datetime
end_date : datetime
list_price : double unsigned
sale_price : double unsigned
type_id : int
object : mediumblob

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_links_terms0
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_links_terms1
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_links_terms2
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_links_terms3
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_links_terms4
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_links_terms5
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_links_terms6
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_links_terms7
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_links_terms8
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_links_terms9
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_links_termsa
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_links_termsb
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_links_termsc
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_links_termsd
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_links_termse
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_links_termsf
link_id : int unsigned
term_id : int unsigned
weight : float unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_taxonomy
id : int unsigned
parent_id : int unsigned
title : varchar(255)
state : tinyint unsigned
access : tinyint unsigned
ordering : tinyint unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_taxonomy_map
link_id : int unsigned
node_id : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_terms
term_id : int unsigned
term : varchar(75)
stem : varchar(75)
common : tinyint unsigned
phrase : tinyint unsigned
weight : float unsigned
soundex : varchar(75)
links : int
language : char(3)

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_terms_common
term : varchar(75)
language : varchar(3)

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_tokens
term : varchar(75)
stem : varchar(75)
common : tinyint unsigned
phrase : tinyint unsigned
weight : float unsigned
context : tinyint unsigned
language : char(3)

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_tokens_aggregate
term_id : int unsigned
map_suffix : char(1)
term : varchar(75)
stem : varchar(75)
common : tinyint unsigned
phrase : tinyint unsigned
term_weight : float unsigned
context : tinyint unsigned
context_weight : float unsigned
total_weight : float unsigned
language : char(3)

v		cabecab4_joomla_3_9_11_helix nu0qz_finder_types
id : int unsigned
title : varchar(100)
mime : varchar(100)

v		cabecab4_joomla_3_9_11_helix nu0qz_languages
lang_id : int unsigned
asset_id : int unsigned
lang_code : char(7)
title : varchar(50)
title_native : varchar(50)
sef : varchar(50)
image : varchar(50)
description : varchar(512)
metakey : text
metadesc : text
sitename : varchar(1024)
published : int
access : int unsigned
ordering : int

v		cabecab4_joomla_3_9_11_helix nu0qz_menu
id : int
menutype : varchar(24)
title : varchar(255)
alias : varchar(400)
note : varchar(255)
path : varchar(1024)
link : varchar(1024)
type : varchar(16)
published : tinyint
parent_id : int unsigned
level : int unsigned
component_id : int unsigned
checked_out : int unsigned
checked_out_time : datetime
browserNav : tinyint
access : int unsigned
img : varchar(255)
template_style_id : int unsigned
params : text
lft : int
rgt : int
home : tinyint unsigned
language : char(7)
client_id : tinyint

v		cabecab4_joomla_3_9_11_helix nu0qz_menu_types
id : int unsigned
asset_id : int unsigned
menutype : varchar(24)
title : varchar(48)
description : varchar(255)
client_id : int

v		cabecab4_joomla_3_9_11_helix nu0qz_messages
message_id : int unsigned
user_id_from : int unsigned
user_id_to : int unsigned
folder_id : tinyint unsigned
date_time : datetime
state : tinyint(1)
priority : tinyint unsigned
subject : varchar(255)
message : text

v		cabecab4_joomla_3_9_11_helix nu0qz_messages_cfg
user_id : int unsigned
cfg_name : varchar(100)
cfg_value : varchar(255)

v		cabecab4_joomla_3_9_11_helix nu0qz_modules
id : int
asset_id : int unsigned
title : varchar(100)
note : varchar(255)
content : text
ordering : int
position : varchar(50)
checked_out : int unsigned
checked_out_time : datetime
publish_up : datetime
publish_down : datetime
published : tinyint(1)
module : varchar(50)
access : int unsigned
showtitle : tinyint unsigned
params : text
client_id : tinyint
language : char(7)

v		cabecab4_joomla_3_9_11_helix nu0qz_modules_menu
moduleid : int
menuid : int

v		cabecab4_joomla_3_9_11_helix nu0qz_newsfeeds
catid : int
id : int unsigned
name : varchar(100)
alias : varchar(400)
link : varchar(2048)
published : tinyint(1)
numarticles : int unsigned
cache_time : int unsigned
checked_out : int unsigned
checked_out_time : datetime
ordering : int
rtl : tinyint
access : int unsigned
language : char(7)
params : text
created : datetime
created_by : int unsigned
created_by_alias : varchar(255)
modified : datetime
modified_by : int unsigned
metakey : text
metadesc : text
metadata : text
xreference : varchar(50)
publish_up : datetime
publish_down : datetime
description : text
version : int unsigned
hits : int unsigned
images : text

v		cabecab4_joomla_3_9_11_helix nu0qz_overrider
id : int
constant : varchar(255)
string : text
file : varchar(255)

v		cabecab4_joomla_3_9_11_helix nu0qz_postinstall_messages
postinstall_message_id : bigint unsigned
extension_id : bigint
title_key : varchar(255)
description_key : varchar(255)
action_key : varchar(255)
language_extension : varchar(255)
language_client_id : tinyint
type : varchar(10)
action_file : varchar(255)
action : varchar(255)
condition_file : varchar(255)
condition_method : varchar(255)
version_introduced : varchar(50)
enabled : tinyint

v		cabecab4_joomla_3_9_11_helix nu0qz_privacy_consents
id : int unsigned
user_id : int unsigned
state : int
created : datetime
subject : varchar(255)
body : text
remind : tinyint
token : varchar(100)

v		cabecab4_joomla_3_9_11_helix nu0qz_privacy_requests
id : int unsigned
email : varchar(100)
requested_at : datetime
status : tinyint
request_type : varchar(25)
confirm_token : varchar(100)
confirm_token_created_at : datetime

v		cabecab4_joomla_3_9_11_helix nu0qz_quix
id : int unsigned
asset_id : int unsigned
title : varchar(255)
catid : int
builder : enum('classic','frontend')
builder_version : varchar(10)
data : longtext
metadata : longtext
language : varchar(5)
ordering : int
state : tinyint(1)
access : int
created : datetime
created_by : int unsigned
modified : datetime
modified_by : int unsigned
checked_out : int
checked_out_time : datetime
params : longtext
version : int unsigned
hits : int
xreference : varchar(50)

v		cabecab4_joomla_3_9_11_helix nu0qz_quix_collections
id : int unsigned
asset_id : int unsigned
uid : varchar(255)
title : varchar(255)
type : enum('layout','section')
catid : int
builder : enum('classic','frontend')
builder_version : varchar(10)
data : longtext
metadata : longtext
language : varchar(5)
ordering : int
state : tinyint(1)
access : int
created : datetime
created_by : int unsigned
modified : datetime
modified_by : int unsigned
checked_out : int
checked_out_time : datetime
params : longtext
version : int unsigned
hits : int
xreference : varchar(50)

v		cabecab4_joomla_3_9_11_helix nu0qz_quix_collection_map
id : int unsigned
cid : int unsigned
pid : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_quix_conditions
id : int
item_id : int
item_type : varchar(100)
component : varchar(100)
condition_type : varchar(100)
condition_id : int
condition_info : varchar(100)
params : longtext

v		cabecab4_joomla_3_9_11_helix nu0qz_quix_configs
name : varchar(255)
params : text

v		cabecab4_joomla_3_9_11_helix nu0qz_quix_editor_map
id : int
context : varchar(100)
context_id : int
collection_id : int
status : tinyint
params : longtext

v		cabecab4_joomla_3_9_11_helix nu0qz_quix_elements
id : smallint
alias : varchar(100)
status : tinyint(1)
params : varchar(255)

v		cabecab4_joomla_3_9_11_helix nu0qz_quix_imgstats
id : int
item_id : int
item_type : varchar(100)
images_count : int
original_size : int
optimise_size : int
mobile_size : int
params : longtext

v		cabecab4_joomla_3_9_11_helix nu0qz_redirect_links
id : int unsigned
old_url : varchar(2048)
new_url : varchar(2048)
referer : varchar(2048)
comment : varchar(255)
hits : int unsigned
published : tinyint
created_date : datetime
modified_date : datetime
header : smallint

v		cabecab4_joomla_3_9_11_helix nu0qz_schemas
extension_id : int
version_id : varchar(20)

v		cabecab4_joomla_3_9_11_helix nu0qz_session
session_id : varbinary(192)
client_id : tinyint unsigned
guest : tinyint unsigned
time : int
data : mediumtext
userid : int
username : varchar(150)

v		cabecab4_joomla_3_9_11_helix nu0qz_speasyimagegallery_albums
id : int unsigned
asset_id : int unsigned
title : varchar(255)
alias : varchar(400)
image : varchar(500)
description : mediumtext
published : tinyint
catid : int
created : datetime
created_by : int unsigned
modified : datetime
modified_by : int unsigned
checked_out : int unsigned
checked_out_time : datetime
attribs : varchar(5120)
ordering : int
metakey : text
metadesc : text
access : int unsigned
hits : int unsigned
metadata : text
featured : tinyint unsigned
language : char(7)

v		cabecab4_joomla_3_9_11_helix nu0qz_speasyimagegallery_images
id : int unsigned
asset_id : int unsigned
album_id : int
title : varchar(255)
alt : varchar(255)
filename : varchar(255)
description : mediumtext
state : tinyint
created : datetime
created_by : int unsigned
modified : datetime
modified_by : int unsigned
checked_out : int unsigned
checked_out_time : datetime
images : varchar(5120)
ordering : int
language : char(7)

v		cabecab4_joomla_3_9_11_helix nu0qz_spmedia
id : bigint unsigned
title : varchar(255)
path : varchar(255)
thumb : varchar(255)
alt : varchar(255)
caption : varchar(2048)
description : mediumtext
type : varchar(100)
extension : varchar(100)
created_on : datetime
created_by : bigint
modified_on : datetime
modified_by : bigint

v		cabecab4_joomla_3_9_11_helix nu0qz_sppagebuilder
id : bigint unsigned
asset_id : int
title : varchar(255)
text : mediumtext
extension : varchar(255)
extension_view : varchar(255)
view_id : bigint
active : tinyint(1)
published : tinyint
catid : int
access : int
ordering : int
created_on : datetime
created_by : bigint
modified : datetime
modified_by : bigint
checked_out : int
checked_out_time : datetime
og_title : varchar(255)
og_image : varchar(255)
og_description : varchar(255)
language : char(7)
hits : bigint
css : longtext

v		cabecab4_joomla_3_9_11_helix nu0qz_sppagebuilder_addons
id : int unsigned
title : varchar(255)
code : text
created : datetime
created_by : bigint

v		cabecab4_joomla_3_9_11_helix nu0qz_sppagebuilder_integrations
id : bigint unsigned
title : varchar(255)
description : mediumtext
component : varchar(255)
plugin : mediumtext
state : tinyint(1)

v		cabecab4_joomla_3_9_11_helix nu0qz_sppagebuilder_languages
id : int unsigned
title : varchar(255)
description : mediumtext
lang_tag : varchar(255)
lang_key : varchar(100)
version : mediumtext
state : tinyint(1)

v		cabecab4_joomla_3_9_11_helix nu0qz_sppagebuilder_sections
id : int unsigned
title : varchar(255)
section : text
created : datetime
created_by : bigint

v		cabecab4_joomla_3_9_11_helix nu0qz_spsimpleportfolio_items
id : bigint unsigned
title : varchar(255)
alias : varchar(55)
catid : int
image : text
thumbnail : text
video : text
description : mediumtext
client : varchar(100)
client_avatar : text
tagids : text
url : text
published : tinyint
language : varchar(255)
access : int
ordering : int
created_by : bigint
created : datetime
modified_by : bigint
modified : datetime
checked_out : bigint
checked_out_time : datetime

v		cabecab4_joomla_3_9_11_helix nu0qz_spsimpleportfolio_tags
id : bigint unsigned
title : varchar(255)
alias : varchar(55)

v		cabecab4_joomla_3_9_11_helix nu0qz_tags
id : int unsigned
parent_id : int unsigned
lft : int
rgt : int
level : int unsigned
path : varchar(400)
title : varchar(255)
alias : varchar(400)
note : varchar(255)
description : mediumtext
published : tinyint(1)
checked_out : int unsigned
checked_out_time : datetime
access : int unsigned
params : text
metadesc : varchar(1024)
metakey : varchar(1024)
metadata : varchar(2048)
created_user_id : int unsigned
created_time : datetime
created_by_alias : varchar(255)
modified_user_id : int unsigned
modified_time : datetime
images : text
urls : text
hits : int unsigned
language : char(7)
version : int unsigned
publish_up : datetime
publish_down : datetime

v		cabecab4_joomla_3_9_11_helix nu0qz_template_styles
id : int unsigned
template : varchar(50)
client_id : tinyint unsigned
home : char(7)
title : varchar(255)
params : text

v		cabecab4_joomla_3_9_11_helix nu0qz_ucm_base
ucm_id : int unsigned
ucm_item_id : int
ucm_type_id : int
ucm_language_id : int

v		cabecab4_joomla_3_9_11_helix nu0qz_ucm_content
core_content_id : int unsigned
core_type_alias : varchar(400)
core_title : varchar(400)
core_alias : varchar(400)
core_body : mediumtext
core_state : tinyint(1)
core_checked_out_time : varchar(255)
core_checked_out_user_id : int unsigned
core_access : int unsigned
core_params : text
core_featured : tinyint unsigned
core_metadata : varchar(2048)
core_created_user_id : int unsigned
core_created_by_alias : varchar(255)
core_created_time : datetime
core_modified_user_id : int unsigned
core_modified_time : datetime
core_language : char(7)
core_publish_up : datetime
core_publish_down : datetime
core_content_item_id : int unsigned
asset_id : int unsigned
core_images : text
core_urls : text
core_hits : int unsigned
core_version : int unsigned
core_ordering : int
core_metakey : text
core_metadesc : text
core_catid : int unsigned
core_xreference : varchar(50)
core_type_id : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_ucm_history
version_id : int unsigned
ucm_item_id : int unsigned
ucm_type_id : int unsigned
version_note : varchar(255)
save_date : datetime
editor_user_id : int unsigned
character_count : int unsigned
sha1_hash : varchar(50)
version_data : mediumtext
keep_forever : tinyint

v		cabecab4_joomla_3_9_11_helix nu0qz_updates
update_id : int
update_site_id : int
extension_id : int
name : varchar(100)
description : text
element : varchar(100)
type : varchar(20)
folder : varchar(20)
client_id : tinyint
version : varchar(32)
data : text
detailsurl : text
infourl : text
extra_query : varchar(1000)

v		cabecab4_joomla_3_9_11_helix nu0qz_update_sites
update_site_id : int
name : varchar(100)
type : varchar(20)
location : text
enabled : int
last_check_timestamp : bigint
extra_query : varchar(1000)

v		cabecab4_joomla_3_9_11_helix nu0qz_update_sites_extensions
update_site_id : int
extension_id : int

v		cabecab4_joomla_3_9_11_helix nu0qz_usergroups
id : int unsigned
parent_id : int unsigned
lft : int
rgt : int
title : varchar(100)

v		cabecab4_joomla_3_9_11_helix nu0qz_users
id : int
name : varchar(400)
username : varchar(150)
email : varchar(100)
password : varchar(100)
block : tinyint
sendEmail : tinyint
registerDate : datetime
lastvisitDate : datetime
activation : varchar(100)
params : text
lastResetTime : datetime
resetCount : int
otpKey : varchar(1000)
otep : varchar(1000)
requireReset : tinyint

v		cabecab4_joomla_3_9_11_helix nu0qz_user_keys
id : int unsigned
user_id : varchar(150)
token : varchar(255)
series : varchar(191)
invalid : tinyint
time : varchar(200)
uastring : varchar(255)

v		cabecab4_joomla_3_9_11_helix nu0qz_user_notes
id : int unsigned
user_id : int unsigned
catid : int unsigned
subject : varchar(100)
body : text
state : tinyint
checked_out : int unsigned
checked_out_time : datetime
created_user_id : int unsigned
created_time : datetime
modified_user_id : int unsigned
modified_time : datetime
review_time : datetime
publish_up : datetime
publish_down : datetime

v		cabecab4_joomla_3_9_11_helix nu0qz_user_profiles
user_id : int
profile_key : varchar(100)
profile_value : text
ordering : int

v		cabecab4_joomla_3_9_11_helix nu0qz_user_usergroup_map
user_id : int unsigned
group_id : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_utf8_conversion
converted : tinyint

v		cabecab4_joomla_3_9_11_helix nu0qz_viewlevels
id : int unsigned
title : varchar(100)
ordering : int
rules : varchar(5120)

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_adminmenuentries
id : tinyint unsigned
module_id : tinyint unsigned
parent_id : tinyint unsigned
name : char(64)
link : char(64)
depends : char(64)
icon_class : char(96)
ordering : int
published : tinyint(1)
tooltip : char(128)
view : char(32)
task : char(32)

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_calcs
virtuemart_calc_id : int unsigned
virtuemart_vendor_id : int unsigned
calc_jplugin_id : int
calc_name : varchar(64)
calc_descr : varchar(128)
calc_kind : varchar(16)
calc_value_mathop : varchar(8)
calc_value : decimal(10,4)
calc_currency : smallint unsigned
calc_shopper_published : tinyint(1)
calc_vendor_published : tinyint(1)
publish_up : datetime
publish_down : datetime
for_override : tinyint(1)
calc_params : varchar(15359)
ordering : int
shared : tinyint(1)
published : tinyint(1)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_calc_categories
id : int unsigned
virtuemart_calc_id : int unsigned
virtuemart_category_id : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_calc_countries
id : int unsigned
virtuemart_calc_id : int unsigned
virtuemart_country_id : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_calc_manufacturers
id : int unsigned
virtuemart_calc_id : int unsigned
virtuemart_manufacturer_id : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_calc_shoppergroups
id : int unsigned
virtuemart_calc_id : int unsigned
virtuemart_shoppergroup_id : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_calc_states
id : int unsigned
virtuemart_calc_id : int unsigned
virtuemart_state_id : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_carts
virtuemart_cart_id : int unsigned
virtuemart_user_id : int unsigned
virtuemart_vendor_id : int unsigned
cartData : varbinary(50000)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_categories
virtuemart_category_id : int unsigned
virtuemart_vendor_id : int unsigned
category_template : varchar(128)
category_layout : varchar(64)
category_product_layout : varchar(64)
products_per_row : varchar(1)
limit_list_step : varchar(32)
limit_list_initial : smallint unsigned
hits : int unsigned
cat_params : varchar(15359)
metarobot : varchar(40)
metaauthor : varchar(64)
ordering : int
shared : tinyint(1)
published : tinyint(1)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_categories_es_es
virtuemart_category_id : int unsigned
category_name : varchar(180)
category_description : varchar(19000)
metadesc : varchar(400)
metakey : varchar(400)
customtitle : varchar(255)
slug : varchar(192)

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_category_categories
id : int unsigned
category_parent_id : int unsigned
category_child_id : int unsigned
ordering : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_category_medias
id : int unsigned
virtuemart_category_id : int unsigned
virtuemart_media_id : int unsigned
ordering : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_configs
virtuemart_config_id : tinyint unsigned
config : text
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_countries
virtuemart_country_id : int unsigned
virtuemart_worldzone_id : tinyint(1)
country_name : varchar(64)
country_3_code : char(3)
country_2_code : char(2)
ordering : int
published : tinyint(1)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_coupons
virtuemart_coupon_id : int unsigned
virtuemart_vendor_id : int unsigned
coupon_code : varchar(32)
percent_or_total : enum('percent','total')
coupon_type : enum('gift','permanent')
coupon_value : decimal(15,5)
coupon_start_date : datetime
coupon_expiry_date : datetime
coupon_value_valid : decimal(15,5)
coupon_used : varchar(200)
published : tinyint(1)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_currencies
virtuemart_currency_id : int unsigned
virtuemart_vendor_id : int unsigned
currency_name : varchar(64)
currency_code_2 : char(2)
currency_code_3 : char(3)
currency_numeric_code : int
currency_exchange_rate : decimal(12,5)
currency_symbol : varchar(8)
currency_decimal_place : varchar(8)
currency_decimal_symbol : varchar(8)
currency_thousands : varchar(8)
currency_positive_style : varchar(64)
currency_negative_style : varchar(64)
ordering : int
shared : tinyint(1)
published : tinyint(1)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_customs
virtuemart_custom_id : int unsigned
custom_parent_id : int unsigned
virtuemart_vendor_id : int unsigned
custom_jplugin_id : int
custom_element : varchar(50)
admin_only : tinyint(1)
custom_title : varchar(255)
show_title : tinyint(1)
custom_tip : varchar(255)
custom_value : varchar(4095)
custom_desc : varchar(4095)
field_type : varchar(2)
is_list : tinyint(1)
is_hidden : tinyint(1)
is_cart_attribute : tinyint(1)
is_input : tinyint(1)
searchable : tinyint(1)
layout_pos : varchar(24)
custom_params : text
virtuemart_shoppergroup_id : varchar(255)
shared : tinyint(1)
published : tinyint(1)
created_on : datetime
created_by : int
ordering : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_invoices
virtuemart_invoice_id : int unsigned
virtuemart_vendor_id : int unsigned
virtuemart_order_id : int unsigned
invoice_number : varchar(64)
order_status : char(2)
xhtml : text
o_hash : varchar(33)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_manufacturercategories
virtuemart_manufacturercategories_id : int unsigned
published : tinyint(1)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_manufacturercategories_es_es
virtuemart_manufacturercategories_id : int unsigned
mf_category_name : varchar(180)
mf_category_desc : varchar(19000)
slug : varchar(192)

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_manufacturers
virtuemart_manufacturer_id : int unsigned
virtuemart_manufacturercategories_id : int
metarobot : varchar(400)
metaauthor : varchar(400)
hits : int unsigned
published : tinyint(1)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_manufacturers_es_es
virtuemart_manufacturer_id : int unsigned
mf_name : varchar(180)
mf_email : varchar(255)
mf_desc : varchar(19000)
mf_url : varchar(255)
metadesc : varchar(400)
metakey : varchar(400)
customtitle : varchar(255)
slug : varchar(192)

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_manufacturer_medias
id : int unsigned
virtuemart_manufacturer_id : int unsigned
virtuemart_media_id : int unsigned
ordering : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_medias
virtuemart_media_id : int unsigned
virtuemart_vendor_id : int unsigned
file_title : varchar(126)
file_description : varchar(254)
file_meta : varchar(254)
file_class : varchar(64)
file_mimetype : varchar(64)
file_type : varchar(32)
file_url : varchar(900)
file_url_thumb : varchar(900)
file_is_product_image : tinyint(1)
file_is_downloadable : tinyint(1)
file_is_forSale : tinyint(1)
file_params : varchar(12287)
file_lang : varchar(500)
shared : tinyint(1)
published : tinyint(1)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_migration_oldtonew_ids
id : smallint unsigned
cats : longblob
catsxref : blob
manus : longblob
mfcats : blob
shoppergroups : longblob
products : longblob
products_start : int
orderstates : blob
orders : longblob
attributes : longblob
relatedproducts : longblob
orders_start : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_modules
module_id : int unsigned
module_name : char(255)
module_description : varchar(15359)
module_perms : char(255)
published : tinyint(1)
is_admin : enum('0','1')
ordering : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_orders
virtuemart_order_id : int unsigned
virtuemart_user_id : int unsigned
virtuemart_vendor_id : int unsigned
order_number : varchar(64)
customer_number : varchar(32)
order_pass : varchar(34)
order_create_invoice_pass : varchar(32)
invoice_locked : tinyint(1)
order_total : decimal(15,5)
order_salesPrice : decimal(15,5)
order_billTaxAmount : decimal(15,5)
order_billTax : varchar(400)
order_billDiscountAmount : decimal(15,5)
order_discountAmount : decimal(15,5)
order_subtotal : decimal(15,5)
order_tax : decimal(12,5)
order_shipment : decimal(12,5)
order_shipment_tax : decimal(10,5)
order_payment : decimal(12,2)
order_payment_tax : decimal(10,5)
coupon_discount : decimal(12,2)
coupon_code : varchar(32)
order_discount : decimal(12,2)
order_currency : smallint
order_status : char(1)
user_currency_id : smallint
user_currency_rate : decimal(12,6)
user_shoppergroups : varchar(30)
payment_currency_id : smallint
payment_currency_rate : decimal(12,6)
virtuemart_paymentmethod_id : int unsigned
virtuemart_shipmentmethod_id : int unsigned
delivery_date : varchar(200)
order_language : varchar(7)
ip_address : char(15)
STsameAsBT : tinyint(1)
paid : decimal(15,5)
paid_on : datetime
o_hash : varchar(33)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_orderstates
virtuemart_orderstate_id : tinyint unsigned
virtuemart_vendor_id : int unsigned
order_status_code : char(1)
order_status_name : varchar(64)
order_status_color : varchar(64)
order_status_description : varchar(15359)
order_stock_handle : char(1)
ordering : int
published : tinyint(1)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_order_calc_rules
virtuemart_order_calc_rule_id : int unsigned
virtuemart_calc_id : int unsigned
virtuemart_order_id : int unsigned
virtuemart_vendor_id : int unsigned
virtuemart_order_item_id : int
calc_rule_name : varchar(64)
calc_kind : varchar(16)
calc_mathop : varchar(16)
calc_amount : decimal(15,5)
calc_result : decimal(15,5)
calc_value : decimal(15,5)
calc_currency : int
calc_params : varchar(15359)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_order_histories
virtuemart_order_history_id : int unsigned
virtuemart_order_id : int unsigned
order_status_code : char(1)
customer_notified : tinyint(1)
comments : varchar(15359)
paid : decimal(15,5)
o_hash : varchar(33)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_order_items
virtuemart_order_item_id : int unsigned
virtuemart_order_id : int unsigned
virtuemart_vendor_id : int unsigned
virtuemart_product_id : int
order_item_sku : varchar(255)
order_item_name : varchar(4096)
product_quantity : int
product_item_price : decimal(15,5)
product_priceWithoutTax : decimal(15,5)
product_tax : decimal(15,5)
product_basePriceWithTax : decimal(15,5)
product_discountedPriceWithoutTax : decimal(15,5)
product_final_price : decimal(15,5)
product_subtotal_discount : decimal(15,5)
product_subtotal_with_tax : decimal(15,5)
order_item_currency : int
order_status : char(1)
product_attribute : mediumtext
delivery_date : varchar(200)
paid : decimal(15,5)
oi_hash : varchar(33)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_order_item_histories
virtuemart_order_item_history_id : int unsigned
virtuemart_order_item_id : int unsigned
virtuemart_order_id : int unsigned
virtuemart_vendor_id : int unsigned
virtuemart_product_id : int
action : varchar(255)
order_item_sku : varchar(255)
order_item_name : varchar(4096)
product_quantity : int
product_item_price : decimal(15,5)
product_priceWithoutTax : decimal(15,5)
product_tax : decimal(15,5)
product_basePriceWithTax : decimal(15,5)
product_discountedPriceWithoutTax : decimal(15,5)
product_final_price : decimal(15,5)
product_subtotal_discount : decimal(15,5)
product_subtotal_with_tax : decimal(15,5)
order_item_currency : int
order_status : char(1)
product_attribute : mediumtext
delivery_date : varchar(200)
paid : decimal(15,5)
oi_hash : varchar(33)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_order_userinfos
virtuemart_order_userinfo_id : int unsigned
virtuemart_order_id : int unsigned
virtuemart_user_id : int unsigned
address_type : char(2)
address_type_name : varchar(32)
company : varchar(64)
title : varchar(32)
last_name : varchar(96)
first_name : varchar(96)
middle_name : varchar(96)
phone_1 : varchar(32)
phone_2 : varchar(32)
fax : varchar(32)
address_1 : varchar(96)
address_2 : varchar(64)
city : varchar(96)
virtuemart_state_id : smallint unsigned
virtuemart_country_id : smallint unsigned
zip : varchar(32)
email : varchar(128)
agreed : tinyint(1)
tos : tinyint(1)
customer_note : varchar(5000)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_paymentmethods
virtuemart_paymentmethod_id : int unsigned
virtuemart_vendor_id : int unsigned
payment_jplugin_id : int
payment_element : varchar(50)
payment_params : text
currency_id : int unsigned
shared : tinyint(1)
ordering : int
published : tinyint(1)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_paymentmethods_es_es
virtuemart_paymentmethod_id : int unsigned
payment_name : varchar(180)
payment_desc : varchar(19000)
slug : varchar(192)

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_paymentmethod_shoppergroups
id : int unsigned
virtuemart_paymentmethod_id : int unsigned
virtuemart_shoppergroup_id : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_payment_plg_standard
id : int unsigned
virtuemart_order_id : int unsigned
order_number : char(64)
virtuemart_paymentmethod_id : mediumint unsigned
payment_name : varchar(5000)
payment_order_total : decimal(15,5)
payment_currency : char(3)
email_currency : char(3)
cost_per_transaction : decimal(10,2)
cost_min_transaction : decimal(10,2)
cost_percent_total : decimal(10,2)
tax_id : smallint
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_products
virtuemart_product_id : int unsigned
virtuemart_vendor_id : int unsigned
product_parent_id : int unsigned
product_sku : varchar(255)
product_gtin : varchar(64)
product_mpn : varchar(64)
product_weight : decimal(10,4)
product_weight_uom : varchar(7)
product_length : decimal(10,4)
product_width : decimal(10,4)
product_height : decimal(10,4)
product_lwh_uom : varchar(7)
product_url : varchar(255)
product_in_stock : int
product_ordered : int
product_stockhandle : varchar(24)
low_stock_notification : int unsigned
product_available_date : datetime
product_availability : varchar(32)
product_special : tinyint(1)
product_discontinued : tinyint(1)
product_sales : int
product_unit : varchar(8)
product_packaging : decimal(8,4) unsigned
product_params : varchar(255)
product_canon_category_id : int
hits : int unsigned
intnotes : text
metarobot : varchar(400)
metaauthor : varchar(400)
layout : varchar(16)
published : tinyint(1)
pordering : int unsigned
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_products_es_es
virtuemart_product_id : int unsigned
product_s_desc : varchar(2000)
product_desc : text
product_name : varchar(180)
metadesc : varchar(400)
metakey : varchar(400)
customtitle : varchar(255)
slug : varchar(192)

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_product_categories
id : int unsigned
virtuemart_product_id : int unsigned
virtuemart_category_id : int unsigned
ordering : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_product_customfields
virtuemart_customfield_id : int unsigned
virtuemart_product_id : int
virtuemart_custom_id : int
customfield_value : varchar(2500)
customfield_price : decimal(15,6)
disabler : int unsigned
override : int unsigned
noninheritable : int unsigned
customfield_params : text
product_sku : varchar(64)
product_gtin : varchar(64)
product_mpn : varchar(64)
published : tinyint(1)
created_on : datetime
created_by : int unsigned
modified_on : datetime
modified_by : int unsigned
locked_on : datetime
locked_by : int unsigned
ordering : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_product_manufacturers
id : int unsigned
virtuemart_product_id : int
virtuemart_manufacturer_id : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_product_medias
id : int unsigned
virtuemart_product_id : int unsigned
virtuemart_media_id : int unsigned
ordering : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_product_prices
virtuemart_product_price_id : int unsigned
virtuemart_product_id : int unsigned
virtuemart_shoppergroup_id : int unsigned
product_price : decimal(15,6)
override : tinyint(1)
product_override_price : decimal(15,5)
product_tax_id : int
product_discount_id : int
product_currency : smallint
product_price_publish_up : datetime
product_price_publish_down : datetime
price_quantity_start : int unsigned
price_quantity_end : int unsigned
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_product_shoppergroups
id : int unsigned
virtuemart_product_id : int unsigned
virtuemart_shoppergroup_id : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_ratings
virtuemart_rating_id : int unsigned
virtuemart_product_id : int unsigned
rates : int
ratingcount : int unsigned
rating : decimal(10,1)
published : tinyint(1)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_rating_reviews
virtuemart_rating_review_id : int unsigned
virtuemart_rating_vote_id : int unsigned
virtuemart_product_id : int unsigned
comment : varchar(15359)
review_ok : tinyint(1)
review_rates : int unsigned
review_ratingcount : int unsigned
review_rating : decimal(10,2)
review_editable : tinyint(1)
lastip : char(50)
published : tinyint(1)
customer : varchar(128)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_rating_votes
virtuemart_rating_vote_id : int unsigned
virtuemart_product_id : int unsigned
vote : int
lastip : char(50)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_shipmentmethods
virtuemart_shipmentmethod_id : int unsigned
virtuemart_vendor_id : int unsigned
shipment_jplugin_id : int
shipment_element : varchar(50)
shipment_params : text
currency_id : int unsigned
ordering : int
shared : tinyint(1)
published : tinyint(1)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_shipmentmethods_es_es
virtuemart_shipmentmethod_id : int unsigned
shipment_name : varchar(180)
shipment_desc : varchar(19000)
slug : varchar(192)

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_shipmentmethod_shoppergroups
id : int unsigned
virtuemart_shipmentmethod_id : int unsigned
virtuemart_shoppergroup_id : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_shipment_plg_weight_countries
id : int unsigned
virtuemart_order_id : int unsigned
order_number : char(32)
virtuemart_shipmentmethod_id : mediumint unsigned
shipment_name : varchar(5000)
order_weight : decimal(10,4)
shipment_weight_unit : char(3)
shipment_cost : decimal(10,2)
shipment_package_fee : decimal(10,2)
tax_id : smallint
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_shoppergroups
virtuemart_shoppergroup_id : int unsigned
virtuemart_vendor_id : int unsigned
shopper_group_name : varchar(128)
shopper_group_desc : varchar(255)
custom_price_display : tinyint(1)
price_display : blob
default : tinyint(1)
sgrp_additional : tinyint(1)
ordering : int
shared : tinyint(1)
published : tinyint(1)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_states
virtuemart_state_id : int unsigned
virtuemart_vendor_id : int unsigned
virtuemart_country_id : int unsigned
virtuemart_worldzone_id : int unsigned
state_name : varchar(64)
state_3_code : char(3)
state_2_code : char(2)
ordering : int
shared : tinyint(1)
published : tinyint(1)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_userfields
virtuemart_userfield_id : int unsigned
virtuemart_vendor_id : int unsigned
userfield_jplugin_id : int
name : varchar(250)
title : varchar(255)
description : varchar(2048)
type : varchar(70)
maxlength : int
size : int
required : tinyint
cols : int
rows : int
value : varchar(255)
default : varchar(255)
placeholder : varchar(255)
registration : tinyint(1)
shipment : tinyint(1)
account : tinyint(1)
cart : tinyint(1)
readonly : tinyint(1)
calculated : tinyint(1)
sys : tinyint
userfield_params : text
ordering : int
shared : tinyint(1)
published : tinyint(1)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_userfield_values
virtuemart_userfield_value_id : int unsigned
virtuemart_userfield_id : int unsigned
fieldtitle : varchar(255)
fieldvalue : varchar(255)
sys : tinyint
ordering : int
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_userinfos
virtuemart_userinfo_id : int unsigned
virtuemart_user_id : int unsigned
address_type : char(2)
address_type_name : varchar(32)
company : varchar(64)
title : varchar(32)
last_name : varchar(96)
first_name : varchar(96)
middle_name : varchar(96)
phone_1 : varchar(32)
phone_2 : varchar(32)
fax : varchar(32)
address_1 : varchar(96)
address_2 : varchar(64)
city : varchar(96)
virtuemart_state_id : smallint unsigned
virtuemart_country_id : smallint unsigned
zip : varchar(32)
agreed : tinyint(1)
tos : tinyint(1)
customer_note : varchar(5000)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_vendors
virtuemart_vendor_id : int unsigned
vendor_name : varchar(64)
vendor_currency : int
vendor_accepted_currencies : varchar(1536)
vendor_params : varchar(14335)
metarobot : varchar(20)
metaauthor : varchar(64)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_vendors_es_es
virtuemart_vendor_id : int unsigned
vendor_store_desc : text
vendor_terms_of_service : text
vendor_legal_info : text
vendor_letter_css : text
vendor_letter_header_html : varchar(8000)
vendor_letter_footer_html : varchar(8000)
vendor_store_name : varchar(180)
vendor_phone : varchar(26)
vendor_url : varchar(255)
metadesc : varchar(400)
metakey : varchar(400)
customtitle : varchar(255)
vendor_invoice_free1 : varchar(255)
vendor_invoice_free2 : varchar(255)
vendor_mail_free1 : varchar(255)
vendor_mail_free2 : varchar(255)
vendor_mail_css : varchar(255)
slug : varchar(192)

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_vendor_medias
id : int unsigned
virtuemart_vendor_id : int unsigned
virtuemart_media_id : int unsigned
ordering : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_vendor_users
id : int unsigned
virtuemart_vendor_user_id : int unsigned
virtuemart_user_id : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_vmusers
virtuemart_user_id : int unsigned
virtuemart_vendor_id : int unsigned
user_is_vendor : tinyint(1)
customer_number : varchar(32)
virtuemart_paymentmethod_id : int unsigned
virtuemart_shipmentmethod_id : int unsigned
agreed : tinyint(1)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_vmuser_shoppergroups
id : int unsigned
virtuemart_user_id : int unsigned
virtuemart_shoppergroup_id : int unsigned

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_waitingusers
virtuemart_waitinguser_id : int unsigned
virtuemart_product_id : int unsigned
virtuemart_user_id : int unsigned
notify_email : varchar(150)
notified : tinyint(1)
notify_date : timestamp
ordering : int
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_virtuemart_worldzones
virtuemart_worldzone_id : smallint unsigned
virtuemart_vendor_id : int unsigned
zone_name : varchar(255)
zone_cost : decimal(10,2)
zone_limit : decimal(10,2)
zone_description : varchar(14335)
zone_tax_rate : int unsigned
ordering : int
shared : tinyint(1)
published : tinyint(1)
created_on : datetime
created_by : int
modified_on : datetime
modified_by : int
locked_on : datetime
locked_by : int

v		cabecab4_joomla_3_9_11_helix nu0qz_wf_profiles
id : int
name : varchar(255)
description : text
users : text
types : text
components : text
area : tinyint
device : varchar(255)
rows : text
plugins : text
published : tinyint
ordering : int
checked_out : int
checked_out_time : datetime
params : text

Create relationship
FOREIGN KEY
on delete
on update