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
FIC_CODEITEM
FIC_PERCIBIDO
FIC_IMP01ACTIVO
FIC_IMP01PORCENT
FIC_IMP01EXENTO
FIC_IMP01MONTO
FIC_IMP02ACTIVO
FIC_IMP02PORCENT
FIC_IMP02EXENTO
FIC_IMP02MONTO
FIC_COSTOANTBOLIVARES
FIC_COSTOACTBOLIVARES
FIC_COSTOPROMEDIO
FIC_COSTOANTEXTRANJERO
FIC_COSTOACTEXTRANJERO
FIC_COSTOPROMEDIOEXTRANJERO
FIC_COSTOREFERENCIA
FIC_P01PORCENTUTILIDAD
FIC_P01UTILIDAD
FIC_P01PRECIOSINIMPUESTO
FIC_P01IMTOIMPUESTO01
FIC_P01IMTOIMPUESTO02
FIC_P01IPRECIOTOTAL
FIC_P01PORCENTUTILIDADEXT
FIC_P01UTILIDADEXT
FIC_P01PRECIOTOTALEXT
FIC_P01TIPOROUND
FIC_P02PORCENTUTILIDAD
FIC_P02UTILIDAD
FIC_P02PRECIOSINIMPUESTO
FIC_P02IMTOIMPUESTO01
FIC_P02IMTOIMPUESTO02
FIC_P02IPRECIOTOTAL
FIC_P02PORCENTUTILIDADEXT
FIC_P02UTILIDADEXT
FIC_P02PRECIOTOTALEXT
FIC_P02TIPOROUND
FIC_P03PORCENTUTILIDAD
FIC_P03UTILIDAD
FIC_P03PRECIOSINIMPUESTO
FIC_P03IMTOIMPUESTO01
FIC_P03IMTOIMPUESTO02
FIC_P03IPRECIOTOTAL
FIC_P03PORCENTUTILIDADEXT
FIC_P03UTILIDADEXT
FIC_P03PRECIOTOTALEXT
FIC_P03TIPOROUND
FIC_P04PORCENTUTILIDAD
FIC_P04UTILIDAD
FIC_P04PRECIOSINIMPUESTO
FIC_P04IMTOIMPUESTO01
FIC_P04IMTOIMPUESTO02
FIC_P04IPRECIOTOTAL
FIC_P04PORCENTUTILIDADEXT
FIC_P04UTILIDADEXT
FIC_P04PRECIOTOTALEXT
FIC_P04TIPOROUND
FIC_P05PORCENTUTILIDAD
FIC_P05UTILIDAD
FIC_P05PRECIOSINIMPUESTO
FIC_P05IMTOIMPUESTO01
FIC_P05IMTOIMPUESTO02
FIC_P05IPRECIOTOTAL
FIC_P05PORCENTUTILIDADEXT
FIC_P05UTILIDADEXT
FIC_P05PRECIOTOTALEXT
FIC_P05TIPOROUND
FIC_P06PORCENTUTILIDAD
FIC_P06UTILIDAD
FIC_P06PRECIOSINIMPUESTO
FIC_P06IMTOIMPUESTO01
FIC_P06IMTOIMPUESTO02
FIC_P06IPRECIOTOTAL
FIC_P06PORCENTUTILIDADEXT
FIC_P06UTILIDADEXT
FIC_P06PRECIOTOTALEXT
FIC_P06TIPOROUND