Shipment Group tbl
From UG
(Difference between revisions)
(Created page with 'Category:Groups <pre> DROP TABLE IF EXISTS `tblShipmentGroup`; CREATE TABLE `tblShipmentGroup` ( `Id` int(10) NOT NULL auto_increment, `TransportModeId` int(10) NOT NU…') |
|||
Line 6: | Line 6: | ||
CREATE TABLE `tblShipmentGroup` ( | CREATE TABLE `tblShipmentGroup` ( | ||
- | `Id` | + | `Id` INTEGER(10) NOT NULL AUTO_INCREMENT, |
- | `TransportModeId` | + | `TransportModeId` INTEGER(10) NOT NULL, |
- | `ClientCompanyId` | + | `ClientCompanyId` INTEGER(10) NOT NULL, |
- | `MasterId` | + | `MasterId` INTEGER(10) DEFAULT NULL, |
- | PRIMARY KEY | + | PRIMARY KEY (`Id`), |
KEY `TransportModeId` (`TransportModeId`), | KEY `TransportModeId` (`TransportModeId`), | ||
KEY `ClientCompanyId` (`ClientCompanyId`), | KEY `ClientCompanyId` (`ClientCompanyId`), | ||
Line 17: | Line 17: | ||
CONSTRAINT `tblShipmentGroup_fk1` FOREIGN KEY (`ClientCompanyId`) REFERENCES `tblClientCompany` (`Id`) ON UPDATE CASCADE, | CONSTRAINT `tblShipmentGroup_fk1` FOREIGN KEY (`ClientCompanyId`) REFERENCES `tblClientCompany` (`Id`) ON UPDATE CASCADE, | ||
CONSTRAINT `tblShipmentGroup_fk2` FOREIGN KEY (`MasterId`) REFERENCES `tblMasterOcean` (`Id`) | CONSTRAINT `tblShipmentGroup_fk2` FOREIGN KEY (`MasterId`) REFERENCES `tblMasterOcean` (`Id`) | ||
- | ) ENGINE=InnoDB AUTO_INCREMENT= | + | )ENGINE=InnoDB |
+ | AUTO_INCREMENT=5635 CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci' | ||
+ | COMMENT='InnoDB free: 9216 kB; (`TransportModeId`) REFER `cybertrax/t'; | ||
</pre> | </pre> |
Current revision as of 16:37, 6 August 2014
DROP TABLE IF EXISTS `tblShipmentGroup`; CREATE TABLE `tblShipmentGroup` ( `Id` INTEGER(10) NOT NULL AUTO_INCREMENT, `TransportModeId` INTEGER(10) NOT NULL, `ClientCompanyId` INTEGER(10) NOT NULL, `MasterId` INTEGER(10) DEFAULT NULL, PRIMARY KEY (`Id`), KEY `TransportModeId` (`TransportModeId`), KEY `ClientCompanyId` (`ClientCompanyId`), KEY `tblShipmentGroup_fk2` (`MasterId`), CONSTRAINT `tblShipmentGroup_fk` FOREIGN KEY (`TransportModeId`) REFERENCES `tblTransportMode` (`Id`) ON UPDATE CASCADE, CONSTRAINT `tblShipmentGroup_fk1` FOREIGN KEY (`ClientCompanyId`) REFERENCES `tblClientCompany` (`Id`) ON UPDATE CASCADE, CONSTRAINT `tblShipmentGroup_fk2` FOREIGN KEY (`MasterId`) REFERENCES `tblMasterOcean` (`Id`) )ENGINE=InnoDB AUTO_INCREMENT=5635 CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci' COMMENT='InnoDB free: 9216 kB; (`TransportModeId`) REFER `cybertrax/t';