BeWoPlaner/Model/Changes_2019_06_05 PersonHistory und EmployeeHistory Tabelle erstellt.txt

CREATE TABLE IF NOT EXISTS `personhistory` (
  `Oid` bigint(19) PRIMARY KEY AUTO_INCREMENT,
  `Tid` int(10) DEFAULT NULL,
  `IsActive` tinyint(4) DEFAULT NULL,
  `Notice` varchar(1024) DEFAULT NULL,
  `InsTs` datetime DEFAULT NULL,
  `InsUser` varchar(256) DEFAULT NULL,
  `Version` bigint(19) DEFAULT NULL,
  `UdpUser` varchar(256) DEFAULT NULL,
  `SystemEntryID` int(10) DEFAULT NULL,
  `ChangeType` int(10) DEFAULT NULL,
  
  `Person_Oid` bigint(19) NOT NULL,
  `Person_BankAccountOid` bigint(19) DEFAULT NULL,
  `Person_AddressOid` bigint(19) DEFAULT NULL,
  `Person_InvoiceAddressOid` bigint(19) DEFAULT NULL,
  `Person_Tid` int(10) NOT NULL,
  `Person_FirstName` varchar(256) DEFAULT NULL,
  `Person_LastName` varchar(256) DEFAULT NULL,
  `Person_Abbreviation` varchar(16) DEFAULT NULL,
  `Person_DateOfBirth` datetime DEFAULT NULL,
  `Person_Sex` int(10) DEFAULT NULL,
  `Person_FamilyStatus` int(10) DEFAULT NULL,
  `Person_Profession` varchar(256) DEFAULT NULL,
  `Person_Type` int(10) DEFAULT NULL,
  `Person_Notice` mediumtext,
  `Person_InsTs` datetime DEFAULT NULL,
  `Person_InsUser` varchar(256) DEFAULT NULL,
  `Person_Version` bigint(19) DEFAULT NULL,
  `Person_UdpUser` varchar(256) DEFAULT NULL,
  `Person_IsActive` tinyint(4) DEFAULT NULL,
  `Person_SystemEntryID` int(10) DEFAULT NULL,
  `Person_Title` varchar(2048) DEFAULT NULL,
  `Person_Function` varchar(2048) DEFAULT NULL,
  `Person_IsMigrant` tinyint(4) DEFAULT NULL,
  `Person_Nationalitaet` varchar(2048) DEFAULT NULL,
  `Person_AufenthaltsStatus` varchar(2048) DEFAULT NULL
)ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `employeehistory` (
  `Oid` bigint(19) PRIMARY KEY AUTO_INCREMENT,
  `Tid` int(10) DEFAULT NULL,
  `IsActive` tinyint(4) DEFAULT NULL,
  `Notice` varchar(1024) DEFAULT NULL,
  `InsTs` datetime DEFAULT NULL,
  `InsUser` varchar(256) DEFAULT NULL,
  `Version` bigint(19) DEFAULT NULL,
  `UdpUser` varchar(256) DEFAULT NULL,
  `SystemEntryID` int(10) DEFAULT NULL,
  `ChangeType` int(10) DEFAULT NULL,
  
  `Employee_Oid` bigint(19) NOT NULL,
  `Employee_PersonOid` bigint(19) NOT NULL,
  `Employee_ApplicationUserOid` bigint(19) DEFAULT NULL,
  `Employee_Tid` int(10) NOT NULL,
  `Employee_PersonnelNumber` varchar(128) DEFAULT NULL,
  `Employee_TaxNumber` varchar(128) DEFAULT NULL,
  `Employee_HealthInsurance` varchar(128) DEFAULT NULL,
  `Employee_InsuranceNumber` varchar(128) DEFAULT NULL,
  `Employee_HourlyRate` decimal(18,10) DEFAULT NULL,
  `Employee_EntryDate` datetime DEFAULT NULL,
  `Employee_CancellationPeriod` int(10) DEFAULT NULL,
  `Employee_ProbationPeriod` int(10) DEFAULT NULL,
  `Employee_Sequence` int(10) DEFAULT NULL,
  `Employee_IsActive` tinyint(4) DEFAULT NULL,
  `Employee_Notice` varchar(1024) DEFAULT NULL,
  `Employee_InsTs` datetime DEFAULT NULL,
  `Employee_InsUser` varchar(256) DEFAULT NULL,
  `Employee_Version` bigint(19) DEFAULT NULL,
  `Employee_UdpUser` varchar(256) DEFAULT NULL,
  `Employee_SystemEntryID` int(10) DEFAULT NULL,
  `Employee_weeklyfls` decimal(18,10) DEFAULT NULL,
  `Employee_weeklytotalhours` decimal(18,10) DEFAULT NULL,
  `Employee_leavedays` decimal(18,10) DEFAULT NULL,
  `Employee_IsQualified` tinyint(4) DEFAULT NULL,
  `Employee_Text1` varchar(128) DEFAULT NULL,
  `Employee_Text2` varchar(128) DEFAULT NULL,
  `Employee_Text3` varchar(128) DEFAULT NULL,
  `Employee_Text4` varchar(128) DEFAULT NULL,
  `Employee_Text5` varchar(128) DEFAULT NULL,
  `Employee_Notice2` mediumtext,
  `Employee_EmployeeColor` varchar(9) DEFAULT NULL,
  `Employee_EmployeeImage` longblob,
  `Employee_EmployeeThumbnail` longblob,
  `Employee_Pflege` tinyint(4) DEFAULT NULL,
  `Employee_Toilettengang` tinyint(4) DEFAULT NULL,
  `Employee_Aggressiv` tinyint(4) DEFAULT NULL,
  `Employee_Schutzstufe` varchar(1024) DEFAULT NULL,
  `Employee_Hygienebelehrung` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;