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.
id
YEAR
MONTH
TYPE
MAHINA
DATE_NEP
CHET_KITAB_NIVEDAN_SANKHYA
CHET_KITAB_KAM_TAMELI
CHET_KITAB_BANKI
NAKSHA_NIVEDAN_SANKHYA
NAKSHA_FULL_SIZE
NAKSHA_HALF_SIZE
NAKSHA_QUATER_SIZE
NAKSHA_NIVEDAN_BAKI
NAKSHA_EMANYA_REL_KHARCHA
NAKSHA_TEST_KHARCHA
NAKSHA_RAJASWO
CHETRAFAL_NIVEDAN_SANKHYA
CHETRAFAL_KAM_TAMELI
CHETRAFAL_BAKI
REKHANKAN_NIVEDAN_SANKHYA
REKAHNKAN_KAM_TAMELI
REKHANKAN_BAKI
REKHANKAN_RAJWO_RAKAM
KITTA_JAMMA_RAJINAMA
KITTA_JAMMA_NAPI
KITTA_JAMMA_ADALAT
KITTA_KAM_RAJINAMA
KITTA_KAM_NAPI
KITTA_KAM_ADALAT
KITTA_BAKI_RAJINAMA
KITTA_BAKI_NAPI
KITTA_BAKI_ADALAT
FIELD_JACH_RAJINAMA
FIELD_JACH_NAPI
FIELD_JACH_ADALAT
FIELD_JACH_KAM_RAJINAMA
FIELD_JACH_KAM_NAPI
FIELD_JACH_KAM_ADALAT
FIELD_JACH_BAKI_RAJINAMA
FIELD_JACH_BAKI_NAPI
FIELD_JACH_BAKI_ADALAT
TRACE_GP_JAMMA_NAKSHA
TRACE_GP_BAKI_NAKSHA
TRACE_BP_BAKI
GATA_MAHINA_TRACE
YESH_MAHINA_TRACE
FILE_NAKSHA
SAMASYA_SAMADHAN
KAUFIYAT
CREATED_AT
CREATED_BY
UPDATED_AT
UPDATED_BY