Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis »Table: employee_masters
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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:
Internal relations
Column Internal relation An internal relation is not necessary when a corresponding FOREIGN KEY relation exists.
id
empid
current_date
emp_name
dob
qualification
marital_status
a_year
a_month
a_day
gender
doj
blood_group
dol
father_sp
pf
relegion
location
staff_type
department_master_id
dept_code
dept_desc
status
desigcode
designation_id
description
house_no
street
a_location
district
town
state
country
pin
email
ph1
ph2
ph3
mob
fax
pager
created_date
created_by
modified_date
modified_by
auth
min_discount
max_discount
dis_request
req_dis_min
req_dis_max
cash
nippon_emp_id
posted_voucher_dis_apr_1
posted_voucher_dis_apr_2
locationname
biomatric_id
Foreign key constraints
Actions Constraint properties ColumnOnly columns with index will be displayed. You can define an index below. Foreign key constraint (INNODB)
ON DELETE   ON UPDATE  
+ Add column
+ Add constraint