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_CONTROL
FCP_DESCRIPCION
FCP_RIF
FCP_NIT
FCP_TELEFONO
FCP_DIRECCION
FCP_NUMERORETENCION
FCP_HORAEMISION
FCP_FECHALIBRO
FCP_CTOCOSTO
FCP_SUSTRAENDO
FCP_REFERENCIA
FCP_FECHAPAGO
FCP_ENTERADO
FCP_VTANAPAGO