10 lines
637 B
Plaintext
10 lines
637 B
Plaintext
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; |