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 :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `REFERENTIAL_CONSTRAINTS`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME UNIQUE_CONSTRAINT_CATALOG UNIQUE_CONSTRAINT_SCHEMA UNIQUE_CONSTRAINT_NAME MATCH_OPTION UPDATE_RULE DELETE_RULE TABLE_NAME REFERENCED_TABLE_NAME
def baranguard fk_ai_log_barangay def baranguard PRIMARY NONE RESTRICT RESTRICT ai_processing_log barangay
def baranguard fk_ai_log_incident def baranguard PRIMARY NONE RESTRICT RESTRICT ai_processing_log incident
def baranguard fk_ai_log_requested_by def baranguard PRIMARY NONE RESTRICT SET NULL ai_processing_log user
def baranguard fk_audit_actor def baranguard PRIMARY NONE RESTRICT SET NULL audit_log user
def baranguard fk_audit_barangay def baranguard PRIMARY NONE RESTRICT SET NULL audit_log barangay
def baranguard fk_auth_session_user def baranguard PRIMARY NONE RESTRICT CASCADE auth_session user
def baranguard fk_blotter_amended_by def baranguard PRIMARY NONE RESTRICT SET NULL blotter_record user
def baranguard fk_blotter_approved_by def baranguard PRIMARY NONE RESTRICT SET NULL blotter_record user
def baranguard fk_blotter_barangay def baranguard PRIMARY NONE RESTRICT RESTRICT blotter_record barangay
def baranguard fk_blotter_incident def baranguard PRIMARY NONE RESTRICT RESTRICT blotter_record incident
def baranguard fk_blotter_recorded_by def baranguard PRIMARY NONE RESTRICT RESTRICT blotter_record user
def baranguard fk_blotter_revision_blotter def baranguard PRIMARY NONE RESTRICT RESTRICT blotter_revision blotter_record
def baranguard fk_blotter_revision_user def baranguard PRIMARY NONE RESTRICT SET NULL blotter_revision user
def baranguard fk_citizen_report_barangay def baranguard PRIMARY NONE RESTRICT RESTRICT citizen_report barangay
def baranguard fk_citizen_report_incident def baranguard PRIMARY NONE RESTRICT SET NULL citizen_report incident
def baranguard fk_dispatch_cancelled_by def baranguard PRIMARY NONE RESTRICT SET NULL dispatch user
def baranguard fk_dispatch_dispatched_by def baranguard PRIMARY NONE RESTRICT RESTRICT dispatch user
def baranguard fk_dispatch_incident def baranguard PRIMARY NONE RESTRICT RESTRICT dispatch incident
def baranguard fk_dispatch_tanod def baranguard PRIMARY NONE RESTRICT RESTRICT dispatch user
def baranguard fk_duty_status_user def baranguard PRIMARY NONE RESTRICT RESTRICT duty_status user
def baranguard fk_evidence_incident def baranguard PRIMARY NONE RESTRICT RESTRICT evidence_attachment incident
def baranguard fk_evidence_uploaded_by def baranguard PRIMARY NONE RESTRICT RESTRICT evidence_attachment user
def baranguard fk_fatigue_acknowledged_by def baranguard PRIMARY NONE RESTRICT SET NULL fatigue_flag user
def baranguard fk_fatigue_shift def baranguard PRIMARY NONE RESTRICT RESTRICT fatigue_flag shift_schedule
def baranguard fk_fatigue_user def baranguard PRIMARY NONE RESTRICT RESTRICT fatigue_flag user
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query