2025-07-11 18:48:37 +02:00
|
|
|
CREATE TABLE IF NOT EXISTS `supportconceptapprovalperiodhistory` (
|
2021-12-01 14:09:56 +01:00
|
|
|
`Oid` bigint NOT NULL AUTO_INCREMENT,
|
|
|
|
|
`Tid` int NOT NULL,
|
|
|
|
|
`IsActive` varchar(45) DEFAULT NULL,
|
|
|
|
|
`Notice` varchar(1024) DEFAULT NULL,
|
|
|
|
|
`InsTs` datetime DEFAULT NULL,
|
|
|
|
|
`InsUser` varchar(256) DEFAULT NULL,
|
|
|
|
|
`Version` bigint DEFAULT NULL,
|
|
|
|
|
`UdpUser` varchar(256) DEFAULT NULL,
|
|
|
|
|
`SystemEntryID` int DEFAULT NULL,
|
|
|
|
|
`ChangeType` tinyint NOT NULL DEFAULT '0',
|
|
|
|
|
`supportconceptapprovalperiod_EndDate` datetime DEFAULT NULL,
|
|
|
|
|
`supportconceptapprovalperiod_StartDate` datetime DEFAULT NULL,
|
|
|
|
|
`supportconceptapprovalperiod_MonthlyPayment` decimal(18,10) DEFAULT NULL,
|
|
|
|
|
`supportconceptapprovalperiod_IsApprovedFixedAmountShifting` tinyint(1) DEFAULT NULL,
|
|
|
|
|
`supportconceptapprovalperiod_ApprovedBEPerInterval` decimal(18,10) DEFAULT NULL,
|
|
|
|
|
`supportconceptapprovalperiod_ApprovedBEInterval` int DEFAULT NULL,
|
|
|
|
|
`supportconceptapprovalperiod_IsApprovedBEShifting` tinyint(1) DEFAULT NULL,
|
|
|
|
|
`supportconceptapprovalperiod_ApprovedBETotal` decimal(18,10) DEFAULT NULL,
|
|
|
|
|
`supportconceptapprovalperiod_ApprovedFixedAmount` decimal(18,10) DEFAULT NULL,
|
|
|
|
|
`supportconceptapprovalperiod_ApprovedFixedAmountInterval` int DEFAULT NULL,
|
|
|
|
|
`supportconceptapprovalperiod_CostBearer2SupportConceptHistoryOid` bigint DEFAULT NULL,
|
|
|
|
|
`supportconceptapprovalperiod_Percentage` decimal(18,10) DEFAULT NULL,
|
|
|
|
|
`supportconceptapprovalperiod_SupportConceptHistoryOid` bigint DEFAULT NULL,
|
|
|
|
|
`supportconceptapprovalperiod_ServiceCategoryOid` bigint DEFAULT NULL,
|
|
|
|
|
`supportconceptapprovalperiod_ContactCountPerInterval` decimal(18,10) DEFAULT NULL,
|
|
|
|
|
`supportconceptapprovalperiod_ContactCountInterval` int DEFAULT NULL,
|
|
|
|
|
`supportconceptapprovalperiod_BudgetOid` bigint DEFAULT NULL,
|
|
|
|
|
`supportconceptapprovalperiod_Bewilligungsart` int NOT NULL DEFAULT '0',
|
|
|
|
|
PRIMARY KEY (`Oid`)
|
|
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
