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
Drop Drop
ON DELETE ON UPDATE
+ Add column
Drop Drop
ON DELETE ON UPDATE
+ Add column
Drop Drop
ON DELETE ON UPDATE
+ Add column
Drop Drop
ON DELETE ON UPDATE
+ Add column
Drop Drop
ON DELETE ON UPDATE
+ Add column
Drop Drop
ON DELETE ON UPDATE
+ Add column
Drop Drop
ON DELETE ON UPDATE
+ Add 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
ref_no
requester_id
request_type
for_employee
for_driver
driver_instruction
needs_vehicle
travel_date
destination
dest_lat
dest_lng
dest_address
purpose
time_from
time_to
department_id
requisitioner_name
approver_id
approver_name
status
approver_remarks
decided_at
qr_token
qr_sent_at
admin_status
date_received
vehicle_id
driver1_id
driver2_id
driver_sched_departure
driver_sched_arrival
arrangement_made_by
arrangement_approved_by
admin_remarks
admin_updated_by
admin_updated_at
guard_status
time_departure
km_out
time_arrival
km_in
guard_id
guard_name
guard_remarks
created_at
updated_at