Shipment Group tbl

From UG

Revision as of 22:39, 4 February 2010 by Alex (Talk | contribs)
(diff) ← Older revision | Current revision (diff) | Newer revision → (diff)
Jump to: navigation, search



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;

Personal tools