Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: gul »Table: approver
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
IndexesDocumentation
No index defined!
ActionKeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoId5ANo
idx_approver_titleHASHYesNotitleAYes
idx_approver_extension_businessBTREENoNoExtensionBusiness (768)5AYes
idx_approver_extension_familyBTREENoNoExtensionFamily (768)5AYes
idx_approver_extension_medicalBTREENoNoExtensionMedical (768)5AYes
idx_approver_extension_studyBTREENoNoExtensionStudy (768)5AYes
idx_approver_extension_spouseBTREENoNoExtensionSpouse (768)5AYes
idx_approver_extension_workBTREENoNoExtensionWork (768)5AYes
idx_approver_extension_touristBTREENoNoExtensionTourist (768)2AYes
idx_approver_extension_other_countryBTREENoNoExtensionOtherCountry (768)5AYes
idx_approver_extension_medical_etaBTREENoNoExtensionMedicalETA (768)5AYes
idx_approver_extension_tablighBTREENoNoExtensionTabligh (768)2AYes
idx_approver_extension_diplomaticBTREENoNoExtensionDiplomatic (768)2AYes
idx_approver_extension_officialBTREENoNoExtensionOfficial (768)2AYes
idx_approver_extension_sportBTREENoNoExtensionSport (768)2AYes
idx_approver_exit_businessBTREENoNoExitBusiness (768)2AYes
idx_approver_exit_familyBTREENoNoExitFamily (768)2AYes
idx_approver_exit_medicalBTREENoNoExitMedical (768)5AYes
idx_approver_exit_studyBTREENoNoExitStudy (768)2AYes
idx_approver_exit_spouseBTREENoNoExitSpouse (768)5AYes
idx_approver_exit_workBTREENoNoExitWork (768)5AYes
idx_approver_exit_touristBTREENoNoExitTourist (768)2AYes
idx_approver_exit_tablighBTREENoNoExitTabligh (768)2AYes
idx_approver_exit_afghanBTREENoNoExitAfghan (768)5AYes
idx_approver_exit_other_countryBTREENoNoExitOtherCountry (768)2AYes
idx_approver_exit_diplomaticBTREENoNoExitDiplomatic (768)2AYes
idx_approver_exit_officialBTREENoNoExitOfficial (768)2AYes
idx_approver_exit_sportBTREENoNoExitSport (768)2AYes
idx_approver_entry_businessBTREENoNoEntryBusiness (768)5AYes
idx_approver_entry_familyBTREENoNoEntryFamily (768)2AYes
idx_approver_entry_medicalBTREENoNoEntryMedical (768)2AYes
idx_approver_entry_studyBTREENoNoEntryStudy (768)5AYes
idx_approver_entry_spouseBTREENoNoEntrySpouse (768)2AYes
idx_approver_entry_workBTREENoNoEntryWork (768)5AYes
idx_approver_entry_touristBTREENoNoEntryTourist (768)2AYes
idx_approver_entry_other_countryBTREENoNoEntryOtherCountry (768)2AYes
idx_approver_entry_tablighBTREENoNoEntryTabligh (768)2AYes
idx_approver_entry_diplomaticBTREENoNoEntryDiplomatic (768)2AYes
idx_approver_entry_officialBTREENoNoEntryOfficial (768)2AYes
idx_approver_entry_sportBTREENoNoEntrySport (768)2AYes