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
FP_CODIGO
FP_DESCRIPCION
FP_CLASIFICACION
FP_MONEDA
FP_STATUS
FP_DESCRIPCIONDETALLADA
FP_DIRECCION1
FP_DIRECCION2
FP_DIRECCION3
FP_TELEFONO
FP_TELEFAX
FP_EMAIL
FP_CONTACTO
FP_WEBSITE
FP_FORMAENVIO
FP_NIT
FP_RIF
FP_LOGO
FP_IMAGE
FP_LIMITECREDITO
FP_DIASCREDITO
FP_FECHAINICIO
FP_TIPOCARGO
FP_FECHACARGO
FP_ULTIMOCARGO
FP_SALDO
FP_PAGOSADELANTADOS
FP_SALDOMONEDA2
FP_PAGOSADELMONEDA2
FP_TOTALCOMPRAS
FP_MAXIMOCREDITO
FP_PROMEDIOPAGODIAS
FP_DESCTOPRONTOPAGO
FP_TOTALIVAPAGADO
FP_PORCRETENCION
FP_DESCUENTOPRONTOPAGO
FP_FECHANACIMIENTO
BASE_AUTOINCREMENT
FP_FORMATOORDEN
FP_FORMATOCOMPRA
FP_FORMATODEVOLUCION
FP_FORMATONOTAENTREGA
FP_ESPECIAL
FP_CTOCOSTO
FP_RETENCIONIVA
FP_MSGTEXTO1
FP_MSGTEXTO2
FP_MSGTEXTO3
FP_MSGTEXTO4
FP_MSGTEXTO5
FP_TIPORETENCION
FP_CODERETENCION