Shipment Group tbl
From UG
(Difference between revisions)
Alex (Talk | contribs)
(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…')
Newer edit →
(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…')
Newer edit →
Revision as of 22:39, 4 February 2010
DROP TABLE IF EXISTS `tblShipmentGroup`; CREATE TABLE `tblShipmentGroup` ( `Id` int(10) NOT NULL auto_increment, `TransportModeId` int(10) NOT NULL, `ClientCompanyId` int(10) NOT NULL, `MasterId` int(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=89 DEFAULT CHARSET=latin1;