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 :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id int(11)
company_id int(11)
branch_id int(11)
unit_id int(11)
attendance_id int(11)
student_id int(11)
admission_id int(11)
notification_type enum('absent', 'late', 'half_day', 'leave', 'permission', 'shortage', 'summary', 'custom') utf8mb4_unicode_ci
channel enum('whatsapp', 'sms', 'email', 'mobile_app') utf8mb4_unicode_ci
recipient_type enum('father', 'mother', 'guardian', 'student', 'other') utf8mb4_unicode_ci
recipient_name varchar(180) utf8mb4_unicode_ci
recipient_mobile varchar(40) utf8mb4_unicode_ci
recipient_email varchar(180) utf8mb4_unicode_ci
message_title varchar(180) utf8mb4_unicode_ci
message_text text utf8mb4_unicode_ci
send_status enum('pending', 'sent', 'failed', 'skipped') utf8mb4_unicode_ci
provider_name varchar(120) utf8mb4_unicode_ci
provider_reference varchar(180) utf8mb4_unicode_ci
response_text text utf8mb4_unicode_ci
sent_at datetime
is_active tinyint(1)
delete_status tinyint(1)
created_by int(11)
created_at datetime
Display order: