gambia.feste-ip.net / 127.0.0.1 / axiuss40_africa_personal_program_bk

There are no favorite tables.

New
axiuss40_africa
information_schema
mysql
performance_schema
task_manager
- task_manager
- task_manager_staging
test

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`).
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.

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 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 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 display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

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 :

Untitled *

v		axiuss40_africa_personal_program_bk backup_logs
ID : int(8) unsigned
CreateDT : datetime
Path : varchar(255)
DBName : varchar(150)
UserName : varchar(150)
IsSentMessage : tinyint(1) unsigned

v		axiuss40_africa_personal_program_bk employment_types
ID : int(8) unsigned
Name : char(20)
ShortName : char(8)
EmpltType : int(8) unsigned
Color : int(8) unsigned

v		axiuss40_africa_personal_program_bk last_user
ID : int(8) unsigned
Name : varchar(40)
Password : varchar(100)

v		axiuss40_africa_personal_program_bk pe_groups
ID : int(8) unsigned
Name : varchar(20)
DataType : varchar(40)

v		axiuss40_africa_personal_program_bk pe_keywords
ID : int(8) unsigned
MaskID : int(8) unsigned
Name : varchar(40)
Code : varchar(60)
Pos : int(8) unsigned

v		axiuss40_africa_personal_program_bk pe_masks
ID : int(8) unsigned
TopicID : int(8) unsigned
Name : varchar(40)

v		axiuss40_africa_personal_program_bk pe_objects
ID : int(8) unsigned
GroupID : int(8) unsigned
Name : varchar(255)
Description : varchar(255)
FileName : varchar(255)

v		axiuss40_africa_personal_program_bk pe_topics
ID : int(8) unsigned
Name : varchar(40)

v		axiuss40_africa_personal_program_bk pm_additional_work
ID : int(8) unsigned
Name : varchar(255)
Price : decimal(10,2)
IsRemove : tinyint(1) unsigned
PercentageOfBasicSalary : decimal(10,2)

v		axiuss40_africa_personal_program_bk pm_additional_work_salary_settings
ID : int(10) unsigned
AdditionalWorkID : int(11)
DT : date
GivenAlways : enum('Ja','Nein')
NotGivenWhenIll : enum('Ja','Nein')
NotGivenWhenVacation : enum('Ja','Nein')
OnlyGivenOnVacation : enum('Ja','Nein')
NotTaxed : enum('Ja','Nein')
DoubleShift : enum('Ja','Nein')

v		axiuss40_africa_personal_program_bk pm_board_member
ID : int(8) unsigned
Name : varchar(55)
Surname : varchar(55)
Sex : enum('empty','man','woman')
Birth : date
Nationality : varchar(40)
Contact1 : varchar(40)
Contact2 : varchar(40)
WhatsAppNo : varchar(55)
Email : varchar(55)
ExecutivBoardPositionID : int(8)
PositionSince : date
PhotoID : int(8)
IsRemoved : varchar(5)

v		axiuss40_africa_personal_program_bk pm_bonus_reg
ID : int(8) unsigned
Valid : enum('Ja','Nein')
Item1ID : int(8)
Item2ID : int(8)
Item3ID : int(8)
EmploymentMonths : int(8)

v		axiuss40_africa_personal_program_bk pm_bonus_reg_items
ID : int(8) unsigned
ItemType : enum('empty','salary','allowance','duty')
Valid : enum('Ja','Nein')
PerCent : double
NumTimes : tinyint(3) unsigned
OtherFreq : enum('Ja','Nein')
FreqID : int(8)

v		axiuss40_africa_personal_program_bk pm_bonus_reg_item_freqs
BonusRegItemFreqSetID : int(8) unsigned
YearMonth : int(8) unsigned

v		axiuss40_africa_personal_program_bk pm_bonus_reg_item_freq_set
ID : int(8) unsigned
YearsDiffer : enum('Ja','Nein')

v		axiuss40_africa_personal_program_bk pm_complaints
ID : int(8) unsigned
Date : date
AccepterID : int(8)
MessengerID : int(8)
MessengerOther : varchar(70)
MessageType : enum('Verbal','Phone','Letter')
LetterDocID : int(8)
WorkerNotificationDocID : int(8)
GuiltyWorkerID : int(8)
Info : text
ReactionOfManagement : text
IsCompleted : tinyint(1) unsigned

v		axiuss40_africa_personal_program_bk pm_da_documents
ID : int(8) unsigned
Name : varchar(255)
Content : longblob

v		axiuss40_africa_personal_program_bk pm_da_files
ID : int(8) unsigned
Name : varchar(40)
FolderID : int(8) unsigned
UserID : int(8) unsigned
Date : date
FileID : int(8)
ArchiveID : int(8)
IsArchive : enum('Ja','Nein')
Stamp : timestamp

v		axiuss40_africa_personal_program_bk pm_da_files_items
ID : int(8) unsigned
FileID : int(8) unsigned
Name : varchar(100)
Info : varchar(255)
Pictures : enum('Ja','Nein')

v		axiuss40_africa_personal_program_bk pm_da_files_items_pictures
ID : int(8)
FileDocItemID : int(8) unsigned
FileName : varchar(255)
PictureID : int(8) unsigned

v		axiuss40_africa_personal_program_bk pm_da_folders
ID : int(8) unsigned
Name : varchar(40)
ParentID : int(8)

v		axiuss40_africa_personal_program_bk pm_duties
ID : int(8) unsigned
Name : varchar(100)
Daily : tinyint(1) unsigned
Monday : tinyint(1) unsigned
Tuesday : tinyint(1) unsigned
Wednesday : tinyint(1) unsigned
Thursday : tinyint(1) unsigned
Friday : tinyint(1) unsigned
Saturday : tinyint(1) unsigned
Sunday : tinyint(1) unsigned
EveryWeek : tinyint(1) unsigned
EverySecondWeek : tinyint(1) unsigned
EveryThirdWeek : tinyint(1) unsigned
EveryFourthWeek : tinyint(1) unsigned
SecondWeekStart : date
ThirdWeekStart : date
FourthWeekStart : date
EveryNumOfMonth : int(8) unsigned
DutyDoneByEvery : tinyint(1) unsigned
ExplanationGeneral : text
ExplanationAdvice : text
ResponsibilityID : int(8)
EveryNumOfFollowingMonth : int(8) unsigned
January : tinyint(1) unsigned
February : tinyint(1) unsigned
March : tinyint(1) unsigned
April : tinyint(1) unsigned
May : tinyint(1) unsigned
June : tinyint(1) unsigned
July : tinyint(1) unsigned
August : tinyint(1) unsigned
September : tinyint(1) unsigned
October : tinyint(1) unsigned
November : tinyint(1) unsigned
December : tinyint(1) unsigned
IfNecessary : tinyint(1) unsigned

v		axiuss40_africa_personal_program_bk pm_employees
ID : int(8) unsigned
Name : varchar(40)
Surname : varchar(40)
Sex : enum('empty','man','woman')
Birth : date
Nationality : varchar(40)
Religion : varchar(40)
SectorID : int(8)
Mobile : varchar(40)
Contact1 : varchar(40)
Contact2 : varchar(40)
Profession : varchar(40)
Employed : varchar(25)
DtEmployment : date
DtResignation : date
ResignType : enum('resigned','terminated')
NumVocationDays : int(8) unsigned
StaffHouse : enum('Ja','Nein')
StaffHouseMembers : int(8) unsigned
IsFatherAlive : enum('Ja','Nein')
IsMotherAlive : enum('Ja','Nein')
PhotoID : int(8)
SignatureID : int(8)
NetAllowances : decimal(6,2)
TransportAllowances : decimal(6,2)
SocSecNumber : varchar(20)
SocSecGovNumber : varchar(255)
TinNumber : varchar(255)
Town : varchar(255)
Street : varchar(255)
POBox : varchar(255)
PLZ : int(8)
IsNotEmployee : tinyint(1) unsigned
BankName : varchar(255)
BankID : varchar(255)
BankAccount : varchar(255)
IsLivesInProject : tinyint(1) unsigned
WhatsAppNo : varchar(55)
CanReadOrWrite : enum('empty','read','write')

v		axiuss40_africa_personal_program_bk pm_employees_bonus
ID : int(8) unsigned
EmployeeID : int(8) unsigned
Type : enum('empty','percent','absolute')
DefBonusReg : enum('Ja','Nein')
Percent : decimal(12,2)
TimesYear : tinyint(3) unsigned
Amount : decimal(12,2)
Period : tinyint(3) unsigned
Bonus1ID : int(8)
Bonus2ID : int(8)
Bonus3ID : int(8)

v		axiuss40_africa_personal_program_bk pm_employees_bonus_period
EmployeeID : int(8) unsigned
YearMonth : int(8) unsigned

v		axiuss40_africa_personal_program_bk pm_employees_documents
ID : int(8) unsigned
Name : varchar(255)
Content : longblob

v		axiuss40_africa_personal_program_bk pm_employees_document_contract
ID : int(8) unsigned
EmployeeID : int(8)
DocumentID : int(8)
UserID : int(8)

v		axiuss40_africa_personal_program_bk pm_employees_document_item
ID : int(8) unsigned
EmployeeID : int(8)
EmployeeDocumentTemplateID : int(8)
ScanDocumentID : int(8)
ScanNecessaryID : int(8)

v		axiuss40_africa_personal_program_bk pm_employees_document_template
ID : int(8) unsigned
Name : varchar(255)
AppliesAllEmployees : tinyint(1) unsigned
OnlyAppliesSector : tinyint(1) unsigned
SectorID : int(8) unsigned
OnlyForProfession : tinyint(1) unsigned
Professions : varchar(255)
AppliesIndividually : tinyint(1) unsigned
UseTemplateFile : tinyint(1) unsigned
TemplateFileID : int(8) unsigned
SignatureScanDocument : tinyint(1) unsigned
SignatureScanNecessary : tinyint(1) unsigned

v		axiuss40_africa_personal_program_bk pm_employees_duty_cost
ID : int(8) unsigned
EmployeeID : int(8) unsigned
DutyID : int(8) unsigned
Info : varchar(255)
NoOfPerson : int(8) unsigned
Deputy : int(8)
Supervisor : int(8)
DateFrom : date
DateTill : date
Cost : decimal(12,2)

v		axiuss40_africa_personal_program_bk pm_employees_duty_cost_periods
ID : int(8) unsigned
EmplDutyID : int(8)
DateStop : date
DateRestore : date
Type : enum('empty','Interrupt_duty','Interrupt_duty_payment')

v		axiuss40_africa_personal_program_bk pm_employees_employments
ID : int(8) unsigned
EmployeeID : int(8)
Year : int(8)
Month : int(8)
D1 : varchar(1)
D2 : varchar(1)
D3 : varchar(1)
D4 : varchar(1)
D5 : varchar(1)
D6 : varchar(1)
D7 : varchar(1)
D8 : varchar(1)
D9 : varchar(1)
D10 : varchar(1)
D11 : varchar(1)
D12 : varchar(1)
D13 : varchar(1)
D14 : varchar(1)
D15 : varchar(1)
D16 : varchar(1)
D17 : varchar(1)
D18 : varchar(1)
D19 : varchar(1)
D20 : varchar(1)
D21 : varchar(1)
D22 : varchar(1)
D23 : varchar(1)
D24 : varchar(1)
D25 : varchar(1)
D26 : varchar(1)
D27 : varchar(1)
D28 : varchar(1)
D29 : varchar(1)
D30 : varchar(1)
D31 : varchar(1)

v		axiuss40_africa_personal_program_bk pm_employees_life_changes
ID : int(8) unsigned
EmployeeID : int(8)
DT : date
Name : varchar(40)
Surname : varchar(40)
Position : varchar(25)
BasicSalary : decimal(10,2)
Allowances : decimal(10,2)

v		axiuss40_africa_personal_program_bk pm_employees_life_changes_detailed
ID : int(8) unsigned
AdditionalWorkID : int(8)
EmployeeLifeChangesID : int(8)

v		axiuss40_africa_personal_program_bk pm_employees_lives_in_project_periods
ID : int(8) unsigned
EmployeeID : int(8)
DtFrom : date
DtTill : date

v		axiuss40_africa_personal_program_bk pm_employees_related_documents
ID : int(8) unsigned
EmployeeID : int(8)
DocumentID : int(8)
UserID : int(8)
DocumentType : enum('empty','certificates','contracts','rules','responsibilities','descriptions','warnings','salary_related')

v		axiuss40_africa_personal_program_bk pm_employees_relatives
ID : int(8) unsigned
EmployeeID : int(8) unsigned
Name : varchar(40)
Died : date
Relation : enum('empty','father','mother','child')

v		axiuss40_africa_personal_program_bk pm_employees_required_fields
ID : int(8) unsigned
RequiredFields : varchar(255)

v		axiuss40_africa_personal_program_bk pm_employees_salary
ID : int(8) unsigned
EmployeeID : int(8) unsigned
Schedule : char(7)
TimeFrom : time
TimeTo : time
RedMissedDays : enum('Ja','Nein')
PayDuties : enum('Ja','Nein')
IncomeTax : decimal(12,2)
DtStopCalcSocSecurity : date

v		axiuss40_africa_personal_program_bk pm_employees_salary_brutto
ID : int(8) unsigned
ChangeDate : timestamp
EmployeeID : int(8) unsigned
YearMonth : int(8) unsigned
EndYearMonth : int(8)
BasicSalary : decimal(12,2)
Allowances : decimal(12,2)

v		axiuss40_africa_personal_program_bk pm_employees_tasks
ID : int(8)
SectorID : int(8)
SupervisorID : int(8)
EmployeeID : int(8)
DateFrom : date
DateTill : date
TimeFrom : time
TimeTill : time
TaskID : int(8)
AdditionalInfo : mediumtext
TaskPeriodID : int(8)
TaskEventID : int(8)
RelatedToID : int(8)

v		axiuss40_africa_personal_program_bk pm_employees_tasks_period
ID : int(8) unsigned
Daily : tinyint(1) unsigned
Monday : tinyint(1) unsigned
Tuesday : tinyint(1) unsigned
Wednesday : tinyint(1) unsigned
Thursday : tinyint(1) unsigned
Friday : tinyint(1) unsigned
Saturday : tinyint(1) unsigned
Sunday : tinyint(1) unsigned
EveryWeek : tinyint(1) unsigned
EverySecondWeek : tinyint(1) unsigned
EveryThirdWeek : tinyint(1) unsigned
EveryFourthWeek : tinyint(1) unsigned
SecondWeekStart : date
ThirdWeekStart : date
FourthWeekStart : date
EveryNumOfMonth : int(8) unsigned
EveryNumOfFollowingMonth : int(8) unsigned
January : tinyint(1) unsigned
February : tinyint(1) unsigned
March : tinyint(1) unsigned
April : tinyint(1) unsigned
May : tinyint(1) unsigned
June : tinyint(1) unsigned
July : tinyint(1) unsigned
August : tinyint(1) unsigned
September : tinyint(1) unsigned
October : tinyint(1) unsigned
November : tinyint(1) unsigned
December : tinyint(1) unsigned
WithoutWeekend : tinyint(1) unsigned
WithoutPublicHolidays : tinyint(1) unsigned

v		axiuss40_africa_personal_program_bk pm_employees_tax
ID : int(8) unsigned
EmployeeID : int(8) unsigned
Name : varchar(40)
Cost : decimal(12,2)

v		axiuss40_africa_personal_program_bk pm_employees_tax_period
ID : int(8) unsigned
EmplSalaryID : int(8)
TaxID : int(8)
Name : varchar(40)
Cost : decimal(12,2)
Amount : decimal(12,2)

v		axiuss40_africa_personal_program_bk pm_employees_working_plan
ID : int(8) unsigned
EmployeeID : int(8) unsigned
YearMonth : int(8) unsigned
IsDefined : enum('Ja','Nein')
HoursPerWeek : int(8) unsigned

v		axiuss40_africa_personal_program_bk pm_employees_working_plan_weeks
ID : int(8) unsigned
PlanID : int(8) unsigned
Schedule : varchar(7)
TimeFrom : time
TimeTo : time
WeekIndex : tinyint(3) unsigned

v		axiuss40_africa_personal_program_bk pm_employee_tasks_events
ID : int(8) unsigned
EmployeeTaskID : int(8) unsigned
EventID : int(8) unsigned
Info : varchar(255)

v		axiuss40_africa_personal_program_bk pm_employee_task_contacts
ID : int(8) unsigned
EmpTaskID : int(8)
EmployeeID : int(8)
PartnerID : int(8)

v		axiuss40_africa_personal_program_bk pm_employee_task_documents
ID : int(8) unsigned
Name : varchar(255)
Content : longblob

v		axiuss40_africa_personal_program_bk pm_employee_task_related_documents
ID : int(8) unsigned
EmployeeTaskID : int(8)
EmployeeTaskDocumentID : int(8)
UserID : int(8)

v		axiuss40_africa_personal_program_bk pm_events
ID : int(8)
Name : varchar(255)
DayDelta : int(8)

v		axiuss40_africa_personal_program_bk pm_event_dates
ID : int(8) unsigned
EventID : int(8) unsigned
Date : date
Info : varchar(255)

v		axiuss40_africa_personal_program_bk pm_executiv_board_positions
ID : int(8) unsigned
Name : varchar(255)

v		axiuss40_africa_personal_program_bk pm_firm_info
ID : int(8) unsigned
Name : varchar(40)
Street : varchar(40)
PLZ : int(8)
Town : varchar(40)
POBox : varchar(50)
Country : varchar(255)
Email : varchar(40)
Phone : varchar(40)
Mobile : varchar(255)
Fax : varchar(40)
Homepage : varchar(255)
TinNumber : varchar(255)

v		axiuss40_africa_personal_program_bk pm_fn_accounts
ID : int(8) unsigned
SubjectID : int(8)
Type : enum('empty','empl_account','empl_ss','empl_purse','org','empl_taxes','empl_ss_goverm','empl_injury')

v		axiuss40_africa_personal_program_bk pm_fn_operations
ID : int(8) unsigned
GroupID : int(8)
OperDateTime : datetime
AccountFromID : int(8)
AccountToID : int(8)
Amount : decimal(12,2)
UserID : int(8)
Type : enum('empty','ss_rest','ss_firm_pay','ss_wrk_pay','income_tax_pay','salary_pay','advance_pay','charge_allowance','reg_bonus_charge','irreg_bonus_charge','loan_pay','loan_pay_back','interest_pay','fees_pay','pension_pay','charge_salary','other_taxes_pay','charge_duties','injury_firm_pay','injury_empl_pay')
Info : char(16)

v		axiuss40_africa_personal_program_bk pm_fn_operations_copy
ID : int(8)
GroupID : int(8)
OperDateTime : datetime
AccountFromID : int(8)
AccountToID : int(8)
Amount : decimal(12,2)
UserID : int(8)
Type : enum('empty','ss_rest','ss_firm_pay','ss_wrk_pay','tax_pay','salary_pay','advance_pay','allowance_pay','reg_bonus_charge','irreg_bonus_charge','loan_pay','loan_pay_back','interest_pay','fees_pay','pension_pay','charge_salary')

v		axiuss40_africa_personal_program_bk pm_holidays
ID : mediumint(8)
Name : varchar(100)
HolidayDate : date

v		axiuss40_africa_personal_program_bk pm_income_tax_properties
ID : int(8) unsigned
YearMonth : int(8) unsigned
SSecurCompPercent : tinyint(3) unsigned
SSecurEmplPercent : tinyint(3) unsigned
SSecurMaxAge : int(10) unsigned
SSecurForAgeMoreThan : tinyint(1) unsigned
SSecurForBasicSalary : tinyint(1) unsigned
SSecurForAllowances : tinyint(1) unsigned
SSecurForTransportAllowances : tinyint(1) unsigned
SSecurForRegularBonus : tinyint(1) unsigned
SSecurForIrregularBonus : tinyint(1) unsigned
SSecurForDutiesPayment : tinyint(1) unsigned
SSecurCompHasAccount : tinyint(1) unsigned
SSecurLoansFromFond : tinyint(1) unsigned
SSecurBookingMonthlyAuto : tinyint(1) unsigned

v		axiuss40_africa_personal_program_bk pm_income_tax_rate
FromInt : decimal(10,2)
ToInt : decimal(10,2)
Amount : decimal(10,2)
OwnerID : int(10)

v		axiuss40_africa_personal_program_bk pm_injury_properties
ID : int(8) unsigned
YearMonth : int(8) unsigned
SSecurCompPercent : tinyint(3) unsigned
SSecurEmplPercent : tinyint(3) unsigned
SSecurMaxAge : int(10) unsigned
SSecurForAgeMoreThan : tinyint(1) unsigned
SSecurMinAmountValue : decimal(12,2) unsigned
SSecurMinValue : decimal(12,2) unsigned
SSecurMaxValue : decimal(12,2) unsigned
SSecurForBasicSalary : tinyint(1) unsigned
SSecurForAllowances : tinyint(1) unsigned
SSecurForTransportAllowances : tinyint(1) unsigned
SSecurForRegularBonus : tinyint(1) unsigned
SSecurForIrregularBonus : tinyint(1) unsigned
SSecurForDutiesPayment : tinyint(1) unsigned
SSecurCompHasAccount : tinyint(1) unsigned
SSecurLoansFromFond : tinyint(1) unsigned
SSecurBookingMonthlyAuto : tinyint(1) unsigned

v		axiuss40_africa_personal_program_bk pm_insurance_workers
ID : int(8) unsigned
WorkerID : int(8) unsigned
InsuranceID : int(8) unsigned
Anrede : varchar(25)
Mobile2 : varchar(25)
Email1 : varchar(50)
Email2 : varchar(50)
IsDeleted : tinyint(1)
StartMonth : int(11)
EndMonth : int(11)
Amount : decimal(10,0)

v		axiuss40_africa_personal_program_bk pm_insurence
ID : int(8) unsigned
Name : varchar(40)
Type : enum('privateIns','governmentIns')
Adress : text
Phone : varchar(25)
Mobile : varchar(25)
Fax : varchar(25)
Email : varchar(40)
Homepage : varchar(40)
IsDeleted : tinyint(1)

v		axiuss40_africa_personal_program_bk pm_letter_designations
ID : int(8) unsigned
Name : varchar(255)
SortingIndex : int(8)
Letter : varchar(1)

v		axiuss40_africa_personal_program_bk pm_ll_documents
ID : int(8) unsigned
Name : varchar(255)
Content : longblob

v		axiuss40_africa_personal_program_bk pm_ll_files
ID : int(8) unsigned
Name : varchar(40)
FolderID : int(8) unsigned
UserID : int(8) unsigned
Date : date
FileID : int(8)
ArchiveID : int(8)
IsArchive : enum('Ja','Nein')
Stamp : timestamp

v		axiuss40_africa_personal_program_bk pm_ll_folders
ID : int(8) unsigned
Name : varchar(40)
ParentID : int(8)

v		axiuss40_africa_personal_program_bk pm_loans
ID : int(8) unsigned
EmployeeID : int(8) unsigned
LoanDate : date
Amount : decimal(12,2)
Duration : tinyint(3) unsigned
Finished : enum('Ja','Nein')
OperationID : int(8)

v		axiuss40_africa_personal_program_bk pm_loans_repayments
ID : int(8) unsigned
LoanID : int(8)
YearMonth : int(8) unsigned
Amount : decimal(12,2)
OperationID : int(8)
SalaryCalcID : int(8)

v		axiuss40_africa_personal_program_bk pm_loans_repayments_cache
ID : int(8) unsigned
LoanID : int(8)
YearMonth : int(8) unsigned
Amount : decimal(12,2)
OperationID : int(8)
SalaryCalcID : int(8)

v		axiuss40_africa_personal_program_bk pm_messengers
ID : int(8) unsigned
Name : varchar(70)

v		axiuss40_africa_personal_program_bk pm_organizations
ID : int(8) unsigned
Name : varchar(50)
Info : varchar(255)

v		axiuss40_africa_personal_program_bk pm_partners
ID : int(8) unsigned
Type : varchar(25)
Name : varchar(40)
Street : varchar(40)
PLZ : int(8)
Town : varchar(40)
POBox : varchar(50)
Email : varchar(40)
Phone : varchar(40)
Fax : varchar(40)
IsRemoved : varchar(5)

v		axiuss40_africa_personal_program_bk pm_partners_contacts
ID : int(8) unsigned
PartnerID : int(8) unsigned
Sex : varchar(60)
Name : varchar(60)
Surname : varchar(60)
Phone : varchar(50)
Mobile : varchar(60)
Fax : varchar(60)
Email : varchar(60)
Note : varchar(255)
Address : varchar(100)
Title : varchar(100)
Pos : varchar(100)

v		axiuss40_africa_personal_program_bk pm_positive_feedback
ID : int(8) unsigned
Date : date
AccepterID : int(8)
MessengerID : int(8)
MessengerOther : varchar(70)
MessageType : enum('Verbal','Phone','Letter')
LetterDocID : int(8)
GoodWorkerID : int(8)
Info : text
ReactionOfManagement : text
IsCompleted : tinyint(1) unsigned

v		axiuss40_africa_personal_program_bk pm_responsibilities
ID : int(8) unsigned
Name : varchar(100)
SectorID : int(8)

v		axiuss40_africa_personal_program_bk pm_salaries_history
ID : int(8) unsigned
YearMonth : int(8)
EmplID : int(8)
CalculationDate : date
WorkDays : int(8) unsigned
WorkDaysInMonth : int(8) unsigned
BasicSalary : decimal(12,2)
BasicSalaryManual : tinyint(1) unsigned
Allowances : decimal(12,2)
AllowancesManual : tinyint(1) unsigned
RegularBonus : decimal(12,2)
IrregularBonus : decimal(12,2)
IrregularBonusManual : tinyint(1) unsigned
PaidAdvance : decimal(12,2)
RepaymentOfLoan : decimal(12,2)
RepaymentOfLoanManual : tinyint(1) unsigned
IncomeTax : decimal(12,2)
IncomeTaxManual : tinyint(1) unsigned
OtherTaxes : decimal(12,2)
EmplSocialSecurity : decimal(12,2)
EmplSocialSecurityPercent : decimal(12,2)
CompSocialSecurity : decimal(12,2)
CompSocialSecurityPercent : decimal(12,2)
SocialSecurityTotal : decimal(12,2)
EmplSocialSecurityGov : decimal(12,2)
EmplSocialSecurityPercentGov : decimal(12,2)
CompSocialSecurityGov : decimal(12,2)
CompSocialSecurityPercentGov : decimal(12,2)
SocialSecurityTotalGov : decimal(12,2)
EmplSocialSecurityInj : decimal(12,2)
EmplSocialSecurityPercentInj : decimal(12,2)
CompSocialSecurityInj : decimal(12,2)
CompSocialSecurityPercentInj : decimal(12,2)
SocialSecurityTotalInj : decimal(12,2)
InsurenceAmount : decimal(12,2)
Brutto : decimal(12,2)
Payment : decimal(12,2)
Calculated : tinyint(1) unsigned
CountPaidDayForBasicSalary : int(8)
NotPaidDaysForBasicSalary : text
SettlementDate : date

v		axiuss40_africa_personal_program_bk pm_salaries_history_allowances
ID : int(8) unsigned
SalaryHistoryID : int(8)
AllowanceID : int(8)
AmountAllDays : int(8)
AmountCalculateDays : int(8)
Amount : decimal(12,2)
NotPaidDays : text

v		axiuss40_africa_personal_program_bk pm_salaries_history_duties
ID : int(8) unsigned
SalaryHistoryID : int(8)
DutyID : int(8)
DateFrom : date
DateTill : date
Amount : decimal(12,2)

v		axiuss40_africa_personal_program_bk pm_salaries_settlement_dates
ID : int(8) unsigned
YearMonth : int(8)
SettlementDate : date

v		axiuss40_africa_personal_program_bk pm_salary_properties
ID : int(8) unsigned
SSecurCompPercent : tinyint(3) unsigned
SSecurEmplPercent : tinyint(3) unsigned
SSecurForBasicSalary : tinyint(1) unsigned
SSecurForAllowances : tinyint(1) unsigned
SSecurForTransportAllowances : tinyint(1) unsigned
SSecurForRegularBonus : tinyint(1) unsigned
SSecurForIrregularBonus : tinyint(1) unsigned
SSecurForDutiesPayment : tinyint(1) unsigned
SSecurCompHasAccount : tinyint(1) unsigned
SSecurLoansFromFond : tinyint(1) unsigned
SSecurBookingMonthlyAuto : tinyint(1) unsigned
LoanEmplCanGetAfter : tinyint(3) unsigned
LoanReturnPeriod : tinyint(3) unsigned
LoanNewAfterReturnOld : tinyint(1) unsigned
LoanLessSSFund : tinyint(1) unsigned
LoanLessSalaryForMonths : tinyint(3) unsigned
LoanRegularBonus : tinyint(1) unsigned
LoanIrregularBonus : tinyint(1) unsigned
InTaxForBasicSalary : tinyint(1) unsigned
InTaxForAllowances : tinyint(1) unsigned
InTaxForTransportAllowances : tinyint(1)
InTaxForDutiesPayment : tinyint(1) unsigned
InTaxPercentage : double(10,2)
DefBonus1ID : int(8)
DefBonus2ID : int(8)
DefBonus3ID : int(8)
ActivePart : tinyint(1) unsigned

v		axiuss40_africa_personal_program_bk pm_sectors
ID : int(8) unsigned
Name : varchar(100)

v		axiuss40_africa_personal_program_bk pm_soc_sec_gov_properties
ID : int(8) unsigned
YearMonth : int(8) unsigned
SSecurCompPercent : tinyint(3) unsigned
SSecurEmplPercent : tinyint(3) unsigned
SSecurForBasicSalary : tinyint(1) unsigned
SSecurForAllowances : tinyint(1) unsigned
SSecurForTransportAllowances : tinyint(1) unsigned
SSecurForRegularBonus : tinyint(1) unsigned
SSecurForIrregularBonus : tinyint(1) unsigned
SSecurForDutiesPayment : tinyint(1) unsigned
SSecurCompHasAccount : tinyint(1) unsigned
SSecurLoansFromFond : tinyint(1) unsigned
SSecurBookingMonthlyAuto : tinyint(1) unsigned
SSecurForAgeMoreThan : tinyint(1) unsigned
SSecurMaxAge : int(10) unsigned

v		axiuss40_africa_personal_program_bk pm_soc_sec_properties
ID : int(8) unsigned
YearMonth : int(8) unsigned
SSecurCompPercent : tinyint(3) unsigned
SSecurEmplPercent : tinyint(3) unsigned
SSecurMaxAge : int(10) unsigned
SSecurForAgeMoreThan : tinyint(1) unsigned
SSecurForBasicSalary : tinyint(1) unsigned
SSecurForAllowances : tinyint(1) unsigned
SSecurForTransportAllowances : tinyint(1) unsigned
SSecurForRegularBonus : tinyint(1) unsigned
SSecurForIrregularBonus : tinyint(1) unsigned
SSecurForDutiesPayment : tinyint(1) unsigned
SSecurCompHasAccount : tinyint(1) unsigned
SSecurLoansFromFond : tinyint(1) unsigned
SSecurBookingMonthlyAuto : tinyint(1) unsigned

v		axiuss40_africa_personal_program_bk pm_tasks
ID : int(8)
Name : varchar(255)

v		axiuss40_africa_personal_program_bk pm_task_groups
ID : int(8) unsigned
EmpTaskID : int(8)
EmployeeID : int(8)
Date : date
Done : tinyint(1) unsigned
NotNeeded : tinyint(1) unsigned
ChangingDate : date
DoneDateFrom : date
DoneDateTill : date
DoneTimeFrom : time
DoneTimeTill : time
Remark : text

v		axiuss40_africa_personal_program_bk pm_tmp_fn_operations
ID : int(8) unsigned
GroupID : int(8)
OperDateTime : datetime
AccountFromID : int(8)
AccountToID : int(8)
Amount : decimal(12,2)
UserID : int(8)
Type : enum('empty','ss_rest','ss_firm_pay','ss_wrk_pay','income_tax_pay','salary_pay','advance_pay','charge_allowance','reg_bonus_charge','irreg_bonus_charge','loan_pay','loan_pay_back','interest_pay','fees_pay','pension_pay','charge_salary','other_taxes_pay','charge_duties')
Info : char(16)

v		axiuss40_africa_personal_program_bk pm_tmp_rest_from
AccountID : int(8) unsigned
SumFrom : double(19,2)

v		axiuss40_africa_personal_program_bk pm_tmp_rest_to
AccountID : int(8) unsigned
SumTo : double(19,2)

v		axiuss40_africa_personal_program_bk pm_tm_related_to
ID : int(8) unsigned
Name : varchar(255)

v		axiuss40_africa_personal_program_bk sc_sector_tasks
ID : int(8) unsigned
SectorID : int(8)
Task : varchar(255)
Mondays : int(8)
Tuesdays : int(8)
Wednesdays : int(8)
Thursdays : int(8)
Fridays : int(8)
Saturdays : int(8)
Sundays : int(8)
AllPublicHolidays : int(8)
NoChangeOnHolidays : tinyint(1)

v		axiuss40_africa_personal_program_bk sc_sector_task_item
ID : tinyint(8) unsigned
TimeFrom : time
TimeTill : time
Hours : int(8) unsigned
NoRegularWorkingTime : tinyint(1)
WorkersAmount : int(8) unsigned
Additional : tinyint(1) unsigned

v		axiuss40_africa_personal_program_bk sc_worker_assigned_tasks
ID : int(8)
Date : date
EmplID : int(8)
TaskItemID : int(8)
Hours : time

v		axiuss40_africa_personal_program_bk users
ID : int(8) unsigned
Name : varchar(40)
Password : varchar(100)

v		axiuss40_africa_personal_program_bk worker_groups
ID : int(8) unsigned
Name : varchar(30)

v		axiuss40_africa_personal_program_bk worker_group_members
ID : int(8) unsigned
GroupID : int(8) unsigned
WorkerID : int(8) unsigned
Pos : int(4) unsigned

v		axiuss40_africa_personal_program_bk worker_schedule
Date : date
WorkerID : mediumint(8) unsigned
EmpltTmplID : smallint(4) unsigned

Create relationship
FOREIGN KEY
on delete
on update