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.
DIV
CAT_COD
PRDCD
LOKASI
RCOST
MAX
CTGR
PTAG
SALDO_AWAL
RP_SLD_AWL
BEGBAL
BSUPPQ
BSUPPR
BTOKOQ
BTOKOR
BFRANQ
BFRANR
BGUDQ
BGUDR
BLAINQ
BLAINR
BBAIKQ
BBAIKR
BRETUQ
BRETUR
KRETUQ
KRETUR
KSUPPQ
KSUPPR
KTOKOQ
KTOKOR
KFRANQ
KFRANR
KGUDQ
KGUDR
KLAINQ
KLAINR
KRUSAQ
KRUSAR
KHILAQ
KHILAR
KMUSNQ
KMUSNR
ADJQ
ADJR
MPPQ1
MPPR1
MPPQ2
MPPR2
MPPQ3
MPPR3
MPPQSO
MPPRSO
ADJRP
ADJRP02
SALDO_AKH
RP_SLD_AKH
DESC2
TGLMATI
KET
PERIODE
PLUID
PLU4
GUDANG