* ID CreateDT Path DBName UserName IsSentMessage

* ID Name ShortName EmpltType Color

* ID Name Password

* ID Name DataType

* ID MaskID Name Code Pos

* ID TopicID Name

* ID GroupID Name Description FileName

* ID Name

* ID Name Price IsRemove PercentageOfBasicSalary

* ID AdditionalWorkID DT GivenAlways NotGivenWhenIll NotGivenWhenVacation OnlyGivenOnVacation NotTaxed DoubleShift

* ID Name Surname Sex Birth Nationality Contact1 Contact2 WhatsAppNo Email ExecutivBoardPositionID PositionSince PhotoID IsRemoved

* ID Valid Item1ID Item2ID Item3ID EmploymentMonths

* ID ItemType Valid PerCent NumTimes OtherFreq FreqID

* BonusRegItemFreqSetID YearMonth

* ID YearsDiffer

* ID Date AccepterID MessengerID MessengerOther MessageType LetterDocID WorkerNotificationDocID GuiltyWorkerID Info ReactionOfManagement IsCompleted

* ID Name Content

* ID Name FolderID UserID Date FileID ArchiveID IsArchive Stamp

* ID FileID Name Info Pictures

* ID FileDocItemID FileName PictureID

* ID Name ParentID

* ID Name Daily Monday Tuesday Wednesday Thursday Friday Saturday Sunday EveryWeek EverySecondWeek EveryThirdWeek EveryFourthWeek SecondWeekStart ThirdWeekStart FourthWeekStart EveryNumOfMonth DutyDoneByEvery ExplanationGeneral ExplanationAdvice ResponsibilityID EveryNumOfFollowingMonth January February March April May June July August September October November December IfNecessary

* ID Name Surname Sex Birth Nationality Religion SectorID Mobile Contact1 Contact2 Profession Employed DtEmployment DtResignation ResignType NumVocationDays StaffHouse StaffHouseMembers IsFatherAlive IsMotherAlive PhotoID SignatureID NetAllowances TransportAllowances SocSecNumber SocSecGovNumber TinNumber Town Street POBox PLZ IsNotEmployee BankName BankID BankAccount IsLivesInProject WhatsAppNo CanReadOrWrite

* ID EmployeeID Type DefBonusReg Percent TimesYear Amount Period Bonus1ID Bonus2ID Bonus3ID

* EmployeeID YearMonth

* ID Name Content

* ID EmployeeID DocumentID UserID

* ID EmployeeID EmployeeDocumentTemplateID ScanDocumentID ScanNecessaryID

* ID Name AppliesAllEmployees OnlyAppliesSector SectorID OnlyForProfession Professions AppliesIndividually UseTemplateFile TemplateFileID SignatureScanDocument SignatureScanNecessary

* ID EmployeeID DutyID Info NoOfPerson Deputy Supervisor DateFrom DateTill Cost

* ID EmplDutyID DateStop DateRestore Type

* ID EmployeeID Year Month D1 D2 D3 D4 D5 D6 D7 D8 D9 D10 D11 D12 D13 D14 D15 D16 D17 D18 D19 D20 D21 D22 D23 D24 D25 D26 D27 D28 D29 D30 D31

* ID EmployeeID DT Name Surname Position BasicSalary Allowances

* ID AdditionalWorkID EmployeeLifeChangesID

* ID EmployeeID DtFrom DtTill

* ID EmployeeID DocumentID UserID DocumentType

* ID EmployeeID Name Died Relation

* ID RequiredFields

* ID EmployeeID Schedule TimeFrom TimeTo RedMissedDays PayDuties IncomeTax DtStopCalcSocSecurity

* ID ChangeDate EmployeeID YearMonth EndYearMonth BasicSalary Allowances

* ID SectorID SupervisorID EmployeeID DateFrom DateTill TimeFrom TimeTill TaskID AdditionalInfo TaskPeriodID TaskEventID RelatedToID

* ID Daily Monday Tuesday Wednesday Thursday Friday Saturday Sunday EveryWeek EverySecondWeek EveryThirdWeek EveryFourthWeek SecondWeekStart ThirdWeekStart FourthWeekStart EveryNumOfMonth EveryNumOfFollowingMonth January February March April May June July August September October November December WithoutWeekend WithoutPublicHolidays

* ID EmployeeID Name Cost

* ID EmplSalaryID TaxID Name Cost Amount

* ID EmployeeID YearMonth IsDefined HoursPerWeek

* ID PlanID Schedule TimeFrom TimeTo WeekIndex

* ID EmployeeTaskID EventID Info

* ID EmpTaskID EmployeeID PartnerID

* ID Name Content

* ID EmployeeTaskID EmployeeTaskDocumentID UserID

* ID Name DayDelta

* ID EventID Date Info

* ID Name

* ID Name Street PLZ Town POBox Country Email Phone Mobile Fax Homepage TinNumber

* ID SubjectID Type

* ID GroupID OperDateTime AccountFromID AccountToID Amount UserID Type Info

* ID GroupID OperDateTime AccountFromID AccountToID Amount UserID Type

* ID Name HolidayDate

* ID YearMonth SSecurCompPercent SSecurEmplPercent SSecurMaxAge SSecurForAgeMoreThan SSecurForBasicSalary SSecurForAllowances SSecurForTransportAllowances SSecurForRegularBonus SSecurForIrregularBonus SSecurForDutiesPayment SSecurCompHasAccount SSecurLoansFromFond SSecurBookingMonthlyAuto

* FromInt ToInt Amount OwnerID

* ID YearMonth SSecurCompPercent SSecurEmplPercent SSecurMaxAge SSecurForAgeMoreThan SSecurMinAmountValue SSecurMinValue SSecurMaxValue SSecurForBasicSalary SSecurForAllowances SSecurForTransportAllowances SSecurForRegularBonus SSecurForIrregularBonus SSecurForDutiesPayment SSecurCompHasAccount SSecurLoansFromFond SSecurBookingMonthlyAuto

* ID WorkerID InsuranceID Anrede Mobile2 Email1 Email2 IsDeleted StartMonth EndMonth Amount

* ID Name Type Adress Phone Mobile Fax Email Homepage IsDeleted

* ID Name SortingIndex Letter

* ID Name Content

* ID Name FolderID UserID Date FileID ArchiveID IsArchive Stamp

* ID Name ParentID

* ID EmployeeID LoanDate Amount Duration Finished OperationID

* ID LoanID YearMonth Amount OperationID SalaryCalcID

* ID LoanID YearMonth Amount OperationID SalaryCalcID

* ID Name

* ID Name Info

* ID Type Name Street PLZ Town POBox Email Phone Fax IsRemoved

* ID PartnerID Sex Name Surname Phone Mobile Fax Email Note Address Title Pos

* ID Date AccepterID MessengerID MessengerOther MessageType LetterDocID GoodWorkerID Info ReactionOfManagement IsCompleted

* ID Name SectorID

* ID YearMonth EmplID CalculationDate WorkDays WorkDaysInMonth BasicSalary BasicSalaryManual Allowances AllowancesManual RegularBonus IrregularBonus IrregularBonusManual PaidAdvance RepaymentOfLoan RepaymentOfLoanManual IncomeTax IncomeTaxManual OtherTaxes EmplSocialSecurity EmplSocialSecurityPercent CompSocialSecurity CompSocialSecurityPercent SocialSecurityTotal EmplSocialSecurityGov EmplSocialSecurityPercentGov CompSocialSecurityGov CompSocialSecurityPercentGov SocialSecurityTotalGov EmplSocialSecurityInj EmplSocialSecurityPercentInj CompSocialSecurityInj CompSocialSecurityPercentInj SocialSecurityTotalInj InsurenceAmount Brutto Payment Calculated CountPaidDayForBasicSalary NotPaidDaysForBasicSalary SettlementDate

* ID SalaryHistoryID AllowanceID AmountAllDays AmountCalculateDays Amount NotPaidDays

* ID SalaryHistoryID DutyID DateFrom DateTill Amount

* ID YearMonth SettlementDate

* ID SSecurCompPercent SSecurEmplPercent SSecurForBasicSalary SSecurForAllowances SSecurForTransportAllowances SSecurForRegularBonus SSecurForIrregularBonus SSecurForDutiesPayment SSecurCompHasAccount SSecurLoansFromFond SSecurBookingMonthlyAuto LoanEmplCanGetAfter LoanReturnPeriod LoanNewAfterReturnOld LoanLessSSFund LoanLessSalaryForMonths LoanRegularBonus LoanIrregularBonus InTaxForBasicSalary InTaxForAllowances InTaxForTransportAllowances InTaxForDutiesPayment InTaxPercentage DefBonus1ID DefBonus2ID DefBonus3ID ActivePart

* ID Name

* ID YearMonth SSecurCompPercent SSecurEmplPercent SSecurForBasicSalary SSecurForAllowances SSecurForTransportAllowances SSecurForRegularBonus SSecurForIrregularBonus SSecurForDutiesPayment SSecurCompHasAccount SSecurLoansFromFond SSecurBookingMonthlyAuto SSecurForAgeMoreThan SSecurMaxAge

* ID YearMonth SSecurCompPercent SSecurEmplPercent SSecurMaxAge SSecurForAgeMoreThan SSecurForBasicSalary SSecurForAllowances SSecurForTransportAllowances SSecurForRegularBonus SSecurForIrregularBonus SSecurForDutiesPayment SSecurCompHasAccount SSecurLoansFromFond SSecurBookingMonthlyAuto

* ID Name

* ID EmpTaskID EmployeeID Date Done NotNeeded ChangingDate DoneDateFrom DoneDateTill DoneTimeFrom DoneTimeTill Remark

* ID GroupID OperDateTime AccountFromID AccountToID Amount UserID Type Info

* AccountID SumFrom

* AccountID SumTo

* ID Name

* ID SectorID Task Mondays Tuesdays Wednesdays Thursdays Fridays Saturdays Sundays AllPublicHolidays NoChangeOnHolidays

* ID TimeFrom TimeTill Hours NoRegularWorkingTime WorkersAmount Additional

* ID Date EmplID TaskItemID Hours

* ID Name Password

* ID Name

* ID GroupID WorkerID Pos

* Date WorkerID EmpltTmplID

select table backup_logs employment_types last_user pe_groups pe_keywords pe_masks pe_objects pe_topics pm_additional_work pm_additional_work_salary_settings pm_board_member pm_bonus_reg pm_bonus_reg_items pm_bonus_reg_item_freqs pm_bonus_reg_item_freq_set pm_complaints pm_da_documents pm_da_files pm_da_files_items pm_da_files_items_pictures pm_da_folders pm_duties pm_employees pm_employees_bonus pm_employees_bonus_period pm_employees_documents pm_employees_document_contract pm_employees_document_item pm_employees_document_template pm_employees_duty_cost pm_employees_duty_cost_periods pm_employees_employments pm_employees_life_changes pm_employees_life_changes_detailed pm_employees_lives_in_project_periods pm_employees_related_documents pm_employees_relatives pm_employees_required_fields pm_employees_salary pm_employees_salary_brutto pm_employees_tasks pm_employees_tasks_period pm_employees_tax pm_employees_tax_period pm_employees_working_plan pm_employees_working_plan_weeks pm_employee_tasks_events pm_employee_task_contacts pm_employee_task_documents pm_employee_task_related_documents pm_events pm_event_dates pm_executiv_board_positions pm_firm_info pm_fn_accounts pm_fn_operations pm_fn_operations_copy pm_holidays pm_income_tax_properties pm_income_tax_rate pm_injury_properties pm_insurance_workers pm_insurence pm_letter_designations pm_ll_documents pm_ll_files pm_ll_folders pm_loans pm_loans_repayments pm_loans_repayments_cache pm_messengers pm_organizations pm_partners pm_partners_contacts pm_positive_feedback pm_responsibilities pm_salaries_history pm_salaries_history_allowances pm_salaries_history_duties pm_salaries_settlement_dates pm_salary_properties pm_sectors pm_soc_sec_gov_properties pm_soc_sec_properties pm_tasks pm_task_groups pm_tmp_fn_operations pm_tmp_rest_from pm_tmp_rest_to pm_tm_related_to sc_sector_tasks sc_sector_task_item sc_worker_assigned_tasks users worker_groups worker_group_members worker_schedule . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table backup_logs employment_types last_user pe_groups pe_keywords pe_masks pe_objects pe_topics pm_additional_work pm_additional_work_salary_settings pm_board_member pm_bonus_reg pm_bonus_reg_items pm_bonus_reg_item_freqs pm_bonus_reg_item_freq_set pm_complaints pm_da_documents pm_da_files pm_da_files_items pm_da_files_items_pictures pm_da_folders pm_duties pm_employees pm_employees_bonus pm_employees_bonus_period pm_employees_documents pm_employees_document_contract pm_employees_document_item pm_employees_document_template pm_employees_duty_cost pm_employees_duty_cost_periods pm_employees_employments pm_employees_life_changes pm_employees_life_changes_detailed pm_employees_lives_in_project_periods pm_employees_related_documents pm_employees_relatives pm_employees_required_fields pm_employees_salary pm_employees_salary_brutto pm_employees_tasks pm_employees_tasks_period pm_employees_tax pm_employees_tax_period pm_employees_working_plan pm_employees_working_plan_weeks pm_employee_tasks_events pm_employee_task_contacts pm_employee_task_documents pm_employee_task_related_documents pm_events pm_event_dates pm_executiv_board_positions pm_firm_info pm_fn_accounts pm_fn_operations pm_fn_operations_copy pm_holidays pm_income_tax_properties pm_income_tax_rate pm_injury_properties pm_insurance_workers pm_insurence pm_letter_designations pm_ll_documents pm_ll_files pm_ll_folders pm_loans pm_loans_repayments pm_loans_repayments_cache pm_messengers pm_organizations pm_partners pm_partners_contacts pm_positive_feedback pm_responsibilities pm_salaries_history pm_salaries_history_allowances pm_salaries_history_duties pm_salaries_settlement_dates pm_salary_properties pm_sectors pm_soc_sec_gov_properties pm_soc_sec_properties pm_tasks pm_task_groups pm_tmp_fn_operations pm_tmp_rest_from pm_tmp_rest_to pm_tm_related_to sc_sector_tasks sc_sector_task_item sc_worker_assigned_tasks users worker_groups worker_group_members worker_schedule .	select column