2019-08-09 16:40:41 +02:00
|
|
|
CREATE TABLE `textbaustein` (
|
|
|
|
|
`Oid` BIGINT(19) NOT NULL AUTO_INCREMENT,
|
|
|
|
|
`Tid` INT(10) DEFAULT NULL,
|
|
|
|
|
`IsActive` TINYINT(1) 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,
|
|
|
|
|
`Text` VARCHAR(2048) DEFAULT NULL,
|
|
|
|
|
`Position` INT(10) DEFAULT NULL,
|
|
|
|
|
`Name` VARCHAR(256) DEFAULT NULL,
|
|
|
|
|
`ServiceCategoryOid` BIGINT(19) DEFAULT NULL,
|
|
|
|
|
`EmployeeOid` BIGINT(19) DEFAULT NULL,
|
|
|
|
|
`IsOnlyForEmployee` TINYINT(1) DEFAULT NULL,
|
|
|
|
|
PRIMARY KEY (`Oid`),
|
|
|
|
|
KEY `SERVICECATEGORY_TEXTBAUSTEIN_FK` (`ServiceCategoryOid`),
|
|
|
|
|
KEY `EMPLOYEE_TEXTBAUSTEIN_FK` (`EmployeeOid`),
|
|
|
|
|
CONSTRAINT `FK_SERVICECATEGORY_TEXTBAUSTEIN` FOREIGN KEY (`ServiceCategoryOid`) REFERENCES `ServiceCategory` (`Oid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
|
|
|
|
|
CONSTRAINT `FK_EMPLOYEE_TEXTBAUSTEIN` FOREIGN KEY (`EmployeeOid`) REFERENCES `Employee` (`Oid`) ON DELETE NO ACTION ON UPDATE NO ACTION
|
2016-06-27 01:45:38 +02:00
|
|
|
)ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=LATIN1;
|
