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.
id
company_id
branch_id
application_no
application_date
enquiry_id
admission_type
student_name
gender
dob
blood_group
nationality
religion
category
caste
sub_caste
mother_tongue
academic_year_id
academic_year_name
class_id
class_name
section_id
section_name
father_name
father_mobile
father_email
father_occupation
father_income
mother_name
mother_mobile
mother_email
mother_occupation
mother_income
guardian_name
guardian_relation
guardian_mobile
guardian_email
primary_mobile
alternate_mobile
whatsapp_no
primary_email
current_address
permanent_address
city
state
pincode
previous_school
previous_class
previous_board
previous_percentage
transfer_certificate_no
sibling_available
sibling_details
transport_required
hostel_required
application_fee
registration_fee
fee_concession_requested
fee_concession_remarks
selection_status
approval_status
approved_by
approved_at
admission_no
student_id
admitted_at
remarks
delete_status
created_by
updated_by
deleted_by
created_at
updated_at
deleted_at