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
FC_CODIGO
FC_DESCRIPCION
FC_STATUS
FC_CLASIFICACION
FC_DESCRIPCIONDETALLADA
FC_NIT
FC_RIF
FC_TIPO
FC_CONTACTO
FC_DIRECCION1
FC_DIRECCION2
FC_DIRECCION3
FC_TELEFONO
FC_TELEFAX
FC_EMAIL
FC_WEBSITE
FC_FORMAENVIO
FC_ZONA
FC_VENDEDOR
FC_COBRADOR
FC_LIMITECREDITO
FC_DIASCREDITO
FC_MORA
FC_FECHAINICIO
FC_MAXIMODESCUENTO
FC_SALDO
FC_PAGOSADELANTADOS
FC_SALDOMONEDA2
FC_PAGOSADELMONEDA2
FC_TOTALVENTA
FC_MAXIMOCREDITO
FC_PROMEDIOPAGOSDIAS
FC_TOTALIVARETENIDO
FC_DESCTOPRONTOPAGO
FC_FLAGCONTABILIDAD
FC_FLAGULTIMASOPERACIONES
FC_IMAGEN
FC_FOTO
FC_MONEDA
FC_EXENTO
FC_FRECUENCIA
FC_DIACORTE
FC_PRECIODEFECTO
FC_DESCUENTOPRONTOPAGO
FC_RECORDCONTADO
FC_FECHANACIMIENTO
BASE_AUTOINCREMENT
FC_RETENCION
FC_FORMATOFACTURA
FC_FORMATOAPARTADO
FC_FORMATOLOTE
FC_FORMATODEVOLUCION
FC_FORMATOPRESUPUESTO
FC_FORMATONOTAENTREGA
FC_FORMATOPEDIDO
FC_MONEDACARGOSFIJO
FC_MONEDACONVENIO
FC_ESPECIAL
FC_HISTORICO
FC_EMISION
FC_TOLERANCIA
FC_CTOCOSTO
FC_MSGTEXTO1
FC_MSGTEXTO2
FC_MSGTEXTO3
FC_MSGTEXTO4
FC_MSGTEXTO5
FC_CODERETENCION