Recent
`information_schema`.`ENABLED_ROLES`
`information_schema`.`CLIENT_STATISTICS`
`information_schema`.`STATISTICS`
`information_schema`.`ROUTINES`
`information_schema`.`INDEX_STATISTICS`
`information_schema`.`PLUGINS`
`information_schema`.`TABLE_STATISTICS`
`information_schema`.`user_variables`
`information_schema`.`ENGINES`
`information_schema`.`ALL_PLUGINS`
Favorites
There are no favorite tables.
New
axiuss40_africa
charity_program
axiuss40_africa_charity_program
axiuss40_africa_charity_program_staging
money_program
axiuss40_africa_money_program
axiuss40_africa_money_program_bk
axiuss40_africa_money_program_private
axiuss40_africa_money_program_private_german
axiuss40_africa_money_program_rdi
axiuss40_africa_money_program_staging
patient_program
axiuss40_africa_patient_program
axiuss40_africa_patient_program_bk
axiuss40_africa_patient_program_staging
axiuss40_africa_patient_program_staging_old
personal_program
axiuss40_africa_personal_program
axiuss40_africa_personal_program_bk
axiuss40_africa_personal_program_school
axiuss40_africa_personal_program_staging
information_schema
mysql
performance_schema
task_manager
task_manager
task_manager_staging
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize 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.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize 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
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Yes
/
No
/
Delete settings
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: task_manager
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Designer
Console
Clear
History
Options
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 :
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
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Switch to
visual builder
Column:
`allowances`.*
`allowances`.`id`
`allowances`.`name`
`allowances`.`price`
`allowances`.`percentageOfBasicSalary`
`allowances`.`status`
`allowances`.`deleted`
`allowances`.`addedOn`
`allowances`.`addedBy`
`allowances`.`modifiedBy`
`allowances`.`modifiedOn`
`board_members`.*
`board_members`.`id`
`board_members`.`Name`
`board_members`.`Surname`
`board_members`.`Gender`
`board_members`.`Birth`
`board_members`.`Nationality`
`board_members`.`MobileNo_1`
`board_members`.`IsWhatsapp_1`
`board_members`.`IsComon_1`
`board_members`.`MobileNo_2`
`board_members`.`IsWhatsapp_2`
`board_members`.`IsComon_2`
`board_members`.`Email`
`board_members`.`ExecutivBoardPositionID`
`board_members`.`PositionSince`
`board_members`.`ImagePath`
`board_members`.`status`
`board_members`.`deleted`
`board_members`.`addedOn`
`board_members`.`addedBy`
`board_members`.`modifiedBy`
`board_members`.`modifiedOn`
`bonus_reg`.*
`bonus_reg`.`ID`
`bonus_reg`.`Valid`
`bonus_reg`.`Item1ID`
`bonus_reg`.`Item2ID`
`bonus_reg`.`Item3ID`
`bonus_reg`.`EmploymentMonths`
`calendar_items`.*
`calendar_items`.`id`
`calendar_items`.`item_type`
`calendar_items`.`item_id`
`ci_sessions`.*
`ci_sessions`.`id`
`ci_sessions`.`user_email`
`ci_sessions`.`ip_address`
`ci_sessions`.`user_agent`
`ci_sessions`.`timestamp`
`ci_sessions`.`data`
`ci_sessions`.`browser`
`ci_sessions`.`version`
`ci_sessions`.`device`
`ci_sessions`.`platform`
`company_details`.*
`company_details`.`id`
`company_details`.`name`
`company_details`.`value`
`company_details`.`language_id`
`company_details`.`addedOn`
`company_details`.`modifiedOn`
`contents`.*
`contents`.`id`
`contents`.`category_id`
`contents`.`title`
`contents`.`description`
`contents`.`image`
`contents`.`status`
`contents`.`order_no`
`contents`.`deleted`
`contents`.`slug`
`contents`.`meta_title`
`contents`.`meta_key`
`contents`.`meta_description`
`contents`.`addedBy`
`contents`.`addedOn`
`contents`.`modifiedOn`
`contents`.`modifiedBy`
`currencies`.*
`currencies`.`id`
`currencies`.`name`
`currencies`.`symbol`
`currencies`.`exchange_rate`
`currencies`.`code`
`currencies`.`exchange_rate_def`
`currencies`.`status`
`currencies`.`deleted`
`currencies`.`addedBy`
`currencies`.`modifiedBy`
`currencies`.`addedOn`
`currencies`.`modifiedOn`
`day_task_finished`.*
`day_task_finished`.`EmpTaskID`
`day_task_finished`.`Date`
`day_task_finished`.`Finished`
`email_templates`.*
`email_templates`.`id`
`email_templates`.`name`
`email_templates`.`email_template_key`
`email_templates`.`email_from`
`email_templates`.`email_subject`
`email_templates`.`content`
`email_templates`.`content_cn`
`email_templates`.`email_subject_cn`
`email_templates`.`variables`
`email_templates`.`sms_template`
`email_templates`.`sms_send_status`
`email_templates`.`status`
`email_templates`.`modifiedDate`
`email_templates`.`createdDate`
`email_templates`.`addedBy`
`email_templates`.`modifiedBy`
`employee_extras`.*
`employee_extras`.`id`
`employee_extras`.`id_image`
`employee_extras`.`signature_image`
`employee_extras`.`tin_number`
`employee_extras`.`employee_id`
`employee_extras`.`status`
`employee_extras`.`deleted`
`employee_extras`.`addedOn`
`employee_extras`.`addedBy`
`employee_extras`.`modifiedBy`
`employee_extras`.`modifiedOn`
`employee_miscellaneous`.*
`employee_miscellaneous`.`id`
`employee_miscellaneous`.`employeed_as`
`employee_miscellaneous`.`date_of_employment`
`employee_miscellaneous`.`date_of_termination`
`employee_miscellaneous`.`days_of_vocation`
`employee_miscellaneous`.`is_living_in_staffhouse`
`employee_miscellaneous`.`employee_id`
`employee_miscellaneous`.`status`
`employee_miscellaneous`.`deleted`
`employee_miscellaneous`.`addedOn`
`employee_miscellaneous`.`addedBy`
`employee_miscellaneous`.`modifiedBy`
`employee_miscellaneous`.`modifiedOn`
`employee_roles`.*
`employee_roles`.`id`
`employee_roles`.`organisation_id`
`employee_roles`.`name`
`employee_roles`.`status`
`employee_roles`.`deleted`
`employee_roles`.`addedOn`
`employee_roles`.`addedBy`
`employee_roles`.`modifiedBy`
`employee_roles`.`modifiedOn`
`employee_salaries`.*
`employee_salaries`.`id`
`employee_salaries`.`employee_id`
`employee_salaries`.`basic_salary`
`employee_salaries`.`allowances`
`employee_salaries`.`allowances_ids`
`employee_salaries`.`total_salary`
`employee_salaries`.`position`
`employee_salaries`.`bank_name`
`employee_salaries`.`bban`
`employee_salaries`.`bank_account_number`
`employee_salaries`.`status`
`employee_salaries`.`deleted`
`employee_salaries`.`addedOn`
`employee_salaries`.`addedBy`
`employee_salaries`.`modifiedBy`
`employee_salaries`.`modifiedOn`
`employee_send_messages`.*
`employee_send_messages`.`id`
`employee_send_messages`.`employee_id`
`employee_send_messages`.`message_template_id`
`employee_send_messages`.`subject`
`employee_send_messages`.`content`
`employee_send_messages`.`email`
`employee_send_messages`.`email_from`
`employee_send_messages`.`email_send_at`
`employee_send_messages`.`email_send_status`
`employee_send_messages`.`file_name`
`employee_send_messages`.`file`
`employee_send_messages`.`status`
`employee_send_messages`.`deleted`
`employee_send_messages`.`addedOn`
`employee_send_messages`.`addedBy`
`employee_send_messages`.`modifiedBy`
`employee_send_messages`.`modifiedOn`
`employees`.*
`employees`.`id`
`employees`.`organisation_id`
`employees`.`first_name`
`employees`.`sur_name`
`employees`.`gender`
`employees`.`date_of_birth`
`employees`.`nationality_id`
`employees`.`religion_id`
`employees`.`mobile_no_1`
`employees`.`is_whatsapp_mobile_1`
`employees`.`is_comon_mobile_1`
`employees`.`mobile_no_2`
`employees`.`is_whatsapp_mobile_2`
`employees`.`is_comon_mobile_2`
`employees`.`email`
`employees`.`city`
`employees`.`town`
`employees`.`street`
`employees`.`social_security_no`
`employees`.`tax_no`
`employees`.`profession_id`
`employees`.`sector_id`
`employees`.`can_read`
`employees`.`can_write`
`employees`.`is_lives_in_project_staff_house`
`employees`.`from_date`
`employees`.`to_date`
`employees`.`ResignType`
`employees`.`image`
`employees`.`signature_image`
`employees`.`status`
`employees`.`deleted`
`employees`.`addedOn`
`employees`.`addedBy`
`employees`.`modifiedBy`
`employees`.`modifiedOn`
`employees_emergency_contact_details`.*
`employees_emergency_contact_details`.`id`
`employees_emergency_contact_details`.`employee_id`
`employees_emergency_contact_details`.`person_name`
`employees_emergency_contact_details`.`contact_number`
`employees_emergency_contact_details`.`relation`
`employees_emergency_contact_details`.`status`
`employees_emergency_contact_details`.`deleted`
`employees_emergency_contact_details`.`addedOn`
`employees_emergency_contact_details`.`addedBy`
`employees_emergency_contact_details`.`modifiedBy`
`employees_emergency_contact_details`.`modifiedOn`
`employees_related_documents`.*
`employees_related_documents`.`id`
`employees_related_documents`.`EmployeeID`
`employees_related_documents`.`Name`
`employees_related_documents`.`Content`
`employees_related_documents`.`DocumentType`
`employees_related_documents`.`status`
`employees_related_documents`.`deleted`
`employees_related_documents`.`addedOn`
`employees_related_documents`.`addedBy`
`employees_related_documents`.`modifiedBy`
`employees_related_documents`.`modifiedOn`
`employment_types`.*
`employment_types`.`ID`
`employment_types`.`Name`
`employment_types`.`ShortName`
`employment_types`.`EmpltType`
`employment_types`.`Color`
`events`.*
`events`.`id`
`events`.`organisation_id`
`events`.`sector_id`
`events`.`related_to`
`events`.`responsible_person_id`
`events`.`supervisor_id`
`events`.`title`
`events`.`short_description`
`events`.`long_description`
`events`.`status`
`events`.`deleted`
`events`.`addedOn`
`events`.`addedBy`
`events`.`modifiedBy`
`events`.`modifiedOn`
`executing_persons`.*
`executing_persons`.`id`
`executing_persons`.`organisation_id`
`executing_persons`.`employee_id`
`executing_persons`.`Name`
`executing_persons`.`Surname`
`executing_persons`.`Gender`
`executing_persons`.`Birth`
`executing_persons`.`profession`
`executing_persons`.`MobileNo_1`
`executing_persons`.`IsWhatsapp_1`
`executing_persons`.`IsComon_1`
`executing_persons`.`MobileNo_2`
`executing_persons`.`IsWhatsapp_2`
`executing_persons`.`IsComon_2`
`executing_persons`.`Email`
`executing_persons`.`sector_ids`
`executing_persons`.`preferred_communication`
`executing_persons`.`status`
`executing_persons`.`deleted`
`executing_persons`.`addedOn`
`executing_persons`.`addedBy`
`executing_persons`.`modifiedBy`
`executing_persons`.`modifiedOn`
`folder_files`.*
`folder_files`.`id`
`folder_files`.`folder_id`
`folder_files`.`file_original_name`
`folder_files`.`file_name`
`folder_files`.`user_id`
`folder_files`.`file_size`
`folder_files`.`extension`
`folder_files`.`type`
`folder_files`.`created_at`
`folder_files`.`updated_at`
`folder_files`.`deleted_at`
`folder_files`.`deleted`
`folder_files`.`status`
`folders`.*
`folders`.`id`
`folders`.`parent_id`
`folders`.`name`
`folders`.`date`
`folders`.`status`
`folders`.`deleted`
`folders`.`addedOn`
`folders`.`addedBy`
`folders`.`modifiedBy`
`folders`.`modifiedOn`
`holidays`.*
`holidays`.`id`
`holidays`.`name`
`holidays`.`date`
`holidays`.`status`
`holidays`.`deleted`
`holidays`.`addedOn`
`holidays`.`addedBy`
`holidays`.`modifiedBy`
`holidays`.`modifiedOn`
`languages`.*
`languages`.`id`
`languages`.`name`
`languages`.`short_form`
`languages`.`language_code`
`languages`.`text_direction`
`languages`.`status`
`languages`.`deleted`
`languages`.`language_order`
`languages`.`text_editor_lang`
`languages`.`flag_path`
`last_user`.*
`last_user`.`ID`
`last_user`.`Name`
`last_user`.`Password`
`location_cities`.*
`location_cities`.`id`
`location_cities`.`name`
`location_cities`.`state_id`
`location_cities`.`state_code`
`location_cities`.`country_id`
`location_cities`.`country_code`
`location_cities`.`latitude`
`location_cities`.`longitude`
`location_cities`.`created_at`
`location_cities`.`updated_at`
`location_cities`.`flag`
`location_cities`.`wikiDataId`
`location_countries`.*
`location_countries`.`id`
`location_countries`.`name`
`location_countries`.`iso3`
`location_countries`.`iso2`
`location_countries`.`phonecode`
`location_countries`.`capital`
`location_countries`.`currency`
`location_countries`.`currency_symbol`
`location_countries`.`tld`
`location_countries`.`native`
`location_countries`.`region`
`location_countries`.`subregion`
`location_countries`.`timezones`
`location_countries`.`translations`
`location_countries`.`latitude`
`location_countries`.`longitude`
`location_countries`.`emoji`
`location_countries`.`emojiU`
`location_countries`.`created_at`
`location_countries`.`updated_at`
`location_countries`.`status`
`location_countries`.`wikiDataId`
`location_states`.*
`location_states`.`id`
`location_states`.`name`
`location_states`.`country_id`
`location_states`.`country_code`
`location_states`.`fips_code`
`location_states`.`iso2`
`location_states`.`latitude`
`location_states`.`longitude`
`location_states`.`created_at`
`location_states`.`updated_at`
`location_states`.`flag`
`location_states`.`wikiDataId`
`location_villages`.*
`location_villages`.`id`
`location_villages`.`name`
`location_villages`.`distance`
`location_villages`.`status`
`location_villages`.`deleted`
`location_villages`.`addedOn`
`location_villages`.`addedBy`
`location_villages`.`modifiedBy`
`location_villages`.`modifiedOn`
`login_attempts`.*
`login_attempts`.`id`
`login_attempts`.`ip_address`
`login_attempts`.`login`
`login_attempts`.`time`
`login_records`.*
`login_records`.`id`
`login_records`.`session_id`
`login_records`.`user_email`
`login_records`.`user_id`
`login_records`.`ip_address`
`login_records`.`user_agent`
`login_records`.`login_time`
`login_records`.`logout_time`
`login_records`.`browser`
`login_records`.`version`
`login_records`.`device`
`login_records`.`platform`
`login_records`.`mac_id`
`login_records`.`modifiedOn`
`message_templates`.*
`message_templates`.`id`
`message_templates`.`name`
`message_templates`.`email_template_for`
`message_templates`.`sectors_ids`
`message_templates`.`professions_ids`
`message_templates`.`email_subject`
`message_templates`.`content`
`message_templates`.`status`
`message_templates`.`deleted`
`message_templates`.`modifiedDate`
`message_templates`.`createdDate`
`message_templates`.`addedBy`
`message_templates`.`modifiedBy`
`modules`.*
`modules`.`id`
`modules`.`section`
`modules`.`name`
`modules`.`lang_names`
`modules`.`alias`
`modules`.`order_no`
`modules`.`is_url`
`modules`.`url`
`modules`.`parent_id`
`modules`.`description`
`modules`.`icon`
`modules`.`permissions`
`modules`.`is_public`
`modules`.`addedBy`
`modules`.`status`
`modules`.`deleted`
`modules`.`addedOn`
`modules`.`modifiedOn`
`modules`.`modifiedBy`
`nationalities`.*
`nationalities`.`id`
`nationalities`.`name`
`nationalities`.`status`
`nationalities`.`deleted`
`nationalities`.`addedOn`
`nationalities`.`addedBy`
`nationalities`.`modifiedBy`
`nationalities`.`modifiedOn`
`organisations`.*
`organisations`.`id`
`organisations`.`name`
`organisations`.`status`
`organisations`.`deleted`
`organisations`.`addedOn`
`organisations`.`addedBy`
`organisations`.`modifiedBy`
`organisations`.`modifiedOn`
`partners`.*
`partners`.`id`
`partners`.`type`
`partners`.`sub_type`
`partners`.`Name`
`partners`.`Street`
`partners`.`PLZ`
`partners`.`Town`
`partners`.`POBox`
`partners`.`Email`
`partners`.`Phone`
`partners`.`Fax`
`partners`.`status`
`partners`.`deleted`
`partners`.`addedOn`
`partners`.`addedBy`
`partners`.`modifiedBy`
`partners`.`modifiedOn`
`partners`.`bank_name`
`partners`.`bank_iban`
`partners`.`contacts`
`partners_contacts`.*
`partners_contacts`.`id`
`partners_contacts`.`PartnerID`
`partners_contacts`.`Gender`
`partners_contacts`.`Address`
`partners_contacts`.`Title`
`partners_contacts`.`Pos`
`partners_contacts`.`Name`
`partners_contacts`.`Surname`
`partners_contacts`.`Phone`
`partners_contacts`.`Mobile`
`partners_contacts`.`Fax`
`partners_contacts`.`Email`
`partners_contacts`.`Note`
`partners_contacts`.`status`
`partners_contacts`.`deleted`
`partners_contacts`.`addedOn`
`partners_contacts`.`addedBy`
`partners_contacts`.`modifiedBy`
`partners_contacts`.`modifiedOn`
`partners_sub_types`.*
`partners_sub_types`.`id`
`partners_sub_types`.`partners_type_id`
`partners_sub_types`.`name`
`partners_sub_types`.`status`
`partners_sub_types`.`deleted`
`partners_sub_types`.`addedOn`
`partners_sub_types`.`addedBy`
`partners_sub_types`.`modifiedBy`
`partners_sub_types`.`modifiedOn`
`partners_types`.*
`partners_types`.`id`
`partners_types`.`name`
`partners_types`.`status`
`partners_types`.`deleted`
`partners_types`.`addedOn`
`partners_types`.`addedBy`
`partners_types`.`modifiedBy`
`partners_types`.`modifiedOn`
`professions`.*
`professions`.`id`
`professions`.`organisation_id`
`professions`.`name`
`professions`.`status`
`professions`.`deleted`
`professions`.`addedOn`
`professions`.`addedBy`
`professions`.`modifiedBy`
`professions`.`modifiedOn`
`reasons`.*
`reasons`.`id`
`reasons`.`name`
`reasons`.`status`
`reasons`.`deleted`
`reasons`.`addedOn`
`reasons`.`addedBy`
`reasons`.`modifiedBy`
`reasons`.`modifiedOn`
`religions`.*
`religions`.`id`
`religions`.`name`
`religions`.`status`
`religions`.`deleted`
`religions`.`addedOn`
`religions`.`addedBy`
`religions`.`modifiedBy`
`religions`.`modifiedOn`
`responsible_persons`.*
`responsible_persons`.`id`
`responsible_persons`.`organisation_id`
`responsible_persons`.`employee_id`
`responsible_persons`.`Name`
`responsible_persons`.`Surname`
`responsible_persons`.`Gender`
`responsible_persons`.`Birth`
`responsible_persons`.`profession`
`responsible_persons`.`MobileNo_1`
`responsible_persons`.`IsWhatsapp_1`
`responsible_persons`.`IsComon_1`
`responsible_persons`.`MobileNo_2`
`responsible_persons`.`IsWhatsapp_2`
`responsible_persons`.`IsComon_2`
`responsible_persons`.`Email`
`responsible_persons`.`sector_ids`
`responsible_persons`.`preferred_communication`
`responsible_persons`.`status`
`responsible_persons`.`deleted`
`responsible_persons`.`addedOn`
`responsible_persons`.`addedBy`
`responsible_persons`.`modifiedBy`
`responsible_persons`.`modifiedOn`
`role_permissions`.*
`role_permissions`.`id`
`role_permissions`.`role_id`
`role_permissions`.`module_id`
`role_permissions`.`parent_module_id`
`role_permissions`.`section`
`role_permissions`.`permission_add`
`role_permissions`.`permission_edit`
`role_permissions`.`permission_view`
`role_permissions`.`permission_delete`
`role_permissions`.`permission_status`
`role_permissions`.`addedBy`
`role_permissions`.`addedOn`
`role_permissions`.`modifiedOn`
`roles`.*
`roles`.`id`
`roles`.`parent_id`
`roles`.`name`
`roles`.`description`
`roles`.`modifiedBy`
`roles`.`deleted`
`roles`.`addedBy`
`roles`.`addedOn`
`roles`.`modifiedOn`
`roles`.`status`
`salaries_history_allowances`.*
`salaries_history_allowances`.`ID`
`salaries_history_allowances`.`SalaryHistoryID`
`salaries_history_allowances`.`AllowanceID`
`salaries_history_allowances`.`AmountAllDays`
`salaries_history_allowances`.`AmountCalculateDays`
`salaries_history_allowances`.`Amount`
`salaries_history_allowances`.`NotPaidDays`
`salary_histories`.*
`salary_histories`.`id`
`salary_histories`.`YearMonth`
`salary_histories`.`EmplID`
`salary_histories`.`CalculationDate`
`salary_histories`.`WorkDays`
`salary_histories`.`WorkDaysInMonth`
`salary_histories`.`BasicSalary`
`salary_histories`.`BasicSalaryManual`
`salary_histories`.`Allowances`
`salary_histories`.`AllowancesManual`
`salary_histories`.`RegularBonus`
`salary_histories`.`IrregularBonus`
`salary_histories`.`IrregularBonusManual`
`salary_histories`.`PaidAdvance`
`salary_histories`.`RepaymentOfLoan`
`salary_histories`.`RepaymentOfLoanManual`
`salary_histories`.`IncomeTax`
`salary_histories`.`IncomeTaxManual`
`salary_histories`.`OtherTaxes`
`salary_histories`.`EmplSocialSecurity`
`salary_histories`.`EmplSocialSecurityPercent`
`salary_histories`.`CompSocialSecurity`
`salary_histories`.`CompSocialSecurityPercent`
`salary_histories`.`SocialSecurityTotal`
`salary_histories`.`EmplSocialSecurityGov`
`salary_histories`.`EmplSocialSecurityPercentGov`
`salary_histories`.`CompSocialSecurityGov`
`salary_histories`.`CompSocialSecurityPercentGov`
`salary_histories`.`SocialSecurityTotalGov`
`salary_histories`.`EmplSocialSecurityInj`
`salary_histories`.`EmplSocialSecurityPercentInj`
`salary_histories`.`CompSocialSecurityInj`
`salary_histories`.`CompSocialSecurityPercentInj`
`salary_histories`.`SocialSecurityTotalInj`
`salary_histories`.`InsurenceAmount`
`salary_histories`.`Brutto`
`salary_histories`.`Payment`
`salary_histories`.`Calculated`
`salary_histories`.`CountPaidDayForBasicSalary`
`salary_histories`.`NotPaidDaysForBasicSalary`
`salary_histories`.`SettlementDate`
`salary_histories`.`status`
`salary_histories`.`deleted`
`salary_histories`.`addedOn`
`salary_histories`.`addedBy`
`salary_histories`.`modifiedBy`
`salary_histories`.`modifiedOn`
`salary_histories`.`Extra`
`salary_histories`.`Minus`
`sectors`.*
`sectors`.`id`
`sectors`.`organisation_id`
`sectors`.`name`
`sectors`.`status`
`sectors`.`deleted`
`sectors`.`addedOn`
`sectors`.`addedBy`
`sectors`.`modifiedBy`
`sectors`.`modifiedOn`
`settings`.*
`settings`.`id`
`settings`.`name`
`settings`.`value`
`settings`.`language_id`
`settings`.`addedOn`
`settings`.`modifiedOn`
`supervisors`.*
`supervisors`.`id`
`supervisors`.`organisation_id`
`supervisors`.`employee_id`
`supervisors`.`Name`
`supervisors`.`Surname`
`supervisors`.`Gender`
`supervisors`.`Birth`
`supervisors`.`profession`
`supervisors`.`MobileNo_1`
`supervisors`.`IsWhatsapp_1`
`supervisors`.`IsComon_1`
`supervisors`.`MobileNo_2`
`supervisors`.`IsWhatsapp_2`
`supervisors`.`IsComon_2`
`supervisors`.`Email`
`supervisors`.`sector_ids`
`supervisors`.`preferred_communication`
`supervisors`.`status`
`supervisors`.`deleted`
`supervisors`.`addedOn`
`supervisors`.`addedBy`
`supervisors`.`modifiedBy`
`supervisors`.`modifiedOn`
`tasks`.*
`tasks`.`id`
`tasks`.`organisation_id`
`tasks`.`related_to`
`tasks`.`related_preferred_communication`
`tasks`.`parent_task_id`
`tasks`.`is_subtask`
`tasks`.`is_recurring`
`tasks`.`subtask_order`
`tasks`.`sector_id`
`tasks`.`responsible_person_id`
`tasks`.`responsible_preferred_communication`
`tasks`.`supervisor_id`
`tasks`.`supervisor_preferred_communication`
`tasks`.`title`
`tasks`.`short_description`
`tasks`.`long_description`
`tasks`.`from_date`
`tasks`.`till_date`
`tasks`.`subtask_offset`
`tasks`.`completion_time`
`tasks`.`file_name`
`tasks`.`status`
`tasks`.`task_status`
`tasks`.`is_informed`
`tasks`.`is_execut_informed`
`tasks`.`is_respon_informed`
`tasks`.`execut_informed_on`
`tasks`.`respon_informed_on`
`tasks`.`execut_informed_by`
`tasks`.`respon_informed_by`
`tasks`.`informed_on`
`tasks`.`informed_by`
`tasks`.`partially_completed_reason_id`
`tasks`.`partially_completed_notes`
`tasks`.`is_extended`
`tasks`.`original_task_id`
`tasks`.`extension_days`
`tasks`.`extension_date`
`tasks`.`deleted`
`tasks`.`addedOn`
`tasks`.`addedBy`
`tasks`.`modifiedBy`
`tasks`.`modifiedOn`
`tasks`.`is_communication_task`
`tasks`.`communication_type`
`tasks`.`communication_to`
`tasks`.`contact_info`
`tasks`.`original_communication_title`
`transfers`.*
`transfers`.`id`
`transfers`.`number`
`transfers`.`date`
`transfers`.`pay_from`
`transfers`.`pay_to`
`transfers`.`amount`
`transfers`.`info`
`transfers`.`document`
`transfers`.`status`
`transfers`.`deleted`
`transfers`.`addedOn`
`transfers`.`addedBy`
`transfers`.`modifiedBy`
`transfers`.`modifiedOn`
`tribes`.*
`tribes`.`id`
`tribes`.`name`
`tribes`.`checked`
`tribes`.`status`
`tribes`.`deleted`
`tribes`.`addedOn`
`tribes`.`addedBy`
`tribes`.`modifiedBy`
`tribes`.`modifiedOn`
`uploads`.*
`uploads`.`id`
`uploads`.`file_original_name`
`uploads`.`file_name`
`uploads`.`user_id`
`uploads`.`file_size`
`uploads`.`extension`
`uploads`.`type`
`uploads`.`created_at`
`uploads`.`updated_at`
`uploads`.`deleted_at`
`user_address_books`.*
`user_address_books`.`id`
`user_address_books`.`user_id`
`user_address_books`.`is_favourite`
`user_address_books`.`name`
`user_address_books`.`phone_no`
`user_address_books`.`address`
`user_address_books`.`area`
`user_address_books`.`lat`
`user_address_books`.`lng`
`user_address_books`.`address_type`
`user_address_books`.`is_gift`
`user_address_books`.`status`
`user_address_books`.`deleted`
`user_address_books`.`addedBy`
`user_address_books`.`modifiedBy`
`user_address_books`.`addedOn`
`user_address_books`.`modifiedOn`
`user_profiles`.*
`user_profiles`.`id`
`user_profiles`.`parent_id`
`user_profiles`.`user_id`
`user_profiles`.`full_name`
`user_profiles`.`fname`
`user_profiles`.`lname`
`user_profiles`.`email`
`user_profiles`.`phone_code`
`user_profiles`.`phone_no`
`user_profiles`.`profile_image`
`user_profiles`.`gender`
`user_profiles`.`dob`
`user_profiles`.`about`
`user_profiles`.`landmark`
`user_profiles`.`address`
`user_profiles`.`lat`
`user_profiles`.`lng`
`user_profiles`.`state_id`
`user_profiles`.`country_id`
`user_profiles`.`city_id`
`user_profiles`.`pincode`
`user_profiles`.`addedOn`
`user_profiles`.`modifiedOn`
`user_profiles`.`modifiedBy`
`user_schedules`.*
`user_schedules`.`id`
`user_schedules`.`user_id`
`user_schedules`.`day`
`user_schedules`.`day_name`
`user_schedules`.`time_from`
`user_schedules`.`time_to`
`user_schedules`.`type`
`user_schedules`.`modifiedOn`
`user_settings`.*
`user_settings`.`id`
`user_settings`.`user_id`
`user_settings`.`time_zone`
`user_settings`.`language_id`
`user_settings`.`multifactor_authenticate`
`user_settings`.`google_auth_code`
`user_settings`.`authenticate_using_otp`
`user_settings`.`otp_phone`
`user_settings`.`otp`
`user_settings`.`authenticate_using_google`
`user_settings`.`modifiedOn`
`user_settings`.`modifiedBy`
`users`.*
`users`.`id`
`users`.`parent_id`
`users`.`role_ids`
`users`.`login_id`
`users`.`password`
`users`.`is_online`
`users`.`is_verified`
`users`.`is_admin_verified`
`users`.`is_first_login`
`users`.`otp`
`users`.`device_type`
`users`.`ios_device_id`
`users`.`android_device_id`
`users`.`web_token`
`users`.`login_type`
`users`.`addedOn`
`users`.`modifiedOn`
`users`.`addedBy`
`users`.`modifiedBy`
`users`.`status`
`users`.`deleted`
`users`.`login_language`
`allowances`.*
`allowances`.`id`
`allowances`.`name`
`allowances`.`price`
`allowances`.`percentageOfBasicSalary`
`allowances`.`status`
`allowances`.`deleted`
`allowances`.`addedOn`
`allowances`.`addedBy`
`allowances`.`modifiedBy`
`allowances`.`modifiedOn`
`board_members`.*
`board_members`.`id`
`board_members`.`Name`
`board_members`.`Surname`
`board_members`.`Gender`
`board_members`.`Birth`
`board_members`.`Nationality`
`board_members`.`MobileNo_1`
`board_members`.`IsWhatsapp_1`
`board_members`.`IsComon_1`
`board_members`.`MobileNo_2`
`board_members`.`IsWhatsapp_2`
`board_members`.`IsComon_2`
`board_members`.`Email`
`board_members`.`ExecutivBoardPositionID`
`board_members`.`PositionSince`
`board_members`.`ImagePath`
`board_members`.`status`
`board_members`.`deleted`
`board_members`.`addedOn`
`board_members`.`addedBy`
`board_members`.`modifiedBy`
`board_members`.`modifiedOn`
`bonus_reg`.*
`bonus_reg`.`ID`
`bonus_reg`.`Valid`
`bonus_reg`.`Item1ID`
`bonus_reg`.`Item2ID`
`bonus_reg`.`Item3ID`
`bonus_reg`.`EmploymentMonths`
`calendar_items`.*
`calendar_items`.`id`
`calendar_items`.`item_type`
`calendar_items`.`item_id`
`ci_sessions`.*
`ci_sessions`.`id`
`ci_sessions`.`user_email`
`ci_sessions`.`ip_address`
`ci_sessions`.`user_agent`
`ci_sessions`.`timestamp`
`ci_sessions`.`data`
`ci_sessions`.`browser`
`ci_sessions`.`version`
`ci_sessions`.`device`
`ci_sessions`.`platform`
`company_details`.*
`company_details`.`id`
`company_details`.`name`
`company_details`.`value`
`company_details`.`language_id`
`company_details`.`addedOn`
`company_details`.`modifiedOn`
`contents`.*
`contents`.`id`
`contents`.`category_id`
`contents`.`title`
`contents`.`description`
`contents`.`image`
`contents`.`status`
`contents`.`order_no`
`contents`.`deleted`
`contents`.`slug`
`contents`.`meta_title`
`contents`.`meta_key`
`contents`.`meta_description`
`contents`.`addedBy`
`contents`.`addedOn`
`contents`.`modifiedOn`
`contents`.`modifiedBy`
`currencies`.*
`currencies`.`id`
`currencies`.`name`
`currencies`.`symbol`
`currencies`.`exchange_rate`
`currencies`.`code`
`currencies`.`exchange_rate_def`
`currencies`.`status`
`currencies`.`deleted`
`currencies`.`addedBy`
`currencies`.`modifiedBy`
`currencies`.`addedOn`
`currencies`.`modifiedOn`
`day_task_finished`.*
`day_task_finished`.`EmpTaskID`
`day_task_finished`.`Date`
`day_task_finished`.`Finished`
`email_templates`.*
`email_templates`.`id`
`email_templates`.`name`
`email_templates`.`email_template_key`
`email_templates`.`email_from`
`email_templates`.`email_subject`
`email_templates`.`content`
`email_templates`.`content_cn`
`email_templates`.`email_subject_cn`
`email_templates`.`variables`
`email_templates`.`sms_template`
`email_templates`.`sms_send_status`
`email_templates`.`status`
`email_templates`.`modifiedDate`
`email_templates`.`createdDate`
`email_templates`.`addedBy`
`email_templates`.`modifiedBy`
`employee_extras`.*
`employee_extras`.`id`
`employee_extras`.`id_image`
`employee_extras`.`signature_image`
`employee_extras`.`tin_number`
`employee_extras`.`employee_id`
`employee_extras`.`status`
`employee_extras`.`deleted`
`employee_extras`.`addedOn`
`employee_extras`.`addedBy`
`employee_extras`.`modifiedBy`
`employee_extras`.`modifiedOn`
`employee_miscellaneous`.*
`employee_miscellaneous`.`id`
`employee_miscellaneous`.`employeed_as`
`employee_miscellaneous`.`date_of_employment`
`employee_miscellaneous`.`date_of_termination`
`employee_miscellaneous`.`days_of_vocation`
`employee_miscellaneous`.`is_living_in_staffhouse`
`employee_miscellaneous`.`employee_id`
`employee_miscellaneous`.`status`
`employee_miscellaneous`.`deleted`
`employee_miscellaneous`.`addedOn`
`employee_miscellaneous`.`addedBy`
`employee_miscellaneous`.`modifiedBy`
`employee_miscellaneous`.`modifiedOn`
`employee_roles`.*
`employee_roles`.`id`
`employee_roles`.`organisation_id`
`employee_roles`.`name`
`employee_roles`.`status`
`employee_roles`.`deleted`
`employee_roles`.`addedOn`
`employee_roles`.`addedBy`
`employee_roles`.`modifiedBy`
`employee_roles`.`modifiedOn`
`employee_salaries`.*
`employee_salaries`.`id`
`employee_salaries`.`employee_id`
`employee_salaries`.`basic_salary`
`employee_salaries`.`allowances`
`employee_salaries`.`allowances_ids`
`employee_salaries`.`total_salary`
`employee_salaries`.`position`
`employee_salaries`.`bank_name`
`employee_salaries`.`bban`
`employee_salaries`.`bank_account_number`
`employee_salaries`.`status`
`employee_salaries`.`deleted`
`employee_salaries`.`addedOn`
`employee_salaries`.`addedBy`
`employee_salaries`.`modifiedBy`
`employee_salaries`.`modifiedOn`
`employee_send_messages`.*
`employee_send_messages`.`id`
`employee_send_messages`.`employee_id`
`employee_send_messages`.`message_template_id`
`employee_send_messages`.`subject`
`employee_send_messages`.`content`
`employee_send_messages`.`email`
`employee_send_messages`.`email_from`
`employee_send_messages`.`email_send_at`
`employee_send_messages`.`email_send_status`
`employee_send_messages`.`file_name`
`employee_send_messages`.`file`
`employee_send_messages`.`status`
`employee_send_messages`.`deleted`
`employee_send_messages`.`addedOn`
`employee_send_messages`.`addedBy`
`employee_send_messages`.`modifiedBy`
`employee_send_messages`.`modifiedOn`
`employees`.*
`employees`.`id`
`employees`.`organisation_id`
`employees`.`first_name`
`employees`.`sur_name`
`employees`.`gender`
`employees`.`date_of_birth`
`employees`.`nationality_id`
`employees`.`religion_id`
`employees`.`mobile_no_1`
`employees`.`is_whatsapp_mobile_1`
`employees`.`is_comon_mobile_1`
`employees`.`mobile_no_2`
`employees`.`is_whatsapp_mobile_2`
`employees`.`is_comon_mobile_2`
`employees`.`email`
`employees`.`city`
`employees`.`town`
`employees`.`street`
`employees`.`social_security_no`
`employees`.`tax_no`
`employees`.`profession_id`
`employees`.`sector_id`
`employees`.`can_read`
`employees`.`can_write`
`employees`.`is_lives_in_project_staff_house`
`employees`.`from_date`
`employees`.`to_date`
`employees`.`ResignType`
`employees`.`image`
`employees`.`signature_image`
`employees`.`status`
`employees`.`deleted`
`employees`.`addedOn`
`employees`.`addedBy`
`employees`.`modifiedBy`
`employees`.`modifiedOn`
`employees_emergency_contact_details`.*
`employees_emergency_contact_details`.`id`
`employees_emergency_contact_details`.`employee_id`
`employees_emergency_contact_details`.`person_name`
`employees_emergency_contact_details`.`contact_number`
`employees_emergency_contact_details`.`relation`
`employees_emergency_contact_details`.`status`
`employees_emergency_contact_details`.`deleted`
`employees_emergency_contact_details`.`addedOn`
`employees_emergency_contact_details`.`addedBy`
`employees_emergency_contact_details`.`modifiedBy`
`employees_emergency_contact_details`.`modifiedOn`
`employees_related_documents`.*
`employees_related_documents`.`id`
`employees_related_documents`.`EmployeeID`
`employees_related_documents`.`Name`
`employees_related_documents`.`Content`
`employees_related_documents`.`DocumentType`
`employees_related_documents`.`status`
`employees_related_documents`.`deleted`
`employees_related_documents`.`addedOn`
`employees_related_documents`.`addedBy`
`employees_related_documents`.`modifiedBy`
`employees_related_documents`.`modifiedOn`
`employment_types`.*
`employment_types`.`ID`
`employment_types`.`Name`
`employment_types`.`ShortName`
`employment_types`.`EmpltType`
`employment_types`.`Color`
`events`.*
`events`.`id`
`events`.`organisation_id`
`events`.`sector_id`
`events`.`related_to`
`events`.`responsible_person_id`
`events`.`supervisor_id`
`events`.`title`
`events`.`short_description`
`events`.`long_description`
`events`.`status`
`events`.`deleted`
`events`.`addedOn`
`events`.`addedBy`
`events`.`modifiedBy`
`events`.`modifiedOn`
`executing_persons`.*
`executing_persons`.`id`
`executing_persons`.`organisation_id`
`executing_persons`.`employee_id`
`executing_persons`.`Name`
`executing_persons`.`Surname`
`executing_persons`.`Gender`
`executing_persons`.`Birth`
`executing_persons`.`profession`
`executing_persons`.`MobileNo_1`
`executing_persons`.`IsWhatsapp_1`
`executing_persons`.`IsComon_1`
`executing_persons`.`MobileNo_2`
`executing_persons`.`IsWhatsapp_2`
`executing_persons`.`IsComon_2`
`executing_persons`.`Email`
`executing_persons`.`sector_ids`
`executing_persons`.`preferred_communication`
`executing_persons`.`status`
`executing_persons`.`deleted`
`executing_persons`.`addedOn`
`executing_persons`.`addedBy`
`executing_persons`.`modifiedBy`
`executing_persons`.`modifiedOn`
`folder_files`.*
`folder_files`.`id`
`folder_files`.`folder_id`
`folder_files`.`file_original_name`
`folder_files`.`file_name`
`folder_files`.`user_id`
`folder_files`.`file_size`
`folder_files`.`extension`
`folder_files`.`type`
`folder_files`.`created_at`
`folder_files`.`updated_at`
`folder_files`.`deleted_at`
`folder_files`.`deleted`
`folder_files`.`status`
`folders`.*
`folders`.`id`
`folders`.`parent_id`
`folders`.`name`
`folders`.`date`
`folders`.`status`
`folders`.`deleted`
`folders`.`addedOn`
`folders`.`addedBy`
`folders`.`modifiedBy`
`folders`.`modifiedOn`
`holidays`.*
`holidays`.`id`
`holidays`.`name`
`holidays`.`date`
`holidays`.`status`
`holidays`.`deleted`
`holidays`.`addedOn`
`holidays`.`addedBy`
`holidays`.`modifiedBy`
`holidays`.`modifiedOn`
`languages`.*
`languages`.`id`
`languages`.`name`
`languages`.`short_form`
`languages`.`language_code`
`languages`.`text_direction`
`languages`.`status`
`languages`.`deleted`
`languages`.`language_order`
`languages`.`text_editor_lang`
`languages`.`flag_path`
`last_user`.*
`last_user`.`ID`
`last_user`.`Name`
`last_user`.`Password`
`location_cities`.*
`location_cities`.`id`
`location_cities`.`name`
`location_cities`.`state_id`
`location_cities`.`state_code`
`location_cities`.`country_id`
`location_cities`.`country_code`
`location_cities`.`latitude`
`location_cities`.`longitude`
`location_cities`.`created_at`
`location_cities`.`updated_at`
`location_cities`.`flag`
`location_cities`.`wikiDataId`
`location_countries`.*
`location_countries`.`id`
`location_countries`.`name`
`location_countries`.`iso3`
`location_countries`.`iso2`
`location_countries`.`phonecode`
`location_countries`.`capital`
`location_countries`.`currency`
`location_countries`.`currency_symbol`
`location_countries`.`tld`
`location_countries`.`native`
`location_countries`.`region`
`location_countries`.`subregion`
`location_countries`.`timezones`
`location_countries`.`translations`
`location_countries`.`latitude`
`location_countries`.`longitude`
`location_countries`.`emoji`
`location_countries`.`emojiU`
`location_countries`.`created_at`
`location_countries`.`updated_at`
`location_countries`.`status`
`location_countries`.`wikiDataId`
`location_states`.*
`location_states`.`id`
`location_states`.`name`
`location_states`.`country_id`
`location_states`.`country_code`
`location_states`.`fips_code`
`location_states`.`iso2`
`location_states`.`latitude`
`location_states`.`longitude`
`location_states`.`created_at`
`location_states`.`updated_at`
`location_states`.`flag`
`location_states`.`wikiDataId`
`location_villages`.*
`location_villages`.`id`
`location_villages`.`name`
`location_villages`.`distance`
`location_villages`.`status`
`location_villages`.`deleted`
`location_villages`.`addedOn`
`location_villages`.`addedBy`
`location_villages`.`modifiedBy`
`location_villages`.`modifiedOn`
`login_attempts`.*
`login_attempts`.`id`
`login_attempts`.`ip_address`
`login_attempts`.`login`
`login_attempts`.`time`
`login_records`.*
`login_records`.`id`
`login_records`.`session_id`
`login_records`.`user_email`
`login_records`.`user_id`
`login_records`.`ip_address`
`login_records`.`user_agent`
`login_records`.`login_time`
`login_records`.`logout_time`
`login_records`.`browser`
`login_records`.`version`
`login_records`.`device`
`login_records`.`platform`
`login_records`.`mac_id`
`login_records`.`modifiedOn`
`message_templates`.*
`message_templates`.`id`
`message_templates`.`name`
`message_templates`.`email_template_for`
`message_templates`.`sectors_ids`
`message_templates`.`professions_ids`
`message_templates`.`email_subject`
`message_templates`.`content`
`message_templates`.`status`
`message_templates`.`deleted`
`message_templates`.`modifiedDate`
`message_templates`.`createdDate`
`message_templates`.`addedBy`
`message_templates`.`modifiedBy`
`modules`.*
`modules`.`id`
`modules`.`section`
`modules`.`name`
`modules`.`lang_names`
`modules`.`alias`
`modules`.`order_no`
`modules`.`is_url`
`modules`.`url`
`modules`.`parent_id`
`modules`.`description`
`modules`.`icon`
`modules`.`permissions`
`modules`.`is_public`
`modules`.`addedBy`
`modules`.`status`
`modules`.`deleted`
`modules`.`addedOn`
`modules`.`modifiedOn`
`modules`.`modifiedBy`
`nationalities`.*
`nationalities`.`id`
`nationalities`.`name`
`nationalities`.`status`
`nationalities`.`deleted`
`nationalities`.`addedOn`
`nationalities`.`addedBy`
`nationalities`.`modifiedBy`
`nationalities`.`modifiedOn`
`organisations`.*
`organisations`.`id`
`organisations`.`name`
`organisations`.`status`
`organisations`.`deleted`
`organisations`.`addedOn`
`organisations`.`addedBy`
`organisations`.`modifiedBy`
`organisations`.`modifiedOn`
`partners`.*
`partners`.`id`
`partners`.`type`
`partners`.`sub_type`
`partners`.`Name`
`partners`.`Street`
`partners`.`PLZ`
`partners`.`Town`
`partners`.`POBox`
`partners`.`Email`
`partners`.`Phone`
`partners`.`Fax`
`partners`.`status`
`partners`.`deleted`
`partners`.`addedOn`
`partners`.`addedBy`
`partners`.`modifiedBy`
`partners`.`modifiedOn`
`partners`.`bank_name`
`partners`.`bank_iban`
`partners`.`contacts`
`partners_contacts`.*
`partners_contacts`.`id`
`partners_contacts`.`PartnerID`
`partners_contacts`.`Gender`
`partners_contacts`.`Address`
`partners_contacts`.`Title`
`partners_contacts`.`Pos`
`partners_contacts`.`Name`
`partners_contacts`.`Surname`
`partners_contacts`.`Phone`
`partners_contacts`.`Mobile`
`partners_contacts`.`Fax`
`partners_contacts`.`Email`
`partners_contacts`.`Note`
`partners_contacts`.`status`
`partners_contacts`.`deleted`
`partners_contacts`.`addedOn`
`partners_contacts`.`addedBy`
`partners_contacts`.`modifiedBy`
`partners_contacts`.`modifiedOn`
`partners_sub_types`.*
`partners_sub_types`.`id`
`partners_sub_types`.`partners_type_id`
`partners_sub_types`.`name`
`partners_sub_types`.`status`
`partners_sub_types`.`deleted`
`partners_sub_types`.`addedOn`
`partners_sub_types`.`addedBy`
`partners_sub_types`.`modifiedBy`
`partners_sub_types`.`modifiedOn`
`partners_types`.*
`partners_types`.`id`
`partners_types`.`name`
`partners_types`.`status`
`partners_types`.`deleted`
`partners_types`.`addedOn`
`partners_types`.`addedBy`
`partners_types`.`modifiedBy`
`partners_types`.`modifiedOn`
`professions`.*
`professions`.`id`
`professions`.`organisation_id`
`professions`.`name`
`professions`.`status`
`professions`.`deleted`
`professions`.`addedOn`
`professions`.`addedBy`
`professions`.`modifiedBy`
`professions`.`modifiedOn`
`reasons`.*
`reasons`.`id`
`reasons`.`name`
`reasons`.`status`
`reasons`.`deleted`
`reasons`.`addedOn`
`reasons`.`addedBy`
`reasons`.`modifiedBy`
`reasons`.`modifiedOn`
`religions`.*
`religions`.`id`
`religions`.`name`
`religions`.`status`
`religions`.`deleted`
`religions`.`addedOn`
`religions`.`addedBy`
`religions`.`modifiedBy`
`religions`.`modifiedOn`
`responsible_persons`.*
`responsible_persons`.`id`
`responsible_persons`.`organisation_id`
`responsible_persons`.`employee_id`
`responsible_persons`.`Name`
`responsible_persons`.`Surname`
`responsible_persons`.`Gender`
`responsible_persons`.`Birth`
`responsible_persons`.`profession`
`responsible_persons`.`MobileNo_1`
`responsible_persons`.`IsWhatsapp_1`
`responsible_persons`.`IsComon_1`
`responsible_persons`.`MobileNo_2`
`responsible_persons`.`IsWhatsapp_2`
`responsible_persons`.`IsComon_2`
`responsible_persons`.`Email`
`responsible_persons`.`sector_ids`
`responsible_persons`.`preferred_communication`
`responsible_persons`.`status`
`responsible_persons`.`deleted`
`responsible_persons`.`addedOn`
`responsible_persons`.`addedBy`
`responsible_persons`.`modifiedBy`
`responsible_persons`.`modifiedOn`
`role_permissions`.*
`role_permissions`.`id`
`role_permissions`.`role_id`
`role_permissions`.`module_id`
`role_permissions`.`parent_module_id`
`role_permissions`.`section`
`role_permissions`.`permission_add`
`role_permissions`.`permission_edit`
`role_permissions`.`permission_view`
`role_permissions`.`permission_delete`
`role_permissions`.`permission_status`
`role_permissions`.`addedBy`
`role_permissions`.`addedOn`
`role_permissions`.`modifiedOn`
`roles`.*
`roles`.`id`
`roles`.`parent_id`
`roles`.`name`
`roles`.`description`
`roles`.`modifiedBy`
`roles`.`deleted`
`roles`.`addedBy`
`roles`.`addedOn`
`roles`.`modifiedOn`
`roles`.`status`
`salaries_history_allowances`.*
`salaries_history_allowances`.`ID`
`salaries_history_allowances`.`SalaryHistoryID`
`salaries_history_allowances`.`AllowanceID`
`salaries_history_allowances`.`AmountAllDays`
`salaries_history_allowances`.`AmountCalculateDays`
`salaries_history_allowances`.`Amount`
`salaries_history_allowances`.`NotPaidDays`
`salary_histories`.*
`salary_histories`.`id`
`salary_histories`.`YearMonth`
`salary_histories`.`EmplID`
`salary_histories`.`CalculationDate`
`salary_histories`.`WorkDays`
`salary_histories`.`WorkDaysInMonth`
`salary_histories`.`BasicSalary`
`salary_histories`.`BasicSalaryManual`
`salary_histories`.`Allowances`
`salary_histories`.`AllowancesManual`
`salary_histories`.`RegularBonus`
`salary_histories`.`IrregularBonus`
`salary_histories`.`IrregularBonusManual`
`salary_histories`.`PaidAdvance`
`salary_histories`.`RepaymentOfLoan`
`salary_histories`.`RepaymentOfLoanManual`
`salary_histories`.`IncomeTax`
`salary_histories`.`IncomeTaxManual`
`salary_histories`.`OtherTaxes`
`salary_histories`.`EmplSocialSecurity`
`salary_histories`.`EmplSocialSecurityPercent`
`salary_histories`.`CompSocialSecurity`
`salary_histories`.`CompSocialSecurityPercent`
`salary_histories`.`SocialSecurityTotal`
`salary_histories`.`EmplSocialSecurityGov`
`salary_histories`.`EmplSocialSecurityPercentGov`
`salary_histories`.`CompSocialSecurityGov`
`salary_histories`.`CompSocialSecurityPercentGov`
`salary_histories`.`SocialSecurityTotalGov`
`salary_histories`.`EmplSocialSecurityInj`
`salary_histories`.`EmplSocialSecurityPercentInj`
`salary_histories`.`CompSocialSecurityInj`
`salary_histories`.`CompSocialSecurityPercentInj`
`salary_histories`.`SocialSecurityTotalInj`
`salary_histories`.`InsurenceAmount`
`salary_histories`.`Brutto`
`salary_histories`.`Payment`
`salary_histories`.`Calculated`
`salary_histories`.`CountPaidDayForBasicSalary`
`salary_histories`.`NotPaidDaysForBasicSalary`
`salary_histories`.`SettlementDate`
`salary_histories`.`status`
`salary_histories`.`deleted`
`salary_histories`.`addedOn`
`salary_histories`.`addedBy`
`salary_histories`.`modifiedBy`
`salary_histories`.`modifiedOn`
`salary_histories`.`Extra`
`salary_histories`.`Minus`
`sectors`.*
`sectors`.`id`
`sectors`.`organisation_id`
`sectors`.`name`
`sectors`.`status`
`sectors`.`deleted`
`sectors`.`addedOn`
`sectors`.`addedBy`
`sectors`.`modifiedBy`
`sectors`.`modifiedOn`
`settings`.*
`settings`.`id`
`settings`.`name`
`settings`.`value`
`settings`.`language_id`
`settings`.`addedOn`
`settings`.`modifiedOn`
`supervisors`.*
`supervisors`.`id`
`supervisors`.`organisation_id`
`supervisors`.`employee_id`
`supervisors`.`Name`
`supervisors`.`Surname`
`supervisors`.`Gender`
`supervisors`.`Birth`
`supervisors`.`profession`
`supervisors`.`MobileNo_1`
`supervisors`.`IsWhatsapp_1`
`supervisors`.`IsComon_1`
`supervisors`.`MobileNo_2`
`supervisors`.`IsWhatsapp_2`
`supervisors`.`IsComon_2`
`supervisors`.`Email`
`supervisors`.`sector_ids`
`supervisors`.`preferred_communication`
`supervisors`.`status`
`supervisors`.`deleted`
`supervisors`.`addedOn`
`supervisors`.`addedBy`
`supervisors`.`modifiedBy`
`supervisors`.`modifiedOn`
`tasks`.*
`tasks`.`id`
`tasks`.`organisation_id`
`tasks`.`related_to`
`tasks`.`related_preferred_communication`
`tasks`.`parent_task_id`
`tasks`.`is_subtask`
`tasks`.`is_recurring`
`tasks`.`subtask_order`
`tasks`.`sector_id`
`tasks`.`responsible_person_id`
`tasks`.`responsible_preferred_communication`
`tasks`.`supervisor_id`
`tasks`.`supervisor_preferred_communication`
`tasks`.`title`
`tasks`.`short_description`
`tasks`.`long_description`
`tasks`.`from_date`
`tasks`.`till_date`
`tasks`.`subtask_offset`
`tasks`.`completion_time`
`tasks`.`file_name`
`tasks`.`status`
`tasks`.`task_status`
`tasks`.`is_informed`
`tasks`.`is_execut_informed`
`tasks`.`is_respon_informed`
`tasks`.`execut_informed_on`
`tasks`.`respon_informed_on`
`tasks`.`execut_informed_by`
`tasks`.`respon_informed_by`
`tasks`.`informed_on`
`tasks`.`informed_by`
`tasks`.`partially_completed_reason_id`
`tasks`.`partially_completed_notes`
`tasks`.`is_extended`
`tasks`.`original_task_id`
`tasks`.`extension_days`
`tasks`.`extension_date`
`tasks`.`deleted`
`tasks`.`addedOn`
`tasks`.`addedBy`
`tasks`.`modifiedBy`
`tasks`.`modifiedOn`
`tasks`.`is_communication_task`
`tasks`.`communication_type`
`tasks`.`communication_to`
`tasks`.`contact_info`
`tasks`.`original_communication_title`
`transfers`.*
`transfers`.`id`
`transfers`.`number`
`transfers`.`date`
`transfers`.`pay_from`
`transfers`.`pay_to`
`transfers`.`amount`
`transfers`.`info`
`transfers`.`document`
`transfers`.`status`
`transfers`.`deleted`
`transfers`.`addedOn`
`transfers`.`addedBy`
`transfers`.`modifiedBy`
`transfers`.`modifiedOn`
`tribes`.*
`tribes`.`id`
`tribes`.`name`
`tribes`.`checked`
`tribes`.`status`
`tribes`.`deleted`
`tribes`.`addedOn`
`tribes`.`addedBy`
`tribes`.`modifiedBy`
`tribes`.`modifiedOn`
`uploads`.*
`uploads`.`id`
`uploads`.`file_original_name`
`uploads`.`file_name`
`uploads`.`user_id`
`uploads`.`file_size`
`uploads`.`extension`
`uploads`.`type`
`uploads`.`created_at`
`uploads`.`updated_at`
`uploads`.`deleted_at`
`user_address_books`.*
`user_address_books`.`id`
`user_address_books`.`user_id`
`user_address_books`.`is_favourite`
`user_address_books`.`name`
`user_address_books`.`phone_no`
`user_address_books`.`address`
`user_address_books`.`area`
`user_address_books`.`lat`
`user_address_books`.`lng`
`user_address_books`.`address_type`
`user_address_books`.`is_gift`
`user_address_books`.`status`
`user_address_books`.`deleted`
`user_address_books`.`addedBy`
`user_address_books`.`modifiedBy`
`user_address_books`.`addedOn`
`user_address_books`.`modifiedOn`
`user_profiles`.*
`user_profiles`.`id`
`user_profiles`.`parent_id`
`user_profiles`.`user_id`
`user_profiles`.`full_name`
`user_profiles`.`fname`
`user_profiles`.`lname`
`user_profiles`.`email`
`user_profiles`.`phone_code`
`user_profiles`.`phone_no`
`user_profiles`.`profile_image`
`user_profiles`.`gender`
`user_profiles`.`dob`
`user_profiles`.`about`
`user_profiles`.`landmark`
`user_profiles`.`address`
`user_profiles`.`lat`
`user_profiles`.`lng`
`user_profiles`.`state_id`
`user_profiles`.`country_id`
`user_profiles`.`city_id`
`user_profiles`.`pincode`
`user_profiles`.`addedOn`
`user_profiles`.`modifiedOn`
`user_profiles`.`modifiedBy`
`user_schedules`.*
`user_schedules`.`id`
`user_schedules`.`user_id`
`user_schedules`.`day`
`user_schedules`.`day_name`
`user_schedules`.`time_from`
`user_schedules`.`time_to`
`user_schedules`.`type`
`user_schedules`.`modifiedOn`
`user_settings`.*
`user_settings`.`id`
`user_settings`.`user_id`
`user_settings`.`time_zone`
`user_settings`.`language_id`
`user_settings`.`multifactor_authenticate`
`user_settings`.`google_auth_code`
`user_settings`.`authenticate_using_otp`
`user_settings`.`otp_phone`
`user_settings`.`otp`
`user_settings`.`authenticate_using_google`
`user_settings`.`modifiedOn`
`user_settings`.`modifiedBy`
`users`.*
`users`.`id`
`users`.`parent_id`
`users`.`role_ids`
`users`.`login_id`
`users`.`password`
`users`.`is_online`
`users`.`is_verified`
`users`.`is_admin_verified`
`users`.`is_first_login`
`users`.`otp`
`users`.`device_type`
`users`.`ios_device_id`
`users`.`android_device_id`
`users`.`web_token`
`users`.`login_type`
`users`.`addedOn`
`users`.`modifiedOn`
`users`.`addedBy`
`users`.`modifiedBy`
`users`.`status`
`users`.`deleted`
`users`.`login_language`
`allowances`.*
`allowances`.`id`
`allowances`.`name`
`allowances`.`price`
`allowances`.`percentageOfBasicSalary`
`allowances`.`status`
`allowances`.`deleted`
`allowances`.`addedOn`
`allowances`.`addedBy`
`allowances`.`modifiedBy`
`allowances`.`modifiedOn`
`board_members`.*
`board_members`.`id`
`board_members`.`Name`
`board_members`.`Surname`
`board_members`.`Gender`
`board_members`.`Birth`
`board_members`.`Nationality`
`board_members`.`MobileNo_1`
`board_members`.`IsWhatsapp_1`
`board_members`.`IsComon_1`
`board_members`.`MobileNo_2`
`board_members`.`IsWhatsapp_2`
`board_members`.`IsComon_2`
`board_members`.`Email`
`board_members`.`ExecutivBoardPositionID`
`board_members`.`PositionSince`
`board_members`.`ImagePath`
`board_members`.`status`
`board_members`.`deleted`
`board_members`.`addedOn`
`board_members`.`addedBy`
`board_members`.`modifiedBy`
`board_members`.`modifiedOn`
`bonus_reg`.*
`bonus_reg`.`ID`
`bonus_reg`.`Valid`
`bonus_reg`.`Item1ID`
`bonus_reg`.`Item2ID`
`bonus_reg`.`Item3ID`
`bonus_reg`.`EmploymentMonths`
`calendar_items`.*
`calendar_items`.`id`
`calendar_items`.`item_type`
`calendar_items`.`item_id`
`ci_sessions`.*
`ci_sessions`.`id`
`ci_sessions`.`user_email`
`ci_sessions`.`ip_address`
`ci_sessions`.`user_agent`
`ci_sessions`.`timestamp`
`ci_sessions`.`data`
`ci_sessions`.`browser`
`ci_sessions`.`version`
`ci_sessions`.`device`
`ci_sessions`.`platform`
`company_details`.*
`company_details`.`id`
`company_details`.`name`
`company_details`.`value`
`company_details`.`language_id`
`company_details`.`addedOn`
`company_details`.`modifiedOn`
`contents`.*
`contents`.`id`
`contents`.`category_id`
`contents`.`title`
`contents`.`description`
`contents`.`image`
`contents`.`status`
`contents`.`order_no`
`contents`.`deleted`
`contents`.`slug`
`contents`.`meta_title`
`contents`.`meta_key`
`contents`.`meta_description`
`contents`.`addedBy`
`contents`.`addedOn`
`contents`.`modifiedOn`
`contents`.`modifiedBy`
`currencies`.*
`currencies`.`id`
`currencies`.`name`
`currencies`.`symbol`
`currencies`.`exchange_rate`
`currencies`.`code`
`currencies`.`exchange_rate_def`
`currencies`.`status`
`currencies`.`deleted`
`currencies`.`addedBy`
`currencies`.`modifiedBy`
`currencies`.`addedOn`
`currencies`.`modifiedOn`
`day_task_finished`.*
`day_task_finished`.`EmpTaskID`
`day_task_finished`.`Date`
`day_task_finished`.`Finished`
`email_templates`.*
`email_templates`.`id`
`email_templates`.`name`
`email_templates`.`email_template_key`
`email_templates`.`email_from`
`email_templates`.`email_subject`
`email_templates`.`content`
`email_templates`.`content_cn`
`email_templates`.`email_subject_cn`
`email_templates`.`variables`
`email_templates`.`sms_template`
`email_templates`.`sms_send_status`
`email_templates`.`status`
`email_templates`.`modifiedDate`
`email_templates`.`createdDate`
`email_templates`.`addedBy`
`email_templates`.`modifiedBy`
`employee_extras`.*
`employee_extras`.`id`
`employee_extras`.`id_image`
`employee_extras`.`signature_image`
`employee_extras`.`tin_number`
`employee_extras`.`employee_id`
`employee_extras`.`status`
`employee_extras`.`deleted`
`employee_extras`.`addedOn`
`employee_extras`.`addedBy`
`employee_extras`.`modifiedBy`
`employee_extras`.`modifiedOn`
`employee_miscellaneous`.*
`employee_miscellaneous`.`id`
`employee_miscellaneous`.`employeed_as`
`employee_miscellaneous`.`date_of_employment`
`employee_miscellaneous`.`date_of_termination`
`employee_miscellaneous`.`days_of_vocation`
`employee_miscellaneous`.`is_living_in_staffhouse`
`employee_miscellaneous`.`employee_id`
`employee_miscellaneous`.`status`
`employee_miscellaneous`.`deleted`
`employee_miscellaneous`.`addedOn`
`employee_miscellaneous`.`addedBy`
`employee_miscellaneous`.`modifiedBy`
`employee_miscellaneous`.`modifiedOn`
`employee_roles`.*
`employee_roles`.`id`
`employee_roles`.`organisation_id`
`employee_roles`.`name`
`employee_roles`.`status`
`employee_roles`.`deleted`
`employee_roles`.`addedOn`
`employee_roles`.`addedBy`
`employee_roles`.`modifiedBy`
`employee_roles`.`modifiedOn`
`employee_salaries`.*
`employee_salaries`.`id`
`employee_salaries`.`employee_id`
`employee_salaries`.`basic_salary`
`employee_salaries`.`allowances`
`employee_salaries`.`allowances_ids`
`employee_salaries`.`total_salary`
`employee_salaries`.`position`
`employee_salaries`.`bank_name`
`employee_salaries`.`bban`
`employee_salaries`.`bank_account_number`
`employee_salaries`.`status`
`employee_salaries`.`deleted`
`employee_salaries`.`addedOn`
`employee_salaries`.`addedBy`
`employee_salaries`.`modifiedBy`
`employee_salaries`.`modifiedOn`
`employee_send_messages`.*
`employee_send_messages`.`id`
`employee_send_messages`.`employee_id`
`employee_send_messages`.`message_template_id`
`employee_send_messages`.`subject`
`employee_send_messages`.`content`
`employee_send_messages`.`email`
`employee_send_messages`.`email_from`
`employee_send_messages`.`email_send_at`
`employee_send_messages`.`email_send_status`
`employee_send_messages`.`file_name`
`employee_send_messages`.`file`
`employee_send_messages`.`status`
`employee_send_messages`.`deleted`
`employee_send_messages`.`addedOn`
`employee_send_messages`.`addedBy`
`employee_send_messages`.`modifiedBy`
`employee_send_messages`.`modifiedOn`
`employees`.*
`employees`.`id`
`employees`.`organisation_id`
`employees`.`first_name`
`employees`.`sur_name`
`employees`.`gender`
`employees`.`date_of_birth`
`employees`.`nationality_id`
`employees`.`religion_id`
`employees`.`mobile_no_1`
`employees`.`is_whatsapp_mobile_1`
`employees`.`is_comon_mobile_1`
`employees`.`mobile_no_2`
`employees`.`is_whatsapp_mobile_2`
`employees`.`is_comon_mobile_2`
`employees`.`email`
`employees`.`city`
`employees`.`town`
`employees`.`street`
`employees`.`social_security_no`
`employees`.`tax_no`
`employees`.`profession_id`
`employees`.`sector_id`
`employees`.`can_read`
`employees`.`can_write`
`employees`.`is_lives_in_project_staff_house`
`employees`.`from_date`
`employees`.`to_date`
`employees`.`ResignType`
`employees`.`image`
`employees`.`signature_image`
`employees`.`status`
`employees`.`deleted`
`employees`.`addedOn`
`employees`.`addedBy`
`employees`.`modifiedBy`
`employees`.`modifiedOn`
`employees_emergency_contact_details`.*
`employees_emergency_contact_details`.`id`
`employees_emergency_contact_details`.`employee_id`
`employees_emergency_contact_details`.`person_name`
`employees_emergency_contact_details`.`contact_number`
`employees_emergency_contact_details`.`relation`
`employees_emergency_contact_details`.`status`
`employees_emergency_contact_details`.`deleted`
`employees_emergency_contact_details`.`addedOn`
`employees_emergency_contact_details`.`addedBy`
`employees_emergency_contact_details`.`modifiedBy`
`employees_emergency_contact_details`.`modifiedOn`
`employees_related_documents`.*
`employees_related_documents`.`id`
`employees_related_documents`.`EmployeeID`
`employees_related_documents`.`Name`
`employees_related_documents`.`Content`
`employees_related_documents`.`DocumentType`
`employees_related_documents`.`status`
`employees_related_documents`.`deleted`
`employees_related_documents`.`addedOn`
`employees_related_documents`.`addedBy`
`employees_related_documents`.`modifiedBy`
`employees_related_documents`.`modifiedOn`
`employment_types`.*
`employment_types`.`ID`
`employment_types`.`Name`
`employment_types`.`ShortName`
`employment_types`.`EmpltType`
`employment_types`.`Color`
`events`.*
`events`.`id`
`events`.`organisation_id`
`events`.`sector_id`
`events`.`related_to`
`events`.`responsible_person_id`
`events`.`supervisor_id`
`events`.`title`
`events`.`short_description`
`events`.`long_description`
`events`.`status`
`events`.`deleted`
`events`.`addedOn`
`events`.`addedBy`
`events`.`modifiedBy`
`events`.`modifiedOn`
`executing_persons`.*
`executing_persons`.`id`
`executing_persons`.`organisation_id`
`executing_persons`.`employee_id`
`executing_persons`.`Name`
`executing_persons`.`Surname`
`executing_persons`.`Gender`
`executing_persons`.`Birth`
`executing_persons`.`profession`
`executing_persons`.`MobileNo_1`
`executing_persons`.`IsWhatsapp_1`
`executing_persons`.`IsComon_1`
`executing_persons`.`MobileNo_2`
`executing_persons`.`IsWhatsapp_2`
`executing_persons`.`IsComon_2`
`executing_persons`.`Email`
`executing_persons`.`sector_ids`
`executing_persons`.`preferred_communication`
`executing_persons`.`status`
`executing_persons`.`deleted`
`executing_persons`.`addedOn`
`executing_persons`.`addedBy`
`executing_persons`.`modifiedBy`
`executing_persons`.`modifiedOn`
`folder_files`.*
`folder_files`.`id`
`folder_files`.`folder_id`
`folder_files`.`file_original_name`
`folder_files`.`file_name`
`folder_files`.`user_id`
`folder_files`.`file_size`
`folder_files`.`extension`
`folder_files`.`type`
`folder_files`.`created_at`
`folder_files`.`updated_at`
`folder_files`.`deleted_at`
`folder_files`.`deleted`
`folder_files`.`status`
`folders`.*
`folders`.`id`
`folders`.`parent_id`
`folders`.`name`
`folders`.`date`
`folders`.`status`
`folders`.`deleted`
`folders`.`addedOn`
`folders`.`addedBy`
`folders`.`modifiedBy`
`folders`.`modifiedOn`
`holidays`.*
`holidays`.`id`
`holidays`.`name`
`holidays`.`date`
`holidays`.`status`
`holidays`.`deleted`
`holidays`.`addedOn`
`holidays`.`addedBy`
`holidays`.`modifiedBy`
`holidays`.`modifiedOn`
`languages`.*
`languages`.`id`
`languages`.`name`
`languages`.`short_form`
`languages`.`language_code`
`languages`.`text_direction`
`languages`.`status`
`languages`.`deleted`
`languages`.`language_order`
`languages`.`text_editor_lang`
`languages`.`flag_path`
`last_user`.*
`last_user`.`ID`
`last_user`.`Name`
`last_user`.`Password`
`location_cities`.*
`location_cities`.`id`
`location_cities`.`name`
`location_cities`.`state_id`
`location_cities`.`state_code`
`location_cities`.`country_id`
`location_cities`.`country_code`
`location_cities`.`latitude`
`location_cities`.`longitude`
`location_cities`.`created_at`
`location_cities`.`updated_at`
`location_cities`.`flag`
`location_cities`.`wikiDataId`
`location_countries`.*
`location_countries`.`id`
`location_countries`.`name`
`location_countries`.`iso3`
`location_countries`.`iso2`
`location_countries`.`phonecode`
`location_countries`.`capital`
`location_countries`.`currency`
`location_countries`.`currency_symbol`
`location_countries`.`tld`
`location_countries`.`native`
`location_countries`.`region`
`location_countries`.`subregion`
`location_countries`.`timezones`
`location_countries`.`translations`
`location_countries`.`latitude`
`location_countries`.`longitude`
`location_countries`.`emoji`
`location_countries`.`emojiU`
`location_countries`.`created_at`
`location_countries`.`updated_at`
`location_countries`.`status`
`location_countries`.`wikiDataId`
`location_states`.*
`location_states`.`id`
`location_states`.`name`
`location_states`.`country_id`
`location_states`.`country_code`
`location_states`.`fips_code`
`location_states`.`iso2`
`location_states`.`latitude`
`location_states`.`longitude`
`location_states`.`created_at`
`location_states`.`updated_at`
`location_states`.`flag`
`location_states`.`wikiDataId`
`location_villages`.*
`location_villages`.`id`
`location_villages`.`name`
`location_villages`.`distance`
`location_villages`.`status`
`location_villages`.`deleted`
`location_villages`.`addedOn`
`location_villages`.`addedBy`
`location_villages`.`modifiedBy`
`location_villages`.`modifiedOn`
`login_attempts`.*
`login_attempts`.`id`
`login_attempts`.`ip_address`
`login_attempts`.`login`
`login_attempts`.`time`
`login_records`.*
`login_records`.`id`
`login_records`.`session_id`
`login_records`.`user_email`
`login_records`.`user_id`
`login_records`.`ip_address`
`login_records`.`user_agent`
`login_records`.`login_time`
`login_records`.`logout_time`
`login_records`.`browser`
`login_records`.`version`
`login_records`.`device`
`login_records`.`platform`
`login_records`.`mac_id`
`login_records`.`modifiedOn`
`message_templates`.*
`message_templates`.`id`
`message_templates`.`name`
`message_templates`.`email_template_for`
`message_templates`.`sectors_ids`
`message_templates`.`professions_ids`
`message_templates`.`email_subject`
`message_templates`.`content`
`message_templates`.`status`
`message_templates`.`deleted`
`message_templates`.`modifiedDate`
`message_templates`.`createdDate`
`message_templates`.`addedBy`
`message_templates`.`modifiedBy`
`modules`.*
`modules`.`id`
`modules`.`section`
`modules`.`name`
`modules`.`lang_names`
`modules`.`alias`
`modules`.`order_no`
`modules`.`is_url`
`modules`.`url`
`modules`.`parent_id`
`modules`.`description`
`modules`.`icon`
`modules`.`permissions`
`modules`.`is_public`
`modules`.`addedBy`
`modules`.`status`
`modules`.`deleted`
`modules`.`addedOn`
`modules`.`modifiedOn`
`modules`.`modifiedBy`
`nationalities`.*
`nationalities`.`id`
`nationalities`.`name`
`nationalities`.`status`
`nationalities`.`deleted`
`nationalities`.`addedOn`
`nationalities`.`addedBy`
`nationalities`.`modifiedBy`
`nationalities`.`modifiedOn`
`organisations`.*
`organisations`.`id`
`organisations`.`name`
`organisations`.`status`
`organisations`.`deleted`
`organisations`.`addedOn`
`organisations`.`addedBy`
`organisations`.`modifiedBy`
`organisations`.`modifiedOn`
`partners`.*
`partners`.`id`
`partners`.`type`
`partners`.`sub_type`
`partners`.`Name`
`partners`.`Street`
`partners`.`PLZ`
`partners`.`Town`
`partners`.`POBox`
`partners`.`Email`
`partners`.`Phone`
`partners`.`Fax`
`partners`.`status`
`partners`.`deleted`
`partners`.`addedOn`
`partners`.`addedBy`
`partners`.`modifiedBy`
`partners`.`modifiedOn`
`partners`.`bank_name`
`partners`.`bank_iban`
`partners`.`contacts`
`partners_contacts`.*
`partners_contacts`.`id`
`partners_contacts`.`PartnerID`
`partners_contacts`.`Gender`
`partners_contacts`.`Address`
`partners_contacts`.`Title`
`partners_contacts`.`Pos`
`partners_contacts`.`Name`
`partners_contacts`.`Surname`
`partners_contacts`.`Phone`
`partners_contacts`.`Mobile`
`partners_contacts`.`Fax`
`partners_contacts`.`Email`
`partners_contacts`.`Note`
`partners_contacts`.`status`
`partners_contacts`.`deleted`
`partners_contacts`.`addedOn`
`partners_contacts`.`addedBy`
`partners_contacts`.`modifiedBy`
`partners_contacts`.`modifiedOn`
`partners_sub_types`.*
`partners_sub_types`.`id`
`partners_sub_types`.`partners_type_id`
`partners_sub_types`.`name`
`partners_sub_types`.`status`
`partners_sub_types`.`deleted`
`partners_sub_types`.`addedOn`
`partners_sub_types`.`addedBy`
`partners_sub_types`.`modifiedBy`
`partners_sub_types`.`modifiedOn`
`partners_types`.*
`partners_types`.`id`
`partners_types`.`name`
`partners_types`.`status`
`partners_types`.`deleted`
`partners_types`.`addedOn`
`partners_types`.`addedBy`
`partners_types`.`modifiedBy`
`partners_types`.`modifiedOn`
`professions`.*
`professions`.`id`
`professions`.`organisation_id`
`professions`.`name`
`professions`.`status`
`professions`.`deleted`
`professions`.`addedOn`
`professions`.`addedBy`
`professions`.`modifiedBy`
`professions`.`modifiedOn`
`reasons`.*
`reasons`.`id`
`reasons`.`name`
`reasons`.`status`
`reasons`.`deleted`
`reasons`.`addedOn`
`reasons`.`addedBy`
`reasons`.`modifiedBy`
`reasons`.`modifiedOn`
`religions`.*
`religions`.`id`
`religions`.`name`
`religions`.`status`
`religions`.`deleted`
`religions`.`addedOn`
`religions`.`addedBy`
`religions`.`modifiedBy`
`religions`.`modifiedOn`
`responsible_persons`.*
`responsible_persons`.`id`
`responsible_persons`.`organisation_id`
`responsible_persons`.`employee_id`
`responsible_persons`.`Name`
`responsible_persons`.`Surname`
`responsible_persons`.`Gender`
`responsible_persons`.`Birth`
`responsible_persons`.`profession`
`responsible_persons`.`MobileNo_1`
`responsible_persons`.`IsWhatsapp_1`
`responsible_persons`.`IsComon_1`
`responsible_persons`.`MobileNo_2`
`responsible_persons`.`IsWhatsapp_2`
`responsible_persons`.`IsComon_2`
`responsible_persons`.`Email`
`responsible_persons`.`sector_ids`
`responsible_persons`.`preferred_communication`
`responsible_persons`.`status`
`responsible_persons`.`deleted`
`responsible_persons`.`addedOn`
`responsible_persons`.`addedBy`
`responsible_persons`.`modifiedBy`
`responsible_persons`.`modifiedOn`
`role_permissions`.*
`role_permissions`.`id`
`role_permissions`.`role_id`
`role_permissions`.`module_id`
`role_permissions`.`parent_module_id`
`role_permissions`.`section`
`role_permissions`.`permission_add`
`role_permissions`.`permission_edit`
`role_permissions`.`permission_view`
`role_permissions`.`permission_delete`
`role_permissions`.`permission_status`
`role_permissions`.`addedBy`
`role_permissions`.`addedOn`
`role_permissions`.`modifiedOn`
`roles`.*
`roles`.`id`
`roles`.`parent_id`
`roles`.`name`
`roles`.`description`
`roles`.`modifiedBy`
`roles`.`deleted`
`roles`.`addedBy`
`roles`.`addedOn`
`roles`.`modifiedOn`
`roles`.`status`
`salaries_history_allowances`.*
`salaries_history_allowances`.`ID`
`salaries_history_allowances`.`SalaryHistoryID`
`salaries_history_allowances`.`AllowanceID`
`salaries_history_allowances`.`AmountAllDays`
`salaries_history_allowances`.`AmountCalculateDays`
`salaries_history_allowances`.`Amount`
`salaries_history_allowances`.`NotPaidDays`
`salary_histories`.*
`salary_histories`.`id`
`salary_histories`.`YearMonth`
`salary_histories`.`EmplID`
`salary_histories`.`CalculationDate`
`salary_histories`.`WorkDays`
`salary_histories`.`WorkDaysInMonth`
`salary_histories`.`BasicSalary`
`salary_histories`.`BasicSalaryManual`
`salary_histories`.`Allowances`
`salary_histories`.`AllowancesManual`
`salary_histories`.`RegularBonus`
`salary_histories`.`IrregularBonus`
`salary_histories`.`IrregularBonusManual`
`salary_histories`.`PaidAdvance`
`salary_histories`.`RepaymentOfLoan`
`salary_histories`.`RepaymentOfLoanManual`
`salary_histories`.`IncomeTax`
`salary_histories`.`IncomeTaxManual`
`salary_histories`.`OtherTaxes`
`salary_histories`.`EmplSocialSecurity`
`salary_histories`.`EmplSocialSecurityPercent`
`salary_histories`.`CompSocialSecurity`
`salary_histories`.`CompSocialSecurityPercent`
`salary_histories`.`SocialSecurityTotal`
`salary_histories`.`EmplSocialSecurityGov`
`salary_histories`.`EmplSocialSecurityPercentGov`
`salary_histories`.`CompSocialSecurityGov`
`salary_histories`.`CompSocialSecurityPercentGov`
`salary_histories`.`SocialSecurityTotalGov`
`salary_histories`.`EmplSocialSecurityInj`
`salary_histories`.`EmplSocialSecurityPercentInj`
`salary_histories`.`CompSocialSecurityInj`
`salary_histories`.`CompSocialSecurityPercentInj`
`salary_histories`.`SocialSecurityTotalInj`
`salary_histories`.`InsurenceAmount`
`salary_histories`.`Brutto`
`salary_histories`.`Payment`
`salary_histories`.`Calculated`
`salary_histories`.`CountPaidDayForBasicSalary`
`salary_histories`.`NotPaidDaysForBasicSalary`
`salary_histories`.`SettlementDate`
`salary_histories`.`status`
`salary_histories`.`deleted`
`salary_histories`.`addedOn`
`salary_histories`.`addedBy`
`salary_histories`.`modifiedBy`
`salary_histories`.`modifiedOn`
`salary_histories`.`Extra`
`salary_histories`.`Minus`
`sectors`.*
`sectors`.`id`
`sectors`.`organisation_id`
`sectors`.`name`
`sectors`.`status`
`sectors`.`deleted`
`sectors`.`addedOn`
`sectors`.`addedBy`
`sectors`.`modifiedBy`
`sectors`.`modifiedOn`
`settings`.*
`settings`.`id`
`settings`.`name`
`settings`.`value`
`settings`.`language_id`
`settings`.`addedOn`
`settings`.`modifiedOn`
`supervisors`.*
`supervisors`.`id`
`supervisors`.`organisation_id`
`supervisors`.`employee_id`
`supervisors`.`Name`
`supervisors`.`Surname`
`supervisors`.`Gender`
`supervisors`.`Birth`
`supervisors`.`profession`
`supervisors`.`MobileNo_1`
`supervisors`.`IsWhatsapp_1`
`supervisors`.`IsComon_1`
`supervisors`.`MobileNo_2`
`supervisors`.`IsWhatsapp_2`
`supervisors`.`IsComon_2`
`supervisors`.`Email`
`supervisors`.`sector_ids`
`supervisors`.`preferred_communication`
`supervisors`.`status`
`supervisors`.`deleted`
`supervisors`.`addedOn`
`supervisors`.`addedBy`
`supervisors`.`modifiedBy`
`supervisors`.`modifiedOn`
`tasks`.*
`tasks`.`id`
`tasks`.`organisation_id`
`tasks`.`related_to`
`tasks`.`related_preferred_communication`
`tasks`.`parent_task_id`
`tasks`.`is_subtask`
`tasks`.`is_recurring`
`tasks`.`subtask_order`
`tasks`.`sector_id`
`tasks`.`responsible_person_id`
`tasks`.`responsible_preferred_communication`
`tasks`.`supervisor_id`
`tasks`.`supervisor_preferred_communication`
`tasks`.`title`
`tasks`.`short_description`
`tasks`.`long_description`
`tasks`.`from_date`
`tasks`.`till_date`
`tasks`.`subtask_offset`
`tasks`.`completion_time`
`tasks`.`file_name`
`tasks`.`status`
`tasks`.`task_status`
`tasks`.`is_informed`
`tasks`.`is_execut_informed`
`tasks`.`is_respon_informed`
`tasks`.`execut_informed_on`
`tasks`.`respon_informed_on`
`tasks`.`execut_informed_by`
`tasks`.`respon_informed_by`
`tasks`.`informed_on`
`tasks`.`informed_by`
`tasks`.`partially_completed_reason_id`
`tasks`.`partially_completed_notes`
`tasks`.`is_extended`
`tasks`.`original_task_id`
`tasks`.`extension_days`
`tasks`.`extension_date`
`tasks`.`deleted`
`tasks`.`addedOn`
`tasks`.`addedBy`
`tasks`.`modifiedBy`
`tasks`.`modifiedOn`
`tasks`.`is_communication_task`
`tasks`.`communication_type`
`tasks`.`communication_to`
`tasks`.`contact_info`
`tasks`.`original_communication_title`
`transfers`.*
`transfers`.`id`
`transfers`.`number`
`transfers`.`date`
`transfers`.`pay_from`
`transfers`.`pay_to`
`transfers`.`amount`
`transfers`.`info`
`transfers`.`document`
`transfers`.`status`
`transfers`.`deleted`
`transfers`.`addedOn`
`transfers`.`addedBy`
`transfers`.`modifiedBy`
`transfers`.`modifiedOn`
`tribes`.*
`tribes`.`id`
`tribes`.`name`
`tribes`.`checked`
`tribes`.`status`
`tribes`.`deleted`
`tribes`.`addedOn`
`tribes`.`addedBy`
`tribes`.`modifiedBy`
`tribes`.`modifiedOn`
`uploads`.*
`uploads`.`id`
`uploads`.`file_original_name`
`uploads`.`file_name`
`uploads`.`user_id`
`uploads`.`file_size`
`uploads`.`extension`
`uploads`.`type`
`uploads`.`created_at`
`uploads`.`updated_at`
`uploads`.`deleted_at`
`user_address_books`.*
`user_address_books`.`id`
`user_address_books`.`user_id`
`user_address_books`.`is_favourite`
`user_address_books`.`name`
`user_address_books`.`phone_no`
`user_address_books`.`address`
`user_address_books`.`area`
`user_address_books`.`lat`
`user_address_books`.`lng`
`user_address_books`.`address_type`
`user_address_books`.`is_gift`
`user_address_books`.`status`
`user_address_books`.`deleted`
`user_address_books`.`addedBy`
`user_address_books`.`modifiedBy`
`user_address_books`.`addedOn`
`user_address_books`.`modifiedOn`
`user_profiles`.*
`user_profiles`.`id`
`user_profiles`.`parent_id`
`user_profiles`.`user_id`
`user_profiles`.`full_name`
`user_profiles`.`fname`
`user_profiles`.`lname`
`user_profiles`.`email`
`user_profiles`.`phone_code`
`user_profiles`.`phone_no`
`user_profiles`.`profile_image`
`user_profiles`.`gender`
`user_profiles`.`dob`
`user_profiles`.`about`
`user_profiles`.`landmark`
`user_profiles`.`address`
`user_profiles`.`lat`
`user_profiles`.`lng`
`user_profiles`.`state_id`
`user_profiles`.`country_id`
`user_profiles`.`city_id`
`user_profiles`.`pincode`
`user_profiles`.`addedOn`
`user_profiles`.`modifiedOn`
`user_profiles`.`modifiedBy`
`user_schedules`.*
`user_schedules`.`id`
`user_schedules`.`user_id`
`user_schedules`.`day`
`user_schedules`.`day_name`
`user_schedules`.`time_from`
`user_schedules`.`time_to`
`user_schedules`.`type`
`user_schedules`.`modifiedOn`
`user_settings`.*
`user_settings`.`id`
`user_settings`.`user_id`
`user_settings`.`time_zone`
`user_settings`.`language_id`
`user_settings`.`multifactor_authenticate`
`user_settings`.`google_auth_code`
`user_settings`.`authenticate_using_otp`
`user_settings`.`otp_phone`
`user_settings`.`otp`
`user_settings`.`authenticate_using_google`
`user_settings`.`modifiedOn`
`user_settings`.`modifiedBy`
`users`.*
`users`.`id`
`users`.`parent_id`
`users`.`role_ids`
`users`.`login_id`
`users`.`password`
`users`.`is_online`
`users`.`is_verified`
`users`.`is_admin_verified`
`users`.`is_first_login`
`users`.`otp`
`users`.`device_type`
`users`.`ios_device_id`
`users`.`android_device_id`
`users`.`web_token`
`users`.`login_type`
`users`.`addedOn`
`users`.`modifiedOn`
`users`.`addedBy`
`users`.`modifiedBy`
`users`.`status`
`users`.`deleted`
`users`.`login_language`
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
allowances
board_members
bonus_reg
calendar_items
ci_sessions
company_details
contents
currencies
day_task_finished
email_templates
employee_extras
employee_miscellaneous
employee_roles
employee_salaries
employee_send_messages
employees
employees_emergency_contact_details
employees_related_documents
employment_types
events
executing_persons
folder_files
folders
holidays
languages
last_user
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
message_templates
modules
nationalities
organisations
partners
partners_contacts
partners_sub_types
partners_types
professions
reasons
religions
responsible_persons
role_permissions
roles
salaries_history_allowances
salary_histories
sectors
settings
supervisors
tasks
transfers
tribes
uploads
user_address_books
user_profiles
user_schedules
user_settings
users
SQL query on database
task_manager
: