9 lines
431 B
MySQL
9 lines
431 B
MySQL
|
CREATE TABLE `vn`.`ticketSms` (
|
||
|
|
`smsFk` mediumint(8) unsigned NOT NULL,
|
||
|
|
`ticketFk` int(11) DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`smsFk`),
|
||
|
|
KEY `ticketSms_FK_1` (`ticketFk`),
|
||
|
|
CONSTRAINT `ticketSms_FK` FOREIGN KEY (`smsFk`) REFERENCES `sms` (`id`) ON UPDATE CASCADE,
|
||
|
|
CONSTRAINT `ticketSms_FK_1` FOREIGN KEY (`ticketFk`) REFERENCES `ticket` (`id`) ON UPDATE CASCADE
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci
|