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)
academic_year_id int(11)
constraint_name varchar(200) utf8mb4_general_ci
constraint_code varchar(100) utf8mb4_general_ci
constraint_type enum('TEACHER', 'CLASS', 'SECTION', 'SUBJECT', 'ROOM', 'PERIOD', 'DAY', 'WORKLOAD', 'DISTRIBUTION', 'CUSTOM') utf8mb4_general_ci
rule_level enum('HARD', 'SOFT') utf8mb4_general_ci
priority_level enum('LOW', 'NORMAL', 'HIGH', 'MANDATORY') utf8mb4_general_ci
target_teacher_id int(11)
target_class_id int(11)
target_section_id int(11)
target_subject_id int(11)
target_room_id int(11)
target_period_id int(11)
target_day_name varchar(20) utf8mb4_general_ci
operator_type enum('ALLOW', 'AVOID', 'BLOCK', 'LIMIT', 'PREFER', 'REQUIRE', 'BALANCE') utf8mb4_general_ci
rule_value varchar(255) utf8mb4_general_ci
rule_json longtext utf8mb4_general_ci
is_active tinyint(1)
delete_status tinyint(1)
created_by int(11)
updated_by int(11)
created_at datetime
updated_at datetime