2025-07-11 18:48:37 +02:00
|
|
|
CREATE TABLE IF NOT EXISTS `diensteintrag` (
|
2020-09-30 10:00:31 +02:00
|
|
|
`Oid` bigint(19) NOT NULL 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,
|
|
|
|
|
|
|
|
|
|
`EmployeeOid` bigint(19) DEFAULT NULL,
|
|
|
|
|
`WohnheimOid` bigint(19) DEFAULT NULL,
|
|
|
|
|
`DienstOid` bigint(19) DEFAULT NULL,
|
|
|
|
|
`Zeile` int(10) DEFAULT NULL,
|
|
|
|
|
`Datum` datetime DEFAULT NULL,
|
|
|
|
|
PRIMARY KEY (`Oid`)
|
|
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1
|
