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 :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id bigint(20)
employee_id varchar(50) utf8_general_ci
first_name varchar(100) utf8_general_ci
middle_name varchar(100) utf8_general_ci
last_name varchar(100) utf8_general_ci
nationality bigint(20) Browse foreign values Browse foreign values
birthday date
gender varchar(20) utf8_general_ci
marital_status enum('Married', 'Single', 'Divorced', 'Widowed', 'Other') utf8_general_ci
ssn_num varchar(100) utf8_general_ci
nic_num varchar(100) utf8_general_ci
other_id varchar(100) utf8_general_ci
driving_license varchar(100) utf8_general_ci
driving_license_exp_date date
employment_status bigint(20)
job_title bigint(20)
pay_grade bigint(20)
work_station_id varchar(100) utf8_general_ci
address1 varchar(100) utf8_general_ci
address2 varchar(100) utf8_general_ci
city varchar(150) utf8_general_ci
country char(2) utf8_general_ci Browse foreign values Browse foreign values
province bigint(20) Browse foreign values Browse foreign values
postal_code varchar(20) utf8_general_ci
home_phone varchar(50) utf8_general_ci
mobile_phone varchar(50) utf8_general_ci
work_phone varchar(50) utf8_general_ci
work_email varchar(100) utf8_general_ci
private_email varchar(100) utf8_general_ci
joined_date date
confirmation_date date
supervisor bigint(20)
indirect_supervisors varchar(250) utf8_general_ci
department bigint(20)
name_preferred varchar(60) utf8_general_ci
name_pronunciation varchar(40) utf8_general_ci
pronouns varchar(40) utf8_general_ci
custom4 varchar(250) utf8_general_ci
custom5 varchar(250) utf8_general_ci
custom6 varchar(250) utf8_general_ci
custom7 varchar(250) utf8_general_ci
custom8 varchar(250) utf8_general_ci
custom9 varchar(250) utf8_general_ci
custom10 varchar(250) utf8_general_ci
termination_date date
notes text utf8_general_ci
status enum('Active', 'Terminated') utf8_general_ci
ethnicity bigint(20)
immigration_status bigint(20)
approver1 bigint(20)
approver2 bigint(20)
approver3 bigint(20)
tax_id varchar(50) utf8_general_ci
health_insurance varchar(100) utf8_general_ci
timezone varchar(100) utf8_general_ci