Shipment Group tbl

From UG

(Difference between revisions)
Jump to: navigation, search
(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` int(10) NOT NULL auto_increment,
+
   `Id` INTEGER(10) NOT NULL AUTO_INCREMENT,
-
   `TransportModeId` int(10) NOT NULL,
+
   `TransportModeId` INTEGER(10) NOT NULL,
-
   `ClientCompanyId` int(10) NOT NULL,
+
   `ClientCompanyId` INTEGER(10) NOT NULL,
-
   `MasterId` int(10) default NULL,
+
   `MasterId` INTEGER(10) DEFAULT NULL,
-
   PRIMARY KEY (`Id`),
+
   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=89 DEFAULT CHARSET=latin1;
+
)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';

Personal tools