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.
tid
session_id
transaction_id
platformBillID
student_id
paidamount
discount_amount
payment_mode
card_name
conveyance_fee
conveyance_fee_type
payer_vpa
sender_ifsc
sender_account_number
status
moved_status
transaction_at
payment_type
upi_ref
remarks
schoolCode
yr_id
fee_details
discount_details
split_details
payment_gateway
response_message
response_code
id_type
id_no
paid_type
paid_by
whatsApp_no
message_send
added_at
modified_at
moved_at
added_by_cron
added_by
moved_by