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
employee_code
biometric_code
old_employee_code
salutation
first_name
middle_name
last_name
display_name
gender
date_of_birth
blood_group
marital_status
nationality
religion
caste_category
mobile_no
alternate_mobile_no
email
personal_email
current_address
current_city
current_state
current_pincode
permanent_address
permanent_city
permanent_state
permanent_pincode
joining_date
confirmation_date
probation_end_date
resignation_date
relieving_date
employee_type
employment_category
staff_category
department_name
designation_name
reporting_manager_id
work_location
shift_name
employee_status
attendance_applicable
payroll_applicable
portal_access
aadhaar_no
pan_no
passport_no
driving_license_no
emergency_contact_name
emergency_contact_relation
emergency_contact_mobile
photo_path
signature_path
notes
is_active
delete_status
created_by
updated_by
deleted_by
created_at
updated_at
deleted_at