Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Foreign key constraints
Actions Constraint properties Column Creating a foreign key over a non-indexed column would automatically create an index on it. Alternatively, you can define an index below, before creating the foreign key. Foreign key constraint (INNODB)
Database Table Column
ON DELETE ON UPDATE
+ Add column
+ Add constraint
Internal relationships Documentation
Column Internal relation An internal relation is not necessary when a corresponding FOREIGN KEY relation exists.
_recno
FI_CODIGO
FI_DESCRIPCION
FI_CATEGORIA
FI_DESCRIPCIONDETALLADA
FI_VENDEDOR
FI_STATUS
FI_UNIDAD
FI_TIPOCODIGOBARRA
FI_IMAGEN
FI_SUSTITUTO1
FI_SUSTITUTO2
FI_SUSTITUTO3
FI_REFERENCIA
FI_MARCA
FI_MONEDA
FI_FACTORCONVERSION
FI_UNDEXISTENCIA2
FI_PUESTO
FI_SUJETOACOMISION
FI_MONTOCOMISION
FI_CUENTASCONTABLES
FI_PESOPRODUCTO
FI_DIASDEREPOSICION
FI_PRESENTACION
FI_GARANTIA
FI_SUSTITUTO4
FI_SUSTITUTO5
FI_MONTOCOMISIONP
FI_DEPOSITOS
FI_OFERTAS
FI_VENCIMIENTOS
FI_CLASIFICACION
FI_MANEJOINVENTARIO
FI_SERIALES
FI_CREACION
FI_INVENTARIOINICIALUNIDADES
FI_INVENTARIOINICIALCOSTO
FI_CAPACIDAD
FI_EXISTDECIMAL
FI_COMPUESTOSERIALES
FI_VENDEDORFIJO
FI_VENDEDORFIJOACTIVO
FI_MODELO
FI_SUBCATEGORIA
FI_PESOAFECTACOSTO
FI_IMPRESORA
BASE_AUTOINCREMENT
FI_ZEXTRA1
FI_ZEXTRA2
FI_ZEXTRA3
FI_ZEXTRA4
FI_ZEXTRA5
FI_ZEXTRA6
FI_ZEXTRA1VENTA
FI_ZEXTRA2VENTA
FI_ZEXTRA3VENTA
FI_ZEXTRA4VENTA
FI_ZEXTRA5VENTA
FI_ZEXTRA6VENTA
FI_ZEXTRA1VENTAMOD
FI_ZEXTRA2VENTAMOD
FI_ZEXTRA3VENTAMOD
FI_ZEXTRA4VENTAMOD
FI_ZEXTRA5VENTAMOD
FI_ZEXTRA6VENTAMOD
FI_INTERNET
FI_BALANZA
FI_CODIGOBARRA
FI_PRECIOLISTA
FI_APROVECHAPORC
FI_ARANCEL
FI_POSENTREGA