BeWoPlaner/Model/Changes_2023_01_25_ServiceRecord in NewSchedulerAppointment (Gruppenbuchung bedacht).txt

CREATE TABLE IF NOT EXISTS `servicerecord2newschapp`(
	`Oid` BIGINT NOT NULL AUTO_INCREMENT,
    `ServiceRecordOid` BIGINT DEFAULT NULL,
    `NewSchAppOid` BIGINT DEFAULT NULL,
    PRIMARY KEY (`Oid`),
    KEY `KEY_SERVICERECORD` (`ServiceRecordOid`),
    KEY `KEY_NEWSCHAPP` (`NewSchAppOid`),
    CONSTRAINT `FK_SERVICERECORD` FOREIGN KEY (`ServiceRecordOid`) REFERENCES `servicerecord` (`Oid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    CONSTRAINT `FK_NEWSCHAPP` FOREIGN KEY (`NewSchAppOid`) REFERENCES `newschedulerappointment` (`Oid`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;