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
school_year
student_number
grade_10_section
section
lrn
last_name
first_name
middle_name
grade_10_school
birthday
address
student_contact
guardian_contact
guardian_name
four_ps
account_status
tuition_fee
remaining_balance
date_enrolled
referred_by
birth_certificate
form_138
good_moral
pic_1x1
pic_2x2
form_137
remarks
file_birth_certificate
file_form_138
file_good_moral
file_pic_1x1
file_pic_2x2
file_form_137
graduation_fee
remaining_graduation_balance
email_address
civil_status
sex
grade_level
semester
strand
strand_id
section_id
father_name
mother_name
referral_status
status
remark
was_transferee
total_paid
grade11_original_tuition
is_repeater
repeater_duration
curriculum_version