Recent
`phpmyadmin`.`pma__pdf_pages`
`opencart_db`.`oc_event`
`opencart_db`.`oc_weight_class`
`information_schema`.`INNODB_CMP_PER_INDEX`
`charity_test`.`payment_order`
`opencart_db`.`oc_subscription_log`
`charity_test`.`categories`
`ims`.`failed_jobs`
`warehouse_supplychain`.`branches`
`opencart_db`.`oc_layout_module`
Favourites
There are no favourite tables.
X
New
alnaqeeb_charity
bagisto
biotimedb
charity
charity
charity_test
delivery_db
delivery_db
delivery_db_new
ecommerce_db
emp_track_db
enjazi_db
enjaz_workflow
enterprise_workflow
goal_tracker
hr_complaint_app
icehrm_db
ims
information_schema
inventory_management
invoice_db
jobapplications
kalkun
mysql
opencart_db
performance_schema
phpmyadmin
sales
sales_inventory_db
sales_management
supermarket_app
test
the_old_database
ticket_app_db
ticket_app_db
ticket_app_db_test
velstore
warehouse
warehouse_inventory
warehouse_management
warehouse_supplychain
workflow
zk_attendance
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customise appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favourite tables
Maximum number of favourite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customise the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: icehrm_db
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
Console
Clear
History
Options
Bookmarks
Debug SQL
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
Label:
Target database:
Share this bookmark
OK
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Bookmark
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Switch to
visual builder
Saved bookmarked search:
New bookmark
Column:
`archivedemployees`.*
`archivedemployees`.`id`
`archivedemployees`.`ref_id`
`archivedemployees`.`employee_id`
`archivedemployees`.`first_name`
`archivedemployees`.`last_name`
`archivedemployees`.`gender`
`archivedemployees`.`ssn_num`
`archivedemployees`.`nic_num`
`archivedemployees`.`other_id`
`archivedemployees`.`work_email`
`archivedemployees`.`joined_date`
`archivedemployees`.`confirmation_date`
`archivedemployees`.`supervisor`
`archivedemployees`.`department`
`archivedemployees`.`termination_date`
`archivedemployees`.`notes`
`archivedemployees`.`data`
`assettypes`.*
`assettypes`.`id`
`assettypes`.`name`
`assettypes`.`description`
`assettypes`.`attachment`
`assettypes`.`created`
`assettypes`.`updated`
`attendance`.*
`attendance`.`id`
`attendance`.`employee`
`attendance`.`in_time`
`attendance`.`out_time`
`attendance`.`note`
`attendance`.`image_in`
`attendance`.`image_out`
`attendance`.`map_lat`
`attendance`.`map_lng`
`attendance`.`map_snapshot`
`attendance`.`map_out_lat`
`attendance`.`map_out_lng`
`attendance`.`map_out_snapshot`
`attendance`.`in_ip`
`attendance`.`out_ip`
`auditlog`.*
`auditlog`.`id`
`auditlog`.`time`
`auditlog`.`user`
`auditlog`.`ip`
`auditlog`.`type`
`auditlog`.`employee`
`auditlog`.`details`
`certifications`.*
`certifications`.`id`
`certifications`.`name`
`certifications`.`description`
`clients`.*
`clients`.`id`
`clients`.`name`
`clients`.`details`
`clients`.`first_contact_date`
`clients`.`created`
`clients`.`address`
`clients`.`contact_number`
`clients`.`contact_email`
`clients`.`company_url`
`clients`.`status`
`companyassets`.*
`companyassets`.`id`
`companyassets`.`code`
`companyassets`.`type`
`companyassets`.`attachment`
`companyassets`.`employee`
`companyassets`.`department`
`companyassets`.`description`
`companyassets`.`created`
`companyassets`.`updated`
`companydocuments`.*
`companydocuments`.`id`
`companydocuments`.`name`
`companydocuments`.`details`
`companydocuments`.`valid_until`
`companydocuments`.`status`
`companydocuments`.`notify_employees`
`companydocuments`.`attachment`
`companydocuments`.`share_departments`
`companydocuments`.`share_employees`
`companydocuments`.`share_userlevel`
`companyloans`.*
`companyloans`.`id`
`companyloans`.`name`
`companyloans`.`details`
`companystructures`.*
`companystructures`.`id`
`companystructures`.`title`
`companystructures`.`description`
`companystructures`.`address`
`companystructures`.`type`
`companystructures`.`country`
`companystructures`.`parent`
`companystructures`.`timezone`
`companystructures`.`heads`
`conversations`.*
`conversations`.`id`
`conversations`.`message`
`conversations`.`type`
`conversations`.`attachment`
`conversations`.`employee`
`conversations`.`target`
`conversations`.`created`
`conversations`.`updated`
`conversations`.`timeint`
`conversationuserstatus`.*
`conversationuserstatus`.`id`
`conversationuserstatus`.`employee`
`conversationuserstatus`.`status`
`conversationuserstatus`.`seen_at`
`country`.*
`country`.`id`
`country`.`code`
`country`.`namecap`
`country`.`name`
`country`.`iso3`
`country`.`numcode`
`courses`.*
`courses`.`id`
`courses`.`code`
`courses`.`name`
`courses`.`description`
`courses`.`coordinator`
`courses`.`trainer`
`courses`.`trainer_info`
`courses`.`paymentType`
`courses`.`currency`
`courses`.`cost`
`courses`.`status`
`courses`.`created`
`courses`.`updated`
`crons`.*
`crons`.`id`
`crons`.`name`
`crons`.`class`
`crons`.`lastrun`
`crons`.`frequency`
`crons`.`time`
`crons`.`type`
`crons`.`status`
`currencytypes`.*
`currencytypes`.`id`
`currencytypes`.`code`
`currencytypes`.`name`
`customfields`.*
`customfields`.`id`
`customfields`.`type`
`customfields`.`name`
`customfields`.`data`
`customfields`.`display`
`customfields`.`created`
`customfields`.`updated`
`customfields`.`field_type`
`customfields`.`field_label`
`customfields`.`field_validation`
`customfields`.`field_options`
`customfields`.`display_order`
`customfields`.`display_section`
`customfieldvalues`.*
`customfieldvalues`.`id`
`customfieldvalues`.`type`
`customfieldvalues`.`name`
`customfieldvalues`.`object_id`
`customfieldvalues`.`value`
`customfieldvalues`.`updated`
`customfieldvalues`.`created`
`dataentrybackups`.*
`dataentrybackups`.`id`
`dataentrybackups`.`tableType`
`dataentrybackups`.`data`
`dataimport`.*
`dataimport`.`id`
`dataimport`.`name`
`dataimport`.`dataType`
`dataimport`.`details`
`dataimport`.`columns`
`dataimport`.`updated`
`dataimport`.`created`
`dataimport`.`objectType`
`dataimportfiles`.*
`dataimportfiles`.`id`
`dataimportfiles`.`name`
`dataimportfiles`.`data_import_definition`
`dataimportfiles`.`status`
`dataimportfiles`.`file`
`dataimportfiles`.`details`
`dataimportfiles`.`updated`
`dataimportfiles`.`created`
`deductiongroup`.*
`deductiongroup`.`id`
`deductiongroup`.`name`
`deductiongroup`.`description`
`deductions`.*
`deductions`.`id`
`deductions`.`name`
`deductions`.`componentType`
`deductions`.`component`
`deductions`.`payrollColumn`
`deductions`.`rangeAmounts`
`deductions`.`deduction_group`
`documents`.*
`documents`.`id`
`documents`.`name`
`documents`.`details`
`documents`.`expire_notification`
`documents`.`expire_notification_month`
`documents`.`expire_notification_week`
`documents`.`expire_notification_day`
`documents`.`sign`
`documents`.`sign_label`
`documents`.`created`
`documents`.`updated`
`documents`.`share_with_employee`
`educations`.*
`educations`.`id`
`educations`.`name`
`educations`.`description`
`emaillog`.*
`emaillog`.`id`
`emaillog`.`subject`
`emaillog`.`toEmail`
`emaillog`.`body`
`emaillog`.`cclist`
`emaillog`.`bcclist`
`emaillog`.`created`
`emaillog`.`updated`
`emaillog`.`status`
`emails`.*
`emails`.`id`
`emails`.`subject`
`emails`.`toEmail`
`emails`.`template`
`emails`.`params`
`emails`.`cclist`
`emails`.`bcclist`
`emails`.`error`
`emails`.`created`
`emails`.`updated`
`emails`.`status`
`emergencycontacts`.*
`emergencycontacts`.`id`
`emergencycontacts`.`employee`
`emergencycontacts`.`name`
`emergencycontacts`.`relationship`
`emergencycontacts`.`home_phone`
`emergencycontacts`.`work_phone`
`emergencycontacts`.`mobile_phone`
`employeeapprovals`.*
`employeeapprovals`.`id`
`employeeapprovals`.`type`
`employeeapprovals`.`element`
`employeeapprovals`.`approver`
`employeeapprovals`.`level`
`employeeapprovals`.`status`
`employeeapprovals`.`active`
`employeeapprovals`.`created`
`employeeapprovals`.`updated`
`employeeattendancesheets`.*
`employeeattendancesheets`.`id`
`employeeattendancesheets`.`employee`
`employeeattendancesheets`.`date_start`
`employeeattendancesheets`.`date_end`
`employeeattendancesheets`.`status`
`employeecareer`.*
`employeecareer`.`id`
`employeecareer`.`employee`
`employeecareer`.`job_title`
`employeecareer`.`employment_status`
`employeecareer`.`department`
`employeecareer`.`supervisor`
`employeecareer`.`date_start`
`employeecareer`.`date_end`
`employeecareer`.`details`
`employeecareer`.`created`
`employeecareer`.`updated`
`employeecertifications`.*
`employeecertifications`.`id`
`employeecertifications`.`certification_id`
`employeecertifications`.`employee`
`employeecertifications`.`institute`
`employeecertifications`.`date_start`
`employeecertifications`.`date_end`
`employeecompanyloans`.*
`employeecompanyloans`.`id`
`employeecompanyloans`.`employee`
`employeecompanyloans`.`loan`
`employeecompanyloans`.`start_date`
`employeecompanyloans`.`last_installment_date`
`employeecompanyloans`.`period_months`
`employeecompanyloans`.`currency`
`employeecompanyloans`.`amount`
`employeecompanyloans`.`monthly_installment`
`employeecompanyloans`.`status`
`employeecompanyloans`.`details`
`employeedatahistory`.*
`employeedatahistory`.`id`
`employeedatahistory`.`type`
`employeedatahistory`.`employee`
`employeedatahistory`.`field`
`employeedatahistory`.`old_value`
`employeedatahistory`.`new_value`
`employeedatahistory`.`description`
`employeedatahistory`.`user`
`employeedatahistory`.`updated`
`employeedatahistory`.`created`
`employeedependents`.*
`employeedependents`.`id`
`employeedependents`.`employee`
`employeedependents`.`name`
`employeedependents`.`relationship`
`employeedependents`.`dob`
`employeedependents`.`id_number`
`employeedocuments`.*
`employeedocuments`.`id`
`employeedocuments`.`employee`
`employeedocuments`.`document`
`employeedocuments`.`date_added`
`employeedocuments`.`valid_until`
`employeedocuments`.`status`
`employeedocuments`.`details`
`employeedocuments`.`attachment`
`employeedocuments`.`signature`
`employeedocuments`.`expire_notification_last`
`employeedocuments`.`visible_to`
`employeedocuments`.`hidden`
`employeeeducations`.*
`employeeeducations`.`id`
`employeeeducations`.`education_id`
`employeeeducations`.`employee`
`employeeeducations`.`institute`
`employeeeducations`.`date_start`
`employeeeducations`.`date_end`
`employeeethnicity`.*
`employeeethnicity`.`id`
`employeeethnicity`.`employee`
`employeeethnicity`.`ethnicity`
`employeeexpenses`.*
`employeeexpenses`.`id`
`employeeexpenses`.`employee`
`employeeexpenses`.`expense_date`
`employeeexpenses`.`payment_method`
`employeeexpenses`.`transaction_no`
`employeeexpenses`.`payee`
`employeeexpenses`.`category`
`employeeexpenses`.`notes`
`employeeexpenses`.`amount`
`employeeexpenses`.`currency`
`employeeexpenses`.`attachment1`
`employeeexpenses`.`attachment2`
`employeeexpenses`.`attachment3`
`employeeexpenses`.`created`
`employeeexpenses`.`updated`
`employeeexpenses`.`status`
`employeeforms`.*
`employeeforms`.`id`
`employeeforms`.`employee`
`employeeforms`.`form`
`employeeforms`.`status`
`employeeforms`.`created`
`employeeforms`.`updated`
`employeegoals`.*
`employeegoals`.`id`
`employeegoals`.`employee`
`employeegoals`.`review`
`employeegoals`.`status`
`employeegoals`.`title`
`employeegoals`.`description`
`employeegoals`.`manager_rating`
`employeegoals`.`manager_feedback`
`employeegoals`.`employee_rating`
`employeegoals`.`employee_feedback`
`employeegoals`.`created`
`employeegoals`.`updated`
`employeeimmigrations`.*
`employeeimmigrations`.`id`
`employeeimmigrations`.`employee`
`employeeimmigrations`.`document`
`employeeimmigrations`.`documentname`
`employeeimmigrations`.`valid_until`
`employeeimmigrations`.`status`
`employeeimmigrations`.`details`
`employeeimmigrations`.`attachment1`
`employeeimmigrations`.`attachment2`
`employeeimmigrations`.`attachment3`
`employeeimmigrations`.`created`
`employeeimmigrations`.`updated`
`employeeimmigrationstatus`.*
`employeeimmigrationstatus`.`id`
`employeeimmigrationstatus`.`employee`
`employeeimmigrationstatus`.`status`
`employeelanguages`.*
`employeelanguages`.`id`
`employeelanguages`.`language_id`
`employeelanguages`.`employee`
`employeelanguages`.`reading`
`employeelanguages`.`speaking`
`employeelanguages`.`writing`
`employeelanguages`.`understanding`
`employeeleavedays`.*
`employeeleavedays`.`id`
`employeeleavedays`.`employee_leave`
`employeeleavedays`.`leave_date`
`employeeleavedays`.`leave_type`
`employeeleavelog`.*
`employeeleavelog`.`id`
`employeeleavelog`.`employee_leave`
`employeeleavelog`.`user_id`
`employeeleavelog`.`data`
`employeeleavelog`.`status_from`
`employeeleavelog`.`status_to`
`employeeleavelog`.`created`
`employeeleaves`.*
`employeeleaves`.`id`
`employeeleaves`.`employee`
`employeeleaves`.`leave_type`
`employeeleaves`.`leave_period`
`employeeleaves`.`date_start`
`employeeleaves`.`date_end`
`employeeleaves`.`details`
`employeeleaves`.`status`
`employeeleaves`.`attachment`
`employeeovertime`.*
`employeeovertime`.`id`
`employeeovertime`.`employee`
`employeeovertime`.`start_time`
`employeeovertime`.`end_time`
`employeeovertime`.`category`
`employeeovertime`.`project`
`employeeovertime`.`notes`
`employeeovertime`.`created`
`employeeovertime`.`updated`
`employeeovertime`.`status`
`employeeprojects`.*
`employeeprojects`.`id`
`employeeprojects`.`employee`
`employeeprojects`.`project`
`employeeprojects`.`date_start`
`employeeprojects`.`date_end`
`employeeprojects`.`status`
`employeeprojects`.`details`
`employees`.*
`employees`.`id`
`employees`.`employee_id`
`employees`.`first_name`
`employees`.`middle_name`
`employees`.`last_name`
`employees`.`nationality`
`employees`.`birthday`
`employees`.`gender`
`employees`.`marital_status`
`employees`.`ssn_num`
`employees`.`nic_num`
`employees`.`other_id`
`employees`.`driving_license`
`employees`.`driving_license_exp_date`
`employees`.`employment_status`
`employees`.`job_title`
`employees`.`pay_grade`
`employees`.`work_station_id`
`employees`.`address1`
`employees`.`address2`
`employees`.`city`
`employees`.`country`
`employees`.`province`
`employees`.`postal_code`
`employees`.`home_phone`
`employees`.`mobile_phone`
`employees`.`work_phone`
`employees`.`work_email`
`employees`.`private_email`
`employees`.`joined_date`
`employees`.`confirmation_date`
`employees`.`supervisor`
`employees`.`indirect_supervisors`
`employees`.`department`
`employees`.`name_preferred`
`employees`.`name_pronunciation`
`employees`.`pronouns`
`employees`.`custom4`
`employees`.`custom5`
`employees`.`custom6`
`employees`.`custom7`
`employees`.`custom8`
`employees`.`custom9`
`employees`.`custom10`
`employees`.`termination_date`
`employees`.`notes`
`employees`.`status`
`employees`.`ethnicity`
`employees`.`immigration_status`
`employees`.`approver1`
`employees`.`approver2`
`employees`.`approver3`
`employees`.`tax_id`
`employees`.`health_insurance`
`employees`.`timezone`
`employeesalary`.*
`employeesalary`.`id`
`employeesalary`.`employee`
`employeesalary`.`component`
`employeesalary`.`pay_frequency`
`employeesalary`.`currency`
`employeesalary`.`amount`
`employeesalary`.`details`
`employeeskills`.*
`employeeskills`.`id`
`employeeskills`.`skill_id`
`employeeskills`.`employee`
`employeeskills`.`details`
`employeestatus`.*
`employeestatus`.`id`
`employeestatus`.`employee`
`employeestatus`.`status`
`employeestatus`.`feeling`
`employeestatus`.`message`
`employeestatus`.`status_date`
`employeeteammembers`.*
`employeeteammembers`.`id`
`employeeteammembers`.`team`
`employeeteammembers`.`member`
`employeeteammembers`.`role`
`employeeteams`.*
`employeeteams`.`id`
`employeeteams`.`name`
`employeeteams`.`description`
`employeeteams`.`lead`
`employeeteams`.`department`
`employeetimeentry`.*
`employeetimeentry`.`id`
`employeetimeentry`.`project`
`employeetimeentry`.`employee`
`employeetimeentry`.`timesheet`
`employeetimeentry`.`details`
`employeetimeentry`.`created`
`employeetimeentry`.`date_start`
`employeetimeentry`.`time_start`
`employeetimeentry`.`date_end`
`employeetimeentry`.`time_end`
`employeetimeentry`.`status`
`employeetimesheets`.*
`employeetimesheets`.`id`
`employeetimesheets`.`employee`
`employeetimesheets`.`date_start`
`employeetimesheets`.`date_end`
`employeetimesheets`.`status`
`employeetrainingsessions`.*
`employeetrainingsessions`.`id`
`employeetrainingsessions`.`employee`
`employeetrainingsessions`.`trainingSession`
`employeetrainingsessions`.`feedBack`
`employeetrainingsessions`.`status`
`employeetrainingsessions`.`proof`
`employeetravelrecords`.*
`employeetravelrecords`.`id`
`employeetravelrecords`.`employee`
`employeetravelrecords`.`type`
`employeetravelrecords`.`purpose`
`employeetravelrecords`.`travel_from`
`employeetravelrecords`.`travel_to`
`employeetravelrecords`.`travel_date`
`employeetravelrecords`.`return_date`
`employeetravelrecords`.`details`
`employeetravelrecords`.`funding`
`employeetravelrecords`.`currency`
`employeetravelrecords`.`attachment1`
`employeetravelrecords`.`attachment2`
`employeetravelrecords`.`attachment3`
`employeetravelrecords`.`created`
`employeetravelrecords`.`updated`
`employeetravelrecords`.`status`
`employmentstatus`.*
`employmentstatus`.`id`
`employmentstatus`.`name`
`employmentstatus`.`description`
`ethnicity`.*
`ethnicity`.`id`
`ethnicity`.`name`
`expensescategories`.*
`expensescategories`.`id`
`expensescategories`.`name`
`expensescategories`.`created`
`expensescategories`.`updated`
`expensescategories`.`pre_approve`
`expensespaymentmethods`.*
`expensespaymentmethods`.`id`
`expensespaymentmethods`.`name`
`expensespaymentmethods`.`created`
`expensespaymentmethods`.`updated`
`fieldnamemappings`.*
`fieldnamemappings`.`id`
`fieldnamemappings`.`type`
`fieldnamemappings`.`name`
`fieldnamemappings`.`textOrig`
`fieldnamemappings`.`textMapped`
`fieldnamemappings`.`display`
`fieldnamemappings`.`created`
`fieldnamemappings`.`updated`
`files`.*
`files`.`id`
`files`.`name`
`files`.`filename`
`files`.`employee`
`files`.`file_group`
`files`.`size`
`files`.`size_text`
`forms`.*
`forms`.`id`
`forms`.`name`
`forms`.`description`
`forms`.`items`
`forms`.`created`
`forms`.`updated`
`holidays`.*
`holidays`.`id`
`holidays`.`name`
`holidays`.`dateh`
`holidays`.`status`
`holidays`.`country`
`immigrationdocuments`.*
`immigrationdocuments`.`id`
`immigrationdocuments`.`name`
`immigrationdocuments`.`details`
`immigrationdocuments`.`required`
`immigrationdocuments`.`alert_on_missing`
`immigrationdocuments`.`alert_before_expiry`
`immigrationdocuments`.`alert_before_day_number`
`immigrationdocuments`.`created`
`immigrationdocuments`.`updated`
`immigrationstatus`.*
`immigrationstatus`.`id`
`immigrationstatus`.`name`
`jobtitles`.*
`jobtitles`.`id`
`jobtitles`.`code`
`jobtitles`.`name`
`jobtitles`.`description`
`jobtitles`.`specification`
`languages`.*
`languages`.`id`
`languages`.`name`
`languages`.`description`
`leavegroupemployees`.*
`leavegroupemployees`.`id`
`leavegroupemployees`.`employee`
`leavegroupemployees`.`leave_group`
`leavegroupemployees`.`created`
`leavegroupemployees`.`updated`
`leavegroups`.*
`leavegroups`.`id`
`leavegroups`.`name`
`leavegroups`.`details`
`leavegroups`.`created`
`leavegroups`.`updated`
`leaveperiods`.*
`leaveperiods`.`id`
`leaveperiods`.`name`
`leaveperiods`.`date_start`
`leaveperiods`.`date_end`
`leaveperiods`.`status`
`leaveperiods`.`country`
`leaverules`.*
`leaverules`.`id`
`leaverules`.`leave_type`
`leaverules`.`job_title`
`leaverules`.`employment_status`
`leaverules`.`employee`
`leaverules`.`supervisor_leave_assign`
`leaverules`.`employee_can_apply`
`leaverules`.`apply_beyond_current`
`leaverules`.`leave_accrue`
`leaverules`.`carried_forward`
`leaverules`.`default_per_year`
`leaverules`.`carried_forward_percentage`
`leaverules`.`carried_forward_leave_availability`
`leaverules`.`propotionate_on_joined_date`
`leaverules`.`leave_group`
`leaverules`.`max_carried_forward_amount`
`leaverules`.`exp_days`
`leaverules`.`leave_period`
`leaverules`.`department`
`leaverules`.`employee_leave_period`
`leavestartingbalance`.*
`leavestartingbalance`.`id`
`leavestartingbalance`.`leave_type`
`leavestartingbalance`.`employee`
`leavestartingbalance`.`leave_period`
`leavestartingbalance`.`amount`
`leavestartingbalance`.`note`
`leavestartingbalance`.`created`
`leavestartingbalance`.`updated`
`leavetypes`.*
`leavetypes`.`id`
`leavetypes`.`name`
`leavetypes`.`supervisor_leave_assign`
`leavetypes`.`employee_can_apply`
`leavetypes`.`apply_beyond_current`
`leavetypes`.`leave_accrue`
`leavetypes`.`carried_forward`
`leavetypes`.`default_per_year`
`leavetypes`.`carried_forward_percentage`
`leavetypes`.`carried_forward_leave_availability`
`leavetypes`.`propotionate_on_joined_date`
`leavetypes`.`send_notification_emails`
`leavetypes`.`leave_group`
`leavetypes`.`leave_color`
`leavetypes`.`max_carried_forward_amount`
`leavetypes`.`employee_leave_period`
`migrations`.*
`migrations`.`id`
`migrations`.`file`
`migrations`.`version`
`migrations`.`created`
`migrations`.`updated`
`migrations`.`status`
`migrations`.`last_error`
`modules`.*
`modules`.`id`
`modules`.`menu`
`modules`.`name`
`modules`.`label`
`modules`.`icon`
`modules`.`mod_group`
`modules`.`mod_order`
`modules`.`status`
`modules`.`version`
`modules`.`update_path`
`modules`.`user_levels`
`modules`.`user_roles`
`modules`.`user_roles_blacklist`
`nationality`.*
`nationality`.`id`
`nationality`.`name`
`notifications`.*
`notifications`.`id`
`notifications`.`time`
`notifications`.`fromUser`
`notifications`.`fromEmployee`
`notifications`.`toUser`
`notifications`.`image`
`notifications`.`message`
`notifications`.`action`
`notifications`.`type`
`notifications`.`status`
`notifications`.`employee`
`overtimecategories`.*
`overtimecategories`.`id`
`overtimecategories`.`name`
`overtimecategories`.`created`
`overtimecategories`.`updated`
`payfrequency`.*
`payfrequency`.`id`
`payfrequency`.`name`
`paygrades`.*
`paygrades`.`id`
`paygrades`.`name`
`paygrades`.`currency`
`paygrades`.`min_salary`
`paygrades`.`max_salary`
`payroll`.*
`payroll`.`id`
`payroll`.`name`
`payroll`.`pay_period`
`payroll`.`department`
`payroll`.`column_template`
`payroll`.`columns`
`payroll`.`date_start`
`payroll`.`date_end`
`payroll`.`status`
`payroll`.`payslipTemplate`
`payroll`.`deduction_group`
`payroll`.`error`
`payrollcolumns`.*
`payrollcolumns`.`id`
`payrollcolumns`.`name`
`payrollcolumns`.`calculation_hook`
`payrollcolumns`.`salary_components`
`payrollcolumns`.`deductions`
`payrollcolumns`.`add_columns`
`payrollcolumns`.`sub_columns`
`payrollcolumns`.`colorder`
`payrollcolumns`.`editable`
`payrollcolumns`.`enabled`
`payrollcolumns`.`default_value`
`payrollcolumns`.`calculation_columns`
`payrollcolumns`.`calculation_function`
`payrollcolumns`.`deduction_group`
`payrollcolumns`.`function_type`
`payrollcolumntemplates`.*
`payrollcolumntemplates`.`id`
`payrollcolumntemplates`.`name`
`payrollcolumntemplates`.`columns`
`payrolldata`.*
`payrolldata`.`id`
`payrolldata`.`payroll`
`payrolldata`.`employee`
`payrolldata`.`payroll_item`
`payrolldata`.`amount`
`payrollemployees`.*
`payrollemployees`.`id`
`payrollemployees`.`employee`
`payrollemployees`.`pay_frequency`
`payrollemployees`.`currency`
`payrollemployees`.`deduction_exemptions`
`payrollemployees`.`deduction_allowed`
`payrollemployees`.`deduction_group`
`paysliptemplates`.*
`paysliptemplates`.`id`
`paysliptemplates`.`name`
`paysliptemplates`.`data`
`paysliptemplates`.`status`
`paysliptemplates`.`created`
`paysliptemplates`.`updated`
`performancereviews`.*
`performancereviews`.`id`
`performancereviews`.`name`
`performancereviews`.`employee`
`performancereviews`.`coordinator`
`performancereviews`.`attendees`
`performancereviews`.`form`
`performancereviews`.`status`
`performancereviews`.`review_date`
`performancereviews`.`review_period_start`
`performancereviews`.`review_period_end`
`performancereviews`.`self_assessment_due`
`performancereviews`.`notes`
`performancereviews`.`created`
`performancereviews`.`updated`
`permissions`.*
`permissions`.`id`
`permissions`.`user_level`
`permissions`.`module_id`
`permissions`.`permission`
`permissions`.`meta`
`permissions`.`value`
`projects`.*
`projects`.`id`
`projects`.`name`
`projects`.`client`
`projects`.`details`
`projects`.`created`
`projects`.`status`
`province`.*
`province`.`id`
`province`.`name`
`province`.`code`
`province`.`country`
`reportfiles`.*
`reportfiles`.`id`
`reportfiles`.`employee`
`reportfiles`.`name`
`reportfiles`.`attachment`
`reportfiles`.`created`
`reports`.*
`reports`.`id`
`reports`.`name`
`reports`.`details`
`reports`.`parameters`
`reports`.`query`
`reports`.`paramOrder`
`reports`.`type`
`reports`.`report_group`
`reports`.`output`
`restaccesstokens`.*
`restaccesstokens`.`id`
`restaccesstokens`.`userId`
`restaccesstokens`.`hash`
`restaccesstokens`.`token`
`restaccesstokens`.`created`
`restaccesstokens`.`updated`
`reviewfeedbacks`.*
`reviewfeedbacks`.`id`
`reviewfeedbacks`.`employee`
`reviewfeedbacks`.`review`
`reviewfeedbacks`.`subject`
`reviewfeedbacks`.`form`
`reviewfeedbacks`.`status`
`reviewfeedbacks`.`dueon`
`reviewfeedbacks`.`created`
`reviewfeedbacks`.`updated`
`reviewfeedbacks`.`rating`
`reviewtemplates`.*
`reviewtemplates`.`id`
`reviewtemplates`.`name`
`reviewtemplates`.`description`
`reviewtemplates`.`items`
`reviewtemplates`.`created`
`reviewtemplates`.`updated`
`salarycomponent`.*
`salarycomponent`.`id`
`salarycomponent`.`name`
`salarycomponent`.`componentType`
`salarycomponent`.`details`
`salarycomponenttype`.*
`salarycomponenttype`.`id`
`salarycomponenttype`.`code`
`salarycomponenttype`.`name`
`settings`.*
`settings`.`id`
`settings`.`name`
`settings`.`value`
`settings`.`description`
`settings`.`meta`
`settings`.`category`
`skills`.*
`skills`.`id`
`skills`.`name`
`skills`.`description`
`statuschangelogs`.*
`statuschangelogs`.`id`
`statuschangelogs`.`type`
`statuschangelogs`.`element`
`statuschangelogs`.`user_id`
`statuschangelogs`.`data`
`statuschangelogs`.`status_from`
`statuschangelogs`.`status_to`
`statuschangelogs`.`created`
`supportedlanguages`.*
`supportedlanguages`.`id`
`supportedlanguages`.`name`
`supportedlanguages`.`description`
`systemdata`.*
`systemdata`.`id`
`systemdata`.`name`
`systemdata`.`value`
`tags`.*
`tags`.`id`
`tags`.`name`
`timezones`.*
`timezones`.`id`
`timezones`.`name`
`timezones`.`details`
`trainingsessions`.*
`trainingsessions`.`id`
`trainingsessions`.`name`
`trainingsessions`.`course`
`trainingsessions`.`description`
`trainingsessions`.`scheduled`
`trainingsessions`.`dueDate`
`trainingsessions`.`deliveryMethod`
`trainingsessions`.`deliveryLocation`
`trainingsessions`.`status`
`trainingsessions`.`attendanceType`
`trainingsessions`.`attachment`
`trainingsessions`.`created`
`trainingsessions`.`updated`
`trainingsessions`.`requireProof`
`userinvitations`.*
`userinvitations`.`id`
`userinvitations`.`email`
`userinvitations`.`username`
`userinvitations`.`first_name`
`userinvitations`.`last_name`
`userinvitations`.`user_level`
`userinvitations`.`password`
`userinvitations`.`timezone`
`userinvitations`.`employee_id`
`userinvitations`.`department`
`userinvitations`.`joined_date`
`userinvitations`.`job_title`
`userinvitations`.`employment_status`
`userinvitations`.`pay_grade`
`userinvitations`.`supervisor`
`userinvitations`.`country`
`userinvitations`.`invitation_status`
`userinvitations`.`created_user_id`
`userinvitations`.`created_employee_id`
`userinvitations`.`created`
`userinvitations`.`updated`
`usermeta`.*
`usermeta`.`id`
`usermeta`.`user_id`
`usermeta`.`meta_key`
`usermeta`.`meta_value`
`usermeta`.`created`
`usermeta`.`updated`
`userreports`.*
`userreports`.`id`
`userreports`.`name`
`userreports`.`details`
`userreports`.`parameters`
`userreports`.`query`
`userreports`.`paramOrder`
`userreports`.`type`
`userreports`.`report_group`
`userreports`.`output`
`userroles`.*
`userroles`.`id`
`userroles`.`name`
`userroles`.`additional_permissions`
`users`.*
`users`.`id`
`users`.`username`
`users`.`email`
`users`.`password`
`users`.`employee`
`users`.`default_module`
`users`.`user_level`
`users`.`user_roles`
`users`.`last_login`
`users`.`last_update`
`users`.`created`
`users`.`login_hash`
`users`.`lang`
`users`.`googleUserData`
`users`.`wrong_password_count`
`users`.`last_wrong_attempt_at`
`users`.`last_password_requested_at`
`workdays`.*
`workdays`.`id`
`workdays`.`name`
`workdays`.`status`
`workdays`.`country`
`archivedemployees`.*
`archivedemployees`.`id`
`archivedemployees`.`ref_id`
`archivedemployees`.`employee_id`
`archivedemployees`.`first_name`
`archivedemployees`.`last_name`
`archivedemployees`.`gender`
`archivedemployees`.`ssn_num`
`archivedemployees`.`nic_num`
`archivedemployees`.`other_id`
`archivedemployees`.`work_email`
`archivedemployees`.`joined_date`
`archivedemployees`.`confirmation_date`
`archivedemployees`.`supervisor`
`archivedemployees`.`department`
`archivedemployees`.`termination_date`
`archivedemployees`.`notes`
`archivedemployees`.`data`
`assettypes`.*
`assettypes`.`id`
`assettypes`.`name`
`assettypes`.`description`
`assettypes`.`attachment`
`assettypes`.`created`
`assettypes`.`updated`
`attendance`.*
`attendance`.`id`
`attendance`.`employee`
`attendance`.`in_time`
`attendance`.`out_time`
`attendance`.`note`
`attendance`.`image_in`
`attendance`.`image_out`
`attendance`.`map_lat`
`attendance`.`map_lng`
`attendance`.`map_snapshot`
`attendance`.`map_out_lat`
`attendance`.`map_out_lng`
`attendance`.`map_out_snapshot`
`attendance`.`in_ip`
`attendance`.`out_ip`
`auditlog`.*
`auditlog`.`id`
`auditlog`.`time`
`auditlog`.`user`
`auditlog`.`ip`
`auditlog`.`type`
`auditlog`.`employee`
`auditlog`.`details`
`certifications`.*
`certifications`.`id`
`certifications`.`name`
`certifications`.`description`
`clients`.*
`clients`.`id`
`clients`.`name`
`clients`.`details`
`clients`.`first_contact_date`
`clients`.`created`
`clients`.`address`
`clients`.`contact_number`
`clients`.`contact_email`
`clients`.`company_url`
`clients`.`status`
`companyassets`.*
`companyassets`.`id`
`companyassets`.`code`
`companyassets`.`type`
`companyassets`.`attachment`
`companyassets`.`employee`
`companyassets`.`department`
`companyassets`.`description`
`companyassets`.`created`
`companyassets`.`updated`
`companydocuments`.*
`companydocuments`.`id`
`companydocuments`.`name`
`companydocuments`.`details`
`companydocuments`.`valid_until`
`companydocuments`.`status`
`companydocuments`.`notify_employees`
`companydocuments`.`attachment`
`companydocuments`.`share_departments`
`companydocuments`.`share_employees`
`companydocuments`.`share_userlevel`
`companyloans`.*
`companyloans`.`id`
`companyloans`.`name`
`companyloans`.`details`
`companystructures`.*
`companystructures`.`id`
`companystructures`.`title`
`companystructures`.`description`
`companystructures`.`address`
`companystructures`.`type`
`companystructures`.`country`
`companystructures`.`parent`
`companystructures`.`timezone`
`companystructures`.`heads`
`conversations`.*
`conversations`.`id`
`conversations`.`message`
`conversations`.`type`
`conversations`.`attachment`
`conversations`.`employee`
`conversations`.`target`
`conversations`.`created`
`conversations`.`updated`
`conversations`.`timeint`
`conversationuserstatus`.*
`conversationuserstatus`.`id`
`conversationuserstatus`.`employee`
`conversationuserstatus`.`status`
`conversationuserstatus`.`seen_at`
`country`.*
`country`.`id`
`country`.`code`
`country`.`namecap`
`country`.`name`
`country`.`iso3`
`country`.`numcode`
`courses`.*
`courses`.`id`
`courses`.`code`
`courses`.`name`
`courses`.`description`
`courses`.`coordinator`
`courses`.`trainer`
`courses`.`trainer_info`
`courses`.`paymentType`
`courses`.`currency`
`courses`.`cost`
`courses`.`status`
`courses`.`created`
`courses`.`updated`
`crons`.*
`crons`.`id`
`crons`.`name`
`crons`.`class`
`crons`.`lastrun`
`crons`.`frequency`
`crons`.`time`
`crons`.`type`
`crons`.`status`
`currencytypes`.*
`currencytypes`.`id`
`currencytypes`.`code`
`currencytypes`.`name`
`customfields`.*
`customfields`.`id`
`customfields`.`type`
`customfields`.`name`
`customfields`.`data`
`customfields`.`display`
`customfields`.`created`
`customfields`.`updated`
`customfields`.`field_type`
`customfields`.`field_label`
`customfields`.`field_validation`
`customfields`.`field_options`
`customfields`.`display_order`
`customfields`.`display_section`
`customfieldvalues`.*
`customfieldvalues`.`id`
`customfieldvalues`.`type`
`customfieldvalues`.`name`
`customfieldvalues`.`object_id`
`customfieldvalues`.`value`
`customfieldvalues`.`updated`
`customfieldvalues`.`created`
`dataentrybackups`.*
`dataentrybackups`.`id`
`dataentrybackups`.`tableType`
`dataentrybackups`.`data`
`dataimport`.*
`dataimport`.`id`
`dataimport`.`name`
`dataimport`.`dataType`
`dataimport`.`details`
`dataimport`.`columns`
`dataimport`.`updated`
`dataimport`.`created`
`dataimport`.`objectType`
`dataimportfiles`.*
`dataimportfiles`.`id`
`dataimportfiles`.`name`
`dataimportfiles`.`data_import_definition`
`dataimportfiles`.`status`
`dataimportfiles`.`file`
`dataimportfiles`.`details`
`dataimportfiles`.`updated`
`dataimportfiles`.`created`
`deductiongroup`.*
`deductiongroup`.`id`
`deductiongroup`.`name`
`deductiongroup`.`description`
`deductions`.*
`deductions`.`id`
`deductions`.`name`
`deductions`.`componentType`
`deductions`.`component`
`deductions`.`payrollColumn`
`deductions`.`rangeAmounts`
`deductions`.`deduction_group`
`documents`.*
`documents`.`id`
`documents`.`name`
`documents`.`details`
`documents`.`expire_notification`
`documents`.`expire_notification_month`
`documents`.`expire_notification_week`
`documents`.`expire_notification_day`
`documents`.`sign`
`documents`.`sign_label`
`documents`.`created`
`documents`.`updated`
`documents`.`share_with_employee`
`educations`.*
`educations`.`id`
`educations`.`name`
`educations`.`description`
`emaillog`.*
`emaillog`.`id`
`emaillog`.`subject`
`emaillog`.`toEmail`
`emaillog`.`body`
`emaillog`.`cclist`
`emaillog`.`bcclist`
`emaillog`.`created`
`emaillog`.`updated`
`emaillog`.`status`
`emails`.*
`emails`.`id`
`emails`.`subject`
`emails`.`toEmail`
`emails`.`template`
`emails`.`params`
`emails`.`cclist`
`emails`.`bcclist`
`emails`.`error`
`emails`.`created`
`emails`.`updated`
`emails`.`status`
`emergencycontacts`.*
`emergencycontacts`.`id`
`emergencycontacts`.`employee`
`emergencycontacts`.`name`
`emergencycontacts`.`relationship`
`emergencycontacts`.`home_phone`
`emergencycontacts`.`work_phone`
`emergencycontacts`.`mobile_phone`
`employeeapprovals`.*
`employeeapprovals`.`id`
`employeeapprovals`.`type`
`employeeapprovals`.`element`
`employeeapprovals`.`approver`
`employeeapprovals`.`level`
`employeeapprovals`.`status`
`employeeapprovals`.`active`
`employeeapprovals`.`created`
`employeeapprovals`.`updated`
`employeeattendancesheets`.*
`employeeattendancesheets`.`id`
`employeeattendancesheets`.`employee`
`employeeattendancesheets`.`date_start`
`employeeattendancesheets`.`date_end`
`employeeattendancesheets`.`status`
`employeecareer`.*
`employeecareer`.`id`
`employeecareer`.`employee`
`employeecareer`.`job_title`
`employeecareer`.`employment_status`
`employeecareer`.`department`
`employeecareer`.`supervisor`
`employeecareer`.`date_start`
`employeecareer`.`date_end`
`employeecareer`.`details`
`employeecareer`.`created`
`employeecareer`.`updated`
`employeecertifications`.*
`employeecertifications`.`id`
`employeecertifications`.`certification_id`
`employeecertifications`.`employee`
`employeecertifications`.`institute`
`employeecertifications`.`date_start`
`employeecertifications`.`date_end`
`employeecompanyloans`.*
`employeecompanyloans`.`id`
`employeecompanyloans`.`employee`
`employeecompanyloans`.`loan`
`employeecompanyloans`.`start_date`
`employeecompanyloans`.`last_installment_date`
`employeecompanyloans`.`period_months`
`employeecompanyloans`.`currency`
`employeecompanyloans`.`amount`
`employeecompanyloans`.`monthly_installment`
`employeecompanyloans`.`status`
`employeecompanyloans`.`details`
`employeedatahistory`.*
`employeedatahistory`.`id`
`employeedatahistory`.`type`
`employeedatahistory`.`employee`
`employeedatahistory`.`field`
`employeedatahistory`.`old_value`
`employeedatahistory`.`new_value`
`employeedatahistory`.`description`
`employeedatahistory`.`user`
`employeedatahistory`.`updated`
`employeedatahistory`.`created`
`employeedependents`.*
`employeedependents`.`id`
`employeedependents`.`employee`
`employeedependents`.`name`
`employeedependents`.`relationship`
`employeedependents`.`dob`
`employeedependents`.`id_number`
`employeedocuments`.*
`employeedocuments`.`id`
`employeedocuments`.`employee`
`employeedocuments`.`document`
`employeedocuments`.`date_added`
`employeedocuments`.`valid_until`
`employeedocuments`.`status`
`employeedocuments`.`details`
`employeedocuments`.`attachment`
`employeedocuments`.`signature`
`employeedocuments`.`expire_notification_last`
`employeedocuments`.`visible_to`
`employeedocuments`.`hidden`
`employeeeducations`.*
`employeeeducations`.`id`
`employeeeducations`.`education_id`
`employeeeducations`.`employee`
`employeeeducations`.`institute`
`employeeeducations`.`date_start`
`employeeeducations`.`date_end`
`employeeethnicity`.*
`employeeethnicity`.`id`
`employeeethnicity`.`employee`
`employeeethnicity`.`ethnicity`
`employeeexpenses`.*
`employeeexpenses`.`id`
`employeeexpenses`.`employee`
`employeeexpenses`.`expense_date`
`employeeexpenses`.`payment_method`
`employeeexpenses`.`transaction_no`
`employeeexpenses`.`payee`
`employeeexpenses`.`category`
`employeeexpenses`.`notes`
`employeeexpenses`.`amount`
`employeeexpenses`.`currency`
`employeeexpenses`.`attachment1`
`employeeexpenses`.`attachment2`
`employeeexpenses`.`attachment3`
`employeeexpenses`.`created`
`employeeexpenses`.`updated`
`employeeexpenses`.`status`
`employeeforms`.*
`employeeforms`.`id`
`employeeforms`.`employee`
`employeeforms`.`form`
`employeeforms`.`status`
`employeeforms`.`created`
`employeeforms`.`updated`
`employeegoals`.*
`employeegoals`.`id`
`employeegoals`.`employee`
`employeegoals`.`review`
`employeegoals`.`status`
`employeegoals`.`title`
`employeegoals`.`description`
`employeegoals`.`manager_rating`
`employeegoals`.`manager_feedback`
`employeegoals`.`employee_rating`
`employeegoals`.`employee_feedback`
`employeegoals`.`created`
`employeegoals`.`updated`
`employeeimmigrations`.*
`employeeimmigrations`.`id`
`employeeimmigrations`.`employee`
`employeeimmigrations`.`document`
`employeeimmigrations`.`documentname`
`employeeimmigrations`.`valid_until`
`employeeimmigrations`.`status`
`employeeimmigrations`.`details`
`employeeimmigrations`.`attachment1`
`employeeimmigrations`.`attachment2`
`employeeimmigrations`.`attachment3`
`employeeimmigrations`.`created`
`employeeimmigrations`.`updated`
`employeeimmigrationstatus`.*
`employeeimmigrationstatus`.`id`
`employeeimmigrationstatus`.`employee`
`employeeimmigrationstatus`.`status`
`employeelanguages`.*
`employeelanguages`.`id`
`employeelanguages`.`language_id`
`employeelanguages`.`employee`
`employeelanguages`.`reading`
`employeelanguages`.`speaking`
`employeelanguages`.`writing`
`employeelanguages`.`understanding`
`employeeleavedays`.*
`employeeleavedays`.`id`
`employeeleavedays`.`employee_leave`
`employeeleavedays`.`leave_date`
`employeeleavedays`.`leave_type`
`employeeleavelog`.*
`employeeleavelog`.`id`
`employeeleavelog`.`employee_leave`
`employeeleavelog`.`user_id`
`employeeleavelog`.`data`
`employeeleavelog`.`status_from`
`employeeleavelog`.`status_to`
`employeeleavelog`.`created`
`employeeleaves`.*
`employeeleaves`.`id`
`employeeleaves`.`employee`
`employeeleaves`.`leave_type`
`employeeleaves`.`leave_period`
`employeeleaves`.`date_start`
`employeeleaves`.`date_end`
`employeeleaves`.`details`
`employeeleaves`.`status`
`employeeleaves`.`attachment`
`employeeovertime`.*
`employeeovertime`.`id`
`employeeovertime`.`employee`
`employeeovertime`.`start_time`
`employeeovertime`.`end_time`
`employeeovertime`.`category`
`employeeovertime`.`project`
`employeeovertime`.`notes`
`employeeovertime`.`created`
`employeeovertime`.`updated`
`employeeovertime`.`status`
`employeeprojects`.*
`employeeprojects`.`id`
`employeeprojects`.`employee`
`employeeprojects`.`project`
`employeeprojects`.`date_start`
`employeeprojects`.`date_end`
`employeeprojects`.`status`
`employeeprojects`.`details`
`employees`.*
`employees`.`id`
`employees`.`employee_id`
`employees`.`first_name`
`employees`.`middle_name`
`employees`.`last_name`
`employees`.`nationality`
`employees`.`birthday`
`employees`.`gender`
`employees`.`marital_status`
`employees`.`ssn_num`
`employees`.`nic_num`
`employees`.`other_id`
`employees`.`driving_license`
`employees`.`driving_license_exp_date`
`employees`.`employment_status`
`employees`.`job_title`
`employees`.`pay_grade`
`employees`.`work_station_id`
`employees`.`address1`
`employees`.`address2`
`employees`.`city`
`employees`.`country`
`employees`.`province`
`employees`.`postal_code`
`employees`.`home_phone`
`employees`.`mobile_phone`
`employees`.`work_phone`
`employees`.`work_email`
`employees`.`private_email`
`employees`.`joined_date`
`employees`.`confirmation_date`
`employees`.`supervisor`
`employees`.`indirect_supervisors`
`employees`.`department`
`employees`.`name_preferred`
`employees`.`name_pronunciation`
`employees`.`pronouns`
`employees`.`custom4`
`employees`.`custom5`
`employees`.`custom6`
`employees`.`custom7`
`employees`.`custom8`
`employees`.`custom9`
`employees`.`custom10`
`employees`.`termination_date`
`employees`.`notes`
`employees`.`status`
`employees`.`ethnicity`
`employees`.`immigration_status`
`employees`.`approver1`
`employees`.`approver2`
`employees`.`approver3`
`employees`.`tax_id`
`employees`.`health_insurance`
`employees`.`timezone`
`employeesalary`.*
`employeesalary`.`id`
`employeesalary`.`employee`
`employeesalary`.`component`
`employeesalary`.`pay_frequency`
`employeesalary`.`currency`
`employeesalary`.`amount`
`employeesalary`.`details`
`employeeskills`.*
`employeeskills`.`id`
`employeeskills`.`skill_id`
`employeeskills`.`employee`
`employeeskills`.`details`
`employeestatus`.*
`employeestatus`.`id`
`employeestatus`.`employee`
`employeestatus`.`status`
`employeestatus`.`feeling`
`employeestatus`.`message`
`employeestatus`.`status_date`
`employeeteammembers`.*
`employeeteammembers`.`id`
`employeeteammembers`.`team`
`employeeteammembers`.`member`
`employeeteammembers`.`role`
`employeeteams`.*
`employeeteams`.`id`
`employeeteams`.`name`
`employeeteams`.`description`
`employeeteams`.`lead`
`employeeteams`.`department`
`employeetimeentry`.*
`employeetimeentry`.`id`
`employeetimeentry`.`project`
`employeetimeentry`.`employee`
`employeetimeentry`.`timesheet`
`employeetimeentry`.`details`
`employeetimeentry`.`created`
`employeetimeentry`.`date_start`
`employeetimeentry`.`time_start`
`employeetimeentry`.`date_end`
`employeetimeentry`.`time_end`
`employeetimeentry`.`status`
`employeetimesheets`.*
`employeetimesheets`.`id`
`employeetimesheets`.`employee`
`employeetimesheets`.`date_start`
`employeetimesheets`.`date_end`
`employeetimesheets`.`status`
`employeetrainingsessions`.*
`employeetrainingsessions`.`id`
`employeetrainingsessions`.`employee`
`employeetrainingsessions`.`trainingSession`
`employeetrainingsessions`.`feedBack`
`employeetrainingsessions`.`status`
`employeetrainingsessions`.`proof`
`employeetravelrecords`.*
`employeetravelrecords`.`id`
`employeetravelrecords`.`employee`
`employeetravelrecords`.`type`
`employeetravelrecords`.`purpose`
`employeetravelrecords`.`travel_from`
`employeetravelrecords`.`travel_to`
`employeetravelrecords`.`travel_date`
`employeetravelrecords`.`return_date`
`employeetravelrecords`.`details`
`employeetravelrecords`.`funding`
`employeetravelrecords`.`currency`
`employeetravelrecords`.`attachment1`
`employeetravelrecords`.`attachment2`
`employeetravelrecords`.`attachment3`
`employeetravelrecords`.`created`
`employeetravelrecords`.`updated`
`employeetravelrecords`.`status`
`employmentstatus`.*
`employmentstatus`.`id`
`employmentstatus`.`name`
`employmentstatus`.`description`
`ethnicity`.*
`ethnicity`.`id`
`ethnicity`.`name`
`expensescategories`.*
`expensescategories`.`id`
`expensescategories`.`name`
`expensescategories`.`created`
`expensescategories`.`updated`
`expensescategories`.`pre_approve`
`expensespaymentmethods`.*
`expensespaymentmethods`.`id`
`expensespaymentmethods`.`name`
`expensespaymentmethods`.`created`
`expensespaymentmethods`.`updated`
`fieldnamemappings`.*
`fieldnamemappings`.`id`
`fieldnamemappings`.`type`
`fieldnamemappings`.`name`
`fieldnamemappings`.`textOrig`
`fieldnamemappings`.`textMapped`
`fieldnamemappings`.`display`
`fieldnamemappings`.`created`
`fieldnamemappings`.`updated`
`files`.*
`files`.`id`
`files`.`name`
`files`.`filename`
`files`.`employee`
`files`.`file_group`
`files`.`size`
`files`.`size_text`
`forms`.*
`forms`.`id`
`forms`.`name`
`forms`.`description`
`forms`.`items`
`forms`.`created`
`forms`.`updated`
`holidays`.*
`holidays`.`id`
`holidays`.`name`
`holidays`.`dateh`
`holidays`.`status`
`holidays`.`country`
`immigrationdocuments`.*
`immigrationdocuments`.`id`
`immigrationdocuments`.`name`
`immigrationdocuments`.`details`
`immigrationdocuments`.`required`
`immigrationdocuments`.`alert_on_missing`
`immigrationdocuments`.`alert_before_expiry`
`immigrationdocuments`.`alert_before_day_number`
`immigrationdocuments`.`created`
`immigrationdocuments`.`updated`
`immigrationstatus`.*
`immigrationstatus`.`id`
`immigrationstatus`.`name`
`jobtitles`.*
`jobtitles`.`id`
`jobtitles`.`code`
`jobtitles`.`name`
`jobtitles`.`description`
`jobtitles`.`specification`
`languages`.*
`languages`.`id`
`languages`.`name`
`languages`.`description`
`leavegroupemployees`.*
`leavegroupemployees`.`id`
`leavegroupemployees`.`employee`
`leavegroupemployees`.`leave_group`
`leavegroupemployees`.`created`
`leavegroupemployees`.`updated`
`leavegroups`.*
`leavegroups`.`id`
`leavegroups`.`name`
`leavegroups`.`details`
`leavegroups`.`created`
`leavegroups`.`updated`
`leaveperiods`.*
`leaveperiods`.`id`
`leaveperiods`.`name`
`leaveperiods`.`date_start`
`leaveperiods`.`date_end`
`leaveperiods`.`status`
`leaveperiods`.`country`
`leaverules`.*
`leaverules`.`id`
`leaverules`.`leave_type`
`leaverules`.`job_title`
`leaverules`.`employment_status`
`leaverules`.`employee`
`leaverules`.`supervisor_leave_assign`
`leaverules`.`employee_can_apply`
`leaverules`.`apply_beyond_current`
`leaverules`.`leave_accrue`
`leaverules`.`carried_forward`
`leaverules`.`default_per_year`
`leaverules`.`carried_forward_percentage`
`leaverules`.`carried_forward_leave_availability`
`leaverules`.`propotionate_on_joined_date`
`leaverules`.`leave_group`
`leaverules`.`max_carried_forward_amount`
`leaverules`.`exp_days`
`leaverules`.`leave_period`
`leaverules`.`department`
`leaverules`.`employee_leave_period`
`leavestartingbalance`.*
`leavestartingbalance`.`id`
`leavestartingbalance`.`leave_type`
`leavestartingbalance`.`employee`
`leavestartingbalance`.`leave_period`
`leavestartingbalance`.`amount`
`leavestartingbalance`.`note`
`leavestartingbalance`.`created`
`leavestartingbalance`.`updated`
`leavetypes`.*
`leavetypes`.`id`
`leavetypes`.`name`
`leavetypes`.`supervisor_leave_assign`
`leavetypes`.`employee_can_apply`
`leavetypes`.`apply_beyond_current`
`leavetypes`.`leave_accrue`
`leavetypes`.`carried_forward`
`leavetypes`.`default_per_year`
`leavetypes`.`carried_forward_percentage`
`leavetypes`.`carried_forward_leave_availability`
`leavetypes`.`propotionate_on_joined_date`
`leavetypes`.`send_notification_emails`
`leavetypes`.`leave_group`
`leavetypes`.`leave_color`
`leavetypes`.`max_carried_forward_amount`
`leavetypes`.`employee_leave_period`
`migrations`.*
`migrations`.`id`
`migrations`.`file`
`migrations`.`version`
`migrations`.`created`
`migrations`.`updated`
`migrations`.`status`
`migrations`.`last_error`
`modules`.*
`modules`.`id`
`modules`.`menu`
`modules`.`name`
`modules`.`label`
`modules`.`icon`
`modules`.`mod_group`
`modules`.`mod_order`
`modules`.`status`
`modules`.`version`
`modules`.`update_path`
`modules`.`user_levels`
`modules`.`user_roles`
`modules`.`user_roles_blacklist`
`nationality`.*
`nationality`.`id`
`nationality`.`name`
`notifications`.*
`notifications`.`id`
`notifications`.`time`
`notifications`.`fromUser`
`notifications`.`fromEmployee`
`notifications`.`toUser`
`notifications`.`image`
`notifications`.`message`
`notifications`.`action`
`notifications`.`type`
`notifications`.`status`
`notifications`.`employee`
`overtimecategories`.*
`overtimecategories`.`id`
`overtimecategories`.`name`
`overtimecategories`.`created`
`overtimecategories`.`updated`
`payfrequency`.*
`payfrequency`.`id`
`payfrequency`.`name`
`paygrades`.*
`paygrades`.`id`
`paygrades`.`name`
`paygrades`.`currency`
`paygrades`.`min_salary`
`paygrades`.`max_salary`
`payroll`.*
`payroll`.`id`
`payroll`.`name`
`payroll`.`pay_period`
`payroll`.`department`
`payroll`.`column_template`
`payroll`.`columns`
`payroll`.`date_start`
`payroll`.`date_end`
`payroll`.`status`
`payroll`.`payslipTemplate`
`payroll`.`deduction_group`
`payroll`.`error`
`payrollcolumns`.*
`payrollcolumns`.`id`
`payrollcolumns`.`name`
`payrollcolumns`.`calculation_hook`
`payrollcolumns`.`salary_components`
`payrollcolumns`.`deductions`
`payrollcolumns`.`add_columns`
`payrollcolumns`.`sub_columns`
`payrollcolumns`.`colorder`
`payrollcolumns`.`editable`
`payrollcolumns`.`enabled`
`payrollcolumns`.`default_value`
`payrollcolumns`.`calculation_columns`
`payrollcolumns`.`calculation_function`
`payrollcolumns`.`deduction_group`
`payrollcolumns`.`function_type`
`payrollcolumntemplates`.*
`payrollcolumntemplates`.`id`
`payrollcolumntemplates`.`name`
`payrollcolumntemplates`.`columns`
`payrolldata`.*
`payrolldata`.`id`
`payrolldata`.`payroll`
`payrolldata`.`employee`
`payrolldata`.`payroll_item`
`payrolldata`.`amount`
`payrollemployees`.*
`payrollemployees`.`id`
`payrollemployees`.`employee`
`payrollemployees`.`pay_frequency`
`payrollemployees`.`currency`
`payrollemployees`.`deduction_exemptions`
`payrollemployees`.`deduction_allowed`
`payrollemployees`.`deduction_group`
`paysliptemplates`.*
`paysliptemplates`.`id`
`paysliptemplates`.`name`
`paysliptemplates`.`data`
`paysliptemplates`.`status`
`paysliptemplates`.`created`
`paysliptemplates`.`updated`
`performancereviews`.*
`performancereviews`.`id`
`performancereviews`.`name`
`performancereviews`.`employee`
`performancereviews`.`coordinator`
`performancereviews`.`attendees`
`performancereviews`.`form`
`performancereviews`.`status`
`performancereviews`.`review_date`
`performancereviews`.`review_period_start`
`performancereviews`.`review_period_end`
`performancereviews`.`self_assessment_due`
`performancereviews`.`notes`
`performancereviews`.`created`
`performancereviews`.`updated`
`permissions`.*
`permissions`.`id`
`permissions`.`user_level`
`permissions`.`module_id`
`permissions`.`permission`
`permissions`.`meta`
`permissions`.`value`
`projects`.*
`projects`.`id`
`projects`.`name`
`projects`.`client`
`projects`.`details`
`projects`.`created`
`projects`.`status`
`province`.*
`province`.`id`
`province`.`name`
`province`.`code`
`province`.`country`
`reportfiles`.*
`reportfiles`.`id`
`reportfiles`.`employee`
`reportfiles`.`name`
`reportfiles`.`attachment`
`reportfiles`.`created`
`reports`.*
`reports`.`id`
`reports`.`name`
`reports`.`details`
`reports`.`parameters`
`reports`.`query`
`reports`.`paramOrder`
`reports`.`type`
`reports`.`report_group`
`reports`.`output`
`restaccesstokens`.*
`restaccesstokens`.`id`
`restaccesstokens`.`userId`
`restaccesstokens`.`hash`
`restaccesstokens`.`token`
`restaccesstokens`.`created`
`restaccesstokens`.`updated`
`reviewfeedbacks`.*
`reviewfeedbacks`.`id`
`reviewfeedbacks`.`employee`
`reviewfeedbacks`.`review`
`reviewfeedbacks`.`subject`
`reviewfeedbacks`.`form`
`reviewfeedbacks`.`status`
`reviewfeedbacks`.`dueon`
`reviewfeedbacks`.`created`
`reviewfeedbacks`.`updated`
`reviewfeedbacks`.`rating`
`reviewtemplates`.*
`reviewtemplates`.`id`
`reviewtemplates`.`name`
`reviewtemplates`.`description`
`reviewtemplates`.`items`
`reviewtemplates`.`created`
`reviewtemplates`.`updated`
`salarycomponent`.*
`salarycomponent`.`id`
`salarycomponent`.`name`
`salarycomponent`.`componentType`
`salarycomponent`.`details`
`salarycomponenttype`.*
`salarycomponenttype`.`id`
`salarycomponenttype`.`code`
`salarycomponenttype`.`name`
`settings`.*
`settings`.`id`
`settings`.`name`
`settings`.`value`
`settings`.`description`
`settings`.`meta`
`settings`.`category`
`skills`.*
`skills`.`id`
`skills`.`name`
`skills`.`description`
`statuschangelogs`.*
`statuschangelogs`.`id`
`statuschangelogs`.`type`
`statuschangelogs`.`element`
`statuschangelogs`.`user_id`
`statuschangelogs`.`data`
`statuschangelogs`.`status_from`
`statuschangelogs`.`status_to`
`statuschangelogs`.`created`
`supportedlanguages`.*
`supportedlanguages`.`id`
`supportedlanguages`.`name`
`supportedlanguages`.`description`
`systemdata`.*
`systemdata`.`id`
`systemdata`.`name`
`systemdata`.`value`
`tags`.*
`tags`.`id`
`tags`.`name`
`timezones`.*
`timezones`.`id`
`timezones`.`name`
`timezones`.`details`
`trainingsessions`.*
`trainingsessions`.`id`
`trainingsessions`.`name`
`trainingsessions`.`course`
`trainingsessions`.`description`
`trainingsessions`.`scheduled`
`trainingsessions`.`dueDate`
`trainingsessions`.`deliveryMethod`
`trainingsessions`.`deliveryLocation`
`trainingsessions`.`status`
`trainingsessions`.`attendanceType`
`trainingsessions`.`attachment`
`trainingsessions`.`created`
`trainingsessions`.`updated`
`trainingsessions`.`requireProof`
`userinvitations`.*
`userinvitations`.`id`
`userinvitations`.`email`
`userinvitations`.`username`
`userinvitations`.`first_name`
`userinvitations`.`last_name`
`userinvitations`.`user_level`
`userinvitations`.`password`
`userinvitations`.`timezone`
`userinvitations`.`employee_id`
`userinvitations`.`department`
`userinvitations`.`joined_date`
`userinvitations`.`job_title`
`userinvitations`.`employment_status`
`userinvitations`.`pay_grade`
`userinvitations`.`supervisor`
`userinvitations`.`country`
`userinvitations`.`invitation_status`
`userinvitations`.`created_user_id`
`userinvitations`.`created_employee_id`
`userinvitations`.`created`
`userinvitations`.`updated`
`usermeta`.*
`usermeta`.`id`
`usermeta`.`user_id`
`usermeta`.`meta_key`
`usermeta`.`meta_value`
`usermeta`.`created`
`usermeta`.`updated`
`userreports`.*
`userreports`.`id`
`userreports`.`name`
`userreports`.`details`
`userreports`.`parameters`
`userreports`.`query`
`userreports`.`paramOrder`
`userreports`.`type`
`userreports`.`report_group`
`userreports`.`output`
`userroles`.*
`userroles`.`id`
`userroles`.`name`
`userroles`.`additional_permissions`
`users`.*
`users`.`id`
`users`.`username`
`users`.`email`
`users`.`password`
`users`.`employee`
`users`.`default_module`
`users`.`user_level`
`users`.`user_roles`
`users`.`last_login`
`users`.`last_update`
`users`.`created`
`users`.`login_hash`
`users`.`lang`
`users`.`googleUserData`
`users`.`wrong_password_count`
`users`.`last_wrong_attempt_at`
`users`.`last_password_requested_at`
`workdays`.*
`workdays`.`id`
`workdays`.`name`
`workdays`.`status`
`workdays`.`country`
`archivedemployees`.*
`archivedemployees`.`id`
`archivedemployees`.`ref_id`
`archivedemployees`.`employee_id`
`archivedemployees`.`first_name`
`archivedemployees`.`last_name`
`archivedemployees`.`gender`
`archivedemployees`.`ssn_num`
`archivedemployees`.`nic_num`
`archivedemployees`.`other_id`
`archivedemployees`.`work_email`
`archivedemployees`.`joined_date`
`archivedemployees`.`confirmation_date`
`archivedemployees`.`supervisor`
`archivedemployees`.`department`
`archivedemployees`.`termination_date`
`archivedemployees`.`notes`
`archivedemployees`.`data`
`assettypes`.*
`assettypes`.`id`
`assettypes`.`name`
`assettypes`.`description`
`assettypes`.`attachment`
`assettypes`.`created`
`assettypes`.`updated`
`attendance`.*
`attendance`.`id`
`attendance`.`employee`
`attendance`.`in_time`
`attendance`.`out_time`
`attendance`.`note`
`attendance`.`image_in`
`attendance`.`image_out`
`attendance`.`map_lat`
`attendance`.`map_lng`
`attendance`.`map_snapshot`
`attendance`.`map_out_lat`
`attendance`.`map_out_lng`
`attendance`.`map_out_snapshot`
`attendance`.`in_ip`
`attendance`.`out_ip`
`auditlog`.*
`auditlog`.`id`
`auditlog`.`time`
`auditlog`.`user`
`auditlog`.`ip`
`auditlog`.`type`
`auditlog`.`employee`
`auditlog`.`details`
`certifications`.*
`certifications`.`id`
`certifications`.`name`
`certifications`.`description`
`clients`.*
`clients`.`id`
`clients`.`name`
`clients`.`details`
`clients`.`first_contact_date`
`clients`.`created`
`clients`.`address`
`clients`.`contact_number`
`clients`.`contact_email`
`clients`.`company_url`
`clients`.`status`
`companyassets`.*
`companyassets`.`id`
`companyassets`.`code`
`companyassets`.`type`
`companyassets`.`attachment`
`companyassets`.`employee`
`companyassets`.`department`
`companyassets`.`description`
`companyassets`.`created`
`companyassets`.`updated`
`companydocuments`.*
`companydocuments`.`id`
`companydocuments`.`name`
`companydocuments`.`details`
`companydocuments`.`valid_until`
`companydocuments`.`status`
`companydocuments`.`notify_employees`
`companydocuments`.`attachment`
`companydocuments`.`share_departments`
`companydocuments`.`share_employees`
`companydocuments`.`share_userlevel`
`companyloans`.*
`companyloans`.`id`
`companyloans`.`name`
`companyloans`.`details`
`companystructures`.*
`companystructures`.`id`
`companystructures`.`title`
`companystructures`.`description`
`companystructures`.`address`
`companystructures`.`type`
`companystructures`.`country`
`companystructures`.`parent`
`companystructures`.`timezone`
`companystructures`.`heads`
`conversations`.*
`conversations`.`id`
`conversations`.`message`
`conversations`.`type`
`conversations`.`attachment`
`conversations`.`employee`
`conversations`.`target`
`conversations`.`created`
`conversations`.`updated`
`conversations`.`timeint`
`conversationuserstatus`.*
`conversationuserstatus`.`id`
`conversationuserstatus`.`employee`
`conversationuserstatus`.`status`
`conversationuserstatus`.`seen_at`
`country`.*
`country`.`id`
`country`.`code`
`country`.`namecap`
`country`.`name`
`country`.`iso3`
`country`.`numcode`
`courses`.*
`courses`.`id`
`courses`.`code`
`courses`.`name`
`courses`.`description`
`courses`.`coordinator`
`courses`.`trainer`
`courses`.`trainer_info`
`courses`.`paymentType`
`courses`.`currency`
`courses`.`cost`
`courses`.`status`
`courses`.`created`
`courses`.`updated`
`crons`.*
`crons`.`id`
`crons`.`name`
`crons`.`class`
`crons`.`lastrun`
`crons`.`frequency`
`crons`.`time`
`crons`.`type`
`crons`.`status`
`currencytypes`.*
`currencytypes`.`id`
`currencytypes`.`code`
`currencytypes`.`name`
`customfields`.*
`customfields`.`id`
`customfields`.`type`
`customfields`.`name`
`customfields`.`data`
`customfields`.`display`
`customfields`.`created`
`customfields`.`updated`
`customfields`.`field_type`
`customfields`.`field_label`
`customfields`.`field_validation`
`customfields`.`field_options`
`customfields`.`display_order`
`customfields`.`display_section`
`customfieldvalues`.*
`customfieldvalues`.`id`
`customfieldvalues`.`type`
`customfieldvalues`.`name`
`customfieldvalues`.`object_id`
`customfieldvalues`.`value`
`customfieldvalues`.`updated`
`customfieldvalues`.`created`
`dataentrybackups`.*
`dataentrybackups`.`id`
`dataentrybackups`.`tableType`
`dataentrybackups`.`data`
`dataimport`.*
`dataimport`.`id`
`dataimport`.`name`
`dataimport`.`dataType`
`dataimport`.`details`
`dataimport`.`columns`
`dataimport`.`updated`
`dataimport`.`created`
`dataimport`.`objectType`
`dataimportfiles`.*
`dataimportfiles`.`id`
`dataimportfiles`.`name`
`dataimportfiles`.`data_import_definition`
`dataimportfiles`.`status`
`dataimportfiles`.`file`
`dataimportfiles`.`details`
`dataimportfiles`.`updated`
`dataimportfiles`.`created`
`deductiongroup`.*
`deductiongroup`.`id`
`deductiongroup`.`name`
`deductiongroup`.`description`
`deductions`.*
`deductions`.`id`
`deductions`.`name`
`deductions`.`componentType`
`deductions`.`component`
`deductions`.`payrollColumn`
`deductions`.`rangeAmounts`
`deductions`.`deduction_group`
`documents`.*
`documents`.`id`
`documents`.`name`
`documents`.`details`
`documents`.`expire_notification`
`documents`.`expire_notification_month`
`documents`.`expire_notification_week`
`documents`.`expire_notification_day`
`documents`.`sign`
`documents`.`sign_label`
`documents`.`created`
`documents`.`updated`
`documents`.`share_with_employee`
`educations`.*
`educations`.`id`
`educations`.`name`
`educations`.`description`
`emaillog`.*
`emaillog`.`id`
`emaillog`.`subject`
`emaillog`.`toEmail`
`emaillog`.`body`
`emaillog`.`cclist`
`emaillog`.`bcclist`
`emaillog`.`created`
`emaillog`.`updated`
`emaillog`.`status`
`emails`.*
`emails`.`id`
`emails`.`subject`
`emails`.`toEmail`
`emails`.`template`
`emails`.`params`
`emails`.`cclist`
`emails`.`bcclist`
`emails`.`error`
`emails`.`created`
`emails`.`updated`
`emails`.`status`
`emergencycontacts`.*
`emergencycontacts`.`id`
`emergencycontacts`.`employee`
`emergencycontacts`.`name`
`emergencycontacts`.`relationship`
`emergencycontacts`.`home_phone`
`emergencycontacts`.`work_phone`
`emergencycontacts`.`mobile_phone`
`employeeapprovals`.*
`employeeapprovals`.`id`
`employeeapprovals`.`type`
`employeeapprovals`.`element`
`employeeapprovals`.`approver`
`employeeapprovals`.`level`
`employeeapprovals`.`status`
`employeeapprovals`.`active`
`employeeapprovals`.`created`
`employeeapprovals`.`updated`
`employeeattendancesheets`.*
`employeeattendancesheets`.`id`
`employeeattendancesheets`.`employee`
`employeeattendancesheets`.`date_start`
`employeeattendancesheets`.`date_end`
`employeeattendancesheets`.`status`
`employeecareer`.*
`employeecareer`.`id`
`employeecareer`.`employee`
`employeecareer`.`job_title`
`employeecareer`.`employment_status`
`employeecareer`.`department`
`employeecareer`.`supervisor`
`employeecareer`.`date_start`
`employeecareer`.`date_end`
`employeecareer`.`details`
`employeecareer`.`created`
`employeecareer`.`updated`
`employeecertifications`.*
`employeecertifications`.`id`
`employeecertifications`.`certification_id`
`employeecertifications`.`employee`
`employeecertifications`.`institute`
`employeecertifications`.`date_start`
`employeecertifications`.`date_end`
`employeecompanyloans`.*
`employeecompanyloans`.`id`
`employeecompanyloans`.`employee`
`employeecompanyloans`.`loan`
`employeecompanyloans`.`start_date`
`employeecompanyloans`.`last_installment_date`
`employeecompanyloans`.`period_months`
`employeecompanyloans`.`currency`
`employeecompanyloans`.`amount`
`employeecompanyloans`.`monthly_installment`
`employeecompanyloans`.`status`
`employeecompanyloans`.`details`
`employeedatahistory`.*
`employeedatahistory`.`id`
`employeedatahistory`.`type`
`employeedatahistory`.`employee`
`employeedatahistory`.`field`
`employeedatahistory`.`old_value`
`employeedatahistory`.`new_value`
`employeedatahistory`.`description`
`employeedatahistory`.`user`
`employeedatahistory`.`updated`
`employeedatahistory`.`created`
`employeedependents`.*
`employeedependents`.`id`
`employeedependents`.`employee`
`employeedependents`.`name`
`employeedependents`.`relationship`
`employeedependents`.`dob`
`employeedependents`.`id_number`
`employeedocuments`.*
`employeedocuments`.`id`
`employeedocuments`.`employee`
`employeedocuments`.`document`
`employeedocuments`.`date_added`
`employeedocuments`.`valid_until`
`employeedocuments`.`status`
`employeedocuments`.`details`
`employeedocuments`.`attachment`
`employeedocuments`.`signature`
`employeedocuments`.`expire_notification_last`
`employeedocuments`.`visible_to`
`employeedocuments`.`hidden`
`employeeeducations`.*
`employeeeducations`.`id`
`employeeeducations`.`education_id`
`employeeeducations`.`employee`
`employeeeducations`.`institute`
`employeeeducations`.`date_start`
`employeeeducations`.`date_end`
`employeeethnicity`.*
`employeeethnicity`.`id`
`employeeethnicity`.`employee`
`employeeethnicity`.`ethnicity`
`employeeexpenses`.*
`employeeexpenses`.`id`
`employeeexpenses`.`employee`
`employeeexpenses`.`expense_date`
`employeeexpenses`.`payment_method`
`employeeexpenses`.`transaction_no`
`employeeexpenses`.`payee`
`employeeexpenses`.`category`
`employeeexpenses`.`notes`
`employeeexpenses`.`amount`
`employeeexpenses`.`currency`
`employeeexpenses`.`attachment1`
`employeeexpenses`.`attachment2`
`employeeexpenses`.`attachment3`
`employeeexpenses`.`created`
`employeeexpenses`.`updated`
`employeeexpenses`.`status`
`employeeforms`.*
`employeeforms`.`id`
`employeeforms`.`employee`
`employeeforms`.`form`
`employeeforms`.`status`
`employeeforms`.`created`
`employeeforms`.`updated`
`employeegoals`.*
`employeegoals`.`id`
`employeegoals`.`employee`
`employeegoals`.`review`
`employeegoals`.`status`
`employeegoals`.`title`
`employeegoals`.`description`
`employeegoals`.`manager_rating`
`employeegoals`.`manager_feedback`
`employeegoals`.`employee_rating`
`employeegoals`.`employee_feedback`
`employeegoals`.`created`
`employeegoals`.`updated`
`employeeimmigrations`.*
`employeeimmigrations`.`id`
`employeeimmigrations`.`employee`
`employeeimmigrations`.`document`
`employeeimmigrations`.`documentname`
`employeeimmigrations`.`valid_until`
`employeeimmigrations`.`status`
`employeeimmigrations`.`details`
`employeeimmigrations`.`attachment1`
`employeeimmigrations`.`attachment2`
`employeeimmigrations`.`attachment3`
`employeeimmigrations`.`created`
`employeeimmigrations`.`updated`
`employeeimmigrationstatus`.*
`employeeimmigrationstatus`.`id`
`employeeimmigrationstatus`.`employee`
`employeeimmigrationstatus`.`status`
`employeelanguages`.*
`employeelanguages`.`id`
`employeelanguages`.`language_id`
`employeelanguages`.`employee`
`employeelanguages`.`reading`
`employeelanguages`.`speaking`
`employeelanguages`.`writing`
`employeelanguages`.`understanding`
`employeeleavedays`.*
`employeeleavedays`.`id`
`employeeleavedays`.`employee_leave`
`employeeleavedays`.`leave_date`
`employeeleavedays`.`leave_type`
`employeeleavelog`.*
`employeeleavelog`.`id`
`employeeleavelog`.`employee_leave`
`employeeleavelog`.`user_id`
`employeeleavelog`.`data`
`employeeleavelog`.`status_from`
`employeeleavelog`.`status_to`
`employeeleavelog`.`created`
`employeeleaves`.*
`employeeleaves`.`id`
`employeeleaves`.`employee`
`employeeleaves`.`leave_type`
`employeeleaves`.`leave_period`
`employeeleaves`.`date_start`
`employeeleaves`.`date_end`
`employeeleaves`.`details`
`employeeleaves`.`status`
`employeeleaves`.`attachment`
`employeeovertime`.*
`employeeovertime`.`id`
`employeeovertime`.`employee`
`employeeovertime`.`start_time`
`employeeovertime`.`end_time`
`employeeovertime`.`category`
`employeeovertime`.`project`
`employeeovertime`.`notes`
`employeeovertime`.`created`
`employeeovertime`.`updated`
`employeeovertime`.`status`
`employeeprojects`.*
`employeeprojects`.`id`
`employeeprojects`.`employee`
`employeeprojects`.`project`
`employeeprojects`.`date_start`
`employeeprojects`.`date_end`
`employeeprojects`.`status`
`employeeprojects`.`details`
`employees`.*
`employees`.`id`
`employees`.`employee_id`
`employees`.`first_name`
`employees`.`middle_name`
`employees`.`last_name`
`employees`.`nationality`
`employees`.`birthday`
`employees`.`gender`
`employees`.`marital_status`
`employees`.`ssn_num`
`employees`.`nic_num`
`employees`.`other_id`
`employees`.`driving_license`
`employees`.`driving_license_exp_date`
`employees`.`employment_status`
`employees`.`job_title`
`employees`.`pay_grade`
`employees`.`work_station_id`
`employees`.`address1`
`employees`.`address2`
`employees`.`city`
`employees`.`country`
`employees`.`province`
`employees`.`postal_code`
`employees`.`home_phone`
`employees`.`mobile_phone`
`employees`.`work_phone`
`employees`.`work_email`
`employees`.`private_email`
`employees`.`joined_date`
`employees`.`confirmation_date`
`employees`.`supervisor`
`employees`.`indirect_supervisors`
`employees`.`department`
`employees`.`name_preferred`
`employees`.`name_pronunciation`
`employees`.`pronouns`
`employees`.`custom4`
`employees`.`custom5`
`employees`.`custom6`
`employees`.`custom7`
`employees`.`custom8`
`employees`.`custom9`
`employees`.`custom10`
`employees`.`termination_date`
`employees`.`notes`
`employees`.`status`
`employees`.`ethnicity`
`employees`.`immigration_status`
`employees`.`approver1`
`employees`.`approver2`
`employees`.`approver3`
`employees`.`tax_id`
`employees`.`health_insurance`
`employees`.`timezone`
`employeesalary`.*
`employeesalary`.`id`
`employeesalary`.`employee`
`employeesalary`.`component`
`employeesalary`.`pay_frequency`
`employeesalary`.`currency`
`employeesalary`.`amount`
`employeesalary`.`details`
`employeeskills`.*
`employeeskills`.`id`
`employeeskills`.`skill_id`
`employeeskills`.`employee`
`employeeskills`.`details`
`employeestatus`.*
`employeestatus`.`id`
`employeestatus`.`employee`
`employeestatus`.`status`
`employeestatus`.`feeling`
`employeestatus`.`message`
`employeestatus`.`status_date`
`employeeteammembers`.*
`employeeteammembers`.`id`
`employeeteammembers`.`team`
`employeeteammembers`.`member`
`employeeteammembers`.`role`
`employeeteams`.*
`employeeteams`.`id`
`employeeteams`.`name`
`employeeteams`.`description`
`employeeteams`.`lead`
`employeeteams`.`department`
`employeetimeentry`.*
`employeetimeentry`.`id`
`employeetimeentry`.`project`
`employeetimeentry`.`employee`
`employeetimeentry`.`timesheet`
`employeetimeentry`.`details`
`employeetimeentry`.`created`
`employeetimeentry`.`date_start`
`employeetimeentry`.`time_start`
`employeetimeentry`.`date_end`
`employeetimeentry`.`time_end`
`employeetimeentry`.`status`
`employeetimesheets`.*
`employeetimesheets`.`id`
`employeetimesheets`.`employee`
`employeetimesheets`.`date_start`
`employeetimesheets`.`date_end`
`employeetimesheets`.`status`
`employeetrainingsessions`.*
`employeetrainingsessions`.`id`
`employeetrainingsessions`.`employee`
`employeetrainingsessions`.`trainingSession`
`employeetrainingsessions`.`feedBack`
`employeetrainingsessions`.`status`
`employeetrainingsessions`.`proof`
`employeetravelrecords`.*
`employeetravelrecords`.`id`
`employeetravelrecords`.`employee`
`employeetravelrecords`.`type`
`employeetravelrecords`.`purpose`
`employeetravelrecords`.`travel_from`
`employeetravelrecords`.`travel_to`
`employeetravelrecords`.`travel_date`
`employeetravelrecords`.`return_date`
`employeetravelrecords`.`details`
`employeetravelrecords`.`funding`
`employeetravelrecords`.`currency`
`employeetravelrecords`.`attachment1`
`employeetravelrecords`.`attachment2`
`employeetravelrecords`.`attachment3`
`employeetravelrecords`.`created`
`employeetravelrecords`.`updated`
`employeetravelrecords`.`status`
`employmentstatus`.*
`employmentstatus`.`id`
`employmentstatus`.`name`
`employmentstatus`.`description`
`ethnicity`.*
`ethnicity`.`id`
`ethnicity`.`name`
`expensescategories`.*
`expensescategories`.`id`
`expensescategories`.`name`
`expensescategories`.`created`
`expensescategories`.`updated`
`expensescategories`.`pre_approve`
`expensespaymentmethods`.*
`expensespaymentmethods`.`id`
`expensespaymentmethods`.`name`
`expensespaymentmethods`.`created`
`expensespaymentmethods`.`updated`
`fieldnamemappings`.*
`fieldnamemappings`.`id`
`fieldnamemappings`.`type`
`fieldnamemappings`.`name`
`fieldnamemappings`.`textOrig`
`fieldnamemappings`.`textMapped`
`fieldnamemappings`.`display`
`fieldnamemappings`.`created`
`fieldnamemappings`.`updated`
`files`.*
`files`.`id`
`files`.`name`
`files`.`filename`
`files`.`employee`
`files`.`file_group`
`files`.`size`
`files`.`size_text`
`forms`.*
`forms`.`id`
`forms`.`name`
`forms`.`description`
`forms`.`items`
`forms`.`created`
`forms`.`updated`
`holidays`.*
`holidays`.`id`
`holidays`.`name`
`holidays`.`dateh`
`holidays`.`status`
`holidays`.`country`
`immigrationdocuments`.*
`immigrationdocuments`.`id`
`immigrationdocuments`.`name`
`immigrationdocuments`.`details`
`immigrationdocuments`.`required`
`immigrationdocuments`.`alert_on_missing`
`immigrationdocuments`.`alert_before_expiry`
`immigrationdocuments`.`alert_before_day_number`
`immigrationdocuments`.`created`
`immigrationdocuments`.`updated`
`immigrationstatus`.*
`immigrationstatus`.`id`
`immigrationstatus`.`name`
`jobtitles`.*
`jobtitles`.`id`
`jobtitles`.`code`
`jobtitles`.`name`
`jobtitles`.`description`
`jobtitles`.`specification`
`languages`.*
`languages`.`id`
`languages`.`name`
`languages`.`description`
`leavegroupemployees`.*
`leavegroupemployees`.`id`
`leavegroupemployees`.`employee`
`leavegroupemployees`.`leave_group`
`leavegroupemployees`.`created`
`leavegroupemployees`.`updated`
`leavegroups`.*
`leavegroups`.`id`
`leavegroups`.`name`
`leavegroups`.`details`
`leavegroups`.`created`
`leavegroups`.`updated`
`leaveperiods`.*
`leaveperiods`.`id`
`leaveperiods`.`name`
`leaveperiods`.`date_start`
`leaveperiods`.`date_end`
`leaveperiods`.`status`
`leaveperiods`.`country`
`leaverules`.*
`leaverules`.`id`
`leaverules`.`leave_type`
`leaverules`.`job_title`
`leaverules`.`employment_status`
`leaverules`.`employee`
`leaverules`.`supervisor_leave_assign`
`leaverules`.`employee_can_apply`
`leaverules`.`apply_beyond_current`
`leaverules`.`leave_accrue`
`leaverules`.`carried_forward`
`leaverules`.`default_per_year`
`leaverules`.`carried_forward_percentage`
`leaverules`.`carried_forward_leave_availability`
`leaverules`.`propotionate_on_joined_date`
`leaverules`.`leave_group`
`leaverules`.`max_carried_forward_amount`
`leaverules`.`exp_days`
`leaverules`.`leave_period`
`leaverules`.`department`
`leaverules`.`employee_leave_period`
`leavestartingbalance`.*
`leavestartingbalance`.`id`
`leavestartingbalance`.`leave_type`
`leavestartingbalance`.`employee`
`leavestartingbalance`.`leave_period`
`leavestartingbalance`.`amount`
`leavestartingbalance`.`note`
`leavestartingbalance`.`created`
`leavestartingbalance`.`updated`
`leavetypes`.*
`leavetypes`.`id`
`leavetypes`.`name`
`leavetypes`.`supervisor_leave_assign`
`leavetypes`.`employee_can_apply`
`leavetypes`.`apply_beyond_current`
`leavetypes`.`leave_accrue`
`leavetypes`.`carried_forward`
`leavetypes`.`default_per_year`
`leavetypes`.`carried_forward_percentage`
`leavetypes`.`carried_forward_leave_availability`
`leavetypes`.`propotionate_on_joined_date`
`leavetypes`.`send_notification_emails`
`leavetypes`.`leave_group`
`leavetypes`.`leave_color`
`leavetypes`.`max_carried_forward_amount`
`leavetypes`.`employee_leave_period`
`migrations`.*
`migrations`.`id`
`migrations`.`file`
`migrations`.`version`
`migrations`.`created`
`migrations`.`updated`
`migrations`.`status`
`migrations`.`last_error`
`modules`.*
`modules`.`id`
`modules`.`menu`
`modules`.`name`
`modules`.`label`
`modules`.`icon`
`modules`.`mod_group`
`modules`.`mod_order`
`modules`.`status`
`modules`.`version`
`modules`.`update_path`
`modules`.`user_levels`
`modules`.`user_roles`
`modules`.`user_roles_blacklist`
`nationality`.*
`nationality`.`id`
`nationality`.`name`
`notifications`.*
`notifications`.`id`
`notifications`.`time`
`notifications`.`fromUser`
`notifications`.`fromEmployee`
`notifications`.`toUser`
`notifications`.`image`
`notifications`.`message`
`notifications`.`action`
`notifications`.`type`
`notifications`.`status`
`notifications`.`employee`
`overtimecategories`.*
`overtimecategories`.`id`
`overtimecategories`.`name`
`overtimecategories`.`created`
`overtimecategories`.`updated`
`payfrequency`.*
`payfrequency`.`id`
`payfrequency`.`name`
`paygrades`.*
`paygrades`.`id`
`paygrades`.`name`
`paygrades`.`currency`
`paygrades`.`min_salary`
`paygrades`.`max_salary`
`payroll`.*
`payroll`.`id`
`payroll`.`name`
`payroll`.`pay_period`
`payroll`.`department`
`payroll`.`column_template`
`payroll`.`columns`
`payroll`.`date_start`
`payroll`.`date_end`
`payroll`.`status`
`payroll`.`payslipTemplate`
`payroll`.`deduction_group`
`payroll`.`error`
`payrollcolumns`.*
`payrollcolumns`.`id`
`payrollcolumns`.`name`
`payrollcolumns`.`calculation_hook`
`payrollcolumns`.`salary_components`
`payrollcolumns`.`deductions`
`payrollcolumns`.`add_columns`
`payrollcolumns`.`sub_columns`
`payrollcolumns`.`colorder`
`payrollcolumns`.`editable`
`payrollcolumns`.`enabled`
`payrollcolumns`.`default_value`
`payrollcolumns`.`calculation_columns`
`payrollcolumns`.`calculation_function`
`payrollcolumns`.`deduction_group`
`payrollcolumns`.`function_type`
`payrollcolumntemplates`.*
`payrollcolumntemplates`.`id`
`payrollcolumntemplates`.`name`
`payrollcolumntemplates`.`columns`
`payrolldata`.*
`payrolldata`.`id`
`payrolldata`.`payroll`
`payrolldata`.`employee`
`payrolldata`.`payroll_item`
`payrolldata`.`amount`
`payrollemployees`.*
`payrollemployees`.`id`
`payrollemployees`.`employee`
`payrollemployees`.`pay_frequency`
`payrollemployees`.`currency`
`payrollemployees`.`deduction_exemptions`
`payrollemployees`.`deduction_allowed`
`payrollemployees`.`deduction_group`
`paysliptemplates`.*
`paysliptemplates`.`id`
`paysliptemplates`.`name`
`paysliptemplates`.`data`
`paysliptemplates`.`status`
`paysliptemplates`.`created`
`paysliptemplates`.`updated`
`performancereviews`.*
`performancereviews`.`id`
`performancereviews`.`name`
`performancereviews`.`employee`
`performancereviews`.`coordinator`
`performancereviews`.`attendees`
`performancereviews`.`form`
`performancereviews`.`status`
`performancereviews`.`review_date`
`performancereviews`.`review_period_start`
`performancereviews`.`review_period_end`
`performancereviews`.`self_assessment_due`
`performancereviews`.`notes`
`performancereviews`.`created`
`performancereviews`.`updated`
`permissions`.*
`permissions`.`id`
`permissions`.`user_level`
`permissions`.`module_id`
`permissions`.`permission`
`permissions`.`meta`
`permissions`.`value`
`projects`.*
`projects`.`id`
`projects`.`name`
`projects`.`client`
`projects`.`details`
`projects`.`created`
`projects`.`status`
`province`.*
`province`.`id`
`province`.`name`
`province`.`code`
`province`.`country`
`reportfiles`.*
`reportfiles`.`id`
`reportfiles`.`employee`
`reportfiles`.`name`
`reportfiles`.`attachment`
`reportfiles`.`created`
`reports`.*
`reports`.`id`
`reports`.`name`
`reports`.`details`
`reports`.`parameters`
`reports`.`query`
`reports`.`paramOrder`
`reports`.`type`
`reports`.`report_group`
`reports`.`output`
`restaccesstokens`.*
`restaccesstokens`.`id`
`restaccesstokens`.`userId`
`restaccesstokens`.`hash`
`restaccesstokens`.`token`
`restaccesstokens`.`created`
`restaccesstokens`.`updated`
`reviewfeedbacks`.*
`reviewfeedbacks`.`id`
`reviewfeedbacks`.`employee`
`reviewfeedbacks`.`review`
`reviewfeedbacks`.`subject`
`reviewfeedbacks`.`form`
`reviewfeedbacks`.`status`
`reviewfeedbacks`.`dueon`
`reviewfeedbacks`.`created`
`reviewfeedbacks`.`updated`
`reviewfeedbacks`.`rating`
`reviewtemplates`.*
`reviewtemplates`.`id`
`reviewtemplates`.`name`
`reviewtemplates`.`description`
`reviewtemplates`.`items`
`reviewtemplates`.`created`
`reviewtemplates`.`updated`
`salarycomponent`.*
`salarycomponent`.`id`
`salarycomponent`.`name`
`salarycomponent`.`componentType`
`salarycomponent`.`details`
`salarycomponenttype`.*
`salarycomponenttype`.`id`
`salarycomponenttype`.`code`
`salarycomponenttype`.`name`
`settings`.*
`settings`.`id`
`settings`.`name`
`settings`.`value`
`settings`.`description`
`settings`.`meta`
`settings`.`category`
`skills`.*
`skills`.`id`
`skills`.`name`
`skills`.`description`
`statuschangelogs`.*
`statuschangelogs`.`id`
`statuschangelogs`.`type`
`statuschangelogs`.`element`
`statuschangelogs`.`user_id`
`statuschangelogs`.`data`
`statuschangelogs`.`status_from`
`statuschangelogs`.`status_to`
`statuschangelogs`.`created`
`supportedlanguages`.*
`supportedlanguages`.`id`
`supportedlanguages`.`name`
`supportedlanguages`.`description`
`systemdata`.*
`systemdata`.`id`
`systemdata`.`name`
`systemdata`.`value`
`tags`.*
`tags`.`id`
`tags`.`name`
`timezones`.*
`timezones`.`id`
`timezones`.`name`
`timezones`.`details`
`trainingsessions`.*
`trainingsessions`.`id`
`trainingsessions`.`name`
`trainingsessions`.`course`
`trainingsessions`.`description`
`trainingsessions`.`scheduled`
`trainingsessions`.`dueDate`
`trainingsessions`.`deliveryMethod`
`trainingsessions`.`deliveryLocation`
`trainingsessions`.`status`
`trainingsessions`.`attendanceType`
`trainingsessions`.`attachment`
`trainingsessions`.`created`
`trainingsessions`.`updated`
`trainingsessions`.`requireProof`
`userinvitations`.*
`userinvitations`.`id`
`userinvitations`.`email`
`userinvitations`.`username`
`userinvitations`.`first_name`
`userinvitations`.`last_name`
`userinvitations`.`user_level`
`userinvitations`.`password`
`userinvitations`.`timezone`
`userinvitations`.`employee_id`
`userinvitations`.`department`
`userinvitations`.`joined_date`
`userinvitations`.`job_title`
`userinvitations`.`employment_status`
`userinvitations`.`pay_grade`
`userinvitations`.`supervisor`
`userinvitations`.`country`
`userinvitations`.`invitation_status`
`userinvitations`.`created_user_id`
`userinvitations`.`created_employee_id`
`userinvitations`.`created`
`userinvitations`.`updated`
`usermeta`.*
`usermeta`.`id`
`usermeta`.`user_id`
`usermeta`.`meta_key`
`usermeta`.`meta_value`
`usermeta`.`created`
`usermeta`.`updated`
`userreports`.*
`userreports`.`id`
`userreports`.`name`
`userreports`.`details`
`userreports`.`parameters`
`userreports`.`query`
`userreports`.`paramOrder`
`userreports`.`type`
`userreports`.`report_group`
`userreports`.`output`
`userroles`.*
`userroles`.`id`
`userroles`.`name`
`userroles`.`additional_permissions`
`users`.*
`users`.`id`
`users`.`username`
`users`.`email`
`users`.`password`
`users`.`employee`
`users`.`default_module`
`users`.`user_level`
`users`.`user_roles`
`users`.`last_login`
`users`.`last_update`
`users`.`created`
`users`.`login_hash`
`users`.`lang`
`users`.`googleUserData`
`users`.`wrong_password_count`
`users`.`last_wrong_attempt_at`
`users`.`last_password_requested_at`
`workdays`.*
`workdays`.`id`
`workdays`.`name`
`workdays`.`status`
`workdays`.`country`
Alias:
Show:
Sort:
Ascending
Descending
Ascending
Descending
Ascending
Descending
Sort order:
1
2
3
1
2
3
1
2
3
Criteria:
Ins:
And:
Del:
Or:
Modify:
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Ins
Del
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
Add/Delete columns:
-3
-2
-1
0
1
2
3
Use tables
archivedemployees
assettypes
attendance
auditlog
certifications
clients
companyassets
companydocuments
companyloans
companystructures
conversations
conversationuserstatus
country
courses
crons
currencytypes
customfields
customfieldvalues
dataentrybackups
dataimport
dataimportfiles
deductiongroup
deductions
documents
educations
emaillog
emails
emergencycontacts
employeeapprovals
employeeattendancesheets
employeecareer
employeecertifications
employeecompanyloans
employeedatahistory
employeedependents
employeedocuments
employeeeducations
employeeethnicity
employeeexpenses
employeeforms
employeegoals
employeeimmigrations
employeeimmigrationstatus
employeelanguages
employeeleavedays
employeeleavelog
employeeleaves
employeeovertime
employeeprojects
employees
employeesalary
employeeskills
employeestatus
employeeteammembers
employeeteams
employeetimeentry
employeetimesheets
employeetrainingsessions
employeetravelrecords
employmentstatus
ethnicity
expensescategories
expensespaymentmethods
fieldnamemappings
files
forms
holidays
immigrationdocuments
immigrationstatus
jobtitles
languages
leavegroupemployees
leavegroups
leaveperiods
leaverules
leavestartingbalance
leavetypes
migrations
modules
nationality
notifications
overtimecategories
payfrequency
paygrades
payroll
payrollcolumns
payrollcolumntemplates
payrolldata
payrollemployees
paysliptemplates
performancereviews
permissions
projects
province
reportfiles
reports
restaccesstokens
reviewfeedbacks
reviewtemplates
salarycomponent
salarycomponenttype
settings
skills
statuschangelogs
supportedlanguages
systemdata
tags
timezones
trainingsessions
userinvitations
usermeta
userreports
userroles
users
workdays
SQL query on database
icehrm_db
: