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
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
institute_id
year
total_staffs
total_budget
total_score
score_by_staff
score_by_budget
weighted_score
percentage_research_projects_completed_on_time
num_national_international_collaborative_projects
total_num_degrees_guided
grant_received_other_than_CCRAS
num_national_international_programs_organized
num_policies_regulations_contributed
has_accreditation_other_than_statutory
num_awards_received
total_num_startups_incubated
num_commissioned_reports_prepared
num_new_research_fields_impacting_society
num_technologies_targeted_to_sdg_national_programs
num_reports_new_designs_products
facilities_opened_for_testing
patient_services_footfall_drug_testing
average_bed_occupancy
num_speciality_opds
num_copyrights_trademarks_patents
num_technologies_transferred_domestic_international
num_new_products_services_in_market
num_publications_in_peer_reviewed_journals
num_citations_in_last_three_years
num_collaborative_project_publications
percentage_publications_in_indexed_journals
num_books_ebooks_monographs
num_audio_visual_materials_produced
adopted_digital_technologies_ai
website_is_accessible_and_secure
percentage_budget_returned_unutilized
percentage_budget_on_rnd_to_overall_budget
total_annual_earnings
percentage_permanent_scientists_contractual_researchers
percentage_young_women_scientists_researchers
support_for_women_young_scientists_training
num_scientists_deputed_for_training
num_skill_development_programs
num_training_workshops_cmes
num_persons_attended_skill_development_training
num_officers_trained_in_advanced_areas
num_iec_awareness_programs
num_hindi_activities
num_swachata_action_plan
num_days_weeks_celebrations
celebrates_national_international_days
conducts_regular_review_meetings
completed_activities_as_per_calendar
total_count
status
created_at
updated_at
percentage_research_projects_completed_on_time_page_no
num_national_international_collaborative_projects_page_no
total_num_degrees_guided_page_no
grant_received_other_than_CCRAS_page_no
num_national_international_programs_organized_page_no
num_policies_regulations_contributed_page_no
has_accreditation_other_than_statutory_page_no
num_awards_received_page_no
total_num_startups_incubated_page_no
num_commissioned_reports_prepared_page_no
num_new_research_fields_impacting_society_page_no
num_technologies_targeted_to_sdg_national_programs_page_no
num_reports_new_designs_products_page_no
facilities_opened_for_testing_page_no
patient_services_footfall_drug_testing_page_no
average_bed_occupancy_page_no
num_speciality_opds_page_no
num_copyrights_trademarks_patents_page_no
num_technologies_transferred_domestic_international_page_no
num_new_products_services_in_market_page_no
num_publications_in_peer_reviewed_journals_page_no
num_citations_in_last_three_years_page_no
num_collaborative_project_publications_page_no
percentage_publications_in_indexed_journals_page_no
num_books_ebooks_monographs_page_no
num_audio_visual_materials_produced_page_no
adopted_digital_technologies_ai_page_no
website_is_accessible_and_secure_page_no
percentage_budget_returned_unutilized_page_no
percentage_budget_on_rnd_to_overall_budget_page_no
total_annual_earnings_page_no
percentage_permanent_scientists_contractual_researchers_page_no
percentage_young_women_scientists_researchers_page_no
support_for_women_young_scientists_training_page_no
num_scientists_deputed_for_training_page_no
num_skill_development_programs_page_no
num_training_workshops_cmes_page_no
num_persons_attended_skill_development_training_page_no
num_officers_trained_in_advanced_areas_page_no
num_iec_awareness_programs_page_no
num_hindi_activities_page_no
num_swachata_action_plan_page_no
num_days_weeks_celebrations_page_no
celebrates_national_international_days_page_no
conducts_regular_review_meetings_page_no
completed_activities_as_per_calendar_page_no