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
FCP_CODIGO
FCP_FECHAEMISION
FCP_CODIGOUNICO
FCP_CODIGOUNICO2
FCP_NUMERO
FCP_NUMERO2
FCP_TIPOTRANSACCION
FCP_TIPOOPERACION
FCP_DOCUMENTOORIGEN
FCP_DOCUMENTOAFECTADO
FCP_DESCRIPCIONMOV
FCP_FECHAVENCIMIENTO
FCP_FECHAPROXIMA
FCP_MONTODOCUMENTO
FCP_SALDODOCUMENTO
FCP_SALDOMONEDAEXT
FCP_ULTABONODCTO
FCP_ULTFECHAABONO
FCP_ULTABONOMTO
FCP_AFECTACOMPRASMES
FCP_AFECTALIBROCOMPRAS
FCP_MTOCOMISION
FCP_COSTOOPERACION
FCP_ESPAGO
FCP_ESCHEQUE
FCP_NROVENDEDOR
FCP_ESRETENCION
FCP_USUARIO
FCP_MONTORETENCION
FCP_CODERETENCION
FCP_BASERETENCION
FCP_BASEIMPONIBLE
FCP_BASEIMPONIBLE2
FCP_MULTIPLERETENCION
FCP_MONTOMONEDAEXT
FCP_FACTORCAMBIO
FCP_IMPUESTO1
FCP_MTOIMPUESTO1
FCP_IMPUESTO1PORCENT
FCP_IMPUESTO2
FCP_MTOIMPUESTO2
FCP_IMPUESTO2PORCENT
FCP_ESCHEQUEDEVUELTO
FCP_VIENEDE
FCP_FORMAPAGO
FCP_MONEDA
FCP_FECHARECEPCION
FCP_MARKPERIODO
FCP_PAGOORIGINAL
FCP_CONVERTED
BASE_AUTOINCREMENT
FCP_HORAEMISION
FCP_CONTROL
FCP_MONTOORIGINAL
FCP_MONTOORIGINALEXT
FCP_MACHINENAME
FCP_ORDENPAGO
FCP_CTOCOSTO
FCP_FECHALIBRO
FCP_SINCREDITOFISCAL
FCP_VTANAPAGO
FCP_MONEDACAMBIO
FCP_ORIGENCAMBIO
FCP_CODECAMBIO
FCP_VUELTOORG
FCP_FACTORREFERENCIA
FCP_FACTORVUELTO
FCP_FACTORVUELTOTIPO
FCP_ADELANTOXCAMBIO
FCP_FACTORREFERENCIA2
FCP_MULTIVUELTO
FCP_BASEIGTF